Google Sheets

Google Sheets,

Automate ad spend tracking and budget pacing with Google Sheets and Supermetrics [Free cheat sheet and template included]

When I worked in an agency as a paid media consultant, ad spend and budget were some of the most often recurring discussions we had with clients.  I learned that some advertisers’ budgets are more strict than others. Whenever significant overspending or underspending occurs, it can cause real harm to the customer relationship and trust. ...

12-MINUTE READ | By Sofie Segercrantz

If you’ve ever tried to get MySQL data into Google Sheets, you’d probably agree that the process isn’t straightforward, especially if you have to deal with a large amount of data or combine data from sources other than MySQL. That’s why in this article, we’ll show you two ways to export data from MySQL (or ...

5-MINUTE READ | By Joy Huynh

Google Analytics 4 vs. Universal Analytics: what’s the difference

Universal Analytics (UA) will sunset on July 1, 2023. That means your UA properties will stop gathering new data. If your web analytics reports in Google Sheets or Looker Studio still use UA data, it’s time to update them with Google Analytics 4 data. This guide will show you how to update your reports effortlessly ...

10-MINUTE READ | By Mick Chaveroche

How to query Google Sheets data in BigQuery

When I first started using Google Sheets, I thought it was a joke. My first experience with it back in 2010 was in high school when I was in my Intro to Accounting class. My exact thoughts were, “There’s no way Google can pack as much functionality into a web browser as Microsoft does into ...

6-MINUTE READ | By Evan Kaeding

Facebook ads report template

If you’re running ads online, chances are, you’re running ads on Facebook. In the past few years, Facebook has had the second most ad revenue from all digital platforms, right behind Google. The competition is fierce to get the attention of the 2.7 billion active users on Facebook. Are you getting the most out of ...

10-MINUTE READ | By Sophie Michaud

How to import data from one Google Sheet to another

If you’re using Google Sheets, you probably need to reference or import data from another sheet every once in a while. It’s not very complicated, and there are a few ways to do that. You can copy/paste the data, of course. For a tiny, select dataset, that might work. But that way, your data won’t ...

5-MINUTE READ | By Sophie Michaud


Explore the blog

Want to see what Supermetrics can do for you?

Get full access to Supermetrics with a 14-day free trial.

No credit card required.

Book Demo