Supermetrics Blog

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

Hashtags are great for engaging with your followers and driving traffic to your Instagram content. But, what happens when you don’t get your hashtags right? Not using enough hashtags? You’re missing out on the chance to grow your account. Using the wrong hashtags? You’re reaching the wrong audience. Too many hashtags? Where’s your hashtag etiquette? ...

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

It seems like data lakes are all the rage these days. Why is that? And more importantly, if you work with marketing data, why should you care? And if you do care, but don’t know how to query data in your cloud storage bucket from BigQuery, how would you go about doing that? In this ...

LinkedIn is the biggest B2B social media platform with: 722+ million users, 55+ million active companies, and 96% of B2B content marketers use LinkedIn for organic social marketing. ...

Facebook is the most popular social network, so if you’re looking to reach the highest number of people for your business, it’s probably a good place to be. A good place to start would be to optimize your Facebook Ads. Most ad platforms are pretty good at optimizing your campaigns based on user behavior. So ...

If you’ve been running paid Snapchat campaigns, you’ve probably accumulated a ton of data. You’re holding the key to driving more conversions. Of course, only if you know how to make the most out of your data. In this article, I’m going to show you the basics of Snapchat analytics. ...

We’re happy to announce that CallRail has officially joined the Supermetrics connector squad. Now you can easily move your CallRail data to Google Sheets, Google Data Studio, Excel, data visualization tools, and data warehouses with Supermetrics. ...

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