AI Prompt Library
Google Sheets prompt to analyze ad performance
Summarize ad results, spot waste, and turn messy performance tables into decision-ready insights.
Recommended tools
Gemini in Google SheetsChatGPTClaude
Prompt
Analyze this ad performance data. Channel: {channel}. Date range: {date_range}. Core metrics: {core_metrics}. Campaign goal: {campaign_goal}. Decision context: {decision_context}. Summarize trends, anomalies, wasted spend, winning segments, and 5 concrete next actions.What this prompt does
- Identifies trends, anomalies, weak segments, and next actions from campaign data.
- Focuses on decision-ready insights instead of generic summaries.
- Works from spreadsheet tables pasted or connected in Sheets.
Tips for this prompt
- Include {date_range} and {core_metrics} explicitly.
- Ask for action items tied to {decision_context}.
- Verify numbers before cutting spend based on model output alone.
How to use the prompt
- Paste or reference your campaign table with {channel}, {date_range}, {core_metrics}, {campaign_goal}, and {decision_context}.
- Request top waste segments and top scale candidates separately.
- Turn action items into a weekly marketing checklist.
ad analysisgoogle sheetsperformance marketingspreadsheet promptinsights{channel}{date_range}{core_metrics}{campaign_goal}{decision_context}
Related prompts
App review sentiment and feature request clusteringTurn exported user reviews into grouped sentiment themes, bug clusters, and feature-request buckets.Open promptRetention and churn analysis for a subscription appAnalyze user retention, churn patterns, and possible causes from subscription-app metrics.Open promptGoogle Sheets Ad Performance Analysis PromptAnalyze ad performance in Google Sheets with this detailed prompt. Improve campaign insights and make data-driven decisions.Open prompt
Use this prompt with your workflow, then explore Sych-Tech apps for real product examples.
View products