Start a new topic

Choosing a set start date but floating end date

I have several needs where I want the query to use a fixed start date, but i want it to keep updating the end date to yesterday. How can I do this?

So for example, I will pull all GA sessions from 1/19/17 - yesterday and have it refresh daily

Hi Ellen,

you can use written date commands in the fields. For the end date, write "yesterday".

Best regards,

Jouni Hyötylä

Twitter: @Supermetrics 

Support forum: supermetrics/forum

Great, thanks!

What if i want a specific start date till the end of last month?

Can you do end of previous month?

You can also do it like this:

Start date: first day of last month
End date: last day of last month

and many other combos like that.

Best regards,

-Supermetrics Team

Login or Signup to post a comment