Hi all,
I am working with data structured as follows:
Calls with specific IDs on rows with metadata such as the customer, sub-customer it called, phone number, which advert they called etc.
I am trying to create the following calculations:
The average number of unique phone numbers each ad generated per month across the different customers
I would like to double-check with you experts to see which calculation is correct / if either.
{ FIXED [From Nr],[Cust Id]: COUNTD([Meas Custom 101])} and then added as an AVG is "Avg Unique ads by Caller"
and
{ FIXED [Meas Custom 101], MONTH([Start]): COUNTD([From Nr])} and then added as an AVG is "Avg. unique ads by caller (copy 2)"
Hey Jim Dehner,
Thank you for the fast response.
"Measure Custom 101" is the unique ad ID.
So if I understand you correctly, then the first one is the average number of ads each unique from nr (phone number) calls?
And the second one is the average number of unique callers each ad generates?
