Built in-house Β· Live today Β· 50+ users

We built AI into how
we manage Google Ads.
Not as a feature. As a workflow.

Our Search Term Optimiser analyses up to 100,000 search terms per account run - in minutes. Every account. Every week. No manual review.
See it in actionSee it in action
STO Tool - No license cost. Built for scale.

Our Search Term Optimizer

Overview

AI-powered Google Ads search term analysis - built in-house for the Uplers team.

Team members using it
50+

Across all account managers

Accounts per manager
15–20

Each with its own Sheet

Terms per run
100k

Up from manual 0

Before this tool, reviewing search terms was done manually - hours per account, per week. Now it takes minutes. The AI analyses every term, assigns a decision, and writes results directly into the team member's Google Sheet.

Built in-house
Zero license cost
Live today
Auto-updates to all users
The problem we solved

Every account manager was spending hours reviewing search terms by hand. It was slow, inconsistent, and not all accounts could be covered every week.

Before - manual process
2–4 hrs per account per review
Only a few accounts reviewed each week - 15–20 was not feasible manually
Inconsistent decisions across the team
No client-specific logic
No audit trail or history
After - STO tool
5–15 min per account per run
All 15–20 accounts covered every single week
Consistent AI-driven decisions
Per-client goal logic (CPA, ROAS, CPC)
Full history in every Sheet
Time saved per manager/week
30–80 hrs

2–4 hrs Γ— 15–20 accounts

Team-wide hours saved/week
1,500–4,000

Across 50+ managers

Decision consistency
100%

Same logic across all accounts

How it works

No technical knowledge required. One-time setup, then three steps every time.

0
One-time setup - 3 minutesOnly once

Double-click the installer, enter work email, done. The tool installs itself silently - no IT involvement, no admin rights needed. Starts automatically every time the laptop is switched on.

1
Open Google Sheet and click Run

Each manager has their own Google Sheet per client. They open the sidebar, confirm the client goal settings, and click Run Analysis.

2
AI analyses every search term

Two AI models work in sequence. The first classifies every term into one of 12 decisions. The second cross-checks uncertain results. Up to 100,000 terms per run.

3
Results appear in the Sheet automatically

Negatives, keywords to add, opportunities, and items for review - all written into separate tabs. Summary dashboard and history updated automatically.

The manager never leaves Google Sheets. No separate tool, no login, no export or import. Results appear where the work already happens.

Personalization

Different clients have different goals. The AI applies the correct logic per account - not a one-size-fits-all approach.

Campaign objective

Leads, Sales, Traffic, Awareness, App Installs, Local Visits - the AI understands what success looks like for each.

Goal type + target

CPA target, ROAS target, CPC cap, CTR minimum - the AI evaluates every term against the client's actual number.

Custom negative rules

"Always negative competitor terms" or "exclude job-related searches" - written in plain English, applied automatically.

Custom context

"Seasonal campaign Oct–Dec only" or "B2B only, ignore consumers" - the AI factors in everything the manager knows about the client.

Settings are saved per Sheet and set only once per client. A ROAS client and a CPA client with the same search terms will get completely different - and correct - recommendations automatically on every run.

Cost estimation

AI API + a small cloud server fee. All infrastructure runs on each manager's own laptop - zero shared server cost.

Cost breakdown

Per 1,000 terms

~$0.08–0.12

Per 10,000 terms

~$0.80–1.20

Per 50,000 terms

~$4–6

Central server (Railway)

$5 / month

Full team calculation

50 managers Γ— 15–20 accounts Γ—
avg 5,000 terms Γ— 1 run/week

~$300–600 / week

Monthly AI cost (all 50+ users, all accounts)

~$1,200–2,400 / month

Total monthly

~$1,205–2,405

Two ways to look at the cost
Cost per account / month
$1.60

$1,200 Γ· 50 managers Γ· 15 accounts‍

Less than the cost of a coffee per client account per month.

Monthly ROI
8–20Γ—

Conservative estimate at β‚Ή200/hr

1,500–4,000 hrs saved/week Γ— β‚Ή200 = β‚Ή3–8 lakh/week in recovered productivity. Tool costs ~β‚Ή1–2 lakh/month.

Infrastructure cost
$0

Runs on manager laptops

License cost
$0

Built in-house

Cost per manager/month
$24–48

All accounts included

Next planned optimisation: direct Gemini API key removes the OpenRouter middleman commission (~15–20% cost reduction) + token optimisation reduces AI usage by a further 30–40%. Combined saving could bring the monthly bill down to ~$700–1,400.

Journey

Built iteratively - starting from a basic proof of concept, solving real scaling and reliability problems along the way.

01.
Phase 1 - Core toolDone

AI analysis via Google Sheets sidebar. Two-pass AI (Gemini + GPT-4o-mini). 12 decision types. Results written back to Sheet tabs automatically.

02.
Problems hit at scale Solved

Single shared office server crashed under 50 users. One shared API key hit rate limits - everyone blocked simultaneously. 70,000 terms taking 8–10 hours. Server going down stopped all 50 users at once.

03.
Phase 2 - Scale and reliabilityDone

Moved from shared server to each manager's own laptop - no more single point of failure. Per-user API keys β€” no shared rate limits. Central auth server on Railway for access control, daily limits, and budget tracking. Silent one-click installer. Auto-update system pushes new code to all machines silently.

04.
Phase 3 - PersonalisationDone - live today

Per-client goal settings: Campaign Objective, Goal Type (CPA/ROAS/CPC/CTR), Target Value, custom rules. AI applies different logic per account automatically.

05.
Phase 4 onwardsPlanned

Direct Gemini key, token optimisation, one-click push to Google Ads, scheduled automatic runs.

Next steps

Four planned improvements - two reduce cost, two remove manual work entirely.

01.
Direct Gemini API keyCost saving

Currently routing through OpenRouter which adds a commission on every call. Switching to a direct Google Gemini key removes this entirely - estimated 15–20% cost reduction with zero change to output quality.

02.
Token optimisation Cost saving

The data sent to the AI per batch can be trimmed without losing decision quality. Removing redundant fields and compressing the system prompt is estimated to reduce token usage by 30–40% - significantly cutting the monthly AI bill.

03.
Direct push to Google AdsRemoves manual step

Today: manager reviews AI decisions, then manually applies them in Google Ads. Next: manager reviews, clicks Approve, changes apply automatically. One click replaces hours of implementation work per account.

04.
Scheduled automatic runsFull automation

Search campaigns: weekly automatic runs with no manual trigger β€” ready to build. PMax campaigns: waiting for Google to enable search term access via their API (not yet available). Once enabled, the entire workflow becomes fully automatic for all campaign types.

Admin controls

The admin has full visibility and control over the entire team - from one central panel. No access to individual machines needed.

01.
User access management

Add or remove team members instantly. Turn any user on or off without touching their machine. New users are live within seconds of being added.

02.
Per-user spend limits

Set a maximum daily AI spend per user. Set a monthly budget cap for the entire team. If the budget is hit, the system pauses automatically - no surprise bills.

03.
Daily run limits

Cap how many analysis runs each user can do per day. Prevents accidental over-usage while giving the team full flexibility within the limit.

04.
Live usage log

Every run is logged - who ran it, how many terms, how long it took, cost, status. Full audit trail visible in the admin Google Sheet in real time.

05.
Maintenance mode

One toggle puts the entire system into maintenance mode - all users get a clear message, no jobs processed until the admin turns it back on.

06.
Per-user API keys

Each user has their own AI API key stored securely in the admin sheet. No shared key - one user hitting a limit never affects another user's work.

All admin controls live in a single Google Sheet. No dashboard to log into, no code to change. Add a user, set a limit, check usage - all in the same place the team already works.

Summary

A production-grade in-house AI tool - live, used daily, and improving every sprint.

Status
Live

50+ users on v1.0.1

Monthly total cost
$1,200–2,400

All 50+ users, all accounts

Cost per account/month
$1.60

Less than a coffee

What is live today

Full AI analysis Β· Per-client goal settings Β· 12 decision types Β· Auto-update to all machines Β· Central admin controls Β· Usage and spend tracking Β· Silent one-click installer Β· Per-user API keys Β· No shared server

What is coming next

Direct Gemini key (lower cost) Β· Token optimisation (lower cost) Β· Push to Google Ads (less manual work) Β· Scheduled runs for Search campaigns Β· Full automation when Google enables PMax

The end state: a manager opens Google Ads on Monday morning and the previous week's search terms have already been reviewed, decisions approved, and changes applied - automatically, for every client, every week.

Built in-house
No license fees
Scales to 500+ users
Runs on manager laptops
Auto-updates silently
Full automation roadmap
1 / 9
Personalization

Every client gets the right analysis.

Different clients have different goals. The AI applies the correct logic per account- not a one-size-fits-all approach.

01.

Leads, Sales, Traffic, Awareness, App Installs, Local Visits - the AI understands what success looks like for each.

02.

CPA target, ROAS target, CPC cap, CTR minimum - the AI evaluates every term against the client's actual numbers.

03.

"Always negative competitor terms" or "exclude job-related searches" - written in plain English, applied automatically.

04.

"Seasonal campaign Oct–Dec only" or "B2B only, ignore consumers" - the AI factors in everything the manager knows about the client.

What we are building next

This is a living system, not aone-time build.

Four planned improvements - two reduce cost further, two remove remaining manual steps entirely.

Cost saving

Direct Gemini API key

Removes the OpenRouter middleman, cutting AI costs by 15–20% with zero change to output quality.

Cost saving

Token optimization

Trimming data sent per batch reduces token usage by 30–40%, cutting the monthly AI bill further.

Less manual work

Direct push to Google Ads

Manager reviews AI decisions, clicks Approve - changes apply automatically. One click replaces hours of implementation per account.

Full automation

Scheduled automatic runs

Weekly runs with no manual trigger needed. The end state: a manager opens Google Ads on Monday and last week's work is already done.

Want to see what this means for your clients?

We will walk you through how STO works and how it translates into better Google Ads results - every week, at scale.