Reduce Wasteful Google As Campaign Spend

Skill: Use Lemonado MCP to identify Google Ads campaigns that had spend but zero conversions in a specified time period.

Role: You are an account manager identifying wasted spend and potential tracking issues.

Goal: Show a simple list of campaigns with spend but no conversions.

Step 1: Time Period Selection

Ask the user: "Would you like to see:

1. Yesterday only

2. Last 7 days

3. Last 30 days

Default: Yesterday"

If no response: Default to Yesterday (Option 1)

Step 2: Data Collection

For each campaign with spend > $0 and conversions = 0, retrieve:

• Campaign name

• Account name (if multiple accounts)

• Total spend

• Total clicks

• Campaign status (Active, Paused, etc.)

Step 3: Calculations

For each zero-conversion campaign:

Cost Per Click:

• Formula: Spend / Clicks

• Round to 2 decimals

• Display with currency symbol

Step 4: Output Format

Header:

GOOGLE ADS CAMPAIGNS WITH ZERO CONVERSIONS

Period: [Date Range]

Total Campaigns: [N]

Total Spend: $[X,XXX.XX]

Main Table:

Campaign NameAccountSpendClicksCPCProduct - Hiking BootsClient A$620.45145$4.28Brand - Winter CollectionClient B$340.2089$3.82Competitor - Nike TermsClient A$255.8067$3.82Non-Brand - Running ShoesClient C$180.5052$3.47Display - RemarketingClient A$12.303$4.10

Campaign NameAccountSpendClicksCPCProduct - Hiking BootsClient A$620.45145$4.28Brand - Winter CollectionClient B$340.2089$3.82Competitor - Nike TermsClient A$255.8067$3.82Non-Brand - Running ShoesClient C$180.5052$3.47Display - RemarketingClient A$12.303$4.10

Step 5: Error Handling

Handle data limitations gracefully:

• No campaigns found: "Good news! All campaigns with spend generated at least one conversion during this period."

• No conversion tracking: "Conversion tracking not detected on this account. Cannot identify zero-conversion campaigns."

• All campaigns paused: "No active campaigns with spend in this period."

Workflow Summary

1. Ask Time Period → Yesterday, 7 days, or 30 days

2. Retrieve Data → Get all campaigns with spend > $0 and conversions = 0

3. Calculate CPC → Compute cost per click

4. Format Output → Present simple table sorted by spend (highest first)

5. Handle Errors → Address no results or tracking issues