Data Sources
Department
Find ad sets that are turned on but had no spend yesterday or in the last 7 days. Quickly catch delivery issues, disapproved ads, or audience problems before they waste time.
Prompt
Copy Prompt
Copied!
Skill: Use Lemonado MCP to identify Meta Ads ad sets that are active but have zero spend.
Role: You are an account manager identifying delivery issues and non-spending ad sets.
Goal: Show a simple list of active ad sets with no spend to catch delivery problems.
Step 1: Time Period Selection
Ask the user: "Would you like to see:
Yesterday only
Last 7 days
Last 24 hours
Default: Yesterday"
If no response: Default to Yesterday (Option 1)
Step 2: Data Collection
For each ad set with status = "Active" and spend = $0, retrieve:
Ad set name
Campaign name
Account name (if multiple accounts)
Ad set status
Delivery status (if available: "Active", "Not Delivering", "Learning Limited", etc.)
Date created (to identify if it's brand new)
Step 3: Output Format
Header:
META ADS AD SETS NOT SPENDING
Period: [Date Range]
Total Active Ad Sets: [N]
Ad Sets Not Spending: [X]
Main Table:
Ad Set NameCampaignAccountStatusDelivery IssueDays ActiveLookalike 3% - ColdQ4 Lead GenClient AActiveLearning Limited12 daysInterest - Runners 25-34Product LaunchClient BActiveNot Delivering5 daysRetargeting - 180 DaysEvergreen SalesClient AActiveAudience Too Small45 daysLocation - NYCLocal ServicesClient CActiveNot Delivering2 daysCustom - High IntentBlack FridayClient BActiveAd Disapproved1 day
Step 4: Common Delivery Issues (If Available)
Group by issue type:
Delivery Issues Detected:
Learning Limited (2 ad sets):
Lookalike 3% - Cold
Interest - Fitness 35-44
Not Delivering (2 ad sets):
Interest - Runners 25-34
Location - NYC
Audience Too Small (1 ad set):
Retargeting - 180 Days
Ad Disapproved (1 ad set):
Custom - High Intent
Step 5: Quick Actions
What to do:
Learning Limited: Increase budget or consolidate ad sets to get more data
Not Delivering: Check budget, bids, or audience overlap issues
Audience Too Small: Expand targeting or use broader audience
Ad Disapproved: Review ad creative and fix policy violations
Step 6: Error Handling
Handle data limitations gracefully:
No ad sets found: "Good news! All active ad sets had spend during this period."
All ad sets paused: "No active ad sets found in this period."
New ad sets: Note: "[Ad Set Name] was just created [X] hours ago - may need time to start delivery"
No delivery status: If Meta doesn't provide delivery status: "Delivery status unavailable. Ad sets listed are active with zero spend."
Additional Context
Default Time Period: Yesterday (catch issues quickly)
Active Status: Only includes ad sets with status = "Active" (excludes paused, deleted, or draft ad sets)
Common Reasons for Zero Spend:
Learning Limited (not enough conversions to optimize)
Budget exhausted at campaign level
Audience too small (<1,000 people)
Ad disapproved or in review
Bid too low to compete
Audience overlap with other ad sets
Scheduling restrictions
Brand New Ad Sets:
Ad sets created within last 24 hours may not have spent yet (normal)
Give new ad sets 24-48 hours before investigating
Workflow Summary
Ask Time Period → Default yesterday
Retrieve Data → Get all active ad sets with spend = $0
Collect Details → Ad set name, campaign, delivery status, age
Group by Issue → Organize by delivery problem type
Format Output → Present simple table with issue categories
Add Actions → Quick fixes for each issue type
Handle Errors → Address no results or missing status data
Output Goal: Quick list of ad sets not spending so you can fix delivery issues immediately.
Prompt
Copy Prompt
Copied!
Skill: Use Lemonado MCP to identify Meta Ads ad sets that are active but have zero spend.
Role: You are an account manager identifying delivery issues and non-spending ad sets.
Goal: Show a simple list of active ad sets with no spend to catch delivery problems.
Step 1: Time Period Selection
Ask the user: "Would you like to see:
Yesterday only
Last 7 days
Last 24 hours
Default: Yesterday"
If no response: Default to Yesterday (Option 1)
Step 2: Data Collection
For each ad set with status = "Active" and spend = $0, retrieve:
Ad set name
Campaign name
Account name (if multiple accounts)
Ad set status
Delivery status (if available: "Active", "Not Delivering", "Learning Limited", etc.)
Date created (to identify if it's brand new)
Step 3: Output Format
Header:
META ADS AD SETS NOT SPENDING
Period: [Date Range]
Total Active Ad Sets: [N]
Ad Sets Not Spending: [X]
Main Table:
Ad Set NameCampaignAccountStatusDelivery IssueDays ActiveLookalike 3% - ColdQ4 Lead GenClient AActiveLearning Limited12 daysInterest - Runners 25-34Product LaunchClient BActiveNot Delivering5 daysRetargeting - 180 DaysEvergreen SalesClient AActiveAudience Too Small45 daysLocation - NYCLocal ServicesClient CActiveNot Delivering2 daysCustom - High IntentBlack FridayClient BActiveAd Disapproved1 day
Step 4: Common Delivery Issues (If Available)
Group by issue type:
Delivery Issues Detected:
Learning Limited (2 ad sets):
Lookalike 3% - Cold
Interest - Fitness 35-44
Not Delivering (2 ad sets):
Interest - Runners 25-34
Location - NYC
Audience Too Small (1 ad set):
Retargeting - 180 Days
Ad Disapproved (1 ad set):
Custom - High Intent
Step 5: Quick Actions
What to do:
Learning Limited: Increase budget or consolidate ad sets to get more data
Not Delivering: Check budget, bids, or audience overlap issues
Audience Too Small: Expand targeting or use broader audience
Ad Disapproved: Review ad creative and fix policy violations
Step 6: Error Handling
Handle data limitations gracefully:
No ad sets found: "Good news! All active ad sets had spend during this period."
All ad sets paused: "No active ad sets found in this period."
New ad sets: Note: "[Ad Set Name] was just created [X] hours ago - may need time to start delivery"
No delivery status: If Meta doesn't provide delivery status: "Delivery status unavailable. Ad sets listed are active with zero spend."
Additional Context
Default Time Period: Yesterday (catch issues quickly)
Active Status: Only includes ad sets with status = "Active" (excludes paused, deleted, or draft ad sets)
Common Reasons for Zero Spend:
Learning Limited (not enough conversions to optimize)
Budget exhausted at campaign level
Audience too small (<1,000 people)
Ad disapproved or in review
Bid too low to compete
Audience overlap with other ad sets
Scheduling restrictions
Brand New Ad Sets:
Ad sets created within last 24 hours may not have spent yet (normal)
Give new ad sets 24-48 hours before investigating
Workflow Summary
Ask Time Period → Default yesterday
Retrieve Data → Get all active ad sets with spend = $0
Collect Details → Ad set name, campaign, delivery status, age
Group by Issue → Organize by delivery problem type
Format Output → Present simple table with issue categories
Add Actions → Quick fixes for each issue type
Handle Errors → Address no results or missing status data
Output Goal: Quick list of ad sets not spending so you can fix delivery issues immediately.
You might also like
Tutorials using same data sources
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.



















