GAnalytics Trick?

is there a trick to speed up queries with GA?

[Boston_SEM]

I'm loving the new GA - but the more I want to use it, the slower it goes.

Is there a trick to resolving these extremely slow loading times for large data sets?

Will working with the API (if I knew how to do it) make any improvement?

Or do I just wait between keystrokes?

[still]

The larger your datasets become, the more sampled the data becomes. My advise is to prototype with a small sample set in the first place then look into data export api for collation of larger datasets.

I guess it depends what you are wanting to achieve/what story you are wanting to tell.

[chewy]

I've got this very same problem.

With sites with traffic in the millions, GA queries are bogging down or failing so regularly, I'm looking for a real answer.

As soon as I extend out time significantly, or increase the desired number of results, I'm thinking of giving up due to the increased numbers of failures - and I'm not even using any of my add-ins or other basic tricks to get more out of GA that I use every day with smaller sites.

Does anyone have experience with HUGE data sets and GA?

Surely, there must be ways to speed this up and or make it more stable.

Does anyone have any experience with the new PAID Google Analytics tool?

Thanks,

-C

[chewy]

this pretty much sums it up for me.

[webpierat.com...]


basically, Fast Access Mode (aka sampling) is mostly useless, and Paid GA seems to be a bit of an enigma at this time.

So does anyone have anything to add - or am I just talking with myself?

[still]

I have done data sets of around 3.5 million sessions for some benchmark reporting, for consistency I retrieved at 1 week intervals through the api then stitched the data together.