{"id":294,"date":"2016-01-08T14:54:01","date_gmt":"2016-01-08T14:54:01","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=294"},"modified":"2023-06-20T12:31:49","modified_gmt":"2023-06-20T12:31:49","slug":"get-data-from-google-analytics-in-ssis-using-rest-api-call","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/","title":{"rendered":"Get data from Google Analytics in SSIS using REST API Call"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>Google Analytics is the most popular web analytics service that tracks and reports website traffic. In this blog post you will learn how to <em>get data from Google Analytics using SSIS using <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-google-analytics-source-connector\/\">SSIS Google Analytics Source Connector<\/a> (Using drag and drop approach without Coding).<\/em> This article assumes you have basic knowledge about SSIS and you have necessary tools installed &#8211; <a href=\"http:\/\/binaryworld.net\/blogs\/how-to-install-ssis-2012-2014-2016-ssdt-bi-visual-studio\/\" target=\"_blank\" rel=\"noopener\">Check this if not<\/a>)<\/p>\n<p>For demo purpose we will <em>load data from Google Analytics into SQL Server Database<\/em> but you can use same techniques to load data into Oracle, MySQL, Excel or any other RDBMS.<\/p>\n<h2>Prerequisite<\/h2>\n<p>This article assumes you have installed following tools<\/p>\n<ol>\n<li>Install Client Tools for SSIS (atleast one version from below list) &#8211; <a href=\"http:\/\/binaryworld.net\/blogs\/how-to-install-ssis-2012-2014-2016-ssdt-bi-visual-studio\/\" target=\"_blank\" rel=\"noopener\">Check this for detail<\/a>\n<ol>\n<li>BIDS for SSIS 2008 (i.e. SQL Server 2008 or 2008 R2) &#8212; OR &#8212;<\/li>\n<li>SSDT BI for Visual Studio 2012 (i.e. for SQL Server 2012) &#8212; OR &#8212;<\/li>\n<li>SSDT BI for Visual Studio 2013 (i.e. for SQL Server 2014) &#8212; OR &#8212;<\/li>\n<li>SSDT BI for Visual Studio 2015 (i.e. for SQL Server 2012\/2014 or 2016)<\/li>\n<\/ol>\n<\/li>\n<li>Install SSIS PowerPack (<a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">Click here to download<\/a>) it will add new Connector in SSIS Toolbox to access Google Analytics Connector.<\/li>\n<li>You have setup correct permission for user to access google analytics data (See below section or <a href=\"\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#Setup_Google_analytics_data_permission_for_other_users\" target=\"_blank\" rel=\"noopener\">read here<\/a>)<\/li>\n<\/ol>\n<h2>Video Tutorial &#8211; Get data from Google Web Analytics Platform<\/h2>\n<div class=\"lyte-wrapper fourthree\" style=\"width:480px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_gr_s9kdvrKw\"><div id=\"lyte_gr_s9kdvrKw\" data-src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=%2F%2Fi.ytimg.com%2Fvi%2Fgr_s9kdvrKw%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\"><\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/gr_s9kdvrKw\" rel=\"nofollow\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fgr_s9kdvrKw%2F0.jpg\" alt=\"\" width=\"480\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:480px;margin:5px auto;\"><\/div><\/p>\n<h2>What is Google Analytics Connector for SSIS?<\/h2>\n<p>The<em> SSIS Google Analytics Source<\/em> connector can be used to read data from your Google Analytics Service without learning complex APIs or coding\/scripting in Python, Java, C#, etc. It has an easy to use drag and drop interface which allows you to extract large amounts of data, adjusting parameters such as dimensions, metrics, filters, sortby, date range etc. You can also use in-built reports or specify a direct query URL to get the desired data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-source.png\" alt=\"Custom SSIS Components - Google Web Analytics Source Connector\" width=\"53\" height=\"53\" \/> Read more about <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-google-analytics-source-connector\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #248cc8;\">Google Analytics Source Connector<\/span><\/a><\/p>\n<h3>Features<\/h3>\n<ul>\n<li>The intuitive user interface makes Google Analytics data integration super easy and fast without learning complex APIs or scripting languages<\/li>\n<li>Support for OAuth 2.0 Authentication and Google service accounts (*.p12 certificate file)<\/li>\n<li>Support for Proxy Server<\/li>\n<li>Easy to use interface with three different ways to query Google Analytics data: (1) Build query from UI, (2) Use built-in query templates, and (3) Use direct queries<\/li>\n<li>Support for dynamic dimensions, metrics, segments, filters and sortby fields (e.g. supply these values at runtime)<\/li>\n<li>Live preview support at design time<\/li>\n<li>Support for AdWords, AdSense, Ad Exchange and DoubleClick for Publisher (DFP)<\/li>\n<\/ul>\n<h2>Setup Google analytics data permission for users \/ service account<\/h2>\n<p>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<\/p>\n<p>To add\/edit user permissions for Google Analytics Data perform following steps.<\/p>\n<ol>\n<li>Login to your Google Analytics Portal (Login using Admin account or use google user account who setup Google Analytics) <a href=\"https:\/\/analytics.google.com\/analytics\/web\/#management\/Settings\/\" target=\"_blank\" rel=\"noopener\">Click here<\/a>\u00a0to go to google analytics<\/li>\n<li>Click on Admin tab &gt; Click User management &gt; Add\/Edit user account permission<\/li>\n<\/ol>\n<p>For more information you may visit official link :\u00a0<a href=\"https:\/\/support.google.com\/analytics\/answer\/2884495?hl=en\" target=\"_blank\" rel=\"noopener\">How to setup permission for google analytics<\/a><\/p>\n<div id=\"attachment_534\" style=\"width: 808px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-534\" class=\"size-full wp-image-534\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\" alt=\"Add\/Edit Permissions and User Account for Google Analytics Data Access (Service Account\/ Normal Google Login)\" width=\"798\" height=\"600\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png 798w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account-300x226.png 300w\" sizes=\"(max-width: 798px) 100vw, 798px\" \/><\/a><p id=\"caption-attachment-534\" class=\"wp-caption-text\">Add\/Edit Permissions and User Account for Google Analytics Data Access (Service Account\/ Normal Google Login)<\/p><\/div>\n<div>\n<h3>How to setup permissions for Service Account (*.p12 certificate)<\/h3>\n<p>Service account is another method to access google data. This is useful when you don&#8217;t want to use google login to access data (Example: Some consultant working to setup automated jobs for your company and they don&#8217;t really have login for google or you don&#8217;t want to share your personal google login with them).<\/p>\n<p>Service Account method (*.p12 certificate file) doesn&#8217;t require complex flow like OAuth so no more authorization prompts but make sure certificate generated for Service Account is kept secret.<\/p>\n<p>To grant permission to service account so it can access google analytics data, First make sure Service Account is created and find account email (It may look like this account-1234@some-project-id-xyz.gserviceaccount.com ) . <a href=\"\/\/zappysys.com\/blog\/create-google-api-project-service-account\/\" target=\"_blank\" rel=\"noopener\">Click here to know more how to create google service account<\/a>. Once service account created you may follow same steps described in above section to setup permission for Google Analytics Data.<\/p>\n<h2>Access Google Analytics data using OAuth 2.0 authentication protocol<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google Data Connection UI - Access Web Google Analytics data using OAuth 2.0 authentication protocol\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-access-google-analytics-data-using-oauth-2-authentication.png\" alt=\"Google Data Connection UI - Access Google Web Analytics data using OAuth 2.0 authentication protocol\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>Access Google Analytics Data using service account method (*.P12 Certificate file)<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google Data Connection UI - Access Google Web Analytics data using service account method (*.P12 Certificate file)\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-access-google-analytics-data-using-service-account.png\" alt=\"SSIS Google Web Analytics Connector - Access data using service account method (*.P12 Certificate file) - Get data from Google Web Analytics Platform\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<h2>SSIS Google Analytics Connector &#8211; Select Web Profile<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Select Web Profile\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-select-web-profile.png\" alt=\"Google REST API - Select Web Profile\" \/><\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Using build your own query mode<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Automatic URL mode (Build your own query from UI)\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-automatic-mode.png\" alt=\"Google REST API - Automatic URL mode (Build your own query from UI)\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Using direct query mode<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Manual URL mode (Supply predefined URL)\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-manual-url-mode.png\" alt=\"Google REST API - Manual URL mode (Supply predefined URL)\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Predefined Report Templates<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Predefined Reports mode\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-template-report-mode.png\" alt=\"Google REST API - Predefined Reports mode\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Report Preview<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Predefined Report Preview\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-report-template-preview.png\" alt=\"Google REST API - Predefined Report Preview - Get data from Google Web Analytics Platform\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Select Dimensions<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Select Dimensions\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-select-dimensions.png\" alt=\"Google REST API - Select Dimensions - Get data from Google Web Analytics Platform\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Select Metrics<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Select Metrics\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-select-metrics.png\" alt=\"Google REST API - Select Metrics\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Select Filters<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Select Filters\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-select-filters.png\" alt=\"Google REST API - Select Filters - Get data from Google Web Analytics Platform\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>SSIS Google Analytics Connector &#8211; Select Segment<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"Google API - Select Segment\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-google-analytics-select-segment.png\" alt=\"Google REST API - Select Segment\" \/><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<div>\n<h2>How to read google Adwords Data using Google Analytics Source<\/h2>\n<p>If you wish to access Google AdWords data using Google Analytics source then refer instructions listed on AdWords Tab on the UI. Once you enable integration you can view AdWords data easily without any other connector (see below)<\/p>\n<\/div>\n<div id=\"attachment_862\" style=\"width: 738px\" class=\"wp-caption alignnone\"><a href=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/ssis-get-google-adwords-data-using-analytics-source-connector.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-862\" class=\"size-full wp-image-862\" src=\"\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/ssis-get-google-adwords-data-using-analytics-source-connector.png\" alt=\"Get Data from Google AdWords using SSIS ( use Google Analytics Source Connector)\" width=\"728\" height=\"591\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/ssis-get-google-adwords-data-using-analytics-source-connector.png 728w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/ssis-get-google-adwords-data-using-analytics-source-connector-300x244.png 300w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><p id=\"caption-attachment-862\" class=\"wp-caption-text\">Get Data from Google AdWords using SSIS ( use Google Analytics Source Connector)<\/p><\/div>\n<div>\n<p>&nbsp;<\/p>\n<h2>SSIS Package &#8211; Get data from Google Web Analytics Platform and load into SQL Server<\/h2>\n<p><img decoding=\"async\" class=\"figureimage\" title=\"SSIS Package - Get data from Google Web Analytics Platform and load into SQL Server\" src=\"\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/google-analytics-source\/ssis-extract-google-analytics-data-load-into-sql-server-target.png\" alt=\"SSIS Package - Get data from Google Web Analytics Platform and load into SQL Server\" \/><\/p>\n<\/div>\n<h2>Conclusion<\/h2>\n<p>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 <strong>SSIS<\/strong> using High quality Connector using ZappySys <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/ssis-google-analytics-source-connector\/\"><span style=\"color: #248cc8;\">Google Analytics Source Connector<\/span><\/a> will surely make your life easy. It supports all major SQL Server versions upto SQL Server 2016 32-bit\/64-bit. Try <a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a> yourself for FREE.<\/p>\n<h2>Keywords<\/h2>\n<p><strong>Fetch data from Google Web Analytics using SSIS<\/strong> | <strong>Extract google analytics data using SSIS<\/strong> | <strong>Load data from Google Analytics without Coding<\/strong> | <strong>Google Web analytics data import using REST API<\/strong><\/p>\n<p><a href=\"https:\/\/developers.google.com\/analytics\/devguides\/reporting\/core\/v3\/\" target=\"_blank\" rel=\"noopener\">Google Web Analytics Reporting REST API reference link<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":534,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,58],"tags":[107,154,59,56,60,3,12,4],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2016-01-08T14:54:01+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-06-20T12:31:49+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"798\" \/>\r\n\t<meta property=\"og:image:height\" content=\"600\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/\",\"url\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/\",\"name\":\"Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\",\"datePublished\":\"2016-01-08T14:54:01+00:00\",\"dateModified\":\"2023-06-20T12:31:49+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png\",\"width\":798,\"height\":600,\"caption\":\"Add\/Edit Permissions and User Account for Google Analytics Data Access (Service Account\/ Normal Google Login)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Get data from Google Analytics in SSIS using REST API Call\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog","description":"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/","og_locale":"en_US","og_type":"article","og_title":"Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog","og_description":"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.","og_url":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2016-01-08T14:54:01+00:00","article_modified_time":"2023-06-20T12:31:49+00:00","og_image":[{"width":798,"height":600,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/zappysys\/","twitter_misc":{"Written by":"ZappySys","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/","url":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/","name":"Get data from Google Analytics in SSIS using REST API Call | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png","datePublished":"2016-01-08T14:54:01+00:00","dateModified":"2023-06-20T12:31:49+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to get data from Google Analytics in SSIS using REST API Call. This drag and drop approach without coding will make your integration super easy.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/01\/set-permission-google-analytics-service-account.png","width":798,"height":600,"caption":"Add\/Edit Permissions and User Account for Google Analytics Data Access (Service Account\/ Normal Google Login)"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/get-data-from-google-analytics-in-ssis-using-rest-api-call\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Get data from Google Analytics in SSIS using REST API Call"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/294"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=294"}],"version-history":[{"count":5,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":10124,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/294\/revisions\/10124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/534"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}