Advanced Data Analysis, formerly known as Code Interpreter, is an official OpenAI plugin that uses Python to allow for file uploads and downloads. It’s available to ChatGPT Plus and Enterprise users as a beta feature.
This plugin is a big deal for SEO professionals. As someone who has been using Python for years to help with data analysis and automation, this essentially rules a lot of my code defunct – but in a good way.
This enables us to tap into the latest and greatest AI technology to help us analyze large files much faster.
How to access Advanced Data Analysis on ChatGPT
ChatGPT Advanced Data Analysis is only available to paying customers using ChatGPT Plus or Enterprise. (If have not yet subscribed, trust me, it’s worth it!)
To get started with it, here are the steps to access the Advanced Data Analysis plug-in:
Step 1: Log in to ChatGPT and select Settings & Beta.
Step 2: Select Beta features in the submenu and activate Advanced Data Analysis. (This is also a good opportunity to activate Plugins and explore those.)
Step 3: Start a new chat and hover over the option for GPT-4, and you’ll see a menu appear with the option to select Advanced Data Analysis.
Step 4: Once you’ve selected Advanced Data Analysis, you should see a plus button on the left of the input box, allowing you to upload files. From here, you’re all set to get started.
Get the daily newsletter search marketers rely on.
5 ways to use Advanced Data Analysis for SEO
The possibilities for this new feature are still being explored, so I encourage you to explore and share with the world what you find.
Below are some ways I’ve gotten immediate value from this new feature.
- Visualize internal linking
- Perform server log analysis
- Identify themes in keywords
- Optimize titles and meta descriptions
- Automate redirect mapping
1. Visualize internal linking on a website
With the plugin, you can take your tracked internal link data and let AI do its thing.
You can have it create visuals or even point out opportunities that you’re missing.
The prompt to use
Your file can be formatted however you want. ChatGPT is pretty good at interpreting your column headers, but you can provide additional clarification.
Below is my recommended starting prompt.
Make sure you’ve uploaded your internal link file, and let it run!
The results
When asking for multiple charts, I like to have ChatGPT’s Advanced Data Analysis export the results in an HTML file with the ability to hover. This makes it easy to really customize for reporting screenshots.
Here are some examples of visualizations you can get from this prompt. Internal linking heatmap
This chart lets us quickly identify pages that could link to other pages. The chart is set up as follows:
- The x-axis represents the destination pages.
- The y-axis represents the source pages.
- The color intensity represents the number of links between pages.
That light yellow color on the right shows several spots for internal link opportunities.
Link placement distribution
This chart is relatively easy to break down. It simply shows where the majority of your internal links are.
I tested this on my personal site, so it’s really small, which is why the navigation is the majority.
On larger sites, you may want to flip that to have the content section be the most link dense.
Most common anchor text
This can easily be done by downloading your Screaming Frog report and running a pivot table. But it’s cool to see ChatGPT able to generate similar charts like this.
Relationship between anchor text and link placement
We want to see our more valuable keywords as anchor text within the content section. This can help point that out.
2. Perform server log analysis
There are several tools on the market to help monitor server log analysis, many of them freemium.
Using ChatGPT’s Advanced Data Analysis enables you to bypass many of the limits of the freemium tools and generate charts.
This technique can help investigate how Google is crawling your site and what their experience may be like.
The prompt to use
The results
Hits over time
This chart helps illustrate how many times Google crawls your website over time.
Additionally, I added a separation to show status 200 hits versus non-200 hits. (You can request ChatGPT to change the colors if they’re too similar.)
Top hit pages
This chart shows the top 20 pages crawled by Google on the site during the time period.
Get the daily newsletter search marketers rely on.
3. Identify themes in keyword research
I’ve written about this before using Python to identify keyword themes.
However, using Advanced Data Analysis removes many complex elements and makes it more user-friendly.
This process helps quickly analyze large sets of keywords, highlight recurring themes, and even group keywords into similar topic clusters.
The prompt to use
If you have several thousand keywords in your list, you may need to warn ChatGPT and ask it to implement error-handling procedures to prevent memory-limit errors.
The results
I took a sample list of 6,257 keywords and ran it through ChatGPT several times. ChatGPT struggled to process the larger list due to memory limits.
But because I gave it a heads-up, it was able to set up the necessary data batching required to get through the list. It even named the clusters for me.
Dig deeper: How to use ChatGPT for keyword research (with actual prompts)
4. Optimize title tags and meta descriptions
AI can be your friend if you run a large site and need to optimize title tags and meta descriptions in bulk.
Yes, doing them manually will ensure better quality, but if you need a quick fix, this may be your solution.
This can help specifically when you have titles and meta descriptions that may be too long or too short.
The prompt to use
The results
ChatGPT was able to work quickly and create an optimized CSV export for me.
5. Automate redirect mapping
How annoying are redirect maps? Important, yes, but so tedious.
What if we could automate the process to get 60% of the way there?
By tapping into ChatGPT, we can help automate the redirect map process.
Now a huge downside here is that ChatGPT can’t crawl webpages without using a plugin. Right now, we cannot combine plugins and the Advanced Data Analysis.
We’ll have ChatGPT look at the URL slugs to map the pages to get around this.
The prompt to use
The results
Making SEO analysis more straightforward with ChatGPT
The future’s looking pretty bright for SEOs leveraging AI.
We’re on the brink of a new era where AI isn’t just some fancy tool but a game-changer, making our jobs much easier.
Sure, we’re just getting started, but from where I’m standing, the view’s pretty amazing.
Contributing authors are invited to create content for Search Engine Land and are chosen for their expertise and contribution to the search community. Our contributors work under the oversight of the editorial staff and contributions are checked for quality and relevance to our readers. The opinions they express are their own.
