Find the most recent value of an evar/prop | Community
Skip to main content
R
robinl39529461
Level 3
April 25, 2024
Question

Find the most recent value of an evar/prop

  • April 25, 2024
  • 1 reply
  • 1264 views

Hi, 
I received this question: 'We have clients using our App and we want to know what is most recent version used, so we know what can be decommissioned'

In the tagging of our App, we capture the App version in each call send.
And it look like this:

The total of unique visitors is ok but with a breakdown on App version, the sum exceeds the total because a visitor can have multiple App version due to historical total.
So how to find the most recent ones?

 

I think I found a way by creating a segment to filter the data (based on this doc: https://experienceleague.adobe.com/en/docs/analytics/components/segmentation/segmentation-workflow/seg-sequential-build Part about 'Only Before Sequence and Only After Sequence') for which I'd like to have your advice.
So example of the data I can have about a visitor:

 

But as I don't know in advance what will be the value of the dimension App version, I will play with 'App Version exists' to have a common value.
So the data will be interpreted like this:

And what I want to have is the last info of my session 3.

 

So by creating a segment with the condition App version exists and playing with the info After/Before sequence, it's something that seems feasible.
Ex:

As 'Only before sequence' is doing the opposite of what I want, I can invert it with an exclusion to isolate the value I want (in grey above).
So the segment will look like this:

By looking to a specific visitor (here the marketing cloud ID), it seems to work: only the most recent occurence of the most recent session (visit number) is part of the segment:

 

And so, only the most recent 'App version' info:

 

 

And the final result:

Same total amount but with different figures in the breakdown. 

 

Does it sounds logical to you ?

If yes, I hope it can help others.
If not, please shoot to help.

 

Thanks for your help.

 

Robin

 

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

yuhuisg
Community Advisor
yuhuisgCommunity Advisor
Community Advisor
April 25, 2024

How about this:

  1. Remove all of your segments and leave behind your original report showing the App Version and Unique Visitors.
  2. Change your report's date range to the last 30 days, or a slightly longer/shorter date range as desired.
  3. Run the report.

My reason for doing this is based on the original question: "...we want to know what is most recent version used..." I've bolded "most recent" because that, to me, means they want to know the app version that people are using now or close to now, and they don't care about the combinations of app versions that people are using over their lifetimes.

    R
    robinl39529461Author
    Level 3
    April 25, 2024

    Thanks for your comment
    Yes, but with this I have 2 issues:

    - what if the user didn't log in the last 30 days?

    - what if user made an update in the last 30 days, it will be counted more than one time

     

    But you are right, my question is maybe confusing.
    It should be: "What is most recent version used for each visitor?"

    Thanks for your reply

    yuhuisg
    Community Advisor
    yuhuisgCommunity Advisor
    Community Advisor
    April 26, 2024

    Do you need a report that covers all of your unique visitors? I personally think that I would be comfortable with a report that covers the majority (eg >85%) of unique visitors.

    Also, if a user made an app update, then that means the older version can be decommissioned, right? So again, you only need to know what is the most recent, last used app version, without any regard for the previous version.

      Terms & ConditionsAccessibility statement

      Loading footer...