My company enjoys the funnel perspective presented when you look at: Visits --> Unique Visitors --> Customer IDs
But to automate this in a Report Builder report, is has become a manual process. As we advance up the Maturity Model for Analytics and identify the questions that we want answered we have now pushed the limits of what Excel and Report Builder can handle, as we well over 50,000 Cust IDs in a week, and when we want to break it down by our marketing channels and customer segments the 42 Report builder requests crash program. I need the number of unique Cust IDs over a time period at the aggregate level, not a list of all the cust ids.
Also I find it incongruent that this is information I can extract the list of cust ids from the DW manually, but not in the console or especially report builder. But I am still left with a list to count, not a de-duped aggregate number.
I would love to see the functionality added to report builder to count the number of unique occurrence of an evar. Essentially summing the number of elements an evar has of a period of time and then being able to dedupe them.
Allowing for ability to count Evars as a metric would solve a significant problem for my organization who chooses not to use the unique visitor variable.