Search terms review from an ads export
Reads a search terms CSV from your ads account and shows where the budget leaks. You get a list of words to exclude, each with a reason, and converting terms to add as keywords. It never connects to the ads account.
What it does
- Reads the last 30 days of search terms from a CSV export
- Asks what you sell, what you do not, and your profit per order
- Flags terms with no sales above three times your order profit
- Excludes by intent, one word at a time, and protects words customers use for your products
- Writes an exclusion list to paste in and a report by campaign
Your approval boundaries
Read onlyReads connected data. It does not send messages or change records.
You decide what happens next.
More about this workflow
This setup is for marketers and solo creators who need steady output without losing their voice. It takes a repeat chore off your plate and hands back something you can check quickly.
First, it reads the last 30 days of search terms from a CSV export. Next, it asks what you sell, what you do not, and your profit per order. Then it flags terms with no sales above three times your order profit. After that, it excludes by intent, one word at a time, and protects words customers use for your products. Finally, it writes an exclusion list to paste in and a report by campaign. It works with your ads manager and spreadsheets, each on its own login with limited access.
You get the finished work, ready to read. It only reads, so nothing is sent, changed or paid for. You decide what to do with it.
“Google Ads search terms review from a CSV export, with evals”
Explore required tools and model recommendations
Tools and access
Ads manager
Handles the ads manager part of this job. Grant read-only reporting access.
API required: Yes. Ad platforms need a developer app and approved access to read reports.
No sign-up neededGoogle Sheets
Handles the spreadsheets part of this job. Grant access to the single sheet it needs.
API required: Yes. Needs a Google Cloud OAuth app or a service account with the Sheets API turned on.
Official links only. Not sponsored, no affiliate links.
Model recommendations
Best pick
GPT-6.1 Sol
Strong general writer at a mid price.
$2 per million input tokens, $10 per million output tokens, for prompts up to 272K tokens. Longer prompts cost $4 in and $15 out.
OpenAI docs as of October 11, 2026
Cheaper backup
GPT-6 Luna
Very low cost for first drafts and digests.
$0.10 per million input tokens, $0.50 per million output tokens, for prompts up to 272K tokens.
OpenAI docs as of October 11, 2026
Our own picks. Not sponsored, no affiliate links.
Build your prompt
Add your details, then copy the prompt into your tool.
2Your prompt
4 of 4 still emptyYour answers stay in this browser only.
Run your workflow
Connect your tools with only the access this setup needs, then follow these steps.
Steps
Do these in order. Test on old data before it touches live work.
- 1Set up Ads manager. Keep it to read-only reporting access.
- 2Connect Google Sheets with its own login, not yours. Grant access to the single sheet it needs.
- 3Paste the prompt where your harness takes instructions. See the note under the Copy button.
- 4Do a dry run on old or test data first. Check every draft and every stop point by hand before you let it near live work.
- 5Read its log after the first real run. Only widen access once a week of runs looks clean.
Safeguards and trust score
The score describes this example setup’s access, approval boundaries, ability to undo changes, and scope.
Read only. It never writes, sends or spends.
Nothing to approve, it only reads.
No changes to undo. Reads can be logged.
Runs on its own login across 2 tools. Fewer connections means a smaller blast radius.
How to raise it
Nothing major to fix. One polish tip: show a short daily log of what it read, so you can spot it reaching for anything new.
Reviewed by Trustcase (example setup). How scoring works
Embed badge
Show this trust score on your site or README. It links back here.
[](https://trustcase.dev/use-cases/search-terms-review-from-an-ads-export)<a href="https://trustcase.dev/use-cases/search-terms-review-from-an-ads-export"><img src="https://trustcase.dev/badge/search-terms-review-from-an-ads-export.svg" alt="Trustcase trust score for Search terms review from an ads export" height="20"></a>More marketing workflows
- Morning content scan with scripts drafted
Before you wake up, a scheduled task reads your sources and newsletters, sorts stories into post today, save for a series, log, ask me or skip, and drafts a script for anything worth posting. One chat message lists only the decisions.
- Content repurposer
Turns one long post into short posts for each channel.
- Comment and mention digest
Shows you the mentions worth answering today.
- Ad report explainer
Explains last week's ad results in plain words.
Other workflows that use the same tools
- Weekly ops report
Operations. Writes the Monday numbers summary so you do not build it by hand.
- Vendor quote compare
Operations. Lines up quotes from several vendors side by side.
- Profit after fees check
Ecommerce and resale. Tells you what you actually clear on a buy before you buy it.