Connect with us
Cloak And Track Your Affiliate Links With Our User-Friendly Link Cloaking Tool, Try It Free

SEO

How to Visualize Ahrefs Data with ChatGPT

Published

on

How to Visualize Ahrefs Data with ChatGPT

SEOs have access to so much data that sometimes, it’s hard to know what to do with it all. I’ve been experimenting with visualizing Ahrefs data using GPT-4, so I thought I’d share the results with you all.

We’ve already launched some AI-enhanced features like search intent, but we made it even better by adding the traffic share for each intent. Check out this write-up from Si Quan for some more things we might add.

For the visualizations, you’ll need GPT-4. There’s an API, but you can also just use ChatGPT Plus for $20 a month. I’m hoping to bring many of these visuals to life within the tool, but these things take time and you can create them now. Let me know your favorites and any other use cases you find that you want to see us add!

IMPORTANT

For all these, export the data in UTF-8 format from the report indicated and run the prompt. Note that your results may differ a bit because of how LLMs work. You may need to ask for some adjustments to get exactly what you want.

Use case:

This allows you to see outliers. If you have some terms ranking better on Desktop vs Mobile, then you might want to look at mobile issues or Core Web Vitals.

You can see both mobile issues and Core Web Vitals in Ahrefs’ Site Audit. You’ll need to run Site Audit as mobile and connect to PageSpeed Insights.

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

Data source:

Download your desktop and mobile rankings from the Overview report in Rank Tracker (remember to choose the UTF-8 format). Upload both files to ChatGPT.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Read these 2 files that contain desktop and mobile keyword rankings.

Show me a scatter plot comparing the desktop and mobile positions for each keyword.

Label ones that have the biggest gap between rankings.

Branded and unbranded organic traffic and volumeBranded and unbranded organic traffic and volume

Use case:

See the breakdown of traffic and total volume by branded and unbranded terms. At a glance, I can see that the majority of our traffic comes from unbranded terms.

Data source:

Download your keyword rankings from the Organic Keywords report in Site Explorer (make sure to select the UTF-8 file format) and upload the file to ChatGPT.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Label each keyword in the “Keyword” column as branded or unbranded. Then create a pie chart that shows the sum of “Current organic traffic” for both categories.

Also create this chart with the sum of “Volume” for each.

Change in traffic for branded and unbranded termsChange in traffic for branded and unbranded terms

Use case:

See if you’re gaining or losing clicks for branded or unbranded terms between two dates. You need to have compare mode enabled for this to work.

Data source:

Like the previous one, download your keyword rankings from the Organic Keywords report in Site Explorer and upload the file.

Prompt:

Label each keyword in the “Keyword” column as branded or unbranded.

Create a visual that shows me how the organic traffic changed overall for branded and unbranded keywords based on the sum of the data for each in the “Organic traffic change” column.

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

Use case:

See the last time competing content was updated. If competitors are updating their content a lot, it can indicate a more competitive market.

Data source:

Enter a competitor’s website into Content Explorer and export the list of pages (choose UTF-8 as the export format). This can also be done with a keyword or topic.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Show me how many days since the content was updated.

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

Use case:

See how long backlinks were live on average. If you’re losing a lot of backlinks early, you may want to look into the reasons why. Read our study on link rot to see many of the common reasons.

You can filter the Backlinks report for many of the common reasons why links are lost.

Backlinks filters for the reason they're lostBacklinks filters for the reason they're lost

Data source:

Export your link profile from the Backlinks report in Site Explorer (choose UTF-8 as the file format). Upload this to ChatGPT.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Read this file and give me a histogram to show the distribution of backlink lifespans.

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

Use case:

See any seasonal patterns for your acquired links. Here, I see a big spike in the middle of 2022 and what seems to be a bit of a spike in November the last few years.

Data source:

Like the previous one, export your link profile from the Backlinks report in Site Explorer. Upload this to ChatGPT.

Prompt:

Look for seasonal patterns in backlink acquisition.

If you’d prefer a heatmap like the one below, use this prompt instead:

Analyze patterns in link acquisition (e.g., weekdays vs. weekends, monthly trends) using line charts or heatmaps to identify when most backlinks are acquired.

Heatmap showing days and weeks when the site got more linksHeatmap showing days and weeks when the site got more links

Share of voice for each tag group and measured against competitorsShare of voice for each tag group and measured against competitors

Use case:

See which tag groups are strong or weak vs competitors. I can quickly see we dominate for things like link building, but we’re weak for the terms in our general marketing bucket, probably because we mostly focus on SEO.

Data source:

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

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Show me share of voice by tag and split it by competitor as well.

Forecasted time series data for organic trafficForecasted time series data for organic traffic

Use case:

Forecasting traffic or other metrics forward. This is great for getting buy-in.

Data source:

Export graph data from the Overview report in Site Explorer. You can choose any time-series graph you like (organic traffic, referring domains, etc.)

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Forecast this time series data forward one year

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

Long story short on this one. I had a version that wasn’t as good as what Marie Haynes came up with, but I added to her visualization to make it even better.

Use case:

The chart visualizes winners/losers for keyword rankings and shows me overall if I’m doing better or worse. From this image, I can see that more keywords overall are ranking worse, but overall rankings are up, so the positive ones moved up a lot more than the negative ones lost.

Data source:

Download your keyword rankings from the Organic Keywords report in Site Explorer and upload the file.

Prompt:

I used multiple prompts to get the final chart, but they might be able to be simplified into one.

Show me a scatter plot that shows the changes from the previous position and the current position. Include changes to a lower position as green and changes to a higher position as red. Include a legend and trendline.

Add a count for improved and worsened on the previous chart. Also show me on the chart on average, how much did rankings improve or decline

Remove the averages as they are. I want the overall average change in ranking position as one number.

Move the average to the right side of the chart so it’s readable

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

Use case:

Find anomalies in time series data. In this case, most of the anomalies line up with major website changes and Google algorithm updates.

Data source:

Export organic traffic graph data from the Overview report in Site Explorer.

1707348373 914 How to Visualize Ahrefs Data with ChatGPT1707348373 914 How to Visualize Ahrefs Data with ChatGPT

Prompt:

Identify anomalies in this traffic chart

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

Use case:

This tells me if certain tagged groups are doing better or worse between the dates.

Data source:

Export data from the Tags report in Rank Tracker.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Show me share of voice over time by tag.

Traffic between two time points for each tagged group of keywordsTraffic between two time points for each tagged group of keywords

Use case:

See how traffic changed for each tag between two dates. We have a better view for this coming in Rank Tracker that will show the evolution over time.

Data source:

Like the previous one, export data from the Tags report in Rank Tracker.

Prompt:

Show me how traffic is evolving for each tag.

Search volume and clicks by tagSearch volume and clicks by tag

Use case:

See which groups of terms have the most volume vs the clicks that they’re getting. High total volume and low clicks means you have a lot to work on.

Data source:

Export keywords from the Overview report in Rank Tracker. (You can choose between desktop or mobile ranking data with the toggle).

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Visualize search volume and clicks by tag.

Most common SERP features for you and competitorsMost common SERP features for you and competitors

Use case:

Shows common SERP features for you and competitors that you may want to target. If certain schema markup is required but you’re not using it, it can lead to an easy win.

You may also have an issue with your schema markup. Ahrefs’ Site Audit validates against both schema.org and Google standards.

Structured data validation in Ahrefs' Site AuditStructured data validation in Ahrefs' Site Audit

Data source:

Export the data from the Content Gap report in our Competitive Analysis tool.

Exporting the data from AhrefsExporting the data from Ahrefs

Prompt:

Show me which SERP features are most common.

Sidenote.

I would probably adjust this prompt to split them out into individual features rather than feature groups.

Final thoughts

I hope this has sparked some ideas for other SEOs out there. I want to see what you all will create.

Have a cool idea you want to share? Let me know on X or LinkedIn.



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

SEO

Google Gives Exact Reason Why Negative SEO Doesn’t Work

Published

on

By

Google explains negative seo

Google’s Gary Illyes answered a question about negative SEO provides useful insights into the technical details of how Google prevents low quality spam links from affecting normal websites.

The answer about negative SEO was given in an interview in May and has gone unnoticed until now.

Negative SEO

Negative SEO is the practice of sabotaging a competitor with an avalanche of low quality links. The idea is that Google will assume that the competitor is spamming and knock them out of the search engine results pages (SERPs).

The practice of negative SEO originated in the online gambling space where the rewards for top ranking are high and the competition is fierce. I first heard of it around the mid-2000s (probably before 2010) when someone involved in the gambling space told me about it.

Virtually all websites that rank for meaningful search queries attract low quality links and there is nothing unusual about, it’s always been this way. The concept of negative SEO became more prominent after the Penguin link spam update caused site owners to become more aware of the state of their inbound links.

Does Negative SEO Cause Harm?

The person interviewing Gary Illyes was taking questions from the audience.

She asked:

“Does negative SEO via spammy link building, a competitor throwing tens of thousands of links at another competitor, does that kind of thing still harm people or has Google kind of pushed that off to the side?

Google’s Gary Illyes answered the question by first asking the interviewer if she remembered the Penguin update to which she answered yes.

He then explained his experience reviewing examples of negative SEO that site owners and SEOs had sent him. He said that out of hundreds of cases he reviewed there was only one case that might have actually been negative SEO but that the web spam team wasn’t 100% sure.

Gary explained:

“Around the time we released Penguin, there was tons and tons of tons of complaints about negative SEO, specifically link based negative SEO and then very un-smartly, I requested examples like show me examples, like show me how it works and show me that it worked.

And then I got hundreds, literally hundreds of examples of alleged negative SEO and all of them were not negative SEO. It was always something that was so far away from negative SEO that I didn’t even bother looking further, except one that I sent to the web spam team for double checking and that we haven’t made up our mind about it, but it could have been negative SEO.

With this, I want to say that the fear about negative SEO is much bigger than or much larger than it needs to be, we disable insane numbers of links…”

The above is Gary’s experience of negative SEO. Next he explains the exact reason why “negative SEO links” have no effect.

Links From Irrelevant Topics Are Not Counted

At about the 30 minute mark of the interview, Gary confirmed something interesting about how links evaluated that is important to understand. Google has, for a very long time, examined the context of the site that’s linking out to match it to the site that’s being linked to, and if they don’t match up then Google wouldn’t pass the PageRank signal.

Gary continued his answer:

“If you see links from completely irrelevant sites, be that p–n sites or or pure spam sites or whatever, you can safely assume that we disabled the links from those sites because, one of the things is that we try to match the the topic of the target page plus whoever is linking out, and if they don’t match then why on Earth would we use those links?

Like for example if someone is linking to your flower page from a Canadian casino that sells Viagra without prescription, then why would we trust that link?

I would say that I would not worry about it. Like, find something else to worry about.”

Google Matches Topics From Page To Page

There was a time, in the early days of SEO, when thousands of links from non-matching topics could boost a site to the top of Google’s search results.  Some link builders used to offer “free” traffic counter widgets to universities that when placed in the footer would contain a link back to their client sites and they used to work. But Google tightened up on those kinds of links.

What Gary said about links having to be relevant matches up with what link builders have known for at least twenty years. The concept of off topic links not being counted by Google was understood way in the days when people did reciprocal links.

Although I can’t remember everything every Googler has ever said about negative SEO, this seems to be one of the rare occasions that a Googler offered a detailed reason why negative SEO doesn’t work.

Watch Gary Illyes answer the question at the 26 minute mark:

Featured Image by Shutterstock/MDV Edwards

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

What Are The Best Resources To Learn SEO?

Published

on

By

What Are The Best Resources To Learn SEO?

This week’s Ask An SEO question comes from Nicolò, who asks:

“What are the best resources to learn SEO and who are the best people to follow online for good advice?”

This is a great question that goes to the heart of what a lot of people struggle with when learning SEO. There is a lot of information online.

There are a lot of SEO “experts.”

Often, there is a lot of contradictory advice.

So, how do you sort the truth from the fiction – the opinionated from the experienced?

People To Follow

The issue in the SEO industry is that we are often left in the dark. Google and the other search engines offer us morsels of information, and we run wild with speculation.

Unfortunately, this can then become “fact.”

The rumor spreads. Pretty soon, you’ll hear it discussed in agency pitches and incorporated into brand strategies, all without it being properly questioned.

Finding the truth amid all of this noise can be tricky. Essentially, you are asking me, “Who and what can I trust?”

Really, the answer is to find SEO pros to learn from who are constantly testing their own assumptions.

I’m not going to list names here. I don’t want to risk putting you off following an SEO on social media purely because I haven’t included them in my list.

There are a lot of highly accomplished SEO pros who I don’t know.

Instead, I’ll suggest some ways of identifying those people who are digging into SEO and drawing conclusions from data.

Conferences And Publications

Start by attending SEO conferences and taking note of the speakers who are bringing something new to the table.

These are the people who are conducting experiments or backing up their claims with their own case studies.

Similarly, look for authors writing in reputable SEO publications – like Search Engine Journal – read their work and follow those constantly looking to question conventional wisdom and prove or disprove it with data.

Conference organizers and publication owners perform a certain level of due diligence, which means you are a little bit safer following the people they have chosen to showcase than following strangers on the internet.

Follow Who They Follow

A good next step to expand your list is to look at who the people you identified above follow.

If the same names pop up on the social media profiles of these conference speakers and article writers, you can be reassured that they are bringing useful insight to the platform.

Try to identify who they are discussing SEO with on social media. Snoop on those conversations and see who your trusted list of people to follow are also having informed discourse with.

It’s okay, too, if the SEO professionals you follow do not necessarily agree with what’s being said by the other people, as long as those other people are bringing rational, data-backed opinions. Sometimes, we learn best through hearing both sides of an argument!

Ask For Recommendations

It’s also perfectly acceptable to ask for recommendations of who to follow online like this Reddit user did.

To avoid getting back the same small list of famous SEO professionals each time, consider reaching out to some of your “trusted” SEO pros from the list above and ask them who they would recommend for specific areas of SEO.

For example, are you looking to learn more about local SEO or ecommerce SEO?

Ask for recommendations of who they would turn to if they had a question in that field.

Be Part Of The Discussion

SEO is constantly evolving, and no single SEO expert has all the answers. We learn from each other and from discussing ideas and opinions.

It’s never too early in your career to take part in those discussions.

Join In The Conversation

Look for conversations that are happening on SEO topics and join in the discussions. For example, @MordyOberstein’s #SEOChat over on X or the Google Search Central Help Community 

Try some of the Reddit subreddits about SEO, like r/TechSEO and r/bigseo. There will be a lot of discussions (I mean arguments, really) that will give you some quick insight into what practicing SEO pros make of particular ideas or approaches.

You can simply read through questions and replies, or you can take part. Give your own thoughts and ask for critiques and opinions. Engaging in discourse and learning from others can help you to sharpen your knowledge.

Start A Conversation

Perhaps, if you’re feeling brave, you can start your own conversations in these forums.

There is always the risk that you might be met with answers by people who haven’t really practiced SEO that much. The great/awful thing about the internet, however, is there are always people waiting in the wings to argue and say an opinion isn’t valid!

Ask a specific question and crowd-source the answer. Wait for the arguments to be presented and countered, then use it as an opportunity to learn how to validate others’ SEO opinions.

Conferences And Meet-ups

As already mentioned above, seeing who is speaking at events can give you an idea of some reputable people to follow, but let’s explore that a bit more.

Learn Something New

Something I recommend to SEO pros, both experienced and new, is to attend SEO talks that don’t interest them. That might seem counterintuitive, but it can actually be extremely eye-opening.

The chances are that the aspects of SEO you find exciting are the ones you will actively seek to learn more about.

If you are interested in the technical side of SEO, you will likely look for talks on cutting-edge experiments, advances in load speed and rendering, or case studies about complicated migrations.

But you possibly already know a lot about that as you are already interested in it. Every once in a while, set out to attend the talk you are least interested in.

If you are a digital PR at heart, attend a tech talk or two. If you are an in-house SEO, attend a talk about client management.

By doing this, you have a high chance of learning something completely new that will enhance or complement your existing skill set. For example, the in-house SEO will be able to apply skills discussed in the agency talk to their own stakeholder management issues.

Some good conferences to start with include BrightonSEO (Brighton, UK, and San Diego), WTSFest (Philadelphia, London, Berlin), MnSearch Summit.

Read more: The Best SEO Conferences For 2024-2025

Look Outside Of SEO

A good way to expand your knowledge of SEO is to not just attend SEO conferences. Go to events where a more holistic digital marketing approach is spoken about.

Or, if you are feeling really inclined, go to one that discusses adjacent disciplines like PPC and email marketing. This way, you may well learn more about the context of SEO in the digital landscape and how to better implement it within a complicated marketing system.

There are several specialist conferences that cover marketing subjects like paid media, social media and content marketing available, including ADWorld Experience, Hero Conf, and Content Marketing World.

There are also large multi-discipline conferences that cover a wide range of digital marketing topics, including Moz Con, State of Search, INBOUND, and the Growth Marketing Summit.

Go To Panels

A conference talk is, by design, very one-sided (heckling aside!). The speaker presents the material how they want to and goes into as much depth as they feel appropriate.

Due to this, you don’t have any opportunity to hear other peoples’ views on the subject or even their challenges to the assertions made.

Panels, however, are more collaborative and discussion-focused. Many events that have traditional workshop or presentation formats will also have the occasional panel or fireside chat.

These are your opportunities to hear the views of multiple SEO pros, perhaps even disagreements on a subject.

Listening to more than one view of a topic will help you discern what you agree or disagree with and ultimately form your own opinion. It is a good way of preventing yourself from just agreeing with whoever you have heard speak on the subject most recently.

Participate In Webinar Q&As

Webinar question and answer sessions are another way to hear multiple SEO pros give their opinions on a topic. They will also allow you to ask your own questions to the participants.

For example, the Good Signals “SEO Office Hours” webinar hosted by Michael Chidzey and Jo Juliana Turnbull is a weekly webinar that allows viewers to submit their questions in advance or ask questions during the event itself.

Then, a panel of SEO practitioners will discuss their thoughts on the questions.

Similarly, if you want to hear directly from the horse’s mouth, you can participate in Google’s “SEO Office Hoursasking your questions directly to Googlers from the Search Quality team.

Read more: Top 17 SEO Podcasts For 2024

Communities

Many communities have been set up to help with learning SEO. Some are region – or demographic-specific to help with more nuanced questions or support those traditionally less supported in the industry.

These communities are designed to facilitate a safe space to ask questions and get answers from others in the industry.

This sort of networking isn’t just useful for increasing your practical knowledge of SEO, they can also help with job opportunities. There are a lot available but here is a selection:

Location-specific Meetups include:

Create Your Own

If there isn’t a community that serves your specific need, or you’d prefer something smaller, consider creating your own.

It could start off as regular meet-ups at local cafés where you get to know other SEO pros in your area.

Or perhaps, an online call once a month where you can just bring questions to each other.

Maybe you have met some other SEO pros you feel you could learn from. You might be able to invite them to participate in a Slack or WhatsApp group.

Create A Forum

Another way to create a community that uses existing infrastructure and is, therefore, much easier to create is through Reddit or other forums.

You could set up a “subreddit” for a particular aspect of SEO and share it on other SEO subreddits. That way, you can encourage a much wider range of people to participate without you needing to know and invite them all personally.

Resources

To finish, let’s return to the question I discerned at the beginning: “Who and what can I trust?” There are already a lot of resources online about SEO, some less helpful than others!

Newsletters

Other than online blogs like Search Engine Journal, there are newsletters that can round up breaking industry news and case studies.

For example, Aleyda Solis’s “SEOFOMO Newsletter” sends a weekly summary of interesting articles and webinars from the SEO industry.

Nikki Halliwell’s “Tech SEO Tips newsletter” offers news and tips designed to help solidify your tech SEO knowledge.

Tom Critchlow’s “SEO MBA” newsletter focuses on the career and management side of SEO.

Women in Tech SEO also has a newsletter for everyone in the industry to learn SEO from, summarising interesting articles that have been recently released.

Training Courses

There are a lot of SEO training courses out there, paid and free.

Some that have been highly recommended to me in the past are the Hubspot Academy, Semrush Academy, BrightLocal Academy, Blue Array Academy, and the BrightonSEO short courses.

Sometimes, though, you may want to go more in-depth into new areas of SEO. Perhaps you don’t really know where your skills gaps lie. For this, I would strongly recommend looking at Aleyda Solis’s LearningSEO.io.

It is a free and highly comprehensive roadmap of SEO concepts. It runs from beginner to advanced, with reliable free resources accompanying each.

Summary

There is a lot of information about SEO online. It’s an ever-evolving subject and that means more content will be produced on it all the time.

With that amount of information available, it can be overwhelming to know who or what to trust.

Use the suggestions and resources above to start to curate your own list of trustworthy material and people to learn from. That way, you can keep expanding your knowledge in a safe and helpful way.

More resources: 


Featured Image: Paulo Bobita/Search Engine Journal

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

SEO

You Don’t Need Robots.txt On Root Domain, Says Google

Published

on

By

Search Engine Spider Web Crawler Bot concept.

Google’s Gary Illyes shares an unconventional but valid method for centralizing robots.txt rules on CDNs.

  • Robots.txt files can be centralized on CDNs, not just root domains.
  • Websites can redirect robots.txt from main domain to CDN.
  • This unorthodox approach complies with updated standards.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending