MappedMetrics
Returns all mapped metrics in the account. Mapped metrics define the relationship between mapping types (such as revenue, added_to_cart, ordered_product) and the underlying metric or custom metric used for tracking.
Select
The component uses the Klaviyo API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the component.
- Id supports the following operator: =
For example, the following query is processed server-side:
SELECT * FROM MappedMetrics WHERE Id = 'added_to_cart'
Update
You can update a mapped metric by specifying the Id of the record and setting either the MetricId or CustomMetricId field.
UPDATE MappedMetrics SET MetricId = 'QREnXz' WHERE Id = 'added_to_cart'
Columns
| Name | Type | ReadOnly | References | Description | |
| Id [KEY] | String | True |
The type of mapping. Allowed values: added_to_cart, cancelled_sales, ordered_product, refunded_sales, revenue, started_checkout, viewed_product. | ||
| Updated | Datetime | True |
The date and time when this mapping was last updated, in ISO 8601 format (YYYY-MM-DDTHH:MM:SS.mmmmmm). | ||
| MetricId | String | False |
The Id of the metric for this mapping. Set this to update the mapping to a standard metric. Set to null to unset the mapping. | ||
| CustomMetricId | String | False |
The Id of the custom metric for this mapping. Set this to update the mapping to a custom metric. Set to null to unset the mapping. |