Which Meta campaigns are most efficient for leads?

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.

Goal: Show a simple ranked list of campaigns by cost per lead.

Step 1: Time Period Selection

Ask the user: "Would you like to see:

1. Last 7 days

2. Last 30 days

3. Yesterday only

Default: Last 7 days"

If no response: Default to Last 7 days (Option 1)

Step 2: Data Collection

For each Meta Ads campaign, retrieve:

• Campaign name

• Account name (if multiple accounts)

• Total spend

• Total leads (from lead form submissions or conversion events)

• Campaign objective

• Campaign status

Step 3: Calculations

For each campaign with leads > 0:

Cost Per Lead:

• Formula: Spend / Leads

• Round to 2 decimals

• Display with currency symbol

Step 4: Output Format

Header:

META ADS COST PER LEAD

Period: [Date Range]

Total Campaigns: [N]

Total Leads: [X]

Total Spend: $[X,XXX.XX]

Average CPL: $[X.XX]

Main Table (Sorted by CPL - Highest to Lowest):

Campaign NameAccountLeadsSpendCPLStatusCold - Lookalike 5%Client A12$1,850.00$154.17ActiveCompetitor TargetingClient B23$2,340.00$101.74ActiveInterest - Fitness EnthusiastsClient A45$3,200.00$71.11ActiveWarm - Website VisitorsClient C89$4,560.00$51.24ActiveHot - Engagement RetargetingClient A134$5,890.00$43.96Active

Summary:

Best Performer: Hot - Engagement Retargeting at $43.96 CPL

Worst Performer: Cold - Lookalike 5% at $154.17 CPL

CPL Range: $111.21 spread between best and worst

Step 5: Quick Insights

Provide 2-3 simple observations:

1. Retargeting campaigns averaging $47.60 CPL vs cold audiences at $112.96 CPL (2.4x difference)

2. Top 3 campaigns generate 68% of total leads at 35% lower CPL than account average

3. Cold - Lookalike 5% spending $1,850 at $154 CPL - consider pausing or reducing budget

Step 6: Error Handling

Handle data limitations gracefully:

• No leads: "No leads generated in this period. Check lead form setup or conversion tracking."

• All zero leads: "No campaigns generated leads. All spend resulted in zero conversions."

• Single campaign: "Only one campaign active. Need multiple campaigns to compare CPL."

• No conversion tracking: "Lead conversion tracking not detected. Cannot calculate CPL without lead data."

Additional Context

Default Time Period: Last 7 days (standard weekly check)

Lead Definition: Uses Meta's lead conversion events (lead form submissions, lead generation objective conversions, or custom lead events)

CPL Benchmarks (vary widely by industry):

• B2B: $50-$150 typical

• Local Services: $20-$80 typical

• Education: $30-$100 typical

• High-ticket: $100-$500+ acceptable

Sort Order: Highest to lowest CPL (puts worst performers at top for immediate attention)

Workflow Summary

1. Ask Time Period → Default last 7 days

2. Retrieve Data → Get spend and leads for all campaigns

3. Calculate CPL → Compute cost per lead

4. Filter Results → Only show campaigns with leads > 0

5. Sort Table → Order by CPL (highest first)

6. Add Insights → 2-3 simple observations

7. Handle Errors → Address missing lead data

Output Goal: Quick scannable table showing which campaigns are expensive vs efficient at generating leads.