Purchased Last Week

In Campaign
From the 1:N linked order list (Lookup) select all contacts that have an ORDER_DT  less than 7 days ago.

In CI

STEP 1

In CI you’ll have an RFM table with a calculated field USER_DAYS_SINCE_LAST_ORDER. It is a pre-calculated field displaying how many days ago the contact placed a last order.

Formula used: DAYSTO([TRANSACTION].[RFM].[USER_LAST_ORDERDATE],TODAY()). It calculates the number of days between a given date (last order date) and today.

STEP 2

Create a new selection using the calculated field and setting its condition to <7.

STEP 3

However, when leaving the selection like this, orders will be returned. So you need to change the resolution level to the audience list. To do so, drag the change resolution level icon onto the main block. It is added after the condition.

Drag and drop now the audience table onto this block.

STEP 4

Save this selection in the Segments folder and CI creates the dynamic segment on the audience list in Campaign.

 

Back to Purchases Examples