The Supermetrics API makes it easy to get fresh marketing data into Power BI using the “web data connector”. But, Power BI starts to run into issues when the data volume grows beyond 10k rows from a single query. For marketing teams and agencies with large amounts of advertising data, this is simply a non-starter. ...
6-MINUTE READ | By Evan Kaeding
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 ...
15-MINUTE READ | By David Magdolen
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 ...
8-MINUTE READ | By Riku Mikkonen
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
As the volume of marketing data grows, more and more businesses are moving their data to a data warehouse. Snowflake is a great choice for many as it can be built on top of any existing cloud platform, whether it’s Google, Amazon Web Services, or Microsoft Azure. That’s why we built a Snowflake connector for ...
4-MINUTE READ | By Anna Shutko
Be the first to hear about product updates and marketing data tips