Seeing Customer ID for all pages that existed during a visit even when not set on that page.
We have a web portal that collects customer ID (CID) on our website.
That means some visits include pages where Customer ID is set and Pages where it is not set.
I can view all pages seen where Customer ID exists within visit, including those where CID was not set but I want to break the pages down by those CID that saw each non set CID page during a visit.
Currently if I make CID Exists segment at visit level, put it in table with Page as the dimension any page where CID was not set returns nothing when broken down with CID.
| CID Exists Visit Level | |
| Visits | |
| Page: | 454221 |
| Homepage | 234862 |
| Homepage CID Number (breakdown) | 0 |
Table I want but not sure is possible is below:
| CID Exists Visit Level | ||
| Visits | ||
| 454221 | ||
| Page: | 254862 | |
| Homepage | ||
| Homepage CID Number (breakdown) | 254862 | |
| CID123 | 105 | |
| CID124 | 90 | |
| CID125 | 95 |
Any ideas more than welcome, not sure it's possible but interested in thoughts.