I’ve been involved in quite a few reporting projects over the past few years so I want to share my experience with challenges which keep appearing over and over. I am not going to provide solutions for all the points below since the solutions tend to be very specific for each project. Take this article […]
Category: Supermetrics
How to Get Marketing Data to Snowflake
Advanced advertisers and analysts may find themselves in a situation where working with marketing data in Google Sheets or Excel or Google Data Studio is simply not good enough because: They need to do complex transformations of the raw data. They need to enrich the raw data with internal data sources. They need to “own […]
How to Get Google Ads Data to Google Data Studio along with Other Data Sources
Okay, this may sound like yet another useless article about getting Google Ads data into Google Data Studio. Most of the marketing community knows that Google itself provides a free Google Data Studio connector for Google Ads which will get you going in minutes. This is the connector: You just select the connector, then select […]
How to Get LinkedIn Ads Data to Google Data Studio
If you are in B2B marketing, you’ve probably tried running LinkedIn Ads campaigns (which are crazy expensive in my experience). Running the campaign is one thing, reporting on the results is another thing. You may want to present your campaign results in Google Data Studio. In this article, I will show you how to get […]
How to Get Microsoft Advertising Data to Google Data Studio
If you are in the PPC space, sooner or later you will run campaigns in Microsoft Advertising (originally “Bing Ads”). And sooner or later, you will need to get the Microsoft Advertising data into Google Data Studio. In this article, I will show you how to do it. The Process To solve our problem, we’ll […]
How to Pull Aggregated and Blended Marketing Data to Google Data Studio
Pulling data from one data source (say Google Ads) into Google Data Studio is a relatively easy process. The trouble is that you usually don’t run campaigns just in one network so you likely need to pull data from multiple data sources to get a consolidated view of your marketing performance. Google Data Studio finally […]
How to Get Google Ads Data to Google Sheets?
If your are running Google Ads campaigns, you might be wondering how to get Google Ads data to Google Sheets on a regular basis to make your reporting faster and hassle-free. This article covers 3 options to solve this problem. The options are: Manual exports from Google Ads – not necessarily hassle-free so I will […]
Google Search Console Data to Google Sheets
How to get Google Search Console data to Google Sheets automatically and on a regular basis? That is the question this article answers. If you are an SEO pro, you may want to start downloading Search Console data to Google Sheets to create a centralize storage of our SEO data and also have it delivered […]
How to Get PayPal Data to Google Sheets?
Are you running your online business and receiving payments via PayPal? You may want to make your reporting a bit easier and get the PayPal sales data to Google Sheets. This article describes the process of doing so. Disclaimer: PayPal connector from Supermetrics is currently in beta and it may not work properly with your […]
How to Get YouTube Data to Google Sheets?
When you start running your YouTube channel, you may need to get your video performance data to a Google Sheets on a regular basis so you quickly know what’s happening. This article describes how to set up this kind of reporting in less than 30 minutes. The Process You will need to get Supermetrics for […]