Skip to content
Workflow · Track and forecast · Opening soon

Google Ads weekly campaign report

Export a campaign report from Google Ads, then upload it to Mammoth. It compares the latest week in the file with the week before, shows spend, clicks, conversions, and cost per conversion for both weeks, and flags campaigns that spent but converted nothing, stopped spending, or saw cost per conversion rise by more than a quarter.

Early access opens shortly. Check back soon.

Someone typed

“build a weekly google ads report by campaign: this week's spend, clicks, conversions and cost per conversion next to last week's, and flag campaigns whose cost per conversion rose by more than a quarter, campaigns that spent but converted nothing this week, and campaigns that stopped spending”

The agent read it as

Build a weekly Google Ads report by campaign: this week's spend, clicks, conversions and cost per conversion next to last week's, and flag campaigns whose cost per conversion rose by more than a quarter, campaigns that spent but converted nothing this week, and campaigns that stopped spending, from Google Ads weekly campaign report by campaign, using the latest week in the report.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Google Ads weekly campaign report by campaign
    CSV export · 28 rows
  2. Step
    Compare campaign weeks
    Step 1
  3. Result
    Google Ads Campaign Flags
    14 rows
  4. Schedule
    Runs when you say
    Proposed

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

What you get back

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

Google Ads Campaign FlagsSample data14 rows
CampaignThis week spendThis week clicksThis week conversionsThis week cost per conversionLast week spendLast week clicksLast week conversionsLast week cost per conversionCost per conversion flagConversion flagSpend flag
Brand Search - Retailer Name2251,0151231.832109801201.75···
Category - Home Decor34555815233305401423.57···
Category - Kitchenware2794441027.902654301026.50···
Clearance - Search000·2985201127.09··Stopped spending
Geo - Midwest233415925.89225402925···
Geo - Northeast198372824.75190360823.75···
Holiday Gift Guide - Search2954100·6158402722.78·Spent but converted nothing·
Loyalty Members - Search4707482122.384557302022.75···
New Arrivals - Search4527201825.114306901823.89···
Price Drop - Search8257901363.465107702223.18Rose by more than a quarter··
Remarketing - Cart Abandoners5657852522.605407602422.50···
Spring Sale - Search1,2851,8856420.081,2401,8206220···
14 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Google Ads Campaign Flags 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.

Google Ads Campaign Flags: questions

How do you build a weekly Google Ads report by campaign?
Export a campaign report from Google Ads, then upload it to Mammoth. It compares the latest week in the file with the week before, shows spend, clicks, conversions, and cost per conversion for both weeks, and flags campaigns that spent but converted nothing, stopped spending, or saw cost per conversion rise by more than a quarter.
What export should you use from Google Ads?
Use a campaign report export from Google Ads that includes weekly rows for each campaign. It should have the campaign name, week or date, spend, clicks, conversions, and cost per conversion.
What happens to rows that do not match a campaign week?
Rows that do not match the expected campaign and week pattern are left out of the report. The workflow only compares rows it can line up across the two weeks.
How do you change the rules in words?
Edit the workflow instructions in plain language. For example, change the threshold for the cost per conversion increase, or change which campaign flags you want to see.

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 →