How can I filter the data to only pull back the last few days?

May 23, 2011 at 8:28 PM

Hi Tillman,

First and foremost I have to say this is an amazing tool you have create for all of us. Thumbs up!

I would like to only pull back a few days at a time from google analytics.

Is there a way i can set the filters to only pull back the last few days?

Is there documentation on the symbols below?








Thank you!

May 23, 2011 at 11:00 PM

Hi ddorag,

thank you for your feedback!

The best way to limit the date is the start/end date on the first tab.
At this point I would point out once again that all filters are combined with "and".
May 24, 2011 at 12:04 AM

Thank you for the quick response Tillmann!

Is it possible to pass a variable for the start/end date in the first tab?

I would like to limit the amount of data being called because i'm using your awesome tool for an hourly report. 

May 24, 2011 at 6:10 AM

Yes, you can set the start/end date with the expressions of the data flow task.
For properties where you need collections you can use "|" and ";" to seperate the values.




May 25, 2011 at 2:49 PM

Beware of selecting the yesterday until now as Google has given itself 48 hours to update the data completely. So it could happen that you select incomplete data when using yesterday as a filter.

May 25, 2011 at 6:25 PM

Awesome, thanks for the confirmation and the tips