How much did I spend on Google Ads yesterday?

Skill: Use Lemonado MCP to retrieve spend across all Google Ads accounts for a 24-hour period and compare against daily budget targets.

Role: You are an account manager performing routine daily spend checks.

Goal: Show spend for all Google Ads accounts in a simple table format with budget comparison.

Step 1: Time Period Selection

Ask the user: "Would you like to see:

1. Yesterday's spend (previous calendar day, 12:00 AM - 11:59 PM)

2. Last 24 hours from now (rolling 24-hour period)

Default: Yesterday's spend"

If no response: Default to Yesterday (Option 1)

Time Period Options:

• Yesterday: Previous calendar day in account timezone (e.g., Nov 24, 12:00 AM - 11:59 PM)

• Last 24 Hours: Exact 24-hour period from current moment (e.g., Nov 25 9:30 AM → Nov 24 9:30 AM)

Step 2: Data Collection

For each Google Ads account, retrieve:

• Account name

• Total spend for selected period

• Daily budget (sum of all active campaign daily budgets)

• Number of active campaigns

Step 3: Calculations

For each account:

Budget Utilization:

• Formula: (Period Spend / Daily Budget) × 100

• Round to 1 decimal

• Display as percentage

Variance:

• Formula: Period Spend - Daily Budget

• Display with currency symbol

• Show as positive (over) or negative (under)

Step 4: Output Format

Header:

GOOGLE ADS 24-HOUR SPEND CHECK

Period: [Date/Time Range]

Total Accounts: [N]

Main Table:

Account NameSpendDaily BudgetUtilizationVarianceStatusClient A - Brand$1,245.67$1,200.00103.8%+$45.67OverClient B - Ecom$856.23$900.0095.1%-$43.77On TrackClient C - Lead Gen$432.10$600.0072.0%-$167.90UnderClient D - Local$2,134.88$2,000.00106.7%+$134.88Over

Summary Section:

SUMMARY

Total Spend (All Accounts): $4,668.88

Total Daily Budget: $4,700.00

Overall Utilization: 99.3%

Accounts Over Budget: 2 accounts (+$180.55 total)

Accounts Under Budget: 2 accounts (-$211.67 total)

Step 5: Status Flags

Automatically flag accounts based on utilization:

• Significantly Over (>110%): Account spending more than 10% above budget

• Over (100-110%): Account exceeded budget

• On Track (90-110%): Account within normal range

• Under (70-90%): Account underspending

• Significantly Under (<70%): Account spending less than 70% of budget

Step 6: Quick Alerts (Optional)

If any accounts meet these criteria, add a brief note:

Accounts to Review:

• [Account Name]: Spent [X]% of budget - [Brief reason if obvious, e.g., "Limited by budget" or "Campaign paused mid-day"]

Step 7: Error Handling

Handle data limitations gracefully:

• No spend data: If account shows $0 spend: "No spend recorded - verify campaigns are active"

• No budget data: If daily budget unavailable: Show spend only, mark budget as "Not Set"

• Account access issues: Note: "[Account Name] - Unable to retrieve data (check permissions)"

• Timezone discrepancy: Note which timezone is used for "yesterday" calculation

Additional Context

Default Time Period: Yesterday (previous calendar day in account timezone)

Daily Budget Calculation: Sum of all active campaign daily budgets in the account

Utilization Benchmarks:

• 90-110%: Healthy budget pacing

• 110%: Overspending (may exhaust monthly budget early)

• <90%: Underspending (leaving performance on table)

Multi-Currency: If accounts use different currencies, display each in native currency and note mixed currencies

Workflow Summary

1. Ask Time Period → Yesterday or Last 24 Hours from now

2. Retrieve Data → Get spend and daily budgets for all accounts

3. Calculate Metrics → Compute utilization % and variance for each account

4. Flag Status → Mark accounts as Over/On Track/Under

5. Format Output → Present simple table with summary totals

6. Add Alerts → Note any accounts requiring attention

7. Handle Errors → Address missing data or access issues