30 Claude Prompts I Use Daily for Marketing Analytics (Copy + Paste)

The weekly audit (5 prompts)

1. Full marketing weekly audit

Pull last 7 days of data across GSC, GA4, Google Ads, and Meta Ads.
For each channel, report: total sessions/clicks/impressions, week-over-week
% change, and one most-significant change (positive or negative). Flag
anything that warrants attention. Output as a 1-page executive summary.

2. Top winners + losers this week

For last 7 days vs prior 7 days, list:
- Top 5 pages by click increase (with absolute and % change)
- Top 5 pages by click decrease
- Top 3 keywords I newly rank for in top 10
- Top 3 keywords I dropped out of top 10
Pull from Google Search Console.

3. CAC trend by channel

For last 30 days, compute CAC by acquisition channel:
- Google Ads: spend ÷ conversions
- Meta Ads: spend ÷ conversions
- Organic search: assume $0 marginal spend, compute conversions
- Direct: same
Output a table sorted by CAC ascending. Flag any CAC up 30%+ vs prior 30 days.

4. Wasted Google Ads spend

Find keywords in Google Ads where spend > $50 last 30 days AND
conversions = 0. List the top 10 by spend with CPC and impressions.
Recommend pause or negative keyword action.

5. Meta ad set learning status

List all Meta ad sets currently active. For each, show: status
(Learning / Active / Learning Limited), conversions in current week,
days since last edit. Flag ad sets stuck in Learning Limited for >14 days.

Google Ads (8 prompts)

6. Campaign-level ROAS audit

For all active Google Ads campaigns, pull last 30 days:
campaign name, spend, conversions, conversion value, ROAS.
Sort by ROAS ascending. Flag any below 1.5x.

7. Quality Score check

List Google Ads keywords with Quality Score <= 5 from active
ad groups. Show keyword, match type, ad group, current QS, CPC.
Top 20 by spend.

8. Search terms that should be negative keywords

Pull last 30 days of search terms from Google Ads. Filter to terms
with impressions > 100 AND CTR < 0.5%. List top 25 — these are
likely negative keyword candidates.

9. New keyword opportunities

Compare last 30 days of search terms against my current keyword list.
Find terms that drove conversions but aren't yet keywords. Output as
a list of "add as exact match" recommendations.

10. Bidding strategy comparison

For each Google Ads campaign, show current bidding strategy and
performance in last 30 days. Group by strategy type. Output which
strategy is delivering the best ROAS in my account.

11. Day-parting analysis

For Google Ads last 30 days, show conversions and conversion rate
by hour of day. Identify hours where conversion rate is <50% of
average — recommend dayparting bid adjustments.

12. Device performance breakdown

For Google Ads last 30 days, show spend, conversions, conversion
rate by device (mobile, desktop, tablet). Flag if any device
underperforms by 30%+ on conversion rate.

13. Impression share lost analysis

List Google Ads campaigns where lost impression share (budget) is
>20% or lost impression share (rank) is >30%. Recommend specific
fix per campaign (raise budget vs raise bid vs improve QS).

Meta Ads (6 prompts)

14. Andromeda settings audit

For all active Meta ad sets, check: Advantage+ Creative on/off,
Advantage+ Audience on/off, CAPI status, optimization event. Flag
any combination that's likely to underperform under the 2026 Andromeda
retrieval model.

15. Cross-channel ROAS comparison

Pull last 30 days: Meta Ads ROAS, Google Ads ROAS, organic
contribution. Side by side. Recommend which channel deserves
incremental budget based on marginal ROAS not blended ROAS.

16. Creative fatigue check

List Meta ads where frequency >5 AND CTR has dropped >25% vs first
7 days. These are creative-fatigue candidates — pause or refresh.

17. Top creative by ROAS

For last 30 days of Meta ads, list top 10 ads by ROAS with spend
> $200. Pull the creative thumbnails. Identify the common pattern
across the winners.

18. Value rules check

For Meta ad sets with value-based optimization, show whether value
rules are configured. List the audience tiers and bid multipliers.
Identify any value rules with negative ROI (audiences receiving
bid-up that perform worse than baseline).

19. Conversion path analysis

For Meta conversions last 30 days, show breakdown: 7-day click vs
1-day click vs view-through. Flag if view-through is >40% of total —
likely inflated attribution.

GA4 + Search Console (6 prompts)

20. Top declining pages this week

Pull GSC clicks per page, last 7 days vs prior 7 days. List top 10
declining pages by absolute click loss. For each, show current
average position and CTR.

21. AI traffic share

In GA4 last 30 days, calculate sessions from AI sources (chatgpt.com,
claude.ai, perplexity.ai, gemini.google.com, copilot.com, bing).
Show as % of total sessions. Compare to prior 30 days.

22. New keywords I'm ranking for

From GSC, find queries where I gained >100 impressions this week
vs last week and where I have a position <20. List top 20.

23. CTR opportunities

Find GSC pages with >1000 impressions last 28 days AND CTR <1%.
List top 15 sorted by impressions. These are snippet-optimization
opportunities.

24. GA4 funnel drop-off

For the funnel: landing page → pricing page → signup page → completion,
show conversion rate at each step for last 30 days. Identify the
biggest drop-off step.

25. Geographic conversion analysis

From GA4 last 30 days, show conversion rate by country (top 10 countries
by sessions). Flag any country where conversion rate is >3x or <0.3x
the site average.

Cross-channel + strategy (5 prompts)

26. Channel mix recommendation

Given last 30 days of spend, conversions, and ROAS by channel
(Google Ads, Meta, organic), recommend how I should reallocate
$10K of next month's budget. Show new spend mix + projected
incremental conversions.

27. Competitor mention tracking

For last 30 days of GSC queries, list queries where competitor
brand names appear alongside mine. These are comparison-shopping
buyers worth targeting with vs-pages.

28. Stripe revenue by acquisition source

For all Stripe customers acquired last 90 days, cross-reference with
GA4 acquisition source. Compute LTV per source. Identify sources with
LTV > 3x CAC.

29. Content gap analysis

From GSC, list queries where I get >500 impressions but rank
below position 10. These are content opportunities where I have
relevance but not authority. Top 20.

30. Weekly priorities for Monday

Based on last 7 days of data across all channels, list the top 3
things I should focus on this week, ranked by potential revenue
impact. Explain reasoning for each.

How to use these prompts well

• Customize the date range — most prompts default to 7 or 30 days; adjust for your reporting cadence.
• Add account context — if you have multiple accounts connected, prefix with "For client [name]" or "For my [property name] GA4."
• Save the best ones — Claude lets you save custom prompts. Build a library of the 5-10 you actually use weekly.
• Combine with follow-up questions — most insights come from the second or third question, not the first. "Show me more about why" beats running a brand-new prompt.
• Don't trust without verification — for any insight you'll act on (especially budget reallocations), cross-check the underlying data in the platform UI before executing.

Frequently Asked Questions