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 […]
Category: Analytics
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 […]
How to Get LinkedIn Ads Data to Google Sheets?
Have you just started running LinkedIn Ads for your business? You might be wondering how to get the data from LinkedIn campaigns on a regular basis to Google Sheets so you can report on the performance. Read more to find out. The Process Install Supermetrics for Google Sheets for your Google account. You can get it […]
How to Get Google Analytics Data to Google Sheets?
Sooner or later, every digital marketer will face this very basic question: how to get Google Analytics data to Google Sheets on a regular basis? In this article, I will answer that question. You have basically 3 options: Manual exports from Google Analytics UI You can use an add-on for Google Sheets made by Google. […]
How to Get Microsoft Advertising Data to Google Sheets?
In today’s article, I will show you how to get Microsoft Advertising data (aka “Bing Ads”) to Google Sheets. It’s quite simple. You will need to install Supermetrics add-on to your Google Sheets. Get it here: Once the add-on is installed, navigate to the Google Sheet where you want to download Microsoft Advertising data. Go […]