The best way to Visualize Ahrefs Knowledge with ChatGPT

[ad_1]

SEOs have entry to a lot knowledge that typically, it’s exhausting to know what to do with all of it. I’ve been experimenting with visualizing Ahrefs knowledge utilizing GPT-4, so I believed I’d share the outcomes with you all.

We’ve already launched some AI-enhanced options like search intent, however we made it even higher by including the visitors share for every intent. Try this write-up from Si Quan for some extra issues we would add.

For the visualizations, you’ll want GPT-4. There’s an API, however you too can simply use ChatGPT Plus for $20 a month. I’m hoping to deliver many of those visuals to life inside the software, however this stuff take time and you’ll create them now. Let me know your favorites and another use circumstances you discover that you just need to see us add!

IMPORTANT

For all these, export the info in UTF-8 format from the report indicated and run the immediate. Word that your outcomes might differ a bit due to how LLMs work. You might have to ask for some changes to get precisely what you need.

Scatterplot showing mobile and desktop rankings with labeled outliers

Use case:

This lets you see outliers. In case you have some phrases rating higher on Desktop vs Cell, then you definitely would possibly need to take a look at cellular points or Core Net Vitals.

You possibly can see each cellular points and Core Net Vitals in Ahrefs’ Web site Audit. You’ll have to run Web site Audit as cellular and connect with PageSpeed Insights.

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

Knowledge supply:

Obtain your desktop and cellular rankings from the Overview report in Rank Tracker (bear in mind to decide on the UTF-8 format). Add each information to ChatGPT.

Immediate:

Learn these 2 information that include desktop and cellular key phrase rankings.

Present me a scatter plot evaluating the desktop and cellular positions for every key phrase.

Label ones which have the largest hole between rankings.

Branded and unbranded organic traffic and volume

Use case:

See the breakdown of visitors and complete quantity by branded and unbranded phrases. At a look, I can see that almost all of our visitors comes from unbranded phrases.

Knowledge supply:

Obtain your key phrase rankings from the Natural Key phrases report in Web site Explorer (ensure that to pick out the UTF-8 file format) and add the file to ChatGPT.

Immediate:

Label every key phrase within the “Key phrase” column as branded or unbranded. Then create a pie chart that reveals the sum of “Present natural visitors” for each classes.

Additionally create this chart with the sum of “Quantity” for every.

Change in traffic for branded and unbranded terms

Use case:

See if you happen to’re gaining or shedding clicks for branded or unbranded phrases between two dates. You might want to have evaluate mode enabled for this to work.

Knowledge supply:

Just like the earlier one, obtain your key phrase rankings from the Natural Key phrases report in Web site Explorer and add the file.

Immediate:

Label every key phrase within the “Key phrase” column as branded or unbranded.

Create a visible that reveals me how the natural visitors modified general for branded and unbranded key phrases primarily based on the sum of the info for every within the “Natural visitors change” column.

Histogram showing how long it's been since competing content was republished

Use case:

See the final time competing content material was up to date. If rivals are updating their content material so much, it will possibly point out a extra aggressive market.

Knowledge supply:

Enter a competitor’s web site into Content material Explorer and export the record of pages (select UTF-8 because the export format). This can be completed with a key phrase or matter.

Immediate:

Present me what number of days because the content material was up to date.

Use case:

See how lengthy backlinks have been stay on common. Should you’re shedding quite a lot of backlinks early, it’s possible you’ll need to look into the the explanation why. Learn our research on hyperlink rot to see lots of the frequent causes.

You possibly can filter the Backlinks report for lots of the frequent the explanation why hyperlinks are misplaced.

Backlinks filters for the reason they're lost

Knowledge supply:

Export your hyperlink profile from the Backlinks report in Web site Explorer (select UTF-8 because the file format). Add this to ChatGPT.

Immediate:

Learn this file and provides me a histogram to point out the distribution of backlink lifespans.

Line chart with a line for each year showing the seasonal patterns in link acquisition

Use case:

See any seasonal patterns to your acquired hyperlinks. Right here, I see an enormous spike in the course of 2022 and what appears to be a little bit of a spike in November the previous couple of years.

Knowledge supply:

Just like the earlier one, export your hyperlink profile from the Backlinks report in Web site Explorer. Add this to ChatGPT.

Immediate:

Search for seasonal patterns in backlink acquisition.

Should you’d want a heatmap just like the one under, use this immediate as an alternative:

Analyze patterns in hyperlink acquisition (e.g., weekdays vs. weekends, month-to-month traits) utilizing line charts or heatmaps to establish when most backlinks are acquired.

Heatmap showing days and weeks when the site got more links

Share of voice for each tag group and measured against competitors

Use case:

See which tag teams are robust or weak vs rivals. I can rapidly see we dominate for issues like hyperlink constructing, however we’re weak for the phrases in our common advertising and marketing bucket, in all probability as a result of we largely give attention to search engine marketing.

Knowledge supply:

Export the info from the Opponents – Tags report in Rank Tracker (use UTF-8 format).

Immediate:

Present me share of voice by tag and break up it by competitor as effectively.

Forecasted time series data for organic traffic

Use case:

Forecasting visitors or different metrics ahead. That is nice for getting buy-in.

Sidenote.

This failed with bigger datasets or a number of rivals, however you possibly can at all times use my search engine marketing forecasting scripts for this as effectively.

Knowledge supply:

Export graph knowledge from the Overview report in Web site Explorer. You possibly can select any time-series graph you want (natural visitors, referring domains, and many others.)

Immediate:

Forecast this time sequence knowledge ahead one yr

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

Lengthy story brief on this one. I had a model that wasn’t pretty much as good as what Marie Haynes got here up with, however I added to her visualization to make it even higher.

Use case:

The chart visualizes winners/losers for key phrase rankings and reveals me general if I’m doing higher or worse. From this picture, I can see that extra key phrases general are rating worse, however general rankings are up, so the constructive ones moved up much more than the unfavorable ones misplaced.

Knowledge supply:

Obtain your key phrase rankings from the Natural Key phrases report in Web site Explorer and add the file.

Immediate:

I used a number of prompts to get the ultimate chart, however they could be capable of be simplified into one.

Present me a scatter plot that reveals the adjustments from the earlier place and the present place. Embrace adjustments to a decrease place as inexperienced and adjustments to the next place as crimson. Embrace a legend and trendline.

Add a depend for improved and worsened on the earlier chart. Additionally present me on the chart on common, how a lot did rankings enhance or decline

Take away the averages as they’re. I would like the general common change in rating place as one quantity.

Transfer the common to the suitable facet of the chart so it’s readable

Anomalies in the traffic graph denoting major shifts such as algorithm updates or website changes

Use case:

Discover anomalies in time sequence knowledge. On this case, many of the anomalies line up with main web site adjustments and Google algorithm updates.

Knowledge supply:

Export natural visitors graph knowledge from the Overview report in Web site Explorer.

Immediate:

Establish anomalies on this visitors chart

Share of voice between two time points for each tagged group of keywords

Use case:

This tells me if sure tagged teams are doing higher or worse between the dates.

Knowledge supply:

Export knowledge from the Tags report in Rank Tracker.

Immediate:

Present me share of voice over time by tag.

Traffic between two time points for each tagged group of keywords

Use case:

See how visitors modified for every tag between two dates. We now have a greater view for this coming in Rank Tracker that may present the evolution over time.

Knowledge supply:

Just like the earlier one, export knowledge from the Tags report in Rank Tracker.

Immediate:

Present me how visitors is evolving for every tag.

Use case:

See which teams of phrases have probably the most quantity vs the clicks that they’re getting. Excessive complete quantity and low clicks means you’ve gotten so much to work on.