topic Re: Average Number of Days in a Month a Segment of Visito... in Adobe Analytics Questions
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409882#M697
<P>Hello Alex,</P><P> </P><P>Using Calculated Metrics we can calculate the Average Subscribers based on number of days in the below sample (we have used Unique Visitors instead of Subscribers)</P><P> </P><P>Example: In Calculated metric we have used the function <STRONG>Approximate Count Distinct</STRONG> to calculate the number of Days, then we have divied the Unique Visitors (you can use your subscribers metric here) data with that function result.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashokkumarm_0-1622036361270.png" style="width: 400px;"><img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/31948iE33DB692DEA85150/image-size/medium?v=v2&px=400" role="button" title="ashokkumarm_0-1622036361270.png" alt="ashokkumarm_0-1622036361270.png" /></span></P><P> </P><P>Hope the above answer will helps you..!</P><P> </P><P>Thanks</P><P>Ashok</P>Wed, 26 May 2021 13:42:40 GMTashokkumarm2021-05-26T13:42:40ZAverage Number of Days in a Month a Segment of Visitors Visits
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409855#M696
<P>Hi,</P><P> </P><P>I have a segment of visitors, let's call them "subscribers".</P><P> </P><P>I want to know how many distinct days in a month on average this segment of visitors visits my site.</P><P> </P><P>Sounds fairly simple in my head but can't quite figure it out!</P><P> </P><P>Thanks,</P><P>Alex</P><P> </P><P> </P>Wed, 26 May 2021 11:17:32 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409855#M696alexjbaker112021-05-26T11:17:32ZRe: Average Number of Days in a Month a Segment of Visito...
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409882#M697
<P>Hello Alex,</P><P> </P><P>Using Calculated Metrics we can calculate the Average Subscribers based on number of days in the below sample (we have used Unique Visitors instead of Subscribers)</P><P> </P><P>Example: In Calculated metric we have used the function <STRONG>Approximate Count Distinct</STRONG> to calculate the number of Days, then we have divied the Unique Visitors (you can use your subscribers metric here) data with that function result.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ashokkumarm_0-1622036361270.png" style="width: 400px;"><img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/31948iE33DB692DEA85150/image-size/medium?v=v2&px=400" role="button" title="ashokkumarm_0-1622036361270.png" alt="ashokkumarm_0-1622036361270.png" /></span></P><P> </P><P>Hope the above answer will helps you..!</P><P> </P><P>Thanks</P><P>Ashok</P>Wed, 26 May 2021 13:42:40 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409882#M697ashokkumarm2021-05-26T13:42:40ZRe: Average Number of Days in a Month a Segment of Visito...
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409887#M698
Thanks but wouldn't that just give me the unique visitors per day? Rather than the average number of days in a month they visited?Wed, 26 May 2021 13:50:56 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409887#M698alexjbaker112021-05-26T13:50:56ZRe: Average Number of Days in a Month a Segment of Visito...
https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409904#M699
<P>Do you capture the timestamp in a dimension? If you do, and that timestamp contains the date, then you may be able to create a calculated metric using approximate count distinct. Note that you can use approximate count distinct with a classification of the timestamp dimension, which you'd likely need to do in order to isolate the "day" component. For example, create a "Day Number" classification to extract "05" from "2021.05.26".</P><P>This won't give you an average outright, but you can use it on a table with, say, Month on the y-axis to see a trend over time. </P><P>Depending on how many customers you have in this segment, it's distinctly possible that they show up every day of the month.</P><P>Since I haven't done this before, I'm working on this using my own data to see if it actually works as expected.</P><P> </P>Wed, 26 May 2021 15:04:22 GMThttps://experienceleaguecommunities.adobe.com/t5/adobe-analytics-questions/average-number-of-days-in-a-month-a-segment-of-visitors-visits/m-p/409904#M699brentrad2021-05-26T15:04:22Z