Forum Discussion
Set date range limit on google analytics query
When you bring the Time attribute in your query, you have the ability to right click on the time field and specify the filter condition (Before, After, etc.) after the filter has been applied you can click on a gear box next to the Filtered Rows step in the Applied Steps section on the right and tweak it if you need to.
warrencowan this is a good question, I have not tested it on large enough data sets where I could notice wheter all of the data are brought back first or wheter the filter condition is sent as a parameter to Google before the data start flowing in.
I think that is how it works Andre.
Once the query is filtered on the date field, the message dialogue suggests it is indeed pulling back fewer rows from the API and taking less time.
I think there's a bit of fiddling to do though, as you cant specify the filter until the query is built, so its best to build it in the qeury manager, where you work with the preview data. Rather than than the get data fucntion in the report designer.
Andre & Smoupre, very many thanks for your input. :smileyvery-happy:
Really, the lack of date range parameters on this integration makes it near useless. GA doesn't return leaf-level data, so the only metrics which will propery aggregate are counts like pageviews. Also, not having true GA filters and segments is a show-stopper. This integration is basically eye-candy. Tableau made some (but not nearly as many) of the same mistakes in their integration.
i agree - will Microsoft add these features in a future release?
Maybe you can create an Idea on the Ideas board? I'd surely vote for it. It shouldnt be that much trouble eiter, because the GA API calls have room for these parameters.
