SEOs have entry to a lot information that it may be arduous to know what to do with all of it. I have been experimenting with visualizing Ahrefs information utilizing GPT-4 and want to share my outcomes with you.
We have already launched some AI-powered options, corresponding to search intents, and we have made it even higher by including visitors share for every intent. See this text by Si Quan for what you possibly can add.
Visualization requires GPT-4. There’s an API, however you may as well use ChatGPT Plus for $20 monthly. We wish to obtain many of those visuals inside our instruments, which can take time, however you possibly can create them now. If you happen to see your favorites or different use circumstances you need us so as to add, please tell us.
essential
For all of those, export the info from the indicated report in UTF-8 format and run the prompts. Please notice that outcomes might fluctuate barely as a result of manner LLM works. Chances are you’ll have to make some changes to get the outcomes you need.
Use case:
This lets you see outliers. If there are any phrases that rank larger within the desktop vs. cell comparability, chances are you’ll be questioning about cell points or Core web vitals.
Ahrefs’ site audit allows you to check both mobile issues and Core Web Vitals. Site Audit must run as mobile and connect to PageSpeed Insights.
Information source:
Download desktop and mobile rankings from the overview report. Rank Tracker (remember to choose UTF-8 format). Upload both files to ChatGPT.
prompt:
Read two files containing desktop and mobile keyword rankings.
Show me a scatter plot that compares desktop and mobile rankings for each keyword.
Label the one with the largest difference between rankings.
Use case:
View the breakdown of visitors and complete quantity as follows: Branded and unbranded terms. At first glance, you can see that the majority of your traffic comes from unbranded terms.
Information source:
Download keyword rankings from the organic keyword report. Site Explorer (make sure to select the UTF-8 file format) and upload the file to ChatGPT.
prompt:
Label each keyword in the Keyword column as branded or unbranded. Next, create a pie chart that shows the total Current Organic Traffic for both categories.
We will also create this graph that sums up the “volume” of each.
Use case:
See if clicks for branded or unbranded phrases are growing or reducing between two dates. Examine mode should be enabled for this to work.
Info supply:
Much like the earlier report, obtain the key phrase rankings from the Natural Key phrases report. Open Site Explorer and upload your file.
prompt:
Label each keyword in the Keyword column as branded or unbranded.
Create a visual that shows how organic traffic for branded and unbranded keywords has changed overall, based on the sum of each data in the Organic Traffic Change column.
Use case:
See when the conflicting content material was final up to date. In case your rivals are updating their content material continuously, it might be an indication that the market is turning into extra aggressive.
Info supply:
Enter your competitor’s web site Export the list of pages using Content Explorer (select UTF-8 as the export format). This can also be done using keywords or topics.
prompt:
Displays the number of days since the content was updated.
Use case:
See how long your backlinks lived on average. If you’re losing a lot of backlinks early on, you might want to find out why.read Our research into link rot reveals many of the common reasons.
You can filter your backlink report based on many of the common reasons why links are lost.
Information source:
Export your link profile from the Backlinks report in Site Explorer (select UTF-8 as the file format). Upload this to ChatGPT.
prompt:
Read this file and give me a histogram showing the distribution of backlink lifetimes.
Use case:
Test for seasonal patterns within the hyperlinks you get. Right here we see a giant spike in mid-2022, and in previous years he appears to have slightly little bit of a spike in November.
Info supply:
As earlier than, export your hyperlink profile from the Backlinks report in Web site Explorer. Add this to ChatGPT.
immediate:
Search for seasonal patterns in backlink acquisition.
If you wish to use a heatmap just like the one under, use this immediate as a substitute.
Use line graphs and heatmaps to investigate hyperlink acquisition patterns (e.g., weekdays vs. weekends, month-to-month tendencies) to find out when backlinks are acquired essentially the most.
Use case:
See which tag teams are robust or weak in opposition to your rivals. You may rapidly see that we’re nice relating to issues like hyperlink constructing, however we’re weak relating to common advertising terminology. Most likely as a result of he primarily focuses on search engine optimization.
Info supply:
Rank Tracker Opponents – Export information from tag reviews (utilizing UTF-8 format).
immediate:
View share of testimonials by tags and likewise break up by rivals.
Use case:
Forecast visitors or different metrics into the longer term. That is nice for getting buy-in.
Aspect notice.
This has failed with massive datasets and a number of rivals, however you possibly can all the time use my dataset. The same goes for SEO prediction scripts for this.
Information source:
Export chart data from the Site Explorer Overview report. You can choose any time series graph (organic traffic, referring domains, etc.).
prompt:
Forecast this time series data one year ahead
I will clarify this briefly.The model I had wasn’t that good Marie Haynes came up withhowever I added to her visualization to make it even higher.
Use case:
This graph visualizes key phrase rating winners and losers and exhibits whether or not you are doing effectively or poorly total. From this picture, you possibly can see that total extra key phrases are shedding rankings, however the total rankings are going up, so constructive key phrases rank way over unfavourable key phrases. I am elevating it.
Info supply:
Obtain key phrase rankings from the natural key phrase report. Open Site Explorer and upload your file.
prompt:
I used multiple prompts to get the final graph, but it could be simplified to one.
Displays a scatter plot showing the change from the previous position and the current position. Changes to lower positions are included as green and changes to higher positions are included as red. Include a legend and trendline.
Add improvement and deterioration counts to the previous graph.It also shows you in a graph how much your ranking improved or decreased on average
Delete the average value as is. I would like the average overall ranking change to be a single number.
Move the average to the right side of the graph for easier reading
Use case:
Discover anomalies in time collection information. On this case, a lot of the anomalies coincide with main modifications to the web site; Google algorithm update.
Information source:
Export organic traffic graph data from the Site Explorer Overview report.
prompt:
Identify anomalies with this traffic chart
Use case:
This may inform you whether or not a selected tagged group is performing effectively or poorly between dates.
Info supply:
Export information from Rank Tracker tag reviews.
immediate:
See audio share over time for every tag.
Use case:
See how visitors for every tag modified between two dates. You may get a greater take a look at this in our rank tracker, which exhibits our evolution over time.
Info supply:
Much like the earlier one, export information from the Rank Tracker tag report.
immediate:
Reveals how the visitors for every tag is altering.
Use case:
See which time period teams have essentially the most quantity and get essentially the most clicks. Excessive quantity and low clicks means there’s lots to do.
Info supply:
Export key phrases from the Rank Tracker abstract report. (You’ll be able to choose desktop or cell rating information with the toggle).
immediate:
Visualize search quantity and variety of clicks for every tag.
Use case:
Point out widespread SERP options between you and your rivals that you simply would possibly goal.If you happen to’re positive If you need schema markup but aren’t using it, you could be on the hook for a cakewalk.
There may also be a problem with your schema markup. Ahrefs’ site audits validate against both schema.org and Google standards.
Information source:
Export data from the Competitive Analysis Tool’s Content Gap Report.
prompt:
What are the most common SERP features?
Side note.
I would probably adjust this prompt to break it up into individual features rather than feature groups.
final thoughts
I hope this inspired other SEO ideas. I’d love to see what you all make.
Have a great idea you’d like to share? Let us know X or linkedin.
