Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | Year, e.g. 2017 |
| Year of week (Sun-Sat) | yearOfWeek | dim | Year of week for US-style Sunday-Saturday weeks, e.g. 2017 | |
| Year of week (Mon-Sun) | yearOfWeekIso | dim | Year of week for ISO standard Monday-Sunday weeks, e.g. 2017 | |
| Year & month | yearMonth | dim | Year and month, e.g. 2017|06 | |
| Month | month | dim | Month, e.g. 6 | |
| Year & week (Sun-Sat) | yearWeek | dim | Year and week for US-style Sunday-Saturday weeks, e.g. 2017|08 | |
| Year & week (Mon-Sun) | yearWeekIso | dim | Year and week for ISO standard Monday-Sunday weeks, e.g. 2017|08 | |
| Week (Sun-Sat) | week | dim | US week number, e.g. 51 | |
| Week (Mon-Sun) | weekIso | dim | ISO week number, e.g. 51 | |
| Day of month | dayOfMonth | dim | Day of month, e.g. 2 | |
| Day of week (Sun-Sat) | dayOfWeekName | dim | Day of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday | |
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | Day of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday | |
| Date | date | dim | Date, e.g. 2017-01-31 | |
| ACCOUNT | Account name | account_name | dim | Name of the Klaviyo account as you have provided during the login process |
| CAMPAIGN | Campaign name | campaign_name | dim | |
| Campaign ID | campaign_id | dim | ||
| Campaign created date & time | campaign_created_datetime | dim | Datetime value when the campaign was created | |
| Campaign send date & time | campaign_send_datetime | dim | Datetime value when the campaign was sent | |
| Campaign send date | campaign_send_date | dim | Date when the campaign was sent | |
| Campaign send weekday | campaign_send_weekday | dim | Weekday of the date when the campaign was sent | |
| Campaign send time | campaign_send_time | dim | Time when the campaign was sent | |
| Campaign send hour | campaign_send_hour | dim | Hour of the day when the campaign was sent | |
| Content type | campaign_type | dim | ||
| Message type | campaign_message_type | dim | ||
| Subject | campaign_subject | dim | ||
| Campaign is part of a flow | campaign_is_part_of_flow | dim | You can use this dimension to distinguish campaigns that are part of a flow from ones that are not | |
| Campaign is segmented | campaign_is_segmented | dim | ||
| From email | campaign_from_email | dim | ||
| From name | campaign_from_name | dim | ||
| Content status | campaign_status | dim | ||
| Template ID | campaign_template_id | dim | ||
| Content HTML | campaign_html | dim | ||
| FLOW | Flow name | flow_name | dim | |
| Flow ID | flow_id | dim | ||
| Flow URL | flow_url | dim | ||
| LIST | List | list_name | dim | |
| List ID | list_id | dim | ||
| List type | list_type | dim | List type. The possible values include list and segment | |
| PERSON | Person name | person_name | dim | |
| Profile ID | person_id | dim | ID of the recipient profile | |
| Email address | person_email | dim | ||
| Email domain | person_email_domain | dim | ||
| Phone number | person_phone | dim | ||
| Person address line 1 | person_address1 | dim | ||
| Person address line 2 | person_address2 | dim | ||
| Title | person_title | dim | ||
| Organization | person_organization | dim | ||
| Country | person_country | dim | ||
| Region | person_region | dim | ||
| City | person_city | dim | ||
| Zip code | person_zip | dim | ||
| Profile created | person_created | dim | ||
| Age of profile | person_profile_age | dim | ||
| Source | person_source | dim | ||
| Link to profile | person_link | dim | ||
| Accepts marketing | person_accepts_marketing | dim | ||
| Shopify tags | person_shopify_tags | dim | ||
| WEBSITE | Page URL | page | dim | |
| EMAIL CLIENT | Email client | email_client | dim | |
| Email client OS | email_client_os | dim | ||
| Email client type | email_client_type | dim | ||
| PURCHASE | Purchase ID | purchase_id | dim | |
| Is Shopify purchase | purchase_is_shopify | dim | ||
| Is confirmed | purchase_confirmed | dim | ||
| Finacial status | purchase_financial_status | dim | ||
| Is test | purchase_test | dim | ||
| Tags | purchase_tags | dim | ||
| Note | purchase_note | dim | ||
| Currency | purchase_currency | dim | ||
| Payment gateway | purchase_gateway | dim | ||
| Weight | purchase_weight | dim | ||
| Source | purchase_source | dim | POS, Mobile etc | |
| Discount codes | purchase_discount_codes | dim | Any discount or coupon codes someone used towards the order | |
| Shipping rate | purchase_shipping_rate | dim | ||
| Vendor | purchase_vendor | dim | ||
| Order number | purchase_order_number | dim | ||
| Status URL | purchase_order_status_url | dim | ||
| Purchase reference | purchase_reference | dim | ||
| Processing method | purchase_processing_method | dim | ||
| Item count | purchase_item_count | dim | Number of items bought | |
| Total price | purchase_total_price | dim | ||
| Browser IP address | purchase_browser_ip | dim | ||
| Customer locale | purchase_customer_locale | dim | ||
| PURCHASE ITEM | Item name | purchase_item_name | dim | The name or title of the ordered product, e.g., t-shirt |
| Item categories | purchase_item_category | dim | The categories or collections of the ordered product | |
| Item image URL | purchase_item_image_url | dim | URL to the image of the product | |
| Item image | purchase_item_image | dim | URL to the image of the product | |
| Item variant name | purchase_item_variant_name | dim | The name or title of the product variant in Shopify, e.g., red, size medium t-shirt | |
| Item variant title | purchase_item_variant_option_title | dim | ||
| Item variant color | purchase_item_variant_option_color | dim | ||
| Item variant size | purchase_item_variant_option_size | dim | ||
| SKU | purchase_sku | dim | The stock keeping unit of the product variant | |
| Product ID | purchase_product_id | dim | The ID associated with the product in your store | |
| SOURCE | utm_source parameter value | utm_source | dim | Value of the utm_source parameter in the link that brought the buyer to the store |
| utm_medium parameter value | utm_medium | dim | Value of the utm_medium parameter in the link that brought the buyer to the store | |
| utm_campaign parameter value | utm_campaign | dim | Value of the utm_campaign parameter in the link that brought the buyer to the store | |
| utm_content parameter value | utm_content | dim | Value of the utm_content parameter in the link that brought the buyer to the store | |
| utm_term parameter value | utm_term | dim | Value of the utm_term parameter in the link that brought the buyer to the store | |
| Landing page URL | landing_page_url | dim | Landing page URL link that brought the buyer to the store | |
| AD | Ad platform | ad_platform | dim | Platform where the ad was ran |
| Ad campaign name | ad_campaign_name | dim | ||
| Ad set name | ad_set_name | dim | ||
| Ad set ID | ad_set_id | dim | ||
| Ad name | ad_name | dim | ||
| Ad ID | ad_id | dim | ||
| Ad form name | ad_form_name | dim | ||
| Email recipients | klaviyo_total_recipients | met | The number of recipients the email was sent to | |
| Emails received | klaviyo_received_email | met | Number of times when a recipient receives an email | |
| Emails opened | klaviyo_opened_email | met | Number of times when a recipient opens an email | |
| Emails opened (unique) | klaviyo_opened_email_unique | met | Number of recipients that opened an email | |
| Email open rate | klaviyo_open_rate | met | Unique email opens divided by received emails | |
| Emails clicked | klaviyo_clicked_email | met | Number of times when a recipient clicked an email | |
| Emails clicked (unique) | klaviyo_clicked_email_unique | met | Number of recipients that clicked an email | |
| Email click rate | klaviyo_click_rate | met | Unique email clicks divided by received emails | |
| Emails bounced | klaviyo_bounced_email | met | Number of times when an email soft or hard bounced | |
| Email bounce rate | klaviyo_bounce_rate | met | Bounced emails divided by delivered emails | |
| Emails dropped | klaviyo_dropped_email | met | Number of times when an email was not sent because the email address is suspicious | |
| Emails marked as spam | klaviyo_marked_email_as_spam | met | Number of times when a recipient marks an email as spam | |
| Email spam rate | klaviyo_spam_rate | met | Emails marked as spam divided by delivered emails | |
| SMS | SMS recipients | klaviyo_sms_recipients | met | The number of recipients the sms was sent to |
| Received SMS | klaviyo_received_sms | met | Number of times when a recipient receives a sms | |
| Clicked SMS | klaviyo_clicked_sms | met | Number of times when a recipient clicked a sms | |
| Failed to deliver SMS | klaviyo_failed_to_deliver_sms | met | Number of times when a sms failed to deliver | |
| Unsubscribed from SMS | klaviyo_unsubscribed_from_sms | met | Number of times when someone unsubscribes from a specific sms | |
| LIST | New subscriptions to list | klaviyo_subscribed_to_list | met | Number of times when someone opts in to a list |
| Unsubscribes from list | klaviyo_unsubscribed_from_list | met | Number of times when someone unsubscribes from a specific list | |
| Unsubscribes from all emails | klaviyo_unsubscribed | met | Number of times when someone unsubscribes from emails globally | |
| New subscriptions to Back in Stock | klaviyo_subscribed_to_back_in_stock | met | Number of times when a recipient subscribes to be notified about an item being back in stock | |
| LIST MEMBERS | List members | list_members | met | List members count |
| SHOPIFY | Shopify checkout starts | shopify_checkout_started | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Shopify checkout process and clicks continue |
| Shopify checkout start value | shopify_checkout_started_value | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Shopify checkout process and clicks continue | |
| Shopify orders | shopify_placed_order | met | This event is tracked when a customer completes the checkout process and creates an order in your Shopify store | |
| Shopify order value | shopify_placed_order_value | met | The total value of the placed order, inclusive of shipping and any applied discounts | |
| Shopify average order value | shopify_average_order_value | met | The average value of the placed order, inclusive of shipping and any applied discounts | |
| Shopify item quantity | shopify_ordered_product_quantity | met | The total quantity ordered of the product | |
| Shopify checkout completed | shopify_checkout_completed | met | ||
| Shopify checkout completion rate | shopify_checkout_start_to_order_rate | met | Completed checkouts as ratio of checkout starts | |
| Shopify cancelled orders | shopify_cancelled_order | met | This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment | |
| Shopify cancelled order value | shopify_cancelled_order_value | met | This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment | |
| Shopify fulfilled orders | shopify_fulfilled_order | met | This event is tracked when an order is marked as "fulfilled" in your Shopify store | |
| Shopify fulfilled order value | shopify_fulfilled_order_value | met | This event is tracked when an order is marked as "fulfilled" in your Shopify store | |
| Shopify fulfilled partial orders | shopify_fulfilled_partial_order | met | This event is tracked when an order is marked as "partially fulfilled" in your Shopify store | |
| Shopify fulfilled partial order value | shopify_fulfilled_partial_order_value | met | This event is tracked when an order is marked as "partially fulfilled" in your Shopify store | |
| Shopify refunded orders | shopify_refunded_order | met | This event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Shopify refunded order value | shopify_refunded_order_value | met | This event is tracked when a customer completes the checkout process in your Shopify store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Shopify conversion rate | shopify_conversion_rate | met | The number of conversions attributed to a campaign divided by the number of recipients | |
| Shopify revenue per recipient | shopify_revenue_per_recipient | met | The amount of revenue attributed to a campaign divided by the number of recipients | |
| MAGENTO | Magento checkout starts | magento_checkout_started | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Magento checkout process and clicks continue |
| Magento checkout start value | magento_checkout_started_value | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Magento checkout process and clicks continue | |
| Magento orders | magento_placed_order | met | This event is tracked when a customer completes the checkout process and creates an order in your Magento store | |
| Magento order value | magento_placed_order_value | met | The total value of the placed order, inclusive of shipping and any applied discounts | |
| Magento average order value | magento_average_order_value | met | The average value of the placed order, inclusive of shipping and any applied discounts | |
| Magento item quantity | magento_ordered_product_quantity | met | The total quantity ordered of the product | |
| Magento checkout completion rate | magento_checkout_start_to_order_rate | met | Completed checkouts as ratio of checkout starts | |
| Magento cancelled orders | magento_cancelled_order | met | This event is tracked when a customer creates an order in your Magento store but then cancels the order before fulfillment | |
| Magento cancelled order value | magento_cancelled_order_value | met | This event is tracked when a customer creates an order in your Magento store but then cancels the order before fulfillment | |
| Magento fulfilled orders | magento_fulfilled_order | met | This event is tracked when an order is marked as "fulfilled" in your Magento store | |
| Magento fulfilled order value | magento_fulfilled_order_value | met | This event is tracked when an order is marked as "fulfilled" in your Magento store | |
| Magento refunded orders | magento_refunded_order | met | This event is tracked when a customer completes the checkout process in your Magento store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Magento refunded order value | magento_refunded_order_value | met | This event is tracked when a customer completes the checkout process in your Magento store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Magento conversion rate | magento_conversion_rate | met | The number of conversions attributed to a campaign divided by the number of recipients | |
| Magento revenue per recipient | magento_revenue_per_recipient | met | The amount of revenue attributed to a campaign divided by the number of recipients | |
| WOOCOMMERCE | Woocommerce checkout starts | woocommerce_checkout_started | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Woocommerce checkout process and clicks continue |
| Woocommerce checkout start value | woocommerce_checkout_started_value | met | This event is tracked when a customer enters his/her contact and shipping information on the first page of the Woocommerce checkout process and clicks continue | |
| Woocommerce orders | woocommerce_placed_order | met | This event is tracked when a customer completes the checkout process and creates an order in your Woocommerce store | |
| Woocommerce order value | woocommerce_placed_order_value | met | The total value of the placed order, inclusive of shipping and any applied discounts | |
| Woocommerce average order value | woocommerce_average_order_value | met | The average value of the placed order, inclusive of shipping and any applied discounts | |
| Woocommerce item quantity | woocommerce_ordered_product_quantity | met | The total quantity ordered of the product | |
| Woocommerce checkout completion rate | woocommerce_checkout_start_to_order_rate | met | Completed checkouts as ratio of checkout starts | |
| Woocommerce cancelled orders | woocommerce_cancelled_order | met | This event is tracked when a customer creates an order in your Woocommerce store but then cancels the order before fulfillment | |
| Woocommerce cancelled order value | woocommerce_cancelled_order_value | met | This event is tracked when a customer creates an order in your Woocommerce store but then cancels the order before fulfillment | |
| Woocommerce fulfilled orders | woocommerce_fulfilled_order | met | This event is tracked when an order is marked as "fulfilled" in your Woocommerce store | |
| Woocommerce fulfilled order value | woocommerce_fulfilled_order_value | met | This event is tracked when an order is marked as "fulfilled" in your Woocommerce store | |
| Woocommerce refunded orders | woocommerce_refunded_order | met | This event is tracked when a customer completes the checkout process in your Woocommerce store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Woocommerce refunded order value | woocommerce_refunded_order_value | met | This event is tracked when a customer completes the checkout process in your Woocommerce store and a payment is made, but the customer requests the payment to be returned. Klaviyo only receives events from fully refunded orders (not partially refunded orders) | |
| Woocommerce conversion rate | woocommerce_conversion_rate | met | The number of conversions attributed to a campaign divided by the number of recipients | |
| Woocommerce revenue per recipient | woocommerce_revenue_per_recipient | met | The amount of revenue attributed to a campaign divided by the number of recipients | |
| AD | Filled out Facebook lead ad | facebook_advertising_filled_out_lead_ad | met | This event is tracked when a someone fills in a Facebook lead ad |
| STRIPE | Successfully paid | stripe_successfully_paid | met | The total number of successful Stripe payments |
| Successfully paid value | stripe_successfully_paid_value | met | The total value of successful Stripe payments | |
| Failed payment | stripe_failed_payment | met | The total number of failed Stripe payments | |
| Failed payment value | stripe_failed_payment_value | met | The total value of failed Stripe payments | |
| Refunded payment | stripe_refunded_payment | met | The total number of refunded Stripe payments | |
| Refunded payment value | stripe_refunded_payment_value | met | The total value of refunded Stripe payments | |
| Issued invoice | stripe_issued_invoice | met | The total number of issued Stripe invoices | |
| Issued invoice value | stripe_issued_invoice_value | met | The total value of issued Stripe invoices | |
| API | Active on site | api_active_on_site | met | |
| Viewed product | api_viewed_product | met |