Skip to content
Workflow · Track and forecast · Opening soon

Reddit Ads report by campaign and community

Export your Reddit Ads report by campaign and ad group, plus your monthly budgets file. Then Mammoth matches the campaign rows, calculates spend, CTR, and cost per conversion, and flags each row with a status.

Early access opens shortly. Check back soon.

Someone typed

“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.”

The agent read it as

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.

  1. File
    Reddit Ads report by campaign and community
    CSV export · 24 rows
  2. File
    Reddit Ads monthly budgets
    CSV export · 6 rows
  3. Step
    Total spend by campaign
    Step 1
  4. Step
    Make budget campaign key
    Step 2
  5. Join
    Bring in campaign budgets
    24 of 24 paired
  6. Step
    Calculate cost and status
    Step 4
  7. Result
    Reddit Ads Status
    24 rows · 10 flagged
  8. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 24 rows.

What you get back

The result of that run, the rows to look at first.

Reddit Ads StatusSample data24 rows
14 agrees4 low CTR4 over budget2 no conversions
CampaignAd groupCommunitySpendClicksImpressionsConversionsCost per conversionStatusCampaign spendMonthly budget
ProspectingPR - Broad Techr/technology132.5024335,2000·No conversions486.90500
ProspectingPR - Interest Stackr/buildapc118.2019628,7000·No conversions486.90500
Brand AwarenessBA - Daily Lifer/lifehacks287.1022139,4501126.10Over budget1,2001,000
Brand AwarenessBA - Gaming Reachr/gaming304.9526843,8001323.46Over budget1,2001,000
Brand AwarenessBA - New Parentsr/parenting309.5533651,6001619.35Over budget1,2001,000
Brand AwarenessBA - Tech Intror/technology298.4031248,2001421.31Over budget1,2001,000
Content SyndicationCS - Guide Downloadr/UXDesign58.2016,400319.40Low CTR222.00700
Content SyndicationCS - Newsletter Signupr/EntrepreneurRideAlong52.6026,900510.52Low CTR222.00700
Content SyndicationCS - Report Accessr/dataisbeautiful61.4017,200230.70Low CTR222.00700
Content SyndicationCS - Template Offerr/productivity49.8025,800412.45Low CTR222.00700
Community GrowthCG - AMA Inviter/AmItheAsshole78.4014523,100126.53Agrees321.10650
Community GrowthCG - Discussion Starterr/AskReddit82.1016824,800155.47Agrees321.10650
24 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Reddit Ads Status workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your Reddit Ads report by campaign and ad group, plus your monthly budgets file. Then Mammoth matches the campaign rows, calculates spend, CTR, and cost per conversion, and flags each row with a status. You can spot campaigns that are over budget, ad groups with no conversions, and ad groups with fewer than one click per thousand impressions.
Which export do I need for this workflow?
Use the Reddit Ads report export with campaign, ad group, community, spend, clicks, impressions, and conversions. Add a separate monthly budgets export so the workflow can compare spend against budget.
What happens to rows that do not match a budget?
The workflow still keeps the Reddit Ads row. If it cannot find a matching budget row, the budget check will not have a value for that row, while the other calculations still run on the export data.
How do I change the rules in words?
Edit the written rules for the status checks. You can change the spend limit, the clicks per thousand impressions threshold, or the no conversions condition, then rerun the workflow.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.

Workflows like this

The number you report every month, rebuilt from the latest export, plus the forecast that follows from it.

All track and forecast workflows →