<aside> 🧠

SEO vs PPC analysis Prompt

Objective:

Analyze the relationship between SEO performance (Google Search Console) and PPC performance (Google Ads) to:

📌 Identify high-impression SEO keywords that are underperforming in clicks and suggest running PPC campaigns to capture traffic (only if they have high business value). 📌 Find high-converting PPC keywords where organic rankings are weak and suggest SEO page improvements. 📌 Detect cases where PPC spend is high, but no organic page exists, and recommend creating new SEO pages to reduce reliance on ads.

Step 1: Retrieve and Aggregate Data

1️⃣ From Google Search Console (SEO Data)

• Collect keywords with high impressions but low clicks, but only if they meet business intent criteria.
• Retrieve average ranking position and categorize:
  • Positions 7-20: Close to page 1, minor optimizations can push to top positions (Quick Win).
  • Positions 21-50: Mid-range rankings, needs more content and authority building (Moderate SEO Investment).
  • Positions 51+ but high PPC spend/conversions: Assess if quick SEO fixes could push it into the top 10 before dismissing as a low priority (Long-Term SEO Investment).
• Filter out informational-only keywords unless the business has content marketing goals.
• Extract corresponding landing pages to assess relevance and optimization.

2️⃣ From Google Ads (PPC Data)

• Identify high-spend or high-converting keywords and check organic rankings for the same queries.
• Retrieve total PPC spend, CPC, monthly conversions, and competition level for these keywords.
• Identify landing pages used in PPC campaigns.
• Check if an SEO-optimized page exists or if a new page is needed.
• Ensure PPC suggestions align with customer acquisition goals.

3️⃣ Aggregate Keywords by Product or Page Level

• Group close variants of a keyword (e.g., different ways of phrasing the same intent) into a single product/page-level recommendation.
• Focus on business impact rather than individual keyword variations.

Step 2: Prioritize Recommendations Based on Business Impact

Assign each recommendation a priority level based on:

• PPC Spend & Conversion Volume – Prioritize keywords based on:
  • High PPC Spend: Any keyword with ≥10-15% of total PPC budget.
  • High Monthly Conversions: Keywords with above-average monthly conversions, even if total spend is moderate.
  • High Revenue Impact: Keywords that drive high-value conversions, even if CPC is low or mid-range OR click volume is relatively low. We want to uncover high-performing keywords that can be acted upon with SEO tactics.
• CPC Value – If a keyword has a high CPC in PPC, it’s valuable to rank for organically.
• SEO Rank & Potential – If a page is ranking in positions 7-20, minor optimizations may be enough (Quick Win). If ranking 21-50, more effort needed (Moderate Investment). If 51+ but PPC spend/conversions are high, prioritize SEO fixes if quick wins are possible (Long-Term Investment).
• Click Potential – Estimate potential SEO traffic using SEO Value formula: Organic Clicks x CPC
• Relevance & Landing Page Strength – Evaluate if an existing page is under-optimized or if a new page is required.
• Business Intent Score – Ensure keywords are aligned with conversion intent, not just high impressions.

Step 3: Provide Structured Recommendations

📌 Group 1: Keywords Where PPC Should Be LaunchedThese are high-impression, low-click SEO keywords with high commercial intent.

• Suggest launching Google Ads campaigns to capture clicks.
• Prioritize high-intent, transactional keywords over informational ones.

📌 Group 2: Keywords Where SEO Pages Should Be ImprovedThese are high-spend or high-converting PPC keywords where organic presence is weak.

• If an SEO page exists but ranks poorly (Position 7-50+), suggest:
  • Title & meta improvements (optimize for CTR & keywords).
  • Internal linking adjustments (boost authority).
  • Content expansion (address user intent gaps).
  • Technical SEO fixes (if needed).
• If a keyword has high PPC spend or conversions but SEO rank is 50+, assess if small SEO tweaks could push it into the top 10 before dismissing as a low-priority SEO fix.

📌 Group 3: Keywords Where New SEO Pages Should Be CreatedThese are high-PPC-spend or high-converting keywords where no organic page exists.

• Suggest creating a dedicated SEO page to reduce reliance on PPC.
• Recommend page type: Service page (transactional), blog post (informational), or landing page (lead gen).

Step 4: Output Format (Structured Table - Universal for Any Business)

Step 5: Final Recommendations & Next Steps

1. Summarize priority actions based on potential ROI.
2. Highlight quick wins (pages ranking 7-20 with minor tweaks needed & 50+ if SEO improvements could make a significant impact).
3. Provide guidance on whether SEO improvements or new content creation is needed.

</aside>

<aside> 🧠

Example Report

🧑‍💻 Company Name: SwiftHost - Premium Web Hosting Solutions

Overview

SwiftHost is a fast-growing web hosting provider specializing in high-performance VPS, dedicated servers, and managed WordPress hosting. This report analyzes the relationship between SwiftHost’s PPC performance (Google Ads) and organic performance (Google Search Console) to identify:

📌 Keywords where PPC should be launched to capture valuable organic impressions. 📌 High-spend or high-converting PPC keywords where SEO efforts should be improved. 📌 Keywords where no organic page exists but should be created to reduce PPC reliance.

Findings & Recommendations

1️⃣ Keywords Where PPC Should Be Launched

These are high-impression, low-click SEO keywords with strong commercial intent, but not currently targeted in Google Ads.

✅ Action Plan: SwiftHost should launch PPC campaigns for these keywords to capture immediate traffic and test conversion potential.

2️⃣ Keywords Where SEO Pages Should Be Improved

These are high-spend or high-converting PPC keywords where SEO rankings are weak.

✅ Action Plan:

• Optimize meta titles & descriptions to improve SEO CTR.
• Improve internal linking to boost rankings.
• Expand content to address user queries more comprehensively.
• Monitor organic rankings after optimizations to track improvement.

3️⃣ Keywords Where New SEO Pages Should Be Created

These are high-spend or high-converting PPC keywords where no strong organic page exists.

| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |

</aside>