BookmarkSubscribeRSS Feed
Xiaoping
Calcite | Level 5

Sankey diagram is very useful for tracking the trajectory of the event, even a cohort of customers .... however, currently I am facing an issue, sankey disgram can deal with drop off earlier case, but how to deal with the late entry cases?


 For example, there are 5 steps for my event ( ie. step 1 to 5, entry at step 1 and ended at step 5), a part of the cohort can finish at step 4, and a part of the cohort can enter from step 2 or step 3, how should my dataset be structured for the late entry situations?

 

 

4 REPLIES 4
FalkoSchulz
SAS Employee

Hi, The path analysis algorithm does take care of this for you. Given your transaction data set - late entries are determined by their sequence appearance. Have a look at the blog at https://blogs.sas.com/content/sascom/2014/08/19/path-analysis-with-sas-visual-analytics (a little dated but it shows the structure of the expected data set). In this example the customer 'Jane' views web-page B as the first entry whereas everyone else starts with page A. So Jane is coming in one step later as the rest. Obviously this is very basic path - but the same applies to larger paths and scenarios.

Hope this helps. Falko

Xiaoping
Calcite | Level 5

Thanks Falko,

 

but I'd like the B (Jane's start point) at the same column as John's B, for example A, B, C, D are time related event, we'd like they are line up as a time series.

 

Please see the attached mock-up graph, the red circle part

 

sankey.png

FalkoSchulz
SAS Employee

Ah I see. Sorry I misunderstood your question. No, unfortunately in path analysis related events need to have the same start sequence in order to join. If you have a path with only a portion of the events - it's considered a separate path. What you may be able to do - is to use dummy values for the events the customer is not yet part of the main path (e.g. missing value). So a table structure like this with Jane joining in at C:

 

va_82_sankey_simple_path_data.png

 

..would produce a diagram like this (screen shot is using the newer version of VA 8.x so slightly different):

va_82_sankey_simple_path.png

Not exactly what you were after but hope this helps.

 

Cheers, Falko

Xiaoping
Calcite | Level 5

Thanks !

 

that's the method I am using. I use "." instead of "Missing", it works perfectly in the Event view (only showing a dot , no flow from . to real event), but not looks nicely for the pathway views , ie including the . event (blank event) in the pathways.

 

Anyway , thanks a lot ! hopefully SAS VA new version will consider this scenario .

 

Cheers,

xiaoping

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1380 views
  • 2 likes
  • 2 in conversation