How to get GA data without Sampling using the add-on?

[Aparna Pai]

Hi, 

I am trying out the Google Analytics Spreadsheet Add-on. I require to get the data with NO Sampling. I have tried all the three permissible values, but it doesn't seem to allow data retrieval without Sampling with either of the 3 options. Can someone please help on a way out ?

Regards, 

Aparna Pai

[Philip Walton]

The only way to get unsampled data is to use the unsampled reports methods of the Management API, and those are only available to premium customers. It's unlikely the Google Analytics Spreadsheet Add-on will support this feature any time soon.

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spread...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-analytics-spreadsheet-add-on/bb9c1f61-9076-4cd7-8d7c-47462d06ad5e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Aparna Pai]

Thank you Philip for the response!

We do have the Premium Account for Google Analytics hence was looking for unsampled data. 

Regards, 
Aparna Pai

On Friday, May 29, 2015 at 12:21:25 AM UTC+8, Philip Walton wrote:

The only way to get unsampled data is to use the unsampled reports methods of the Management API, and those are only available to premium customers. It's unlikely the Google Analytics Spreadsheet Add-on will support this feature any time soon.

On Thu, May 28, 2015 at 2:54 AM, Aparna Pai <aparn...@icarasia.com> wrote:

Hi, 

I am trying out the Google Analytics Spreadsheet Add-on. I require to get the data with NO Sampling. I have tried all the three permissible values, but it doesn't seem to allow data retrieval without Sampling with either of the 3 options. Can someone please help on a way out ?

Regards, 

Aparna Pai

--
You received this message because you are subscribed to the Google Groups "google-analytics-spreadsheet-add-on" group.

To unsubscribe from this group and stop receiving emails from it, send an email to google-analytics-spreadsheet-add-on+unsubscribe@googlegroups.com.

[J-bob]

Hi, 

You can get unsampled data from Google Analytics with the Big Analytics Data add-on. 

[kryscina...@gmail.com]

Maximum sampling I could get is 35%, so NOPE :)

[Ryan Praskievicz]

Try using fewer dimensions and metric combinations in your queries. Also, you can pull 10k rows per query at a time then stitch the data together after to get unsampled data. See this post on how to do it using the Google Sheets Add-on.

Best,

Ryan Praskievicz

@ryanpraski

[hoc...@qelp.com]

where you edit the report fields, row 15 is called "sampling level" if you enter in HIGHER_PRECISION in this field, it should stop all sampling. However, it does not seem to work with all my reports. I think it depends on the type of segmentation potentially.

[James Corr]

Hi Everyone, 

Sampling in Google Analytics (generally, there are some more nuances which I'm not going to cover here) depends on two things: 

• the number of SESSIONS within a query, threshold = 500K sessions, after which GA will sample your data request resulting in the problems mentioned here and the indication within the GA UI
  
• the number of HITS sent to a Property within a month, threshold = 10MM per month, after which Google can/will stop processing hits to your Property, this is much more difficult to identify when it's happening. You can determine your monthly Property hit amount by going to Property Settings! 

To "get around" sampling using the GA API you have a few options: 

• easiest - make your date range smaller so your query is less than 500K sessions 
  
• harder - pull smaller date ranges and then "stitch" them back together. IE: If you're getting sampled when pulling 12 months of data, pull each month's sessions for the last year one month at a time and add them up elsewhere to get annual sessions. NOTE that you can't use this method for USER based metrics / segments - they are not aggregated in the same way. 

Here's a post from our site that discusses how to get around sampling in GA.