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.

What happens when a buyer drops out?Illustrative ZIP codes
  1. Coverage changes

    The buyer stops paying for calls from 60625. Calls from 60647 now qualify.

    60625 · no payout60647 · eligible
  2. The sync checks the rules

    It reads the feed and compares the eligible ZIP codes with the campaign’s current targets.

    60618 · still eligible
  3. 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.

Explore custom software and automation

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