6 Simple Steps to Optimizing Google Ads [2024 Update]

optimising google ads with color coding in excel

Try my #1 trick to optimizing Google Ads and say goodbye to pouring more money into your running Google Ads campaigns with mediocre results.

The 6 simple steps:

  1. Go into your data.
  2. Find your best seller.
  3. Find your best location.
  4. Make separate campaigns for those.
  5. Check your results.
  6. Scale the winner

Highly likely you’ll have an insane ROAS.

Understanding Data

The most important metrics are:

  1. Cost
  2. # Transactions (Txn)
  3. Cost / Txn
  4. Revenue
  5. Revenue / Txn
  6. ROAS (Return on Ad Spend)

When you’re trying to find your best performers, these metrics are enough.

Rest is often noise.

Finding Bestsellers

MetricGoal
Cost (Amount Spent)🎯 Increase if POAS > 1*
# TransactionsπŸ“ˆ Increase
Cost / TransactionπŸ“‰ Decrease
RevenueπŸ“ˆ Increase
Revenue / TransactionπŸ“ˆ Increase
ROASπŸ“ˆ Increase
*POAS > 1 = Profit > Ad Spend

With the above goals in mind, you need to compare your offers.

Offers may be structured at campaign, adset, or ad levels.

Here’s a sample breakdown to compare keywords within an adset:

highlighting google ads roas through conditional formatting in excel

Color coding helps visualize better. You can find the winning combinations in seconds not hours.

For quicker analysis, you can simply use the Google Ads Report Editor.

google ads report editor

Finding Best Locations

Similarly, you can create a view of your best locations, on the same metrics.

A sample report would look like this –

google ads location metrics report

In the example above, New Delhi location seems to be performing almost 3x better than the overall average.

Combining the Best

Google Ads’ report editor will not allow you some combinations like City (User Location) and Search Term.

But you still can pick the locations with the best ROAS aka Conv. Value/ Cost and create separate campaigns.

Make sure to add only the best keywords in the new city-level campaigns.

For example, in the data above, we can aim to replicate the success of New Delhi. A separate New Delhi campaign is likely to have a much higher ROAS than the average.

Checking Results

Go back the Report Editor and compare results of the newly made campaigns.

Scale the Winner

Keep allocating more budget to the winning combinations.

Rinse and repeat with any other combinations like platforms, placements and demographics.

This is the easiest win out there.

And this post is about any ad platform. Not just Google Ads.

Watch your CAC plummet and share with your friends how it worked out.

Before You Go

Remember, Google Ads is a powerful tool for growth marketers, but it’s not just about using the next big hack.

Keep in mind that any new strategies need to drive traffic meaningfully.

Traffic that translates into sales.

If you need help with optimizing Google Ads, that translate low converting traffic into sales, feel free to contact me via my LinkedIn profile.

You May Like