In this article, we will explain how to build and use formulas to calculate different data using contact attributes and transactional parameters.
Before you start
- Make sure you're familiar with the different types of contact attributes.
How to build a formula?
In Brevo, the two basic functions to build formulas are COUNT and SUM.
COUNT - Count specific data
The COUNT function can be used to count specific data.
COUNT[A] | Will count the number of A. |
COUNT[A,B,C,D] A is mandatory; B, C, and D are optional. |
Will count the number of A, use B as a first condition, use C as an operator (=, < or >), and use D as a second condition. |
SUM - Calculate the total value of specific data
The SUM function can be used to calculate the total value of specific data.
SUM[A] | Will calculate the total value of A. |
SUM[A,B,C,D] A is mandatory; B, C, and D are optional. D can be a fixed number or can be used with the command NOW where NOW(-x) is the date from x days ago. |
Will calculate the total value of A, use B as a first condition, use C as an operator (=, < or >), and use D as a second condition. |
How to use formulas?
Calculated values
A formula can be used in a calculated value to calculate specific data for each of your contacts using transactional parameters. Calculated values are displayed on your contacts' details page.
To learn how to add calculated values, check our dedicated article What are the different types of contact attributes?.
- COUNT[ORDER_ID]: count the total number of orders made by a contact.
- COUNT[ORDER_ID,ORDER_VALUE,>,50]: count the total number of orders over 50€ made by a contact.
- SUM[ORDER_VALUE]: calculate the total value of orders made by a contact.
- SUM[ORDER_VALUE,ORDER_DATE,>,NOW(-30)]: calculate the total value of orders made in the past 30 days by a contact.
Global calculated values
A formula can be used in a global calculated value to calculate custom statistics for your contact lists and emails using contact attributes. Global calculated values are displayed under the Global Computed Values section of your dashboard.
To learn how to add a global calculated value, check our dedicated article Can I add custom statistics to calculate?.
- COUNT[BLACKLISTED,BLACKLISTED,<,NOW()]: count all blocklisted contacts until now.
- COUNT[BOUNCES,SOFT,<,NOW(-30)]: count all soft bounces in the last 30 days.
- COUNT[BOUNCES,HARD,<,NOW()]: count all hard bounces until now.
- COUNT[READS,READS,<,NOW(-15)]: count all opens in the last 15 days.
- COUNT[READERS,READERS,<,NOW()]: count all unique opens until now.
- COUNT[CLICKS,CLICKS,<,NOW(-60)]: count all clicks in the last 60 days.
- COUNT[CLICKERS,CLICKERS,<,NOW()]: count all unique clicks until now.
🤔 Have a question?
If you have a question, feel free to contact our support team by creating a ticket from your account. If you don't have an account yet, you can contact us here.