MARKETING
Weekly Paid Budget Reallocation by Blended CAC
Every Monday, pulls last week's spend and new-customer counts per channel from BigQuery, computes blended CAC.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday 7am schedule fires
- ActionQuery trailing-7-day spend and new customers per channelBigQuery
- LogicCompute blended CAC and flag vs. target
- LogicBuild budget-flat reallocation plan
- OutputPost approval plan to SlackSlack
What it does
Each Monday morning this workflow queries your warehouse for the prior 7 days of paid spend and attributed new customers per channel, calculates blended CAC for each channel and overall, then ranks channels against your target CAC. It produces a concrete reallocation plan (e.g. "cut Meta -15%, move to Google Search") and posts it to a Slack channel for the growth lead to approve before anyone touches an ad account.
When to use it
Use this when paid budgets are managed manually and weekly check-ins drift on gut feel. It is built for teams who want a disciplined, data-backed weekly ritual but still want a human to approve before money moves.
How it works
A Monday 7am schedule fires the run. It queries BigQuery for per-channel spend and new customers over the trailing week. A logic step computes blended CAC per channel and flags channels above and below your target threshold. A second logic step builds a proportional shift plan that holds total budget flat. The plan, with before/after percentages and CAC deltas, is posted to Slack as a formatted approval message.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
Slack UTM Check: Paste a Link, Get an Instant Verdict
Lets marketers drop a tracking URL into a Slack channel and get an immediate threaded reply that says whether the UTMs are valid, what is wrong, and a corrected suggestion.
Unlinked Brand-Mention Detector with Authority Scoring
Scans the web for fresh brand mentions, filters to ones that name you without linking back, scores the publishing domain's authority.
Agentic UTM Taxonomy Steward: Detect, Explain, and Propose Fixes
An agent reviews the full backlog of campaign links in Airtable, reasons about taxonomy drift beyond rigid rules, drafts standardized replacements for malformed UTMs.
Nudge translators on overdue localization returns and escalate stuck ones
Runs on a daily schedule, scans monday.com translation subtasks for items past their return date that aren't marked Returned, reminds the assigned translator in Slack.
Backlink Outreach Drafter for Verified Mentions
Picks verified, high-authority unlinked mentions from Airtable, drafts a personalized backlink-request email for each.
Source-Authority Verifier for Mention Provenance
Takes a queue of detected brand mentions and runs an agent that verifies whether each source is a legitimate, authoritative publisher versus a scraper or syndication copy.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.