Our team of SEO Web Design gurus are standing by to assist you achieve your online marketing goals.

(541) 799-0040‬

SEO Web Design, LLC aims to improve business by delivering effective solutions based on innovative technologies and professional designs. Discover the variety of services we offer and convince yourself on the basis of the latest works that we've done. We love building fresh, unique and usable websites optimized specifically for your niche.

Responsive Web Design

SEO / SEM / Social Media

Conversion Rate Optimization

Email Marketing

Online Presence Analysis

Web Hosting
SEO Web Design / SEO  / Track how PPC performance changed when specific COVID-19 events took place

Track how PPC performance changed when specific COVID-19 events took place

We’re in uncharted territory with COVID-19 and its impact on lives, the economy and our PPC campaigns. I don’t have a medical degree, I’m not a scientist, a first responder, or someone whose job takes them to the front-lines of the situation so I am grateful for everything they are doing. 

With my skills as a PPC expert, the best I can offer is to help people get clarity so they can make the best possible decisions in uncertain situations.

At Google, one of the core tenets of innovation was to share all information. The idea is simple: if you give smart people all information relevant to a situation, they will generally all work towards the same solution to solve the problem.

I’d like to do my part in helping advertisers get all the information in the form of a Google Ads script that overlays government actions related to the pandemic on Google Ads performance metrics.

The idea is to help you see if certain events, like store closures, the start of shelter in place, the closing of schools, or the introduction of social distancing correlates in any way with drop-offs or spikes in performance. 

The script generates a spreadsheet of Google Ads performance data with markers for important COVID-19 events, like school closings, shelter-in-place orders, etc. 

The time frame for which we have data for government action may be too short to see many meaningful patterns but I think the script has value because your boss or your client may ask you how COVID-19 is impacting their ads and this script can save you a couple of hours doing the work of manually compiling that data.

We’ve also heard feedback from our users at Optmyzr that this visualization has helped them because they serve customers in many locations and it’s challenging to stay on top of what is happening in all the different places where your customers may be advertising.

For this script, we are using a dataset from Kaggle with global government actions[1]. It may not be complete or always up-to-date but it seemed like the best source for the data.

Installing the script is very simple. Just add it as a new script in your Google Ads account, add your email address to get notified when a new report is done, and schedule it to run once per day. 

Install the script in Google Ads by overwriting all the sample code of a new script. Then preview the script to get the URL of the report. Screenshot from

The script grabs geo-segmented account data for the past 30 days and adds it to a Google Sheet. 

The spreadsheet is filled with raw geo performance data from Google Ads and any associated government actions on that date in that region.

Then you can filter that data for the geo-location you want to see and the included chart will be updated automatically with just the metrics for that region and overlaid with just the government actions in that same region.

To get a better chart, filter the data for the regions you care most about.

For the US, the data is most relevant at the state level. Internationally, the data is best at the country level.

Here’s the script:

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

About The Author

Frederick (“Fred”) Vallaeys was one of the first 500 employees at Google where he spent 10 years building AdWords and teaching advertisers how to get the most out of it as the Google AdWords Evangelist. Today he is the Cofounder of Optmyzr[3], an AdWords tool company focused on unique data insights, One-Click Optimizations™, advanced reporting to make account management more efficient, and Enhanced Scripts™ for AdWords. He stays up-to-speed with best practices through his work with SalesX[4], a search marketing agency focused on turning clicks into revenue. He is a frequent guest speaker at events where he inspires organizations to be more innovative and become better online marketers. His latest book, Digital Marketing in an AI World, was published in May 2019.


  1. ^ dataset from Kaggle with global government actions (
  2. ^ here (
  3. ^ Optmyzr (
  4. ^ SalesX (

Powered by WPeMatico

Search Engine Land is the leading industry source for daily, must-read news and in-depth analysis about search engine technology.