Case study · Custom automation
Campaign Zip Sync
When nobody could take a call in a ZIP code, the business could still pay for clicks there. I built a tool that updates Google Ads targeting as coverage changes, so those clicks have a chance to earn money.
Google could still charge for the click
The business gets paid when it sends a call to a buyer that covers the caller’s ZIP code. If nobody is buying calls there, the business earns nothing. Google Ads can still show the ad and charge for the click, even if the ad works perfectly and the person picks up the phone.
Coverage and payouts change. A ZIP code that made sense yesterday can be a dead end today, and a new one can open up while the campaign is still running on yesterday’s list.
Let coverage decide where the ads run
I used the call-pricing feed to answer a simple question for each ZIP code. Is there a buyer, and is the payout within the range the business has set? The team sets those rules in a Google Sheet. The tool compares the qualifying ZIP codes with the campaign’s current targets and changes only what needs to change. Existing location exclusions stay in place.
It now runs on AWS Lambda every 15 minutes. The team gets a record of what changed and an alert if the sync fails.
-
Coverage changes
The buyer stops paying for calls from 60625. Calls from 60647 now qualify.
60625 · no payout60647 · eligible -
The sync checks the rules
It reads the feed and compares the eligible ZIP codes with the campaign’s current targets.
60618 · still eligible -
Google Ads updates
It drops 60625, adds 60647 and keeps 60618. The campaign stops paying for new clicks in the dropped ZIP code.
6061860647
What it saves the team from doing
Coverage can change between manual checks. The sync catches those changes as it runs, dropping ZIP codes where calls stop qualifying and picking up new areas as they open. The team can change the rules in a spreadsheet and see what the tool did, without having to keep Google Ads open all day.
Let’s see if we’re a good fit.
Tell me what you want to improve. We’ll talk through what you’ve tried, what’s getting in the way and where I can help.
Ask for a free consultation