Which Meta ad sets are active but not spending?

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:

  1. Yesterday only

  2. Last 7 days

  3. 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:

  1. Learning Limited: Increase budget or consolidate ad sets to get more data

  2. Not Delivering: Check budget, bids, or audience overlap issues

  3. Audience Too Small: Expand targeting or use broader audience

  4. 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

  1. Ask Time Period → Default yesterday

  2. Retrieve Data → Get all active ad sets with spend = $0

  3. Collect Details → Ad set name, campaign, delivery status, age

  4. Group by Issue → Organize by delivery problem type

  5. Format Output → Present simple table with issue categories

  6. Add Actions → Quick fixes for each issue type

  7. 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:

  1. Yesterday only

  2. Last 7 days

  3. 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:

  1. Learning Limited: Increase budget or consolidate ad sets to get more data

  2. Not Delivering: Check budget, bids, or audience overlap issues

  3. Audience Too Small: Expand targeting or use broader audience

  4. 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

  1. Ask Time Period → Default yesterday

  2. Retrieve Data → Get all active ad sets with spend = $0

  3. Collect Details → Ad set name, campaign, delivery status, age

  4. Group by Issue → Organize by delivery problem type

  5. Format Output → Present simple table with issue categories

  6. Add Actions → Quick fixes for each issue type

  7. 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.

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.