Google Ads audit
“audit our google ads keywords: show each keyword with its campaign, quality score and click-through rate as a percent; status Agrees when quality score is 5 or more and click-through rate is 3% or more, Low quality score when the score is under 5, Low click rate when it's under 3%”
audit our Google Ads keywords: show each keyword with its campaign, quality score and click-through rate as a percent; status Agrees when quality score is 5 or more and click-through rate is 3% or more, Low quality score when the score is under 5, Low click rate when it's under 3%
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileGoogle Ads keywordsCSV export · 16 rows
- StepLabel keyword performanceStep 1
- ResultGoogle Ads Keyword Audit16 rows · 5 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 16 rows came out.
- Download Google Ads keywords sample (16 rows)Google Ads: Keywords > Search keywords > Download > CSV (custom columns: Campaign, Keyword, Quality score, CTR)
What you get back
The result of that run, the rows to look at first.
| Keyword | Campaign | Quality score | Click-through rate (%) | Status |
|---|---|---|---|---|
| best rival replacement | Competitor Search | 3 | 1.8 | Low quality score |
| embedded analytics | Nonbrand Search | 4 | 4.2 | Low quality score |
| revenue analytics | Industry Search | 4 | 2.4 | Low quality score |
| rival app alternative | Competitor Search | 6 | 2.7 | Low click rate |
| talk to sales | Retargeting Search | 5 | 2.9 | Low click rate |
| analytics dashboard | Nonbrand Search | 9 | 5.9 | Agrees |
| book a demo | Retargeting Search | 8 | 7.1 | Agrees |
| business reporting software | Nonbrand Search | 5 | 3.3 | Agrees |
| kpi dashboard | Generic Search | 5 | 3 | Agrees |
| northstar ai | Brand Search | 7 | 4.9 | Agrees |
| northstar analytics | Brand Search | 8 | 6.4 | Agrees |
| northstar pricing | Brand Search | 6 | 3.1 | Agrees |
How do you audit your Google Ads keywords?
Export your Google Ads keywords, then upload the file to Mammoth. It shows each keyword with its campaign, quality score, and click-through rate, then labels the row based on your rules.
How it works
How to use the Google Ads Keyword Audit 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.
Google Ads Keyword Audit: questions
What export should you use?
What happens to rows that do not match a rule?
How do you change the rules?
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.
- Customer acquisition cost by channelCalculate customer acquisition cost by channel each month from HubSpot exports, with CAC rounded to whole dollars and a simple status.See the workflow Built by the agent
- 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
- Content auditEvery page's clicks now and before, and a keep, update or prune callSee the workflow Template
- Google Ads wasted spendFind search terms with spend and no conversions in the last 30 days, ranked by spend, from a Google Ads export.See the workflow Built by the agent
- Keyword rankings changeCompare this month's average position with last month from Search Console and see which keywords moved up or down in a keyword ranking report.See the workflow Built by the agent
- Negative keyword finderEvery search term that spent money and never converted, with its share of spendSee the workflow Template