SSIS Google Analytics Source

SSIS Google Analytics Source connector can be used to read data from Google Analytics Service without learning complex API. Easy to use interface 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.

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)
  • Read data from multiple profiles, trackers or accounts using single step (Looping feature)
  • 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)

See also
SSIS WebJSON File Destination JSON File Destination
SSIS JSON Generator JSON Generator Transform
SSIS Web API Destination - Send data to API Web API Destination
Custom SSIS Tasks - Export JSON File Task Export JSON File Task
Custom SSIS Tasks - Call REST API Webservice (GET, POST, DELETE etc) REST API Webservice Task
Custom SSIS Tasks - XML Source Connector (File, SOAP, REST API) XML Source Connector (File, SOAP, REST API)
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

Google Data Connection UI – Create a new Google Data connection

Google Analytic create new connection

Google Data Connection UI – Access Google Analytics data using OAuth 2.0 authentication protocol

Google Data Connection UI – Access Google Analytics data using OAuth 2.0

Google data example connection

SSIS Google Analytics Connector – Valid example with OAuth2. It is valid the option for GA4

Google Data Connection UI – Access Google Analytics data using service account method (*.P12 Certificate file)

Google data connection with p12 certificate file

SSIS Google Analytics Connector – Access data using service account method (*.P12 Certificate file)

SSIS Google Analytics Connector UI – Automatic URL mode (Build your own query from UI)

Google Analytics automatic query mode

SSIS Google Analytics Connector UI – Automatic URL mode (Build your own query from UI)

SSIS Google Analytics Connector UI – Manual URL mode (Supply predefined URL)

Google Analytics manual direct URL

SSIS Google Analytics Connector UI – Manual URL mode (Supply predefined URL)

SSIS Google Analytics Connector UI – Predefined Reports mode

Google Analytics Report template

SSIS Google Analytics Connector UI – Predefined Reports mode

SSIS Google Analytics Connector UI – Predefined Report Preview

Preview example from Google Analytics

SSIS Google Analytics Connector UI – Predefined Report Preview

SSIS Google Analytics Connector UI – Select Web Profile

GA Select Web Profile

SSIS Google Analytics Connector UI – Select Web Profile

SSIS Google Analytics Connector UI – Select Dimensions

GA Select Dimensions

SSIS Google Analytics Connector UI – Select Dimensions

SSIS Google Analytics Connector UI – Select Metrics

SSIS Google Analytics Connector UI – Select Metrics

SSIS Google Analytics Connector UI – Select Metrics

SSIS Google Analytics Connector UI – Select Filters

SSIS Google Analytics Connector UI – Select Filters

SSIS Google Analytics Connector UI – Select Filters

SSIS Google Analytics Connector UI – Select Segment

GA Select Segment

SSIS Google Analytics Connector UI – Select Segment

SSIS Package – Get data from Google Analytics and load into SQL Server

Example package with google Analytics

SSIS Package – Get data from Google Analytics and load into SQL Server

Articles / Tutorials

Click here to see all articles for [SSIS Google Analytics Source] category


SSIS Google Analytics Source – Custom Dimension and Metrics

SSIS Google Analytics Source – Custom Dimension and Metrics

Introduction Custom Dimensions and Metrics pretty powerful feature in Google Analytics. In this post we will learn how you can use them in SSIS Google Analytics Source Find Dimension ID or Metric ID SSIS Google Analytics Source dimension / metric browser doesn’t list custom Dimensions or Custom Metrics so you have to do few extra steps. […]

 


3 ways to get Google Analytics unsampled data in SSIS

3 ways to get Google Analytics unsampled data in SSIS

Introduction If our previous post we saw how to get data from Google Analytics Using SSIS. Once you get going with drag and drop SSIS Google Analytics Connector you may bump up to one interesting challenge. If you request includes sessions more than certain threshold then Google may start sampling your data to give you […]

 


Get data from Google Analytics in SSIS using REST API Call

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 […]

Click here to learn more about System Requirements
Download View All Tasks Like This