ProfilesAnalytics
Provides aggregated analytics data for customer profiles, including engagement and purchase activity.
Select
The provider uses the Klaviyo API to process WHERE clause conditions with the following columns and operators. Remaining filters are evaluated client-side within the provider.
- 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. |