Data Sources
Department
Identify ad sets that were live but spent $0 in the last 7 days (delivery issues) and ad sets burning through budgets faster than planned (overspend risks). Get totals for wasted budget opportunity and projected overruns with actionable insights on what needs immediate attention.
Prompt
Copy Prompt
Copied!
Skill: Use Lemonado MCP to retrieve Meta Ads campaign performance and calculate cost per lead.
Role: You are an account manager monitoring lead generation campaign efficiency.
Analyze Meta Ads ad sets from the last 7 days and identify two critical issues:
1. Zero Spend Ad Sets (Delivery Problems) Find ad sets that were ACTIVE but spent $0 despite having a budget. These indicate delivery issues like targeting problems, bid issues, or ad disapprovals.
For each one, tell me the ad set name, campaign, account, budget, how many days it was live, and whether it got any impressions. Calculate the total wasted budget opportunity across all of them.
2. Overspend Risk Ad Sets (Budget Pacing Problems) Find ad sets that are spending faster than their budget allows. Calculate their daily spend rate (total spend divided by days active) and compare it to their daily budget. Project how much they'll overspend if they keep going at this pace.
For each one, tell me the ad set name, campaign, account, current spend, daily pace, and how much they're projected to overspend. Flag them as High Risk if they're 50%+ over pace, Medium Risk if 20-49% over pace.
Summary & Insights Give me the totals: how much budget was wasted on zero-spend ad sets, how much is projected to be overspent, and how many ad sets have each issue.
Then give me 2-3 quick actionable insights like which ad sets need immediate attention, any patterns you notice (like all zero-spend ad sets have tiny audiences), and what the biggest risks are.
Default to last 7 days unless I specify otherwise.
Prompt
Copy Prompt
Copied!
Skill: Use Lemonado MCP to retrieve Meta Ads campaign performance and calculate cost per lead.
Role: You are an account manager monitoring lead generation campaign efficiency.
Analyze Meta Ads ad sets from the last 7 days and identify two critical issues:
1. Zero Spend Ad Sets (Delivery Problems) Find ad sets that were ACTIVE but spent $0 despite having a budget. These indicate delivery issues like targeting problems, bid issues, or ad disapprovals.
For each one, tell me the ad set name, campaign, account, budget, how many days it was live, and whether it got any impressions. Calculate the total wasted budget opportunity across all of them.
2. Overspend Risk Ad Sets (Budget Pacing Problems) Find ad sets that are spending faster than their budget allows. Calculate their daily spend rate (total spend divided by days active) and compare it to their daily budget. Project how much they'll overspend if they keep going at this pace.
For each one, tell me the ad set name, campaign, account, current spend, daily pace, and how much they're projected to overspend. Flag them as High Risk if they're 50%+ over pace, Medium Risk if 20-49% over pace.
Summary & Insights Give me the totals: how much budget was wasted on zero-spend ad sets, how much is projected to be overspent, and how many ad sets have each issue.
Then give me 2-3 quick actionable insights like which ad sets need immediate attention, any patterns you notice (like all zero-spend ad sets have tiny audiences), and what the biggest risks are.
Default to last 7 days unless I specify otherwise.
You might also like
Tutorials using same data sources
Stop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
