Event Propensity table

An Event Propensity table associates individual customers to the events that, depending on the event, are most likely to lead to engagement with your brand.

Note

The size of the Event Propensity table in your tenant is determined by the number of customers who are associated with events in the table.

How the Event Propensity table is created

Amperity creates the Event Propensity table automatically when you build and activate an event propensity model. You do not need to add the table by hand or write any SQL.

Each active event propensity model produces its own output table, named Predicted_Propensity_{EventName} after the target event name provided during model setup. The table contains one row per customer per event, along with the customer’s score, ranking, and recommended audience-size flags. See the column reference for details.

To start producing an Event Propensity table, build an event propensity model and then activate it:

Column reference

The Event Propensity table has the following columns:

Column name

Data type

Description

Amperity ID

String

The unique identifier assigned to clusters of customer profiles that all represent the same individual. The Amperity ID does not replace primary, foreign, or other unique customer keys, but exists alongside them within unified profiles.

Note

The Amperity ID is a universally unique identifier (UUID) that is 36 characters spread across five groups separated by hyphens: 8-4-4-4-12.

For example:

123e4567-e89b-12d3-a456-426614174000

Audience Size Large

Boolean

A flag that indicates the recommended audience size. When this value is True the recommended audience size is large.

A large audience is predicted to include ~90% of customers who are likely to perform the target event.

Audience Size Medium

Boolean

A flag that indicates the recommended audience size. When this value is True the recommended audience size is medium.

A medium audience is predicted to include ~70% of customers who are likely to perform the target event.

Audience Size Small

Boolean

A flag that indicates the recommended audience size. When this value is True the recommended audience size is small.

A small audience is predicted to include ~50% of customers who are likely to perform the target event.

Use a small audience size to help prevent wasted spend and to reduce opt-outs.

Ranking

Integer

A ranking of customers by score for this event. A rank that is less than or equal to X provides the top N customers with an propensity for this event.

Score

Float

The strength of a customer’s propensity for this event, shown as an uncalibrated probability between 0 and 1.

Tip

Ranking is derived directly from the score–customers are ranked in descending order of score–so a higher score corresponds to a higher ranking. Because the score is uncalibrated, target customers using Ranking and audience size rather than the raw score.

Sort results by Ranking, and then compare those results to audience sizes. Higher rankings within smaller audience sizes correlate with higher propensity.

Target Event Name

String

The name of the target event used with an event propensity model.