Average number of transactions per month

Published June 20, 2022

Modules

Difficulty

Selected Clients

---

Industry

Books

Cosmetics

Electronics

Fashion & Apparel

FMCG

Home & Furniture

Jewelry

Multi

Retail

In this scenario, you will create sample segmentation that allows you to divide your clients into segments based on their average number of transactions per month. You may use that information further for targeted communication with promotions for a specific group.

Prerequisites

• Add a tracking code to your website.
• Become familiar with aggregates and expressions.

Process

1. Create aggregates.
2. Create expression.
3. Create segmentation.

Create aggregates

In the first part of the process, create two aggregates which will be used later for creating expressions:

• An aggregate that counts a total number of transactions a customer made
• An aggregate that returns the timestamp of the first transaction a customer made

Total number of transactions for a customer

1. Go to Analytics > Aggregates > Create aggregate.
2. As the aggregate type, select Profile.
3. Enter the name of the aggregate, for example Total number of transactions.
4. Set Analyze profiles by to Count.
5. From the Choose event dropdown list, select transaction.charge
6. In the date picker, select Lifetime.
7. Save the aggregate.

Timestamp of the first customer’s transaction

1. Go to Analytics > Aggregates > Create aggregate.
2. As the aggregate type, select Profile.
3. Enter the name of the aggregate, for example Timestamp of first transaction.
4. Set Analyze profiles by to First.
5. From the Choose event dropdown list, select transaction.charge.
6. As the event parameter, select TIMESTAMP.
7. In the date picker, select Lifetime.
8. Save the aggregate.

Create expressions

In the next part of the process, create 4 expressions. The fourth one uses the results of the first three to calculate the average number of transactions, and is later used as an attribute for creating a segmentation.

The list of expressions:

• An expression that returns the timestamp of the current date
• An expression that returns the timestamp of the first customer’s transaction expressed in milliseconds
• An expression that returns the number of months that passed since the first transaction
• An expression that returns the average number of transactions per month

Timestamp of the current day

1. Go to Analytics > Expressions > New expression.
2. Enter the name of the expression, for example Timestamp - today.
3. As the expression type, select Attribute.
4. Create the following formula of the expression:
5. Save the expression.

Timestamp of the customer’s first transaction in milliseconds

1. Go to Analytics > Expressions > New expression.
2. Enter the name of the expression, for example Timestamp of the first transaction - milliseconds.
3. As the expression type, select Attribute.
4. Create the following formula of the expression:
5. Save the expression

Number of months since the first transaction

1. Go to Analytics > Expressions > New expression.
2. Enter the name of the expression, for example Months since the first transaction.
3. As the expression type, select Attribute.
4. Create the following formula of the expression.
5. Save the expression.

Average number of transactions per month

1. Go to Analytics > Expressions > New expression.
2. Enter the name of the expression, for example Average number of transactions per month.
3. As the expression type, select Attribute.
4. Create the following formula of the expression:
5. Save the expression.

Create segmentation

In the final part of the process, create a segmentation that organizes customers into three groups:

• More than 2 transactions per month - It gathers the customers who make more than 2 transactions per month on average
• 2 transactions per month - It gathers the customers who make 2 transactions per month on average
• Less than 2 transactions per month - It gathers the customers who make less than 2 transactions per month on average

1. Go to Analytics > Segmentations > New segmentation.
2. Rename Segment A to More than 2.
3. Click Add segment.
4. Rename Segment B to 2.
5. Click Add segment.
6. Rename Segment C to Less than 2.
7. Configure the conditions of each segment:
   
   More than 2

   1. Click Have property…
   2. Select the Average number of transactions per month expression
   3. As the logical parameter, select MORE ()
   4. As the value, enter 2.
   5. Click Performed event…
   6. Select the transaction.charge event.

   2

   1. Click Have property…
   2. Select the Number of months since the first transaction expression
   3. As the logical parameter, select Equal ()
   4. As the value, enter 2.
   5. Click Performed event…
   6. Select the transaction.charge event.

   Less than 2

   1. Click Have property…
   2. Select the Number of months since the first transaction expression
   3. As the logical parameter, select LESS ()
   4. As the value, enter 2.
   5. Click Performed event…
   6. Select the transaction.charge event.

   

8. Save the segmentation.
   Below the settings of the segmentation, you can preview how your customer base splits according to the defined conditions.
9. Click Show preview.
   You receive the number of customers in each segment and the percentage of each segment in relation to the whole population in the segmentation. Additionally:

• You can change the chart type - pie chart and column chart
• You can also export the information to CSV/XLSX (data) or JPEG/PNG/PDF (chart)

Check the use case set up on the Synerise Demo workspace

You can also check the configuration directly in Synerise Demo workspace:

• segmentation
• aggregate that counts a total number of transactions
• aggregate that returns the timestamp of the first transaction
• expression that returns the timestamp of the current date
• expression that returns the timestamp of the first customer’s transaction
• expression that returns the number of months that passed since the first transaction
• expression that returns the average number of transactions per month

If you don’t have access to the Synerise Demo workspace, please leave your contact details in this form, and our representative will contact you shortly.

Read more

• Segmentation