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 add-in 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 add-in.
- 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. |