{"id":1129,"date":"2017-04-26T17:20:45","date_gmt":"2017-04-26T17:20:45","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=1129"},"modified":"2025-11-06T21:43:40","modified_gmt":"2025-11-06T21:43:40","slug":"3-ways-get-unsampled-data-ssis-google-analytics-source","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/","title":{"rendered":"3 ways to get Google Analytics unsampled data in SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

In our previous post, we saw\u00a0how to get data from Google Analytics using SSIS<\/a>. Once you get going with the\u00a0drag and drop SSIS Google Analytics Connector<\/a>, you may bump up to one interesting challenge. If your request includes sessions above a certain threshold, Google may start sampling your data to provide an average for many Metrics. So, how do you make sure your request includes all sessions in the calculation? The following sections will describe a few ways to achieve this.<\/p>\n

Google Analytics Data Sampling Tips<\/h2>\n

There is no way to guarantee 100% Unsampled data in the Standard Google Analytics API call due to restrictions imposed by Google. However, there are a few workarounds that may help you achieve a very high Data Sampling rate.<\/p>\n

The most common solution is that if you set the Sampling option to HIGHER_PRECISION, then Google may honor your request up to a certain threshold, but as the dataset grows (e.g., if you select a larger date range), Google may sample your data even though you set\u00a0HIGHER_PRECISION<\/strong>.<\/span><\/p>\n

\"\"<\/a>

Extract data from Google Analytics in SSIS: Use the Sample Size option to get Unsampled data.<\/p><\/div>\n

Other ways to get unsampled data from the Google Analytics API<\/h2>\n

Now, let’s look at a few other ways if the previous approach doesn’t work.<\/p>\n

    \n
  1. Narrow down your Date range… e.g., Process day by day rather than a full extract. If day by day is also sampling, they try Hour-by-Hour.<\/li>\n
  2. Use the Google API to generate and download Unsampled data (We don’t have an article on this, but see the reference below).<\/li>\n
  3. Use a Google Analytics 360 Premium Account with the unsampled report feature. You can get this via the Web Interface or call the API to automate the extraction. https:\/\/support.google.com\/analytics\/answer\/2601061?hl=en<\/a><\/li>\n<\/ol>\n

    https:\/\/developers.google.com\/analytics\/devguides\/config\/mgmt\/v3\/unsampled-reports<\/a>
    \n    https:\/\/support.google.com\/analytics\/answer\/2637192?hl=en&visit_id=1-636288218914624195-2113255108&rd=1<\/a><\/p>\n

    Downloading Unsampled report using Google Analytics 360 API – ZappySys REST API Task<\/strong><\/p>\n

    If you are a Google Analytics 360 user and wish to use the API to generate a file and download it in SSIS, refer to the following article. It shows how to call the Google API. It’s not about the Analytics API, but you will get a high-level idea.<\/p>\n

    https:\/\/zappysys.com\/blog\/get-data-google-spreadsheet-using-ssis\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    Introduction In our previous post, we saw\u00a0how to get data from Google Analytics using SSIS. Once you get going with the\u00a0drag and drop SSIS Google Analytics Connector, you may bump up to one interesting challenge. If your request includes sessions above a certain threshold, Google may start sampling your data to provide an average for […]<\/p>\n","protected":false},"author":1,"featured_media":11615,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,58],"tags":[56,12,191,4],"yoast_head":"\r\n3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.\" \/>\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\/3-ways-get-unsampled-data-ssis-google-analytics-source\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/\" \/>\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=\"2017-04-26T17:20:45+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-11-06T21:43:40+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"638\" \/>\r\n\t<meta property=\"og:image:height\" content=\"670\" \/>\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=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/\",\"url\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/\",\"name\":\"3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png\",\"datePublished\":\"2017-04-26T17:20:45+00:00\",\"dateModified\":\"2025-11-06T21:43:40+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png\",\"width\":638,\"height\":670,\"caption\":\"Extract data from Google Analytics in SSIS - Use Sample Size option to get Unsampled data\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 ways to get Google Analytics unsampled data in SSIS\"}]},{\"@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":"3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog","description":"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.","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\/3-ways-get-unsampled-data-ssis-google-analytics-source\/","og_locale":"en_US","og_type":"article","og_title":"3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog","og_description":"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.","og_url":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-04-26T17:20:45+00:00","article_modified_time":"2025-11-06T21:43:40+00:00","og_image":[{"width":638,"height":670,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.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":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/","url":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/","name":"3 ways to get Google Analytics unsampled data in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png","datePublished":"2017-04-26T17:20:45+00:00","dateModified":"2025-11-06T21:43:40+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to get unsampled data from Google Analytics using SSIS. Control Sampling Size for GA API call along with other parameters e.g. Dimension, Metric.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/04\/Extract-data-from-Google-Analytics-in-SSIS-Use-Sample-Size-option-to-get-Unsampled-data.png","width":638,"height":670,"caption":"Extract data from Google Analytics in SSIS - Use Sample Size option to get Unsampled data"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/3-ways-get-unsampled-data-ssis-google-analytics-source\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"3 ways to get Google Analytics unsampled data in SSIS"}]},{"@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\/1129"}],"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=1129"}],"version-history":[{"count":7,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1129\/revisions"}],"predecessor-version":[{"id":11616,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/1129\/revisions\/11616"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11615"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=1129"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=1129"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=1129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}