Analyze SEO keyword data with Claude and Semrush

Step 1: Set up semrush and access keyword data

Sign up to Semrush if you don’t have an account already. You’ll need a paid plan to follow this tutorial (they offer a 7-day free trial).

Navigate to https://www.semrush.com/analytics/keywordoverview/, then enter your target keyword (we'll use "cat food" as an example) and select your audience location.

If your keyword relates to a specific website (like your own), enter your website in the domain field. This will give you a more tailored report with data relevant to your domain.

Click "Search" to generate the keyword overview.

Now, for further analysis we need to export the Keyword analysis report. Click "Export to PDF" in the top right corner to download the report.

Step 2: Analyze key metrics

Upload the downloaded Semrush PDF report on Claude and use this prompt to get a comprehensive overview of your keyword's performance:

Analyze the following metrics from the Semrush keyword report:

1. Search volume
2. Number of results
3. CPC (Cost Per Click)
4. Competition

For each metric:
1. State the value
2. Explain what it indicates about the keyword
3. Identify potential opportunities or challenges for SEO and PPC

Step 3: Visualize top phrase match keywords

To better understand the search landscape around your main keyword, let's visualize the top phrase match keywords:

Using the Phrase Match Keywords data from the Semrush report:
1. Create a simple bar chart showing the search volume for the top 5 phrase match keywords.

2. Briefly analyze the chart, noting:
a) How the search volumes of these related keywords compare to the main keyword
b) What these top phrase match keywords suggest about user search intent

3. Based on this data, suggest one content strategy idea to target these related keywords.

Step 4: Evaluate organic search results

Understanding the current top-ranking content is crucial for SEO strategy:

Examine the Keyword Research: Organic Results section of the report:

1. List the top 5 ranking pages and their URLs
2. Identify common patterns among these top-ranking pages (e.g., content type, domain authority)
3. Suggest 3 specific ways to optimize content to compete for top rankings based on these results
4. Analyze any non-commercial sites in the top results (e.g., Reddit, Quora) and explain their significance

Step 5: Analyze ad copy

While our focus is SEO, understanding the PPC landscape can inform our content strategy:

Review the Keyword Research: Ad Copies section of the report:

1. List all the ad headlines and their corresponding URLs
2. Identify the top 3 themes or selling points emphasized in the ads
3. Suggest 3 ways to incorporate successful ad copy elements into organic content
4. Analyze how competitors are positioning their products/services in these ads

Step 6: Generate comprehensive SEO insights

Finally, let's bring all our analysis together to generate actionable SEO insights and recommendations:

Based on all the data and analysis from the Semrush report, provide:

1. A summary of the 3 most important insights about the keyword and its competitive landscape
2. 5 specific, actionable recommendations for creating and optimizing content to target this keyword
3. 3 potential challenges in ranking for this keyword and strategies to overcome them
4. A suggested content calendar with 5 topic ideas, incorporating the keyword and related terms
5. 3 key performance indicators (KPIs) to track the success of SEO efforts for this keyword

Use these insights to create targeted content, optimize your website, and improve your overall SEO performance. Remember to regularly update your keyword research and adjust your strategy based on new data and trends.

‍

This tutorial was created by Tanmay.