Reddit Ads report by campaign and community
“use reddit ads and monthly budgets; show campaign, ad group, community, spend, clicks, impressions, conversions, cost per conversion, and status: Over budget, No conversions, Low CTR, or Agrees when campaign spend is within budget and clicks per thousand impressions is 1 or more.”
use Reddit Ads report by campaign and community and Reddit Ads monthly budgets; show campaign, ad group, community, spend, clicks, impressions, conversions, cost per conversion, and status: Over budget, No conversions, Low CTR, or Agrees when campaign spend is within budget and clicks per thousand impressions is 1 or more.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
- FileReddit Ads report by campaign and communityCSV export · 24 rows
- FileReddit Ads monthly budgetsCSV export · 6 rows
- StepTotal spend by campaignStep 1
- StepMake budget campaign keyStep 2
- JoinBring in campaign budgets24 of 24 paired
- StepCalculate cost and statusStep 4
- ResultReddit Ads Status24 rows · 10 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 24 rows.
- Download Reddit Ads report by campaign and community sample (24 rows)Reddit Ads: Reporting > Campaigns > Export table, filtered to last 30 days and grouped by campaign and ad group
- Download Reddit Ads monthly budgets sample (6 rows)Reddit Ads: Billing > Budgets > Export
What you get back
The result of that run, the rows to look at first.
| Campaign | Ad group | Community | Spend | Clicks | Impressions | Conversions | Cost per conversion | Status | Campaign spend | Monthly budget |
|---|---|---|---|---|---|---|---|---|---|---|
| Prospecting | PR - Broad Tech | r/technology | 132.50 | 243 | 35,200 | 0 | · | No conversions | 486.90 | 500 |
| Prospecting | PR - Interest Stack | r/buildapc | 118.20 | 196 | 28,700 | 0 | · | No conversions | 486.90 | 500 |
| Brand Awareness | BA - Daily Life | r/lifehacks | 287.10 | 221 | 39,450 | 11 | 26.10 | Over budget | 1,200 | 1,000 |
| Brand Awareness | BA - Gaming Reach | r/gaming | 304.95 | 268 | 43,800 | 13 | 23.46 | Over budget | 1,200 | 1,000 |
| Brand Awareness | BA - New Parents | r/parenting | 309.55 | 336 | 51,600 | 16 | 19.35 | Over budget | 1,200 | 1,000 |
| Brand Awareness | BA - Tech Intro | r/technology | 298.40 | 312 | 48,200 | 14 | 21.31 | Over budget | 1,200 | 1,000 |
| Content Syndication | CS - Guide Download | r/UXDesign | 58.20 | 1 | 6,400 | 3 | 19.40 | Low CTR | 222.00 | 700 |
| Content Syndication | CS - Newsletter Signup | r/EntrepreneurRideAlong | 52.60 | 2 | 6,900 | 5 | 10.52 | Low CTR | 222.00 | 700 |
| Content Syndication | CS - Report Access | r/dataisbeautiful | 61.40 | 1 | 7,200 | 2 | 30.70 | Low CTR | 222.00 | 700 |
| Content Syndication | CS - Template Offer | r/productivity | 49.80 | 2 | 5,800 | 4 | 12.45 | Low CTR | 222.00 | 700 |
| Community Growth | CG - AMA Invite | r/AmItheAsshole | 78.40 | 145 | 23,100 | 12 | 6.53 | Agrees | 321.10 | 650 |
| Community Growth | CG - Discussion Starter | r/AskReddit | 82.10 | 168 | 24,800 | 15 | 5.47 | Agrees | 321.10 | 650 |
How it works
How to use the Reddit Ads Status workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Reddit Ads Status: questions
How do you report Reddit Ads results by campaign and community?
Which export do I need for this workflow?
What happens to rows that do not match a budget?
How do I change the rules in words?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.
- Customer lifetime value by cohortWork out customer lifetime value by signup month cohort from Shopify customers and orders exports, with revenue per customer and average order count.See the workflow Built by the agent
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Pareto (ABC) analysisEvery item ranked by its total, with its share, the running share and an A, B or C classSee the workflow Template
- Inventory turnover by SKURank Shopify SKUs by inventory turnover ratio using product, order, and inventory exports from the last 12 months.See the workflow Built by the agent
- Cohort retentionEach month's new customers, and the share still buying 1, 2, 3… months laterSee the workflow Template
- Customer segmentation by revenueSegment Stripe customers into revenue tiers from exported customer, charge, and threshold files, then count customers and revenue in each tier.See the workflow Built by the agent