Forum Discussion

danielcontente's avatar
danielcontente
Helper II
2 years ago

Visualize the most successful customer journey

Hi, 

 

I am trying to analyze and visualize the most successful customer path.

What is the best visual I can use and how should I manipulate the data?

 

The data is structured as below:

visitor_uidURLposition in journey
a11
a32
a23
b11
b42
c11
c42
c53
d21
d12
d63
d34
Need Help
Show and Tell
Tips and Tricks

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    what is your criteria for success?  Your sample data is missing details like stay duration, and goal of interaction. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi danielcontente ,
    Based on your description, in order to go for a better presentation of the most successful customer paths, I would recommend using the funnel cahrt or sankey chart. Both of these visualizations are good for showing stage data or flow path percentages.
    With Sankey, you can clearly find the sources, destinations and steps in between and how the stuff flow across them all in one quick glance. You can also interact with it either by clicking the link or the flow itself and leverage the cross highlighting/filtering feature of Power BI to get even more interesting insights in related data.

    With Sankey, you can clearly find the sources, destinations and steps in between and how the stuff flow across them all in one quick glance. You can also interact with it either by clicking the link or the flow itself and leverage the cross highlighting/filtering feature of Power BI to get even more interesting insights in related data.
    You can refer to the following documentation to learn more about these two types of visual objects
    Visual Awesomeness Unlocked – Sankey diagram | Microsoft Power BI Blog | Microsoft Power BI
    Create and use funnel charts in Power BI - Power BI | Microsoft Learn

    Best regards

    Albert He

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • danielcontente's avatar
    danielcontente
    Helper II
    2 years ago

    Hi lbendlin 
    thanks for getting in touch.

    All of those journeys are successful journeys. The URLs of the last (MAX) "position in journey" is always a success (all of them are a REQUESTED A DEMO type of URL). 

    Thanks

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Please provide sample data that fully covers your issue.
      Please show the expected outcome based on the sample data you provided.

      • danielcontente's avatar
        danielcontente
        Helper II
        2 years ago

        Hi, below is the full raw/sample data (there are three columns. Them id column is too width, so please scroll to the right.)

         

        All of those journeys are successful.

        The end goal is to show the different paths and how many "visitors_uid" have gone throughout these paths.

         

        I visualize a tree or a Sankey Diagram.

         

        visitor_uidURLposition in journey
        -9.21308E+18?utm_campaign=HP-EMEA-12.22&utm_source=google&utm_medium=cpc&utm_campaign=%5BRL%5D%20Branded%20,%20AlgoSec&utm1
        -9.21308E+18products/firewall-analyzer/2
        -9.21308E+18solutions/application-connectivity-management/3
        -9.21308E+18solutions/application-connectivity-management/4
        -9.21308E+18blog/achieving-policy-driven-application-centric-security-management-for-cisco-multi-site-orchestrator/5
        -9.21308E+18solutions/application-connectivity-management/6
        -9.21308E+18products/firewall-analyzer/7
        -9.21308E+18products/firewall-analyzer/8
        -9.21308E+18partners/locate-partner/9
        -9.21308E+18/10
        -9.21308E+18partners/locate-partner/11
        -9.21308E+18partners/locate-partner/12
        -9.21308E+18/13
        -9.21308E+18company/contact-us/14
        -9.21308E+18company/how-to-buy/15
        -9.21308E+18company/contact-us/16
        -9.21308E+18company/careers/find-a-job/regional-sales-manager-uk-3/17
        -9.21308E+18company/contact-us/18
        -9.21308E+18lp/typ-demo-lets-book/19
        -9.19017E+18/1
        -9.19017E+18lp/afa-request-a-demo/2
        -9.19017E+18lp/typ-demo-meeting-scheduled/3
        -9.18939E+18lp/typ-demo-contact/1
        -9.17808E+18company/overview/1
        -9.17808E+18/2
        -9.17808E+18lp/request-a-demo/3
        -9.17808E+18/4
        -9.17808E+18company/contact-us/5
        -9.17808E+18m/firewall-compliance-made-easy?_ga=2.229120276.983804248.1697039280-676222107.16968869356
        -9.17808E+18/7
        -9.17808E+18company/contact-us/8
        -9.17808E+18lp/typ-demo-lets-book/9
        -9.14815E+18resources/roi-calculator/1
        -9.14815E+18products/2
        -9.14815E+18products/firewall-analyzer/3
        -9.14815E+18algosec-vs-tufin?utm_source=google&utm_medium=cpc&utm_campaign=Competitor_Tufin_Europe&utm_term=tufin&keyword=tufin&_bt=665258977425&_bk=tufin&_bm=p&_bn=g&gad_source=1&gclid=4
        -9.14815E+18lp/typ-demo-meeting-scheduled/5
        -9.11982E+18lp/typ-demo-lets-book/1
        -9.09982E+18sp/1
        -9.09982E+18resources/roi-calculator/2
        -9.09982E+18partners/channel-partner-program/3
        -9.09982E+18lp/request-a-demo/4
        -9.09982E+18lp/typ-demo-contact/5
        -9.09403E+18products/firewall-analyzer/#1
        -9.09403E+18lp/afa-request-a-demo/2
        -9.09403E+18lp/typ-demo-contact/3
        -9.07786E+18check-point_and_algosec/1
        -9.07786E+18resources/pci-dss-compliance/2
        -9.07786E+18resources/cloud-network-security/3
        -9.07786E+18pt/4
        -9.07786E+18partners/locate-partner/5
        -9.07786E+18our-customers/customer-success-stories/6
        -9.07786E+18our-customers/customer-success-stories/?industry=Financial+Services7
        -9.07786E+18our-customers/customer-success-stories/2/?industry=Financial+Services8
        -9.07786E+18our-customers/customer-success-stories/1/?industry=Financial+Services9
        -9.07786E+18customer-success-stories/bmfbovespa/#video10
        -9.07786E+18resources/roi-calculator/11
        -9.07786E+18solutions/network-segmentation/12
        -9.07786E+18lp/typ-demo-contact/13
        -9.07669E+18partners/supported-devices/1
        -9.07669E+18company/how-to-buy/2
        -9.07669E+18lp/request-a-quote/3
        -9.07669E+18lp/typ-quote-contact-you/4
        -9.07669E+18lp/request-a-demo/5
        -9.07669E+18lp/typ-demo-meeting-scheduled/6
        -9.07141E+18pt/1
        -9.07141E+18products/firewall-analyzer/2
        -9.07141E+18resources/roi-calculator/3
        -9.07141E+18products/firewall-analyzer/4
        -9.07141E+18resources/read/algosec-autodiscovery-automatically-discover-your-network-applications/5
        -9.07141E+18lp/request-a-demo/6
        -9.07141E+18lp/request-a-demo/?utm_campaign=algosec-autodiscovery-automatically-discover-your-network-applications7
        -9.07141E+18lp/typ-demo-contact/8
        -9.06559E+18lp/afa-request-a-demo/1
        -9.06559E+18lp/typ-demo-contact/2
        -9.06299E+18products/1
        -9.06299E+18products/fireflow/2
        -9.06299E+18lp/aff-request-a-demo/3
        -9.06299E+18lp/typ-demo-contact/4
        -9.05585E+18services/training-services/1
        -9.05585E+18company/contact-us/2
        -9.05585E+18company/contact-us/3
        -9.05585E+18lp/typ-demo-meeting-scheduled/4
        -9.0401E+18algosec-vs-firemon/?utm_source=google&utm_medium=cpc&utm_campaign=%5BRL%5D%20Competitors&utm_term=firemon&keyword=firemon&_bt=529746417505&_bk=firemon&_bm=e&_bn=g&gclid=Cj0KCQjw1_SkBhDwARIsANbGpFuF4E5XL26c8r3iBjcMUWJ5Pu5daFHO18GbZJBX5XPWjEpvc-lMeUoaAkv0EALw_wcB1
        -9.0401E+18algosec-vs-firemon/?utm_source=google&utm_medium=cpc&utm_campaign=%5BRL%5D%20Competitors&utm_term=firemon&keyword=firemon&_bt=529746417505&_bk=firemon&_bm=p&_bn=g&gclid=Cj0KCQjw1_SkBhDwARIsANbGpFvpjQzxeI0ZudV7OinwxnZkhWqJJUa7-e-KnCIC3YpOpP3P3R-lBfYaAn6sEALw_wcB2
        -9.0401E+18lp/typ-demo-contact/3
        -9.00044E+18?utm_source=SocialMedia&utm_medium=linkedin1
        -9.00044E+18lp/typ-demo-lets-book/2
        -8.97552E+18fr/1
        -8.97552E+18algosec-vs-tufin/?utm_source=google&utm_medium=cpc&utm_campaign=%5BRL%5D%20Branded%20,%20Competitors&utm_term=tufin%20technologies&keyword=tufin%20technologies&_bt=647535212824&_bk=tufin%20technologies&_bm=p&_bn=s&gclid=EAIaIQobChMIibaltsvt_QIVSrTtCh0ymQ7xEAAYASABEgLVlPD_BwE2
        -8.97552E+18docs/en/asms/a30.00/asms-help/content/afa-admin/adding-a-palo-alto-networks.htm3
        -8.97552E+18request-a-demo-informative/4
        -8.97552E+18lp/typ-demo-lets-book/5
        -8.96326E+18/1
        -8.96326E+18lp/typ-demo-lets-book/2