Daily ad spend report

Q: 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.

Q: 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.

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

Use this template How automations work

Runs daily Scheduled Delivered 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 report Runs daily · Sent to Slack, Email

Sample output

Yesterday's spend by channel $1,240 total

Google Ads 620 (50%)

Meta 310 (25%)

Reddit 180 (15%)

LinkedIn 90 (7%)

TikTok 40 (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.

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