Get data from Google Analytics in SSIS using REST API Call

Introduction

Google Analytics is the most popular web analytics service that tracks and reports website traffic. In this blog post you will learn how to get data from Google Analytics using SSIS using SSIS Google Analytics Source Connector (Using drag and drop approach without Coding). This article assumes you have basic knowledge about SSIS and you have necessary tools installed – Check this if not)

For demo purpose we will load data from Google Analytics into SQL Server Database but you can use same techniques to load data into Oracle, MySQL, Excel or any other RDBMS.

Prerequisite

This article assumes you have installed following tools

1. Install Client Tools for SSIS (atleast one version from below list) – Check this for detail
   1. BIDS for SSIS 2008 (i.e. SQL Server 2008 or 2008 R2) — OR —
   2. SSDT BI for Visual Studio 2012 (i.e. for SQL Server 2012) — OR —
   3. SSDT BI for Visual Studio 2013 (i.e. for SQL Server 2014) — OR —
   4. SSDT BI for Visual Studio 2015 (i.e. for SQL Server 2012/2014 or 2016)
2. Install SSIS PowerPack (Click here to download) it will add new Connector in SSIS Toolbox to access Google Analytics Connector.
3. You have setup correct permission for user to access google analytics data (See below section or read here)

Video Tutorial – Get data from Google Web Analytics Platform

What is Google Analytics Connector for SSIS?

SSIS Google Analytics Source connector can be used to read data from Google Analytics Service without learning complex API or doing coding/scripting in Python, Java, C# etc. It has easy to use drag and drop interface which allows you extract large amount of data, adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use inbuilt reports or specify direct query URL to get desired data.

Read more about Google Analytics Source Connector

Features

• Intuitive user interface makes Google analytics data integration super easy and fast without learning complex APIs or scripting language
• Support for OAuth 2.0 Authentication and Google service account (*.p12 certificate file)
• Support for Proxy Server
• Easy to use interface with three different ways to query Google analytics data (1) Build query from UI (2) Use built in query templates (3) Use direct query
• Support for dynamic dimensions, metrics, segments, filters and sortby fields (e.g. supply these values at runtime)
• Live preview support at design time
• Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP)

Setup Google analytics data permission for users / service account

If you are not an admin of Google analytics and you need to access google analytics then make sure you ask admin to give you correct permission using below steps

To add/edit user permissions for Google Analytics Data perform following steps.

1. Login to your Google Analytics Portal (Login using Admin account or use google user account who setup Google Analytics) Click here to go to google analytics
2. Click on Admin tab > Click User management > Add/Edit user account permission

For more information you may visit official link : How to setup permission for google analytics

 

 

SSIS Google Analytics Connector – Select Web Profile

 

 

 

 

 

 

 

 

Conclusion

Integration with Google Analytics Data can be challenging unless you understand how to write C#, Java, Python code using Google SDKs. If you are not a coder or you are in time crunch then drag and drop integration in SSIS using High quality Connector using ZappySys Google Analytics Source Connector will surely make your life easy. It supports all major SQL Server versions upto SQL Server 2016 32-bit/64-bit. Try SSIS PowerPack yourself for FREE.

Keywords

Fetch data from Google Web Analytics using SSIS | Extract google analytics data using SSIS | Load data from Google Analytics without Coding | Google Web analytics data import using REST API

Google Web Analytics Reporting REST API reference link