Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Segment or custom date range based on a dimension value

Avatar

Level 2

Hi I've a business requirement to analyse the visits to each page based on 30 days from the Last Modified Date of the page. Each page has a different Last Modified Date and this date is stored in an eVar.

In a freeform table, the Page dimension and Visit metric are used.

 

Q1: Is it possible to create a segment containing hits that are 30 days from the Last Modified Date? This segment can then be used to filter the visits in the freeform table. 

 

Q2: Are there other ways to approach this business requirement?

 

TIA!

 

Rach

1 Accepted Solution

Avatar

Correct answer by
Level 5

Hi @acookie4rachel,

No, you can do that with eVar as it is stored as a string and you can't do calculations or numeric comparisons.

To do that, you need to track the last modified date and the hit time as UNIX timestamp to different metrics. Then you can create a calculated metric by 'hit time timestamp - last modified date timestamp' and then a segment to compare that calculated metric to whatever value you wanted.

View solution in original post

2 Replies

Avatar

Correct answer by
Level 5

Hi @acookie4rachel,

No, you can do that with eVar as it is stored as a string and you can't do calculations or numeric comparisons.

To do that, you need to track the last modified date and the hit time as UNIX timestamp to different metrics. Then you can create a calculated metric by 'hit time timestamp - last modified date timestamp' and then a segment to compare that calculated metric to whatever value you wanted.