MARKETING
Weekly Campaign Scorecard to Notion
Each Monday, builds a week-over-week UTM campaign performance scorecard from BigQuery spend and Stripe revenue and writes a structured page into a Notion database.
How it runs
The automated pipeline, trigger to output.
- TriggerMonday morning schedule
- ActionTwo-week spend per campaignBigQuery
- ActionTwo-week Stripe revenue per campaignStripe
- LogicCompute ROAS and week-over-week deltas
- ActionWrite dated scorecard page to NotionNotion
- OutputSlack link to the new scorecardSlack
What it does
It produces a durable weekly record of campaign performance. For each UTM campaign it pulls last week's spend and revenue, compares them to the prior week, and writes a structured scorecard row into a Notion database so the team has a browsable history instead of ephemeral Slack messages.
When to use it
Use it when leadership reviews marketing in a recurring Notion doc and wants trend context (up/down vs. last week) rather than a single day's snapshot. Pairs well with QBR prep.
How it works
- 1A Monday-morning schedule starts the run.
- 2BigQuery returns spend per `utm_campaign` for the prior two ISO weeks.
- 3Stripe revenue for the same two weeks is pulled per campaign.
- 4A logic step computes current-week ROAS, week-over-week deltas, and a trend direction per campaign.
- 5A new dated page is created in the Notion campaign-scorecard database with a table of campaigns, spend, revenue, ROAS, and deltas.
- 6A short Slack note links to the new Notion page.
Set it up
What you configure once, before turning it on.
- 1Connect BigQueryDatasets, queries, schemas.
- 2Connect StripeCustomers, subscriptions, payments.
- 3Connect NotionPages, databases, comments.
- 4Connect SlackChannels, DMs, threads, mentions.
- 5Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 6Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 7Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Marketing workflows
UTM Link Linter: Block Malformed Tracking URLs Before Launch
Validates every campaign tracking link queued in an Airtable launch table against your UTM naming rules.
Spin up a rush localization handoff from a Slack chat request
A marketer asks the CEO agent in chat to rush-translate a piece of approved copy into specific languages; the agent files the source in Google Drive.
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.
UTM Audit for Campaign Spreadsheets in Google Drive
Watches a Google Drive folder for new or updated campaign link spreadsheets, lints every URL inside.
Real-Time UTM Validator API for Link-Building Forms
Exposes a webhook that validates a tracking URL on the fly and returns a structured pass/fail JSON response.
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.
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.