cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Raghavendra13 Frequent Visitor
Frequent Visitor

Visual to show Attribution Path taken by visitor

Hi all,

 

Can someone point me to a visual where I can show the Attribution Paths taken by visitor, I'm looking for a visual which looks something like the one in the attached image.

Any help would be greatly appreciated in this...

 

 6BD0AC53.PNG

12 REPLIES 12
Raghavendra13 Frequent Visitor
Frequent Visitor

Visual to show attribution path taken by a visitor

Hi all, 

 

 

Can someone point me to a visual where I can show the Attribution Paths taken by visitor, I'm looking for a visual which looks something like the one in the attached image.
Any help would be greatly appreciated in this...

6BD0AC53.PNG

 

Super User
Super User

Re: Visual to show Attribution Path taken by visitor

I don't think you can have arrows but you can created a calculate fields as hyperlink to an image and change that calculated field type to "Image URL" and use that field in the table.

 

Here is link to another thread which has more information. 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Super User
Super User

Re: Visual to show Attribution Path taken by visitor

Hey @Raghavendra13

 

Did you had chance to look at the solution I posted. I don't think there is a visual available, you can custom visual gallery here






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Raghavendra13 Frequent Visitor
Frequent Visitor

Re: Visual to show Attribution Path taken by visitor

Hey @parry2k

 

Thanks for your response on the post, I had a look at what you posted and I'm trying how I can implement it in my report. I'm even looking at Sankey if this can fit my requirments....

Super User
Super User

Re: Visual to show Attribution Path taken by visitor

The way I see is that you have 2 paths to get to Buy (assuming buy is final path), I will save image for each value and then show that field in the table, if you can provide a raw dataset I can put something together for you  as a demo






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Raghavendra13 Frequent Visitor
Frequent Visitor

Re: Visual to show Attribution Path taken by visitor

2 paths is just an example there can be even more, I have attached an excel that has sample data and based on the demo I can see that and I can use it as well....

 

PathPath1Path2Final%Cons BuyTimeToConvert
O&OSEO Buy7%<15 mins
DirectEmail Buy6%<60 mins
MS Store RetargetingO&O Buy3%<30 mins
SEMDirect Buy0.30%<8 hrs
SEOProspectingSEMBuy0.10%<2.5 days
Super User
Super User

Re: Visual to show Attribution Path taken by visitor

Ok, so I was able to achieve this, not sure if that is what you expected:

 

here is the result with sample images:

 

path.PNG

 

I can provide you more deails if you see that we are on right track.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Raghavendra13 Frequent Visitor
Frequent Visitor

Re: Visual to show Attribution Path taken by visitor

Awesome!!!

 

I guess we are in right path can you pls provide me more details so that I will work on this and we can take it further....

Super User
Super User

Re: Visual to show Attribution Path taken by visitor

Here are the steps:

 

- create a column to store the path where we are storing images, in my case I called it myPath

 

myPath = "http://myhostingsite/"

- created 4 new columns like below:

 

Path Image = if(Table2[Path]=BLANK(), BLANK(), concatenate(concatenate(Table2[myPath], lower(Table2[Path])), ".PNG"))

Path1 Image = if(Table2[Path1]=BLANK(), BLANK(), concatenate(concatenate(Table2[myPath], lower(Table2[Path1])), ".PNG"))

Path2 Image = if(Table2[Path2]=BLANK(), BLANK(), concatenate(concatenate(Table2[myPath], lower(Table2[Path2])), ".PNG"))

Buy Image = concatenate(Table2[myPath], "buy.PNG")

in this case I assumed that image file name will be same as value in various paths, for this demo I gave file name in lowre case + ".PNG" and that is why I used lower function in my formula.

 

- Change the date category for these 4 image coloumn to "Image URL"

 

image.PNG

 

- used these image fields in a table, and we have the result.

 

Cheers,

P

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)