Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Customer ID Count Report

Avatar

Level 1

10-02-2015

It's common for analysts to count the number of customers via a customer ID captured with a prop or an eVar instead of using unique visitors. It'd be great if was a report that was a sum of the unique counts within a particular variable. e.g. we use eVar 12 to capture our unique customer ID. When we calculate we penetration for reporting purposes we manually count the number of rows in eVar over a given period. Ideally, there would be a seperate variable that would sum the row count from our eVar 12 customer ID variable. That would also enable customer ID counts for various breakdowns and report automation. 

3 Comments

Avatar

Employee

10-02-2015

This is actually available already in Ad Hoc Analysis. There you can create a calculated metric defined as COUNT(Occurrences), and then that should give you the total number of rows (in this case, customer IDs) that had a page view. (You could replace Occurrences with, for example, Orders if you wanted to return only the count of customer IDs who placed an order.)