Workflow · Search and ads · Opening soon
Google Ads wasted spend
Export your Google Ads search terms report, then flag search terms that spent money with no conversions in the last 30 days. Sort the worst waste first and keep the rows that need a closer look.
Someone typed
“show every google ads search term by day from the search terms export, with a Status that says "Agrees" when spend has conversions and no duplicate row, else flag zero-conv or duplicate spend”
The agent read it as
Show every search term by day from Google Ads search terms, with a Status that says "Agrees" when spend has conversions and no duplicate row, else flag zero-conv or duplicate spend.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Google Ads search terms
CSV export · 22 rows
Step
Flag rows
Step 1
Result
Search term flags
22 rows · 19 flagged
Schedule
Runs when you say
Proposed
- FileGoogle Ads search termsCSV export · 22 rows
- StepFlag rowsStep 1
- ResultSearch term flags22 rows · 19 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 22 rows came out.
- Download Google Ads search terms sample (22 rows)Google Ads: Insights and reports > Search terms > Download
What you get back
The result of that run, the rows to look at first.
Search term flagsSample data22 rows
3 agrees19 no conversions
| Date | Campaign | Ad group | Search term | Match type | Cost | Conversions | Status |
|---|---|---|---|---|---|---|---|
| 2026-10-01 | US | Search | Brand | brand search | northstar coffee roasters careers | Exact match | 12.40 | 0 | No conversions |
| 2026-10-23 | US | Search | Nonbrand | equipment finance | commercial coffee machine lease | Phrase match | 154.78 | 0 | No conversions |
| 2026-10-15 | US | Search | Nonbrand | accessories | coffee grinder wholesale | Broad match | 89.70 | 0 | No conversions |
| 2026-10-24 | US | Search | Nonbrand | bean subscriptions | wholesale coffee beans supplier | Broad match | 168.40 | 0 | No conversions |
| 2026-10-08 | US | Search | Nonbrand | filters | espresso machine cleaning tablets | Broad match | 58.90 | 0 | No conversions |
| 2026-10-28 | US | Search | Nonbrand | espresso machines | commercial espresso machine | Broad match | 312.40 | 0 | No conversions |
| 2026-10-04 | US | Search | Nonbrand | bean subscriptions | single origin coffee beans wholesale | Broad match | 104.06 | 0 | No conversions |
| 2026-10-25 | US | Search | Nonbrand | bean subscriptions | bulk espresso beans wholesale | Broad match | 176.92 | 0 | No conversions |
| 2026-10-06 | US | Search | Nonbrand | coffee equipment | office coffee maker supplier | Phrase match | 139.91 | 0 | No conversions |
| 2026-10-14 | US | Search | Nonbrand | maintenance | espresso machine repair service | Phrase match | 97.20 | 0 | No conversions |
| 2026-10-10 | US | Search | Nonbrand | accessories | barista tools wholesale | Broad match | 77.52 | 0 | No conversions |
| 2026-10-13 | US | Search | Nonbrand | filters | commercial water filter coffee | Broad match | 64.53 | 0 | No conversions |
How do you find Google Ads search terms with wasted spend?
Export your Google Ads search terms report, then group it by search term and day. Mammoth shows each row with a Status, and flags rows with zero conversions or duplicate spend so you can focus on the search terms that wasted budget.
How it works
How to use the Search term flags workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the 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.
Search term flags: questions
Which Google Ads export should I use?
Use the search terms export from Google Ads. Pick the columns you need for search term, date, spend, and conversions.
What happens to rows that do not match the rule?
Rows that do not match stay in the output with a flag, not a delete. That lets you review why they were not counted as a clean match.
How do I change the rule in words?
Change the wording of the rule to match the rows you want to catch. For example, you can ask for a different date range, a different metric threshold, or a different sort order.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Decide which pages to keep, update or prune, and find the search terms that spend without converting.
- ROAS by campaignCalculate ROAS by campaign from Google Ads and Shopify exports, matched by week and utm campaign.See the workflow Built by the agent
- Multi-touch attributionSplit closed HubSpot deal credit across touchpoints, by touch and by channel, from exported deal, contact, engagement, and channel mapping files.See the workflow Built by the agent
- Blended ROAS across Google and Meta AdsCombine Google Ads and Meta Ads exports with Shopify orders to see weekly blended ROAS, with duplicate rows flagged first.See the workflow Built by the agent
- HubSpot leads by source, monthlyTrack new leads per month by original source and count customers from a HubSpot contacts export.See the workflow Built by the agent
- LinkedIn Ads cost per leadShow LinkedIn Ads campaign cost per lead by week, sorted highest first, from your exported campaign file.See the workflow Built by the agent
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template