How to Visualize Ahrefs Data with ChatGPT

9 months ago 54

SEOs person entree to truthful overmuch information that sometimes, it’s hard to cognize what to bash with it all. I’ve been experimenting with visualizing Ahrefs information utilizing GPT-4, truthful I thought I’d stock the results with you all.

We’ve already launched immoderate AI-enhanced features similar hunt intent, but we made it adjacent amended by adding the postulation stock for each intent. Check retired this write-up from Si Quan for immoderate much things we might add.

For the visualizations, you’ll request GPT-4. There’s an API, but you tin besides conscionable usage ChatGPT Plus for $20 a month. I’m hoping to bring galore of these visuals to beingness wrong the tool, but these things instrumentality clip and you tin make them now. Let maine cognize your favorites and immoderate different usage cases you find that you privation to spot us add!

IMPORTANT

For each these, export the information successful UTF-8 format from the study indicated and tally the prompt. Note that your results whitethorn disagree a spot due to the fact that of however LLMs work. You whitethorn request to inquire for immoderate adjustments to get precisely what you want.

Find the biggest gaps betwixt desktop and mobile rankings

Scatterplot showing mobile and desktop rankings with labeled outliers

Use case:

This allows you to spot outliers. If you person immoderate presumption ranking amended connected Desktop vs Mobile, past you mightiness privation to look astatine mobile issues oregon Core Web Vitals.

You tin spot some mobile issues and Core Web Vitals successful Ahrefs’ Site Audit. You’ll request to tally Site Audit arsenic mobile and link to PageSpeed Insights.

Core Web Vital and mobile usability issues successful  Ahrefs' Site Audit

Data source:

Download your desktop and mobile rankings from the Overview study successful Rank Tracker (remember to take the UTF-8 format). Upload some files to ChatGPT.

Exporting the information  from Ahrefs

Prompt:

Read these 2 files that incorporate desktop and mobile keyword rankings.

Show maine a scatter crippled comparing the desktop and mobile positions for each keyword.

Label ones that person the biggest spread betwixt rankings.

See a breakdown of branded and unbranded postulation & volume

Branded and unbranded integrated  postulation   and volume

Use case:

See the breakdown of postulation and full measurement by branded and unbranded terms. At a glance, I tin spot that the bulk of our postulation comes from unbranded terms.

Data source:

Download your keyword rankings from the Organic Keywords study successful Site Explorer (make definite to prime the UTF-8 record format) and upload the record to ChatGPT.

Exporting the information  from Ahrefs

Prompt:

Label each keyword successful the “Keyword” file arsenic branded oregon unbranded. Then make a pastry illustration that shows the sum of “Current integrated traffic” for some categories.

Also make this illustration with the sum of “Volume” for each.

Show the alteration successful measurement for branded and unbranded keywords

Change successful  postulation   for branded and unbranded terms

Use case:

See if you’re gaining oregon losing clicks for branded oregon unbranded presumption betwixt 2 dates. You request to person comparison mode enabled for this to work.

Data source:

Like the erstwhile one, download your keyword rankings from the Organic Keywords study successful Site Explorer and upload the file.

Prompt:

Label each keyword successful the “Keyword” file arsenic branded oregon unbranded.

Create a ocular that shows maine however the integrated postulation changed wide for branded and unbranded keywords based connected the sum of the information for each successful the “Organic postulation change” column.

Find retired erstwhile competing contented was updated

Histogram showing however  agelong  it's been since competing contented  was republished

Use case:

See the past clip competing contented was updated. If competitors are updating their contented a lot, it tin bespeak a much competitory market.

Data source:

Enter a competitor’s website into Content Explorer and export the database of pages (choose UTF-8 arsenic the export format). This tin besides beryllium done with a keyword or topic.

Exporting the information  from Ahrefs

Prompt:

Show maine however galore days since the contented was updated.

Histogram showing however  agelong  it's been since competing contented  was republished

Use case:

See however agelong backlinks were unrecorded connected average. If you’re losing a batch of backlinks early, you whitethorn privation to look into the reasons why. Read our survey connected nexus rot to spot galore of the communal reasons.

You tin filter the Backlinks study for galore of the communal reasons wherefore links are lost.

Backlinks filters for the crushed   they're lost

Data source:

Export your nexus illustration from the Backlinks study successful Site Explorer (choose UTF-8 arsenic the record format). Upload this to ChatGPT.

Exporting the information  from Ahrefs

Prompt:

Read this record and springiness maine a histogram to amusement the organisation of backlink lifespans.

Look for seasonal patterns successful nexus acquisition

Line illustration  with a enactment     for each   twelvemonth  showing the seasonal patterns successful  nexus  acquisition

Use case:

See immoderate seasonal patterns for your acquired links. Here, I spot a large spike successful the mediate of 2022 and what seems to beryllium a spot of a spike successful November the past few years.

Data source:

Like the erstwhile one, export your nexus illustration from the Backlinks study successful Site Explorer. Upload this to ChatGPT.

Prompt:

Look for seasonal patterns successful backlink acquisition.

If you’d similar a heatmap similar the 1 below, usage this punctual instead:

Analyze patterns successful nexus acquisition (e.g., weekdays vs. weekends, monthly trends) utilizing enactment charts oregon heatmaps to place erstwhile astir backlinks are acquired.

Heatmap showing days and weeks erstwhile   the tract  got much  links

Quickly spot stock of dependable by tag & competitor

Share of dependable   for each   tag radical  and measured against competitors

Use case:

See which tag groups are beardown oregon anemic vs competitors. I tin rapidly spot we predominate for things similar nexus building, but we’re anemic for the presumption successful our wide selling bucket, astir apt due to the fact that we mostly absorption on SEO.

Data source:

Export the information from the Competitors - Tags study successful Rank Tracker (use UTF-8 format).

Exporting the information  from Ahrefs

Prompt:

Show maine stock of dependable by tag and divided it by rival as well.

Forecast clip bid data

Forecasted clip  bid    information  for integrated  traffic

Use case:

Forecasting postulation oregon different metrics forward. This is large for getting buy-in.

Sidenote.

This failed with larger datasets oregon aggregate competitors, but you tin ever usage my SEO forecasting scripts for this as well.

Data source:

Export graph information from the Overview study successful Site Explorer. You tin take immoderate time-series graph you similar (organic traffic, referring domains, etc.)

Exporting the information  from Ahrefs

Prompt:

Forecast this clip bid information guardant one year

See the alteration successful keyword rankings

Changes successful  keyword rankings shown successful  a scatterplot with winners/losers separated

Long communicative abbreviated connected this one. I had a mentation that wasn’t arsenic bully arsenic what Marie Haynes came up with, but I added to her visualization to marque it adjacent better.

Use case:

The illustration visualizes winners/losers for keyword rankings and shows maine wide if I’m doing amended oregon worse. From this image, I tin spot that much keywords wide are ranking worse, but wide rankings are up, truthful the affirmative ones moved up a batch much than the antagonistic ones lost.

Data source:

Download your keyword rankings from the Organic Keywords study successful Site Explorer and upload the file.

Prompt:

I utilized aggregate prompts to get the last chart, but they mightiness beryllium capable to beryllium simplified into one.

Show maine a scatter crippled that shows the changes from the erstwhile presumption and the existent position. Include changes to a little presumption arsenic greenish and changes to a higher presumption arsenic red. Include a fable and trendline.

Add a number for improved and worsened connected the erstwhile chart. Also amusement maine connected the illustration connected average, however overmuch did rankings amended oregon decline

Remove the averages arsenic they are. I privation the wide mean alteration successful ranking presumption arsenic 1 number.

Move the mean to the close broadside of the illustration truthful it’s readable

Find anomalies successful integrated traffic

Anomalies successful  the postulation   graph denoting large   shifts specified  arsenic  algorithm updates oregon  website changes

Use case:

Find anomalies successful clip bid data. In this case, astir of the anomalies enactment up with large website changes and Google algorithm updates.

Data source:

Export integrated postulation graph information from the Overview study successful Site Explorer.

Prompt:

Identify anomalies successful this postulation chart

See stock of dependable changes by tag

Share of dependable   betwixt  2  clip  points for each   tagged radical  of keywords

Use case:

This tells maine if definite tagged groups are doing amended oregon worse betwixt the dates.

Data source:

Export information from the Tags study successful Rank Tracker.

Exporting the information  from Ahrefs

Prompt:

Show maine stock of dependable implicit clip by tag.

See however postulation changed for each tag

Traffic betwixt  2  clip  points for each   tagged radical  of keywords

Use case:

See however postulation changed for each tag betwixt 2 dates. We person a amended presumption for this coming successful Rank Tracker that volition amusement the improvement over time.

Data source:

Like the erstwhile one, export information from the Tags study successful Rank Tracker.

Prompt:

Show maine however postulation is evolving for each tag.

Find which groups of presumption person the astir imaginable for improvement

Search measurement   and clicks by tag

Use case:

See which groups of presumption person the astir measurement vs the clicks that they’re getting. High full measurement and debased clicks means you person a batch to work on.

Data source:

Export keywords from the Overview study successful Rank Tracker. (You tin take betwixt desktop oregon mobile ranking information with the toggle).

Exporting the information  from Ahrefs

Prompt:

Visualize hunt measurement and clicks by tag.

See which SERP features are astir common

Most communal  SERP features for you and competitors

Use case:

Shows communal SERP features for you and competitors that you whitethorn privation to target. If definite schema markup is required but you’re not utilizing it, it tin pb to an easy win.

You whitethorn besides person an contented with your schema markup. Ahrefs’ Site Audit validates against some schema.org and Google standards.

Structured information  validation successful  Ahrefs' Site Audit

Data source:

Export the information from the Content Gap study successful our Competitive Analysis tool.

Exporting the information  from Ahrefs

Prompt:

Show maine which SERP features are astir common.

Sidenote.

I would astir apt set this punctual to divided them retired into idiosyncratic features alternatively than diagnostic groups.

Final thoughts

I anticipation this has sparked immoderate ideas for different SEOs retired there. I privation to spot what you each volition create.

Have a chill thought you privation to share? Let maine cognize connected X oregon LinkedIn.

Read Entire Article