Supermetrics Blog

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

Earlier this year, we introduced Supermetrics for Azure Storage, a fully managed data pipeline that allows you to move your marketing and sales data into Microsoft’s data lake solution with a few clicks. ...

These templates will help you organize and analyze your ad data, allowing you to make data-driven decisions and maximize your ad performance. Whether you’re managing ads on multiple platforms or focusing solely on Facebook, these templates give a solid foundation for your reporting. Facebook Ads templates First, let’s look at reports that only include Facebook ...

Have you ever looked at your competitors’ Instagram accounts and wondered how they get all that engagement? What’s their secret? ...

In this guide, I’ll show you how to use the Supermetrics API with Python to query data from marketing and digital advertising platforms (like Facebook, LinkedIn, Twitter, and many more) in JSON format, how to convert that data into a DataFrame, and how to load it into a local MySQL database on your device. But ...

Pinterest is one of those platforms that many small business owners and bloggers overlook. This is often due to the misconception that the platform is only used for looking up recipes and home décor ideas. However, there are several other blog niches, such as fitness, DIY, finance, parenthood, tech, relationships, and coding, that are extremely ...

If you’ve ever been involved in building and maintaining custom API connections between popular marketing/sales platforms and cloud data warehouses or data lakes, you’d probably agree that it’s a tedious process that always takes longer than originally estimated. While building a simple API connection may not take a lot of your data team’s time, the ...

Snapchat Marketing has officially joined the Supermetrics connector squad. ?? We’re happy to announce that you can now pull your paid Snapchat data into Google Sheets, Google Data Studio, Excel, BI tools, and data warehouses with Supermetrics. With this connector, you can: Let’s take a look at each case in more detail. Create in-depth Snapchat ...

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

Building social media reports can be challenging and painful at first. For one thing, you have a ton of decisions to make—things like what metrics you want to track or what tools you should use to build your report. ...