Google Search Console Report Prompt

Google Search Console Report Prompt

Date
May 19, 2025
Size

Source
Tags
SEO

This report generates various reports like top keywords, losing keywords, emerging keywords and also suggest topics to write next.

To make this work first you need to export your Google Search Console Data as follows;

  • Go to your Google search console property
  • Go to performance tab and select your time period i.e. 6 months, 28 days and so on
  • then click on export and select .CSV format.
  • Now you will get ZIP file, extract the same and upload all file to chatgpt.

Then all you need to do is paste the following prompt;

Create a report based on the attached Google Search Console Files. Start with heading Search report for {domain} replace with the domain name. First provide summary from all the profiles in summary section (h2), then create report page in html, css, js with beautiful colorful charts and include charts  for the following scenario;

1. Traffic from top countries with clicks and impressions
2. Top Traffic Keyword (High Impression, High Clicks)
3. Top Ranking Keywords (High Position)
4. Emerging Keywords with Position (High Impressions, Low clicks <10)
5. Keywords with Zero Clicks (0 Click keywords)
6. Traffic Change (Line chart date wise)
7. for Top Devices 
8. Search Appearance (Snippers etc)

After you're done generating HTML Report, then come back to the chat and Then provide key takeaways on which keywords or pages we need to improve with url/keyword. also provide table of topics to cover next based on the  the data with meta title and meta description as well. Be direct, dont provide anything but as instructed, you are SEO expert, therefore, be critical while providing the output data.

Here’s Sample output of HTML report generated;

image