SEOs have entry to a lot knowledge that generally, it’s laborious to know what to do with all of it. I’ve been experimenting with visualizing Ahrefs knowledge utilizing GPT-4, so I assumed 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’d add.
For the visualizations, you’ll want GPT-4. There’s an API, however you may as well simply use ChatGPT Plus for $20 a month. I’m hoping to carry many of those visuals to life throughout the device, however these items take time and you’ll create them now. Let me know your favorites and another use circumstances you discover that you just wish to see us add!
IMPORTANT
For all these, export the information in UTF-8 format from the report indicated and run the immediate. Be aware that your outcomes might differ a bit due to how LLMs work. It’s possible you’ll have to ask for some changes to get precisely what you need.
Use case:
This lets you see outliers. You probably have some phrases rating higher on Desktop vs Cellular, then you definately would possibly wish to have a look at cell points or Core Net Vitals.
You’ll be able to see each cell points and Core Net Vitals in Ahrefs’ Website Audit. You’ll have to run Website Audit as cell and connect with PageSpeed Insights.
Knowledge supply:
Obtain your desktop and cell rankings from the Overview report in Rank Tracker (bear in mind to decide on the UTF-8 format). Add each recordsdata to ChatGPT.
Immediate:
Learn these 2 recordsdata that comprise desktop and cell key phrase rankings.
Present me a scatter plot evaluating the desktop and cell positions for every key phrase.
Label ones which have the most important hole between rankings.
Use case:
See the breakdown of visitors and whole 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 Website Explorer (be certain that to pick 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.
Use case:
See in case you’re gaining or shedding clicks for branded or unbranded phrases between two dates. You have 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 Website 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 total for branded and unbranded key phrases based mostly on the sum of the information for every within the “Natural visitors change” column.
Use case:
See the final time competing content material was up to date. If rivals are updating their content material loads, it may possibly point out a extra aggressive market.
Knowledge supply:
Enter a competitor’s web site into Content material Explorer and export the listing of pages (select UTF-8 because the export format). This can be finished 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. If you happen to’re shedding plenty of backlinks early, chances are you’ll wish to look into the the reason why. Learn our examine on hyperlink rot to see most of the widespread causes.
You’ll be able to filter the Backlinks report for most of the widespread the reason why hyperlinks are misplaced.
Knowledge supply:
Export your hyperlink profile from the Backlinks report in Website Explorer (select UTF-8 because the file format). Add this to ChatGPT.
Immediate:
Learn this file and provides me a histogram to indicate the distribution of backlink lifespans.
Use case:
See any seasonal patterns on 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 Website Explorer. Add this to ChatGPT.
Immediate:
Search for seasonal patterns in backlink acquisition.
If you happen to’d desire 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 developments) utilizing line charts or heatmaps to determine when most backlinks are acquired.
Use case:
See which tag teams are sturdy or weak vs rivals. I can shortly see we dominate for issues like hyperlink constructing, however we’re weak for the phrases in our normal advertising bucket, most likely as a result of we largely concentrate on web optimization.
Knowledge supply:
Export the information from the Rivals – Tags report in Rank Tracker (use UTF-8 format).
Immediate:
Present me share of voice by tag and break up it by competitor as properly.
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 may at all times use my web optimization forecasting scripts for this as properly.
Knowledge supply:
Export graph knowledge from the Overview report in Website Explorer. You’ll be able to select any time-series graph you want (natural visitors, referring domains, and so forth.)
Immediate:
Forecast this time sequence knowledge ahead one yr
Lengthy story quick 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 total if I’m doing higher or worse. From this picture, I can see that extra key phrases total are rating worse, however total rankings are up, so the optimistic ones moved up much more than the unfavourable ones misplaced.
Knowledge supply:
Obtain your key phrase rankings from the Natural Key phrases report in Website 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 a better place as crimson. Embrace a legend and trendline.
Add a rely 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 need the general common change in rating place as one quantity.
Transfer the typical to the correct facet of the chart so it’s readable
Use case:
Discover anomalies in time sequence knowledge. On this case, a lot 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 Website Explorer.
Immediate:
Establish anomalies on this visitors chart
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.
Use case:
See how visitors modified for every tag between two dates. Now we 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 whole quantity and low clicks means you have got loads to work on.
Knowledge supply:
Export key phrases from the Overview report in Rank Tracker. (You’ll be able to select between desktop or cell rating knowledge with the toggle).
Immediate:
Visualize search quantity and clicks by tag.
Use case:
Reveals widespread SERP options for you and rivals that you could be wish to goal. If sure schema markup is required however you’re not utilizing it, it may possibly result in a straightforward win.
You may additionally have a problem along with your schema markup. Ahrefs’ Website Audit validates towards each schema.org and Google requirements.
Knowledge supply:
Export the information from the Content material Hole report in our Aggressive Evaluation device.
Immediate:
Present me which SERP options are commonest.
Sidenote.
I’d most likely alter this immediate to separate them out into particular person options somewhat than function teams.
Closing ideas
I hope this has sparked some concepts for different SEOs on the market. I wish to see what you all will create.
Have a cool thought you wish to share? Let me know on X or LinkedIn.