Choosing a set start date but floating end date

E

Ellen Caywood

started a topic about 3 years ago

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

J

Jouni Hyötylä
said about 3 years ago

Hi Ellen,

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

Best regards,

Jouni Hyötylä

supermetrics.com

Twitter: @Supermetrics

Support forum: supermetrics/forum
E

Ellen Caywood
said about 3 years ago

Great, thanks!

1 person likes this
A

Analytics Inventiv Health
said almost 2 years ago

What if i want a specific start date till the end of last month?
Can you do end of previous month?
J

Jouni Hyötylä
said almost 2 years ago

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 to post a comment

Didn't find what you were looking for?

Start a new topic