• Search Engine Land
  • Sections
    • SEO
    • SEM
    • Local
    • Retail
    • Google
    • Bing
    • Social
    • Resources
    • More
    • Home
  • Search Engine Land
  • SEO
  • SEM
  • Local
  • Retail
  • Google
  • Bing
  • Social
  • Resources
  • Live
  • More
  • Events
  • 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.

Processing...Please wait.

See terms.

ATTEND OUR EVENTS

Lorem ipsum doler this is promo text about SMX events.

April 13, 2021: SMX Create

May 18-19, 2021: SMX London

June 8-9, 2021: SMX Paris

June 15-16, 2021: SMX Advanced

June 21-22, 2021: SMX Advanced Europe

August 17, 2021: SMX Convert

November 9-10, 2021: SMX Next

December 14, 2021: SMX Code

Available On-Demand: SMX

Available On-Demand: SMX Report

×


Learn More About Our SMX Events

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

Next Event: Sept. 14-15, 2021

Available On-Demand: March 2021

Available On-Demand: October 2020

×

Attend MarTech - Click Here


Learn More About Our MarTech Events

White Papers

  • Nielsen Annual Marketing Report: Era of Adaptation
  • Global Social Media Advertising Trends Among Retailers in 2021
  • 2020 Hispanic Market Report
  • Delivering Audio Success: Industry Trends in Streaming Audio & Podcast Performance
  • Ten Tips for Acquisition Email Success
See More Whitepapers

Webinars

  • Drive Customer Engagement with the Power of Personalization
  • 7 Use Cases That Prove Why You Should Implement DAM
  • Accelerate Your SEO & Content Marketing Program with 4 Key Milestones
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

Attend SMX For Only $149

h
Receive daily search news and analysis.

Channels

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

Our Events

  • SMX
  • MarTech

Resources

  • White Papers
  • Research
  • Webinars

About

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

Follow Us

  • Facebook
  • Twitter
  • LinkedIn
  • Newsletters
  • RSS
  • Youtube

© 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