Segment or custom date range based on a dimension value

[acookie4rachel]

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

[leocwlau · Accepted solution]

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.

[acookie4rachel]

Thanks @leocwlau  for the suggestion to use unix timestamp. Let me try it.