ProfilesAnalytics
Provides aggregated analytics data for customer profiles, including engagement and purchase activity.
Select
The add-in uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the add-in.
- Id supports the operators: =, IN
For example, the following query is processed server-side:
SELECT * FROM ProfilesAnalytics
WHERE Id = 'id-1'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | The unique identifier for the profile, automatically generated by Klaviyo. | |
| AverageDaysBetweenOrders | Double | The average number of days between placed orders for the profile. Returns null if only one order has been placed. | |
| AverageOrderValue | Double | The average monetary value of orders placed by the profile. | |
| ChurnProbability | Double | The estimated probability that the customer has churned, based on historical engagement and purchasing behavior. | |
| ExpectedDateOfNextOrder | Datetime | The predicted date of the customer's next order, calculated at the time of their most recent purchase. | |
| HistoricCLV | Int | The total value of all previously completed orders for the profile, representing historic customer lifetime value. | |
| HistoricNumberOfOrders | Int | The total number of orders previously placed by the profile. | |
| PredictedCLV | Int | The predicted total value of all orders the profile is expected to place within the next 365 days. | |
| PredictedNumberOfOrders | Int | The predicted number of orders the profile is expected to place within the next 365 days. | |
| TotalCLV | Int | The combined customer lifetime value, calculated as the sum of historic Customer Lifetime Value (CLV) and predicted CLV. |