cases for ChatGPT Advanced Data Analysis plugin: 5 SEO use-cases
Advanced Data Analysis (formerly Code Interpreter) is an OpenAI plugin which uses Python for file uploads. As a beta, it’s only available to chatGPT Plus users and Enterprise users.
This plugin is an important tool for SEO experts. This plugin is a game changer for SEO professionals who have been using Python to automate and analyze data for years.
We can now use the most advanced AI technology available to analyze large files faster.
Advanced Data Analysis in ChatGPT
ChatGPT Advanced data analysis is available only to customers who pay for ChatGPT Plus and Enterprise. If you haven’t subscribed yet, I can assure you that it is worth it!
Here are the steps you need to take to get the Advanced Data Analysis Plug-in.
Step 2: Select Settings and Beta.
Step 1: Select beta features from the submenu, and activate Advanced Data Analysis. This is a great time to explore plugins.
Step 2: Start up a new chat, hover over GPT-4 and a menu will appear. Select Advanced Data Analysis.
Step 5: After you have selected Advanced Data Analysis you will see a plus icon on the left side of the input field, which allows you to upload your files. You’re ready to start.
SEO: 5 ways to utilize advanced data analysis
This new feature is still under development, so please explore it and let me know what you discover.
Here are some of the ways that I have benefited from this feature.
- Visualize internal links
- Perform server log analysis
- Keywords can be used to identify themes
- Titles and meta descriptions should be optimized
- Automated redirect mapping
1. Visualize internal links on a site
The plugin allows you to take the data from your internal links and let AI work its magic.
It can create visuals, or point out what you are missing.
Use the prompt
You can format your file however you like. ChatGPT does a good job of interpreting column headers. However, you can clarify them if necessary.
Here is my suggested starting prompt.
The “Uploaded” report tracks all the internal links on my website. Please follow the steps below:
1. Understand the purpose of each column by analyzing them.
2. Create a chart to show additional internal link opportunities
3. Create a relationship graph using the link position column to show where the majority of internal links come from.
4. Create a table showing which links have the most and fewest internal links.
5. Create a chart to show the relationship between anchor texts and how many times they appear as anchor text in an internal link. Use this only for link positions which equal the content.
6. Create a chart that shows how anchor text is related to link position.
“The output should be a HTML file with all this information and the ability to hover the charts to see the tooltips.”
Ensure you have uploaded the internal link file and run it!
The results
ChatGPT Advanced Data Analysis is a great tool for exporting multiple charts in an HTML format with hover. This allows for easy customization when reporting screenshots.
You can see some examples of the visualizations that you get when using this prompt. Heatmap for internal linking
This chart allows us to quickly identify pages which could link to another page. The chart is set out as follows:
- The and axes represent the destination pages.
- The and-axis represent the source pages.
- The intensity of the color represents the number links between pages.
The light yellow color to the right of this image shows several places for internal links.
Link placement distribution
It is easy to understand. This chart simply shows the location of your most important internal links.
The navigation is a majority because I’ve tested it on my own site.
You may wish to reverse this on larger sites so that the content section is the most densely linked.
Most Common Anchor Text
You can do this by downloading the Screaming Frog Report and using a pivot table. It’s impressive to see ChatGPT generate charts similar to this.
Relationship of anchor text with link placement
This will help us to identify the most valuable keywords. This can be used to highlight that.
2. Perform server log analysis
Many of these tools are free.
ChatGPT Advanced Data Analysis allows you to generate charts and bypass the limitations of the freemium tool.
This technique allows you to see how Google crawls your website and what they may experience.
Use the prompt
The log files of my website’s web host are attached. Please follow these steps:
1. Search for any hits that contain “google “.
2. Create a graph that shows the Google crawling of my site. Include a metric to indicate status 200 hits versus non-200 hits.
3. Create a chart to show the pages which are most frequently visited.
4. Tell me which pages get the lowest number of hits on Google .”
The results
Hits Over Time
This graph shows how often Google crawls your site over time.
Also, I separated the status 200 hits from non-200 hits. You can ask ChatGPT to alter the colors, if you feel they are too similar.
Top hit pages
This graph shows the 20 most popular pages that Google crawled on the site over the period.
3. Keyword research: Identifying themes
This is not the first time I have written about using Python for keyword themes.
Advanced Data Analysis simplifies the process by removing many of its complex features.
This method allows you to quickly analyse large sets of keywords. It highlights recurring themes and groups keywords into topic clusters.
Use the prompt
Please find attached a list of search terms and their volume. Please follow these steps:
1. Analyze the entire keyword list.
2. Create a visual display of the results by grouping them into topic groups.
3. List the common themes found in .”
You may need to alert ChatGPT to the fact that you have a list of several thousand keywords and request it to use error-handling mechanisms to avoid memory-limit problems.
The results
I ran a list of 6,257 words through ChatGPT multiple times. ChatGPT was unable to process the longer list due to its memory limitations.
It was able, because I had given it some notice, to create the data batching necessary to go through the list. It named the clusters automatically.
Dig deep: How you can use ChatGPT to research keywords (with actual prompts).
4. Title tags and meta descriptions should be optimized
AI is your best friend if you have a large website and need to optimize meta descriptions and title tags in bulk.
This is a good solution if you want to fix them quickly.
You can use this to help you with titles and meta descriptions which are too long or short.
Use the prompt
“Attached, you will find a list with titles and meta descriptions which need to be optimized.
Please limit the title to 50-65 characters.
Please keep meta descriptions between 150 and 165 characters.
Please export the results to CSV.”
The results
ChatGPT worked quickly to create a CSV export that was optimized for me.
5. Automated redirect mapping
How irritating are redirect maps to you? Yes, they are important, but how tedious!
What if you could automate 60% of the process?
ChatGPT can automate the process of redirecting maps.
ChatGPT cannot crawl pages without a plugin. Plugins and Advanced Data Analysis cannot be combined at this time.
ChatGPT will map pages based on the URL slugs.
Use the prompt
Two lists of URLs are attached. I need assistance creating a map redirecting the old URLs into the new URLs. Use the slug to determine the closest match. Lists may not have the same length. It is important to find an exact match for each URL in the old list. Please export your results to a CSV. The old URLs should be in column A and the corresponding URLs from the new list should appear in column B. Column C should contain the similarity percentage .”
The results
ChatGPT makes SEO analysis easier.
SEOs who use AI to optimize their sites are in for a bright future.
We are on the cusp of a new age where AI isn’t just a fancy tool, but a game changer that will make our jobs easier.
From where I am standing, it’s a pretty incredible view.
The post Five SEO use cases for ChatGPT Advanced Data Analysis plugin first appeared on Search Engine Land.