Google Sheets

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

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

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

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

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

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

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

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

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

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