<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Segment or custom date range based on a dimension value in Adobe Analytics Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/452363#M37382</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17296710"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;&lt;P&gt;No, you can do that with eVar as it is stored as a string and you can't do calculations or numeric comparisons.&lt;/P&gt;&lt;P&gt;To do that, you need to track the last modified date and the hit time&amp;nbsp;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.&lt;/P&gt;</description>
    <pubDate>Wed, 18 May 2022 04:22:42 GMT</pubDate>
    <dc:creator>leocwlau</dc:creator>
    <dc:date>2022-05-18T04:22:42Z</dc:date>
    <item>
      <title>Segment or custom date range based on a dimension value</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/452362#M37381</link>
      <description>&lt;P&gt;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.&lt;/P&gt;&lt;P&gt;In a freeform table, the Page dimension and Visit metric are used.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;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.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Q2: Are there other ways to approach this business requirement?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;TIA!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Rach&lt;/P&gt;</description>
      <pubDate>Wed, 18 May 2022 03:43:52 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/452362#M37381</guid>
      <dc:creator>acookie4rachel</dc:creator>
      <dc:date>2022-05-18T03:43:52Z</dc:date>
    </item>
    <item>
      <title>Re: Segment or custom date range based on a dimension value</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/452363#M37382</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17296710"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;&lt;P&gt;No, you can do that with eVar as it is stored as a string and you can't do calculations or numeric comparisons.&lt;/P&gt;&lt;P&gt;To do that, you need to track the last modified date and the hit time&amp;nbsp;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.&lt;/P&gt;</description>
      <pubDate>Wed, 18 May 2022 04:22:42 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/452363#M37382</guid>
      <dc:creator>leocwlau</dc:creator>
      <dc:date>2022-05-18T04:22:42Z</dc:date>
    </item>
    <item>
      <title>Re: Segment or custom date range based on a dimension value</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/453386#M37518</link>
      <description>&lt;P&gt;Thanks&amp;nbsp;&lt;LI-USER uid="2712542"&gt;&lt;/LI-USER&gt;&amp;nbsp; for the suggestion to use unix timestamp. Let me try it.&lt;/P&gt;</description>
      <pubDate>Thu, 26 May 2022 00:56:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/segment-or-custom-date-range-based-on-a-dimension-value/m-p/453386#M37518</guid>
      <dc:creator>acookie4rachel</dc:creator>
      <dc:date>2022-05-26T00:56:37Z</dc:date>
    </item>
  </channel>
</rss>

