Skip to main content

Howdy y’all - 

Our team is working on doing a simple customer count, but is struggling to do so without removing all dimensionality from our metric.

We want to count unique instances of a customer where there is spend - but have dimensionalities flagging different types of spend attributes (ex: a flag for customers who have spend in the US vs those who have spend outside of the US). So - if a customer has spend in both the US and outside of the US - they will have a customer count of over 1, when we want each customer to only be counted once while retaining dimensionality. None of the count/countunique formulas are adequately solving this issue.

The page aggregators are correctly counting the number of customers - but we are unable to use the page aggregators in tables to do calculations. Does anyone know of a way to use the “count” from the aggregator for table calculations - or of any other ways to get customer count without double counting across different dimensions?

Hi,

I’m not so sure about your use case but let’s assume you have a Source Metric dimensioned by Customer, Month and Spend.

Source metric

 

Then if you use a COUNTOF() or COUNTUNIQUEOF() function for example, it removes dimensionality:

 

But, if instead you use an aggregation method: or BY COUNTUNIQUE: ] you would keep the dimensionality.

But still, each cell is counted because my numbers are not unique.

So for the Blue Customer, you’d still end up with a 2 for each month.

 

To avoid that you can either have a complex formula to transform the 2s into 1s and keep your 3 dimensions, or the best way is to remove the dimension that is not desired, in this case Spend. And use an appropriate aggregation method, like MIN or COUNTUNIQUE:

You lose the Spend dimension but you keep the other dimensions with the correct count.

 

Hope this helps.

 

Best,

 

Hey Benoit - thank you for sharing! I do think a key part of this is that we are not trying to lose or remove any dimensionality to make this work. 

Hi,

Have you tried the last option to see if it works for you? 

This option removes Spend but keeps the other dimensions.

Because when you say you need “to count customers for 1 either if they spent or not in the US”, unless I’m mistaken, it basically removes the need for the Spend dimension, you no longer need to be able to pivot your data by Spend because it makes no difference, you need your customers to count for 1 regardless of it.

But I will ask for a second pair of eyes on this one.

Please let me know as well.

Best,

 

Reply


Ask your question here!

Terms & ConditionsCookie settings