• Search Engine Land
  • Sections
    • SEO
    • SEM
    • Local
    • Retail
    • Google
    • Bing
    • Social
    • Resources
    • More
    • Home
  • Follow Us
    • Follow
  • Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • Live
  • More
  • Events
    • Follow
  • SUBSCRIBE

Search Engine Land

Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • More
  • Newsletters
  • Home
SEM

E-commerce brands: Track spend efficiency with this Google Ads Script

The script pulls keywords from your account and their respective ROAS, which you define.

Wesley Parker on July 16, 2019 at 12:13 pm
  • More

It goes without saying that tracking ROAS is essential for e-commerce brands using Google Ads as this is how most track the profitability of their campaigns.

Although Google provides topline figures for ROAS it’s hard to see the health of your account at the keyword level and identify quick wins.

A reader recently wrote in with a smart way of doing this using stacked bar graphs to help visualize ROAS performance of keywords across the account week on week.

However, they were still doing this manually in Excel.

So the developers at my employer designed this Google Ads script to automate this process and create a visual representation showing the keyword level performance.

How the script works

The script pulls all of the keywords within your account and their respective ROAS.

It then takes this data and turns it into two charts that allow you first to visualize what percentage of keywords have a specific ROAS and secondly compare week on week to see if your ROAS has improved across your account.

Within the controls of the script, you define your ROAS buckets. The first graph will then show you the number of keywords within that bucket, like below.

The second graph will show you the number of keywords within the different ROAS buckets, but this time it is weighted by spend to give you a more representative view of what is going on.

Setting up the script

Before you run the script, you will need to change the following settings:

Set your ROAS thresholds. We generally suggest doing this in increments of 100 (e.g., 100, 200, 300). These should be defined on line 17 of the script between the square brackets. Each increment should be separated with a comma.

Go to Google Sheets and create a new document. Copy the URL of the sheet then paste it into line 21 of the script between the quotation marks.
Finally, you need to set a lookback window on line 24. This is the time frame that the script will take data.

The script


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.



About The Author

Wesley Parker
Wesley is managing director at Clicteq. He currently manages a $4M-plus Google Ads portfolio across a range of different sectors. He regularly writes in leading marketing publications such as Econsultancy and Campaign Magazine.

Related Topics

Channel: SEMGoogle: Ads ScriptsPaid Search Column

We're listening.

Have something to say about this article? Share it with us on Facebook, Twitter or our LinkedIn Group.

Get the daily newsletter search marketers rely on.
See terms.

ATTEND OUR EVENTS

Lorem ipsum doler this is promo text about SMX events.

February 23, 2021: SMX Report

April 13, 2021: SMX Create

May 18-19, 2021: SMX London

June 8-9, 2021: SMX Paris

June 15-16, 2021: SMX Advanced

August 17, 2021: SMX Convert

November 9-10, 2021: SMX Next

October 2021: SMX Advanced Europe

December 17, 2021: SMX Code

Available On-Demand: SMX

×


Learn More About Our SMX Events

Discover actionable tactics that can help you overcome crucial marketing challenges. Our next conference will be held:

MarTech 2021: March 16-17

MarTech 2021: Sept. 14-15

MarTech 2020: Watch On-Demand

×

Attend MarTech - Click Here


Learn More About Our MarTech Events

White Papers

  • The State of Local Marketing Report 2020-2021
  • Quality CRM Data: The Key to Delivering Great Customer Experiences
  • How the Microsoft Search Network Can Maximize Your Search Campaigns
  • The Marketer’s Playbook for Customer Acquisition
  • How To Optimize SEO With UGC
See More Whitepapers

Webinars

  • How to Avoid the Digital Transformation Trap
  • How to Build a Marketing System of Record
  • Meet BIMI: The brand-boosting email security marketers must have for 2021
See More Webinars

Research Reports

  • Local Marketing Solutions for Multi-Location Businesses
  • Enterprise Digital Asset Management Platforms
  • Identity Resolution Platforms
  • Customer Data Platforms
  • B2B Marketing Automation Platforms
  • Call Analytics Platforms
See More Research

h
Receive daily search news and analysis.
Search Engine Land
Download the Search Engine Land App on iTunes Download the Search Engine Land App on Google Play

Channels

  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social

Our Events

  • SMX
  • MarTech

Resources

  • White Papers
  • Research
  • Webinars
  • Search Marketing Expo
  • MarTech Conference

About

  • About Us
  • Contact
  • Privacy
  • Marketing Opportunities
  • Staff
  • Connect With Us

Follow Us

  • Facebook
  • Twitter
  • LinkedIn
  • Newsletters
  • Instagram
  • RSS
  • Youtube
  • iOS App
  • Google Play

© 2021 Third Door Media, Inc. All rights reserved.

Your privacy means the world to us. We share your personal information only when you give us explicit permission to do so, and confirm we have your permission each time. Learn more by viewing our privacy policy.Ok