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,

 

Reply


Ask your question here!

Terms & ConditionsCookie settings