Web Analytics Pathing Chart
Hello All!
We use Domo as our digital anlaytics tool. I'd be interested in hearing from other customers who also use this tool for web analytics. More specifically if they have a possible solution for pathing questions. With the introduction of the sankey diagram I thought this would be the ideal chart for web page pathing.
However, if I try to use it it gives me a circular reference error. I think I understand why because if there is a scenario where page A leads to page B there can't also be a scenario where page B leads to page A but that of course can happen a lot in web analytics.
Therefore, I just want to throw out the question here if someone has any experience with pathing here in Domo.
Thanks!
Comments
-
Hi @Stefano ,
I've done some things similarly in terms of attribution modeling using a Markov chain / probability matrix pivot table but it depends on how many different pages you're attempting to display in your pathing report. The more different pages you have the wider and larger your table / matrix becomes. The downside to this is you only get to see where they go on their next step and don't have the overall path.
Page A B C D A 15 22 87 0 B 1 2 3 4 C 42 42 42 42 D 22 2 76 10 The other option is to create the paths yourself as part of a query and seprate it by a delimiter and display all of the possible paths seen as a table
Path Count A > B > C 15 A 1 A > C 42 C > B > C 22 They have their downfalls as it's more data heavy and aren't as pretty as a Sankey chart but I've found them to be an effective way to relay pertinent information to stakeholders. Both methods are dependent on the number of pages you're attempting to display.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thanks Grant!
I don't have a particular set or number of pages I would like to do this. But I rather wanted to look at our entire web analytics dataset. Basically I was hoping to be able to pick any web page in our web eco system and look at the next pages to and from there.
Like with your Markov chain / probability matrix pivot table, what I have done for now is to create a table in which one picks a particualr page and it will list all the next pages that got viewed. Problem now is, I would like to be able to pick one of those next pages and again look at the next pages and so on...
This would also best show at what point or on which page we have a big drop off, meaning people leaving our website.
I have attached a screenshot from adobe analytics and I was hoping to replicate something like that in Domo. Hope this clears up my problem/question.
0 -
@Stefano your visualization is just an extension of @GrantSmith 's path model.
PrevPage Current Page Next Page Count a b c 15 start a end 1 a c end 42 c b c 22 if for SessionID = 1 the journey was
A > B > A >C
then you would have 4 entries for that one journey.
Start > A > B
A > B > A
B > A > C
A > C > End
That'd be a gnarly little piece of SQL @GrantSmith ?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive