Page 1 of 1

The number of bookings in each year of a customer

Posted: Mon Dec 23, 2024 4:44 am
by phonedata
The first booking date is specified as an on-the-fly recency aggregation. In the bottom right we can then use this expression in a selection to select all bookings where this value is <365 (i.e falls in the first year). We can then use that in a further expression as the transactional filter selection on a frequency aggregation to work out the number of bookings in the first year.


In the example below we’ve added this expression to a data grid to check that the results look correct.


This is a very powerful and flexible cyprus mobile number example technique to extend the capabilities of the on-the-fly aggregation with many possible applications. It could also be used for looking at the ratios of journey, to see how often a customer switches between products, or to compare how the trend of a customer spend changes between the first half of their transactions and the second.

Segmentations
We’ve been unable to formulate up segmentation selections to answer questions for some scenarios as we needed the ability to have aggregations with transactional filter selections containing relative date sliding windows. In the example below we have the definition of a simple Frequency aggregation with a transactional filter to only include bookings made to Europe in the last year.