Transaction Lists and Aggregations

Transaction lists are a type of CRM list with transaction data, that contains at least one deployable PII attribute, have at least one column that is aggregated and can be deployed to all deployment partners. In the UI, transaction data gets aggregated up to one row per user.

Transaction Lists

When creating an audience list, if your list has at least one aggregated column, it will be considered a transaction list. There must also be at least one deployable PII.

These lists can be used to create segments based on different columns present on the lists.

More Information

• Unless a unique key is specified when creating the list - the first added PII attribute will be the unique key on that list.

• If you specify another unique key, the PII attribute will be removed from the unique key and you will have to select the PII attribute as well if you want it as a unique key.

When you set up a new Transaction CRM list you can specify aggregation rules for each attribute. Click here to learn how to set up a new CRM List.

While transaction lists are aggregated in the UI, they're not aggregated in the database so you can still use Power Audiences for advanced querying

The Aggregation Types available are:

• None (Last Value)
• Set
• Sum
• Average