This is great! The one problem I have left though is that it now messes up the total row (now over 7M). I could create two separate tables (one for the total and one for the breakdown), but is there any way to make the Home Page row still say 3M?  

Thanks for your response. That's what I suspected, but wanted to verify before I gave up too easily.

Hi Jennifer, Yes I totally understand that this is a click visit (and not a distinct click).  I also recognize that I can't have a click on the HP link without visiting the HP. But you can have a visit to the HP without a click on the HP, thus why this visit-level click thru rate works on the page n...

As you can see from my chart, the values are identical in both of the first two columns so changing the presentation of the columns won't affect the calculation in the third column. For my third column calculation to work, I essentially need to know the # of times each item was clicked (column 1 row...

I'm attempting to create a click thru rate calculation for our Home Page team with the calculation created as the below with HP Click Visits defined as a visit with an event category prefix of RE: (our indicator of a link click).You'll notice that this works great at the Page Name level, but once yo...

Hi Felipe,Thank you for your response. We don't currently have CJA, so it would be nice to have a solution to this problem without paying more. I have also added Excel extension, which can do this as well, but it can break very easily for more complex data pulls.

I totally understand your examples, but I'm not really talking about first or last touch attribution. I'm talking about the default dimension with no attribution. My question is what I would expect in the same session (non attributed) metrics. If hit 1 is Affiliate, but hit 3 is Direct, and I have o...

Hi Faraz,Thank you. I've read this example already. But ours is the reverse as the image (having Direct checked) so that's why I wanted more specific clarification. So for example, let's say I started a visit with an Affiliate, added an item to my cart, opened a new tab and entered the site directly...

One of our business units has their marketing channels set up with Direct Load as a channel and with it checked to Override Last Touch Channel. I know this goes against Adobe's best practices, but what are the implications of having it set up this way? What does this do to your data? Some in the bus...

Thanks. I'll take a look at these scenarios.