Data Sources
Department
A collection of 10 ready-to-go prompts for instant Meta Ads performance analysis with Lemonado. Each prompt covers essential reporting needs from daily overviews to creative audits for individual ad accounts.
Prompt
Copy Prompt
Copied!
How to Use This Starter Pack
Always remember to copy your System Rules along with each chosen prompt.
Specify the account name in each prompt where indicated.
Adjust date ranges as needed for your analysis timeframe.
Pro Tip: Save your most-used prompts with your specific account names pre-filled for even faster access!
System Rules
Skill: Use the Lemonado MCP to query Meta Ads performance data for a single ad account, calculate efficiency metrics, and present results in the appropriate format.
Role: You are a Meta Ads performance analyst helping users access and analyze their advertising data through Lemonado.
Goal: Provide quick, actionable Meta Ads performance reports for single account analysis.
Note: This prompt is designed for single account analysis only. If the user doesn't specify an account name, ask which Meta Ads account they'd like to analyze before proceeding.
10 Ready-to-Go Prompts for Meta Ads Connectors
1. Last 7 Days Performance Overview
Full Prompt: Show me a comprehensive daily breakdown of my Meta Ads performance for [account name] over the last 7 days. Include daily spend, impressions, clicks, conversions, and all key efficiency metrics like CTR, CPA, and CVR. I want to see day-over-day changes so I can spot trends and anomalies quickly.
Expected Output: Daily performance table with columns for date, spend, day-over-day spend change percentage, impressions, clicks, CTR, conversions, CPA, and CVR. Includes 7-day summary totals showing total spend, total impressions, total clicks, total conversions, average CTR, average CPA, and average CVR. Highlights best and worst performing days by efficiency. Flags any days with zero conversions or unusual spend spikes for immediate attention.
2. Top 10 Campaigns by Spend
Full Prompt: Show me the top 10 campaigns by total spend for [account name] over the last 30 days with complete performance metrics. I want to see which campaigns are consuming the most budget and whether they're delivering good results or wasting money.
Expected Output: Ranked table of top 10 campaigns sorted by spend descending, showing campaign name, total spend, percentage of account spend, impressions, clicks, CTR, conversions, CPA, and CVR. Highlights the most efficient campaign (lowest CPA) and least efficient campaign (highest CPA) with clear labels. Includes portfolio averages for comparison. Identifies campaigns with high spend but zero conversions or CPA significantly above account average as optimization opportunities.
3. Ad Set Performance Analysis
Full Prompt: Analyze all ad set performance for [account name] over the last 14 days and show me which ad sets are actually driving conversions versus which ones are burning budget with poor results. I need to know where to cut spending and where to double down.
Expected Output: Ad set performance table ranked by spend descending, showing ad set name, campaign name, spend, impressions, clicks, CTR, conversions, CPA, and CVR. Flags ad sets with zero conversions despite >$100 spend as "waste candidates." Flags ad sets with CPA >150% of account average as "high cost." Highlights top 3 performing ad sets by lowest CPA. Includes summary showing total ad sets analyzed, number with zero conversions, and percentage of budget going to underperformers.
4. Creative Performance Audit
Full Prompt: Show me detailed creative performance for [account name] over the last 30 days. Break down performance by ad format (single image, video, carousel, collection) and show me which creative types are getting the best engagement, clicks, and conversions so I can optimize my creative strategy.
Expected Output: Creative format performance table showing ad format type, number of ads, total spend, impressions, clicks, CTR, engagement rate (reactions + comments + shares / impressions), conversions, CPA, and CVR. Sorted by CPA ascending (most efficient first). Includes format comparison showing which creative type has best CTR, best engagement rate, and best CPA. Identifies underperforming formats consuming significant budget. Provides recommendations like "Video ads show 32% lower CPA than single image - consider shifting 20% of budget to video."
5. Placement Performance Breakdown
Full Prompt: Break down performance by placement for [account name] over the last 14 days. Compare Facebook Feed, Instagram Feed, Instagram Stories, Facebook Stories, Reels, Messenger, and Audience Network. Show me which placements are worth the investment and which are wasting budget.
Expected Output: Placement comparison table showing placement name, spend, percentage of total spend, impressions, clicks, CTR, conversions, CPA, and CVR. Sorted by CPA ascending. Highlights most efficient placement and least efficient placement. Includes spend allocation vs conversion contribution analysis (e.g., "Audience Network receives 18% of spend but delivers only 4% of conversions"). Identifies placement imbalances and provides budget reallocation recommendations. Flags placements with zero conversions for potential exclusion.
6. Audience Performance Insights
Full Prompt: Show me audience segment performance for [account name] over the last 30 days. I want to see which audiences (custom audiences, lookalikes, interest-based, etc.) have the lowest CPA and highest conversion rates so I know which audiences to scale and which to pause.
Expected Output: Audience segment table ranked by CPA ascending, showing audience name, audience type (custom/lookalike/interest/saved), spend, impressions, clicks, CTR, conversions, CPA, and CVR. Highlights top 3 performing audiences by efficiency. Flags audiences with CPA >200% of account average as underperformers. Includes audience overlap analysis if available (warns about audiences competing against each other). Provides scaling recommendations for best performers and pause suggestions for worst performers. Shows percentage of budget allocated to top performers vs underperformers.
7. Age and Gender Breakdown
Full Prompt: Analyze performance by age group and gender for [account name] over the last 30 days. Show me which demographic segments are converting at the lowest cost and highest rates so I can refine my targeting and stop wasting money on segments that don't convert.
Expected Output: Demographic performance table showing age range (18-24, 25-34, 35-44, 45-54, 55-64, 65+), gender (male/female/unknown), spend, impressions, clicks, conversions, CPA, and CVR. Sorted by CPA ascending within each gender group. Highlights most efficient demographic segment overall. Creates a heatmap view showing which age/gender combinations perform best. Identifies demographic segments with high spend but poor conversion rates for potential exclusion. Provides budget reallocation recommendation (e.g., "Women 25-34 show $28 CPA vs $67 portfolio average - consider increasing budget 30% to this segment").
8. Video Ad Performance Analysis
Full Prompt: Show me comprehensive video ad performance for [account name] over the last 14 days. Include video-specific metrics like video views, 3-second views, view rates, average watch time, and compare how video ads are converting versus static image ads. I need to justify video production costs with performance data.
Expected Output: Video performance table showing video ad name, spend, impressions, video views (total), 3-second video views, video view rate percentage, average watch time in seconds, video completion rate, clicks, CTR, conversions, CPA, and CVR. Includes side-by-side comparison table: Video Ads vs Non-Video Ads showing total spend, conversions, average CPA, average CTR, and average engagement rate for each format. Highlights whether video outperforms static ads and by what percentage. Identifies best-performing video creative by watch time and conversion efficiency. Flags expensive video ads with poor view rates or high CPA.
9. Budget Pacing Check
Full Prompt: Check budget pacing for all campaigns in [account name] for the current month. Show me daily average spend versus monthly budget targets and flag any campaigns that are burning through budget too quickly or spending too slowly. I need to catch pacing issues before month-end.
Expected Output: Campaign budget pacing table showing campaign name, monthly budget (if set), days elapsed in month, days remaining, total spend to date, daily average spend, target daily spend (budget / days in month), actual pacing percentage (actual vs target), and status flag (on track / overspending / underspending). Flags campaigns spending >120% of target pace as "overspending risk" with projected overage amount. Flags campaigns spending <80% of target pace as "underspending" with budget at risk of being wasted. Includes portfolio-level summary showing total budget, total spent, overall pacing percentage, and projected end-of-month spend based on current pace.
10. ROAS Performance Report
Full Prompt: Show me return on ad spend (ROAS) performance for [account name] over the last 30 days. Break it down by campaign and ad set level, showing which are delivering the best return on investment. Include revenue, conversion value, ROAS ratio, and identify my top revenue drivers versus money losers.
Expected Output: ROAS performance table ranked by ROAS descending, showing campaign name, ad set name (if applicable), spend, revenue (conversion value), ROAS ratio (e.g., 4.2x means $4.20 revenue per $1 spend), conversions, average conversion value, and profit (revenue minus spend). Highlights campaigns/ad sets exceeding target ROAS (if provided, else >3x). Flags campaigns with ROAS <1x (losing money) as immediate optimization priorities. Includes portfolio summary showing total spend, total revenue, overall ROAS, total profit, and break-even ROAS threshold. Provides recommendations to scale high-ROAS campaigns and pause or optimize low-ROAS campaigns. Notes if conversion value tracking is incomplete or missing.
Prompt
Copy Prompt
Copied!
How to Use This Starter Pack
Always remember to copy your System Rules along with each chosen prompt.
Specify the account name in each prompt where indicated.
Adjust date ranges as needed for your analysis timeframe.
Pro Tip: Save your most-used prompts with your specific account names pre-filled for even faster access!
System Rules
Skill: Use the Lemonado MCP to query Meta Ads performance data for a single ad account, calculate efficiency metrics, and present results in the appropriate format.
Role: You are a Meta Ads performance analyst helping users access and analyze their advertising data through Lemonado.
Goal: Provide quick, actionable Meta Ads performance reports for single account analysis.
Note: This prompt is designed for single account analysis only. If the user doesn't specify an account name, ask which Meta Ads account they'd like to analyze before proceeding.
10 Ready-to-Go Prompts for Meta Ads Connectors
1. Last 7 Days Performance Overview
Full Prompt: Show me a comprehensive daily breakdown of my Meta Ads performance for [account name] over the last 7 days. Include daily spend, impressions, clicks, conversions, and all key efficiency metrics like CTR, CPA, and CVR. I want to see day-over-day changes so I can spot trends and anomalies quickly.
Expected Output: Daily performance table with columns for date, spend, day-over-day spend change percentage, impressions, clicks, CTR, conversions, CPA, and CVR. Includes 7-day summary totals showing total spend, total impressions, total clicks, total conversions, average CTR, average CPA, and average CVR. Highlights best and worst performing days by efficiency. Flags any days with zero conversions or unusual spend spikes for immediate attention.
2. Top 10 Campaigns by Spend
Full Prompt: Show me the top 10 campaigns by total spend for [account name] over the last 30 days with complete performance metrics. I want to see which campaigns are consuming the most budget and whether they're delivering good results or wasting money.
Expected Output: Ranked table of top 10 campaigns sorted by spend descending, showing campaign name, total spend, percentage of account spend, impressions, clicks, CTR, conversions, CPA, and CVR. Highlights the most efficient campaign (lowest CPA) and least efficient campaign (highest CPA) with clear labels. Includes portfolio averages for comparison. Identifies campaigns with high spend but zero conversions or CPA significantly above account average as optimization opportunities.
3. Ad Set Performance Analysis
Full Prompt: Analyze all ad set performance for [account name] over the last 14 days and show me which ad sets are actually driving conversions versus which ones are burning budget with poor results. I need to know where to cut spending and where to double down.
Expected Output: Ad set performance table ranked by spend descending, showing ad set name, campaign name, spend, impressions, clicks, CTR, conversions, CPA, and CVR. Flags ad sets with zero conversions despite >$100 spend as "waste candidates." Flags ad sets with CPA >150% of account average as "high cost." Highlights top 3 performing ad sets by lowest CPA. Includes summary showing total ad sets analyzed, number with zero conversions, and percentage of budget going to underperformers.
4. Creative Performance Audit
Full Prompt: Show me detailed creative performance for [account name] over the last 30 days. Break down performance by ad format (single image, video, carousel, collection) and show me which creative types are getting the best engagement, clicks, and conversions so I can optimize my creative strategy.
Expected Output: Creative format performance table showing ad format type, number of ads, total spend, impressions, clicks, CTR, engagement rate (reactions + comments + shares / impressions), conversions, CPA, and CVR. Sorted by CPA ascending (most efficient first). Includes format comparison showing which creative type has best CTR, best engagement rate, and best CPA. Identifies underperforming formats consuming significant budget. Provides recommendations like "Video ads show 32% lower CPA than single image - consider shifting 20% of budget to video."
5. Placement Performance Breakdown
Full Prompt: Break down performance by placement for [account name] over the last 14 days. Compare Facebook Feed, Instagram Feed, Instagram Stories, Facebook Stories, Reels, Messenger, and Audience Network. Show me which placements are worth the investment and which are wasting budget.
Expected Output: Placement comparison table showing placement name, spend, percentage of total spend, impressions, clicks, CTR, conversions, CPA, and CVR. Sorted by CPA ascending. Highlights most efficient placement and least efficient placement. Includes spend allocation vs conversion contribution analysis (e.g., "Audience Network receives 18% of spend but delivers only 4% of conversions"). Identifies placement imbalances and provides budget reallocation recommendations. Flags placements with zero conversions for potential exclusion.
6. Audience Performance Insights
Full Prompt: Show me audience segment performance for [account name] over the last 30 days. I want to see which audiences (custom audiences, lookalikes, interest-based, etc.) have the lowest CPA and highest conversion rates so I know which audiences to scale and which to pause.
Expected Output: Audience segment table ranked by CPA ascending, showing audience name, audience type (custom/lookalike/interest/saved), spend, impressions, clicks, CTR, conversions, CPA, and CVR. Highlights top 3 performing audiences by efficiency. Flags audiences with CPA >200% of account average as underperformers. Includes audience overlap analysis if available (warns about audiences competing against each other). Provides scaling recommendations for best performers and pause suggestions for worst performers. Shows percentage of budget allocated to top performers vs underperformers.
7. Age and Gender Breakdown
Full Prompt: Analyze performance by age group and gender for [account name] over the last 30 days. Show me which demographic segments are converting at the lowest cost and highest rates so I can refine my targeting and stop wasting money on segments that don't convert.
Expected Output: Demographic performance table showing age range (18-24, 25-34, 35-44, 45-54, 55-64, 65+), gender (male/female/unknown), spend, impressions, clicks, conversions, CPA, and CVR. Sorted by CPA ascending within each gender group. Highlights most efficient demographic segment overall. Creates a heatmap view showing which age/gender combinations perform best. Identifies demographic segments with high spend but poor conversion rates for potential exclusion. Provides budget reallocation recommendation (e.g., "Women 25-34 show $28 CPA vs $67 portfolio average - consider increasing budget 30% to this segment").
8. Video Ad Performance Analysis
Full Prompt: Show me comprehensive video ad performance for [account name] over the last 14 days. Include video-specific metrics like video views, 3-second views, view rates, average watch time, and compare how video ads are converting versus static image ads. I need to justify video production costs with performance data.
Expected Output: Video performance table showing video ad name, spend, impressions, video views (total), 3-second video views, video view rate percentage, average watch time in seconds, video completion rate, clicks, CTR, conversions, CPA, and CVR. Includes side-by-side comparison table: Video Ads vs Non-Video Ads showing total spend, conversions, average CPA, average CTR, and average engagement rate for each format. Highlights whether video outperforms static ads and by what percentage. Identifies best-performing video creative by watch time and conversion efficiency. Flags expensive video ads with poor view rates or high CPA.
9. Budget Pacing Check
Full Prompt: Check budget pacing for all campaigns in [account name] for the current month. Show me daily average spend versus monthly budget targets and flag any campaigns that are burning through budget too quickly or spending too slowly. I need to catch pacing issues before month-end.
Expected Output: Campaign budget pacing table showing campaign name, monthly budget (if set), days elapsed in month, days remaining, total spend to date, daily average spend, target daily spend (budget / days in month), actual pacing percentage (actual vs target), and status flag (on track / overspending / underspending). Flags campaigns spending >120% of target pace as "overspending risk" with projected overage amount. Flags campaigns spending <80% of target pace as "underspending" with budget at risk of being wasted. Includes portfolio-level summary showing total budget, total spent, overall pacing percentage, and projected end-of-month spend based on current pace.
10. ROAS Performance Report
Full Prompt: Show me return on ad spend (ROAS) performance for [account name] over the last 30 days. Break it down by campaign and ad set level, showing which are delivering the best return on investment. Include revenue, conversion value, ROAS ratio, and identify my top revenue drivers versus money losers.
Expected Output: ROAS performance table ranked by ROAS descending, showing campaign name, ad set name (if applicable), spend, revenue (conversion value), ROAS ratio (e.g., 4.2x means $4.20 revenue per $1 spend), conversions, average conversion value, and profit (revenue minus spend). Highlights campaigns/ad sets exceeding target ROAS (if provided, else >3x). Flags campaigns with ROAS <1x (losing money) as immediate optimization priorities. Includes portfolio summary showing total spend, total revenue, overall ROAS, total profit, and break-even ROAS threshold. Provides recommendations to scale high-ROAS campaigns and pause or optimize low-ROAS campaigns. Notes if conversion value tracking is incomplete or missing.
You might also like
Stop fighting with data. Start feeding your AI.
With Lemonado, your data flows straight from your tools into ChatGPT and Claude—clean, ready, and live.














