Supermetrics Blog

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

If you’ve ever dealt with marketing data, you’d probably agree that siloed data is the number one enemy of effective reporting and analytics. And while cloud-based data warehouses like BigQuery and Snowflake are great solutions for integrating, storing, and analyzing large volumes of cross-channel data, many analytically mature companies have recently started adding a new ...

You know how your marketing data lives across dozens of different platforms, including — but definitely not limited to — Google Analytics, Facebook Ads, LinkedIn, Google Analytics, and/or Salesforce? A cloud-based marketing data warehouse (like Google BigQuery, Snowflake, or Azure Synapse Analytics) allows you to centralize all that data into a single destination that’s built ...

If you work in ecommerce but aren’t running Facebook Ads campaigns, you’re missing out on a huge opportunity to grow your business. That’s why we teamed up with Savannah Sanchez, Founder of The Social Savannah, to show you how to set up, analyze, and optimize your Facebook Ads campaigns. By the way, this article is ...

Ecommerce merchants and marketers have one major advantage over brick and mortar retailers: data.  When your shoppers come from the internet, you can measure almost every aspect of your interactions with them. However, that advantage doesn’t count for much without a system for making sense of your data. Many companies think they already have a ...