Ecommerce AnalystTraffic and Acquisition AnalyticsAdvancedSingle prompt

Paid Search Performance Analysis AI Prompt

Analyze Google Shopping and paid search performance for this e-commerce store. Google Ads data: {{ads_data}} (campaign, ad group, keyword, impressions, clicks, conversions, reve... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Analyze Google Shopping and paid search performance for this e-commerce store.

Google Ads data: {{ads_data}} (campaign, ad group, keyword, impressions, clicks, conversions, revenue, spend)
Time period: {{period}}

1. Account-level performance:
   - Total spend, revenue, ROAS, and CPA
   - ROAS target: {{target_roas}} (typically 4-8x for e-commerce)
   - Is the account meeting the ROAS target? Overall and by campaign type?

2. Campaign type breakdown:
   - Branded search: keywords containing the brand name
   - Non-branded search: generic product and category keywords
   - Shopping campaigns: Google Shopping product listing ads
   - Performance Max: automated campaign type
   - ROAS and CPA per campaign type
   - Branded terms typically have very high ROAS (5-15x) but limited incrementality

3. Product/keyword performance:
   - Top 20 keywords/products by revenue
   - Bottom 20 keywords/products by ROAS (candidates for bid reduction or pause)
   - ROAS distribution: what % of spend is above / below the ROAS target?

4. Shopping campaign analysis:
   - Product feed health: any products disapproved or not showing?
   - Impression share: what % of available impressions are we capturing?
   - Lost impression share: due to budget vs due to rank
   - Top products by Shopping revenue and their Shopping CPA

5. Auction insights:
   - Who are the top auction competitors?
   - Impression share comparison vs competitors
   - Are we winning or losing on top-of-page rate?

6. Optimization opportunities:
   - Budget allocation: which campaigns are limited by budget but have high ROAS? Increase budget.
   - Bid adjustment: keywords with ROAS > 2x target: consider raising bids to capture more volume
   - Negative keywords: terms generating clicks but no conversions: add as negatives
   - Product feed improvements: products with high impressions but low CTR need title/image optimization

Return: account performance summary, campaign type breakdown, product/keyword analysis, Shopping health check, auction insights, and optimization recommendations.

When to use this prompt

Use case 01

Use it when you want to begin traffic and acquisition analytics work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in Traffic and Acquisition Analytics or the wider Ecommerce Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Account-level performance:, Total spend, revenue, ROAS, and CPA, ROAS target: {{target_roas}} (typically 4-8x for e-commerce). The final answer should stay clear, actionable, and easy to review inside a traffic and acquisition analytics workflow for ecommerce analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Traffic and Acquisition Analytics.

Frequently asked questions

What does the Paid Search Performance Analysis prompt do?+

It gives you a structured traffic and acquisition analytics starting point for ecommerce analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for ecommerce analyst workflows and marked as advanced, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

Paid Search Performance Analysis is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Affiliate and Influencer Analytics, E-commerce Traffic Source Analysis.