Thursday, November 7, 2024

Visualize Ahrefs Information with ChatGPT

SEOs have entry to a lot information that typically, it’s onerous to know what to do with all of it. I’ve been experimenting with visualizing Ahrefs information 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 site visitors share for every intent. Take a look at 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 too can simply use ChatGPT Plus for $20 a month. I’m hoping to convey many of those visuals to life throughout the device, however these items take time and you may create them now. Let me know your favorites and some other use circumstances you discover that you simply need to see us add!

IMPORTANT

For all these, export the information in UTF-8 format from the report indicated and run the immediate. Notice that your outcomes might differ a bit due to how LLMs work. You could must 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. When you have some phrases rating higher on Desktop vs Cell, then you definately would possibly need to have a look at cell points or Core Internet Vitals.

You possibly can see each cell points and Core Internet Vitals in Ahrefs’ Web site Audit. You’ll must run Web site Audit as cell and connect with PageSpeed Insights.

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

Information 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 information to ChatGPT.

Exporting the data from Ahrefs

Immediate:

Learn these 2 information 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 largest hole between rankings.

Branded and unbranded organic traffic and volume

Use case:

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

Information supply:

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

Exporting the data from Ahrefs

Immediate:

Label every key phrase within the “Key phrase” column as branded or unbranded. Then create a pie chart that exhibits the sum of “Present natural site 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 dropping clicks for branded or unbranded phrases between two dates. It is advisable have evaluate mode enabled for this to work.

Information 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 exhibits me how the natural site visitors modified total for branded and unbranded key phrases based mostly on the sum of the information for every within the “Natural site 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 loads, it may point out a extra aggressive market.

Information 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 carried out with a key phrase or subject.

Exporting the data from Ahrefs

Immediate:

Present me what number of days for the reason that content material was up to date.

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

Use case:

See how lengthy backlinks had been stay on common. For those who’re dropping lots of backlinks early, you could need to look into the explanation why. Learn our research on hyperlink rot to see lots of the widespread causes.

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

Backlinks filters for the reason they're lost

Information supply:

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

Exporting the data from Ahrefs

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 a giant spike in the course of 2022 and what appears to be a little bit of a spike in November the previous couple of years.

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

For those who’d favor a heatmap just like the one under, use this immediate as a substitute:

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.

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 basic advertising bucket, in all probability as a result of we largely deal with search engine optimisation.

Information supply:

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

Exporting the data from Ahrefs

Immediate:

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

Forecasted time series data for organic traffic

Use case:

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

Information supply:

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

Exporting the data from Ahrefs

Immediate:

Forecast this time sequence information 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 exhibits 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.

Information 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 may be capable to be simplified into one.

Present me a scatter plot that exhibits the adjustments from the earlier place and the present place. Embody adjustments to a decrease place as inexperienced and adjustments to a better place as purple. Embody 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 would like the general common change in rating place as one quantity.

Transfer the common to the correct aspect 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 information. On this case, a lot of the anomalies line up with main web site adjustments and Google algorithm updates.

Information supply:

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

Immediate:

Determine anomalies on this site 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.

Information supply:

Export information from the Tags report in Rank Tracker.

Exporting the data from Ahrefs

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 site visitors modified for every tag between two dates. Now we have a greater view for this coming in Rank Tracker that can present the evolution over time.

Information supply:

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

Immediate:

Present me how site visitors is evolving for every tag.

Search volume and clicks by 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’ve loads to work on.

Information supply:

Export key phrases from the Overview report in Rank Tracker. (You possibly can select between desktop or cell rating information with the toggle).

Exporting the data from Ahrefs

Immediate:

Visualize search quantity and clicks by tag.

Most common SERP features for you and competitors

Use case:

Exhibits widespread SERP options for you and rivals that you could be need to goal. If sure schema markup is required however you’re not utilizing it, it may result in a straightforward win.

You may additionally have a difficulty along with your schema markup. Ahrefs’ Web site Audit validates towards each schema.org and Google requirements.

Structured data validation in Ahrefs' Site Audit

Information supply:

Export the information from the Content material Hole report in our Aggressive Evaluation device.

Exporting the data from Ahrefs

Immediate:

Present me which SERP options are most typical.

Sidenote.

I’d in all probability modify this immediate to separate them out into particular person options relatively than function teams.

Last ideas

I hope this has sparked some concepts for different SEOs on the market. I need to see what you all will create.

Have a cool thought you need to share? Let me know on X or LinkedIn.



Related Articles

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Latest Articles