Recipes / How is my Google Ads spend trending day by day?

How is my Google Ads spend trending day by day?

Segmenting by segments.date turns a date-range total into a day-by-day series: select campaign.name, metrics.cost_micros, and segments.date from campaign, grouped by date. This is a custom GAQL query rather than a fixed tool, so it runs through run_gaql_report.

The report

GAQL fieldWhat it means
campaign.nameThe campaign's name.
metrics.cost_microsCost in micros - divide by 1,000,000 for the real amount.
segments.dateThe individual calendar date a row of metrics applies to, when you segment by day.

Resource: campaign. Tool: run_gaql_report - there's no single built-in tool for this, so Caybl.ai runs it as a custom, read-only GAQL query.

Ask it in plain English

“Show me daily spend by campaign for the last 14 days.”

Ask that in Claude or ChatGPT once Google Ads is connected through Caybl.ai, and your agent builds this exact report - you don't need to know the GAQL field names above at all.

What actually trips people up

Spend is dated to when the impression or click happened, not when it's invoiced - but the most recent day or two in any trend are still provisional. Google continues reconciling clicks in the hours and days after they occur (invalid-click credits, delayed conversion attribution), so the last 1-2 points in a daily series can shift after the fact; treat only everything before that window as final.

Ask your own Google Ads account this

Connect once, then ask in plain English. No tokens, no setup.

Get started free

FAQ

Which GAQL fields does "How is my Google Ads spend trending day by day?" need?

campaign.name, metrics.cost_micros, segments.date, from the campaign resource. These are the real Google Ads Query Language (GAQL) field names, so the same report can be built in the Google Ads UI, the API, or through Caybl.ai.

Can I just ask "Show me daily spend by campaign for the last 14 days." instead of writing GAQL?

Yes. Once Google Ads is connected through Caybl.ai, ask "Show me daily spend by campaign for the last 14 days." and your agent runs the report for you - no need to know the campaign.name field or write GAQL yourself.

Does asking about campaign change anything in my Google Ads account?

No. This is a read-only report - it uses Caybl.ai's read access to Google Ads and doesn't touch campaigns, budgets, or keywords. Making changes to your account is a separate, opt-in permission you control per connection.

Related recipes

Sources

  • Google Ads Query Language (GAQL) reference - official Google documentation