Olha Pivnenko shared a reporting prompt for an AI assistant connected (via MCP) to Meta Ads, Google Ads, GA4, Stripe and Microsoft Clarity. It compares the last 7 days with the 7 before and defines CPA as ad spend divided by Stripe-confirmed paid subscriptions (first payment succeeded, excluding trials, refunds and failed payments), not the conversions the ad platforms report. It matches Stripe to campaigns by UTM or campaign ID and must say what's missing rather than estimate. It returns the top 3 campaigns by confirmed sales next to clicks and spend (flagging high clicks with few sales), every ad set whose CPA rose more than 20% week over week (with low-data ad sets listed separately), GA4 engagement plus Clarity scroll depth, rage clicks and dead clicks for those campaigns to see whether landing page friction explains the change, and three creative or landing page changes stated as hypotheses. For a Shopify brand, swap Stripe for Shopify orders. Her post recommends InsightfulPipe as the connector; any MCP that reaches these sources works.
Prompt
You are a senior performance marketing analyst. Using my connected Meta Ads, Google Ads, GA4, Stripe and Microsoft Clarity data, analyze the last 14 days, comparing the most recent 7 days to the 7 days before. Definitions: - "Paid subscription" = a Stripe subscription with a successful first payment, excluding trials, refunds and failed payments. - CPA = ad spend ÷ Stripe-confirmed paid subscriptions (not the ad platform's reported conversions). - Match Stripe to campaigns using UTM parameters or campaign IDs. If you can't match reliably, tell me what's missing instead of estimating. Tasks: 1. Show the top 3 campaigns by Stripe-confirmed paid subscriptions next to their clicks and spend. Flag campaigns with high clicks but few subscriptions. 2. List every ad set whose CPA rose more than 20% week over week. Ignore ad sets with fewer than [5] conversions or less than [$X] spend in either week, and list them separately as "too little data". 3. For the campaigns above, compare GA4 landing page engagement/bounce rate with Clarity scroll depth, rage clicks and dead clicks. Say whether landing page friction helps explain the CPA changes. 4. Give 3 creative or landing page changes for next week. For each, name the ad or campaign, the data behind it, and the expected effect as a hypothesis. Output: one table per task, then a 5-line summary. Name the source platform for each number and flag anything you're unsure about.