Skip to content
Log inStart free

An AI-generated daily ad spend report. Yesterday's spend, clicks, signups, CPC, and CPA across Google, Meta, Reddit, LinkedIn, and TikTok.

Use this templateHow automations work
Runs dailyScheduledDelivered to Slack, Email
Daily ad spend report
Active

Trigger

Runs daily

Instructions

Write a single Slack message summarizing yesterday's ad spend across every paid channel.

Delivery

Slack · Email

Example output

A realistic sample of what this automation delivers — your version draws on your data.

Daily ad spend reportRuns daily · Sent to Slack, Email
Sample output
Yesterday's spend by channel$1,240 total
Total1,240
Google Ads620(50%)
Meta310(25%)
Reddit180(15%)
LinkedIn90(7%)
TikTok40(3%)

Yesterday’s spend: $1,240 across 5 channels — 612 clicks, 34 signups, blended $36.47/signup.

Channel Spend Clicks Signups CPS Note
Google Ads $620 318 21 $29.52 On trend
Meta $310 162 8 $38.75 On trend
Reddit $180 84 4 $45.00 +63% vs. 14d avg
LinkedIn $90 32 1 $90.00 Under threshold, paused this morning
TikTok $40 16 0 — Killed yesterday

Watch. Reddit CPA spiked yesterday — check creative fatigue on the r/dataisbeautiful placement. LinkedIn auto-paused after 5 days above the $80 CPA cap.

Generated by Basedash AI from your connected data sourcesMarketing
The prompt

Copy, paste, customize.

Drop this into a Basedash automation. AI fills in the numbers from every source you've connected.

Instructions
Write a single Slack message summarizing yesterday's ad spend across every paid channel.

Format:

"Yesterday we spent $<total> across <n> channels, drove <clicks> clicks and <conversions> signups — averaging $<cpc> per click and $<cpa> per signup."

Then add a one-line breakdown per channel sorted by spend:

- Google Ads: $X spend, Y clicks, Z signups ($/signup)
- Meta: ...
- Reddit: ...
- LinkedIn: ...

Flag any channel whose CPA is 50% above its trailing 14-day average.

Skip channels with zero spend.
Data sources

Powered by these sources.

Basedash automations read across every connected source in a single run. These are the ones this template tends to use most.

Frequently asked questions

Why send a daily ad spend report?

Daily visibility into spend, CPC, and CPA catches budget mistakes — bid issues, audience changes, paused conversions — within hours instead of weeks. That speed is the difference between a $200 mistake and a $2,000 one.

What's a good cost per signup?

Target CPS depends on your LTV. Healthy self-serve SaaS lands in the $40-$120 range; sales-led businesses can pay much more if downstream conversion is strong. The report should compare daily CPA to your moving target — not just yesterday alone.

Keep going

Related templates

Marketing · Runs weekly

Weekly marketing report

Pulls traffic, signups, ad spend, attribution, and campaign data into a single weekly marketing recap.

Marketing · Runs daily

Email campaign performance

Daily email performance recap with opens, clicks, conversions, and deliverability flags.

Marketing · Runs weekly

SEO performance digest

A weekly SEO recap with top movers, new keywords, lost rankings, and content opportunities surfaced by AI.

We can help you migrate your data and dashboards from any other tool.

Start freeBook a demo