How to Visualize Ahrefs Data with ChatGPT

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!

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.

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.

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.

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.

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.

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.

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.

Prompt:

Show maine however galore days since the contented was updated.

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.

Data source:

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

Prompt:

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

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.

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).

Prompt:

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

Use case:

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

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.)

Prompt:

Forecast this clip bid information guardant one year

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

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

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.

Prompt:

Show maine stock of dependable implicit clip by tag.

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.

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).

Prompt:

Visualize hunt measurement and clicks by tag.

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.

Data source:

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

Prompt:

Show maine which SERP features are astir common.

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.