Supermetrics Blog

Learn (almost) everything you need to know about marketing reporting and analytics.

Search or filter

How to automate marketing mix modeling with an MMM data feed spreadsheet

Marketing mix modeling or MMM is seeing a renaissance, over 60 years since it came into common use. Unlike most marketing attribution methods, MMM doesn’t require user-level data, instead of modeling what channels deserve credit for sales by statistically mapping spikes and dips in spend to actions and events in your marketing channels. Upgrading from ...

Jun 16, 2022 | 9 minute read

Export MySQL data to Google Sheets

If you’ve ever tried to get MySQL data into Google Sheets, you’d probably agree that the process isn’t a walk in the park. Even though you can copy/paste data cell by cell, the real nightmare begins when you have to deal with a large amount of data and/or keep your data fresh. That’s why in ...

Jul 28, 2021 | 3 minute read

ad performance report

Buying paid ads from Google Ads, Bing Ads, or social media platforms is all well and good, but those efforts — and the related expenses — have to amount to something. What’s the point of bringing your ad to a responsive audience only to lose your hard-earned clicks to a bad performing ad? Your solution ...

Jun 17, 2021 | 9 minute read

Import facebook data to google sheets

If you’re running paid ads, in-app ads, or organic campaigns on Facebook, you probably need to export your data to Google Sheets for a more in-depth analysis. You can, of course, go with the old-fashioned CSV copy and pasting data to a spreadsheet. However, the process is time-consuming and error-prone. The worst part is you ...

May 14, 2021 | 8 minute read

Sheets to Power BI

You don’t necessarily need a SQL server to handle data storage when you’re loading a small volume of data to Power BI.  Why deal with the annoyance of Power BI’s built-in direct query options when you can connect your data from Google Sheets directly to Power BI?  To top it off, you’ll get refreshed data ...

Mar 26, 2021 | 7 minute read

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 ...

Mar 17, 2021 | 6 minute read

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 ...

Mar 12, 2021 | 10 minute read

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 ...

Feb 26, 2021 | 5 minute read

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 ...

Dec 21, 2020 | 8 minute read

How to import data from Google Analytics to Google Sheets

If copy/pasting Google Analytics data to Google Sheets is bogging you down, how about I show you a much faster (and much less painful) way to import your data? So open a fresh Google Sheet and let’s get into it. Step 1: Install the Supermetrics add-on First things first. To import Google Analytics data (including ...

Dec 17, 2020 | 5 minute read

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