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 ...
7-MINUTE READ | By Jens Lystlund Madsen
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 ...
6-MINUTE READ | By Evan Kaeding
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. Ever since then, many of our customers have been asking if they could move data directly into Azure Synapse Analytics, Microsoft’s newly ...
5-MINUTE READ | By Anna Shutko
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 ...
10-MINUTE READ | By Sophie Michaud
TL;DR If you’d like to kick-start your Instagram competitor analysis right away, feel free to swipe our Instagram industry insights template. For more tips on analyzing your competition, keep reading. Have you ever looked at your competitors’ Instagram accounts and wondered how they get all that engagement? What’s their secret? There’s only one way to ...
8-MINUTE READ | By Joy Huynh
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
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 ...
10-MINUTE READ | By Christian Coulson
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
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 ...
4-MINUTE READ | By Joy Huynh
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
Be the first to hear about product updates and marketing data tips