Google Sheets

Google Analytics,
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

Supermetrics for Google Sheets vs. Supermetrics for Data Studio

Can’t make up your mind between Supermetrics for Data Studio and Supermetrics for Google Sheets (or Excel)? While we’d naturally recommend that you get both — Data Studio for data visualization and reporting and one of the spreadsheet products for data crunching and analysis — there are a few things you should consider before you ...

8-MINUTE READ | By Pinja Virtanen

1

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.

SecurityTerms of ServicePrivacy PolicyCookie Policy
Cookie Settings
© Supermetrics 2023