Klaviyo

Outros · Disponível

Consultar via API

GET https://askaner.askan.com.br/api/v1/data/klaviyo?fields=date,account_id&date_preset=last_30d
Authorization: Bearer ik_...

Campos (114 métricas, 105 dimensões)

ID	Tipo	Natureza	Descrição
`campaign_report_average_order_value`	NUMERIC	Métrica	Campaign report Average Order Value
`campaign_report_bounce_rate`	PERCENT	Métrica	Campaign report Bounce Rate
`campaign_report_bounced`	NUMERIC	Métrica	Campaign report Bounced
`campaign_report_bounced_or_failed`	NUMERIC	Métrica	Campaign report Bounced Or Failed
`campaign_report_bounced_or_failed_rate`	PERCENT	Métrica	Campaign report Bounced Or Failed Rate
`campaign_report_click_rate`	PERCENT	Métrica	Campaign report Click Rate
`campaign_report_click_to_open_rate`	PERCENT	Métrica	Campaign report Click To Open Rate
`campaign_report_clicks`	NUMERIC	Métrica	Campaign report Clicks
`campaign_report_clicks_unique`	NUMERIC	Métrica	Campaign report Clicks Unique
`campaign_report_conversion_rate`	PERCENT	Métrica	Campaign report Conversion Rate
`campaign_report_conversion_uniques`	NUMERIC	Métrica	Campaign report Conversion Uniques
`campaign_report_conversion_value`	NUMERIC	Métrica	Campaign report Conversion Value
`campaign_report_conversions`	NUMERIC	Métrica	Campaign report Conversions
`campaign_report_delivered`	NUMERIC	Métrica	Campaign report Delivered
`campaign_report_delivery_rate`	PERCENT	Métrica	Campaign report Delivery Rate
`campaign_report_failed`	NUMERIC	Métrica	Campaign report Failed
`campaign_report_failed_rate`	PERCENT	Métrica	Campaign report Failed Rate
`campaign_report_open_rate`	PERCENT	Métrica	Campaign report Open Rate
`campaign_report_opens`	NUMERIC	Métrica	Campaign report Opens
`campaign_report_opens_unique`	NUMERIC	Métrica	Campaign report Opens Unique
`campaign_report_recipients`	NUMERIC	Métrica	Campaign report Recipients
`campaign_report_revenue_per_recipient`	NUMERIC	Métrica	Campaign report Revenue Per Recipient
`campaign_report_spam_complaint_rate`	PERCENT	Métrica	Campaign report Spam Complaint Rate
`campaign_report_spam_complaints`	NUMERIC	Métrica	Campaign report Spam Complaints
`campaign_report_unsubscribe_rate`	PERCENT	Métrica	Campaign report Unsubscribe Rate
`campaign_report_unsubscribe_uniques`	NUMERIC	Métrica	Campaign report Unsubscribe Uniques
`campaign_report_unsubscribes`	NUMERIC	Métrica	Campaign report Unsubscribes
`campaign`	TEXT	Dimensão	Campaign name
`campaign_channel`	TEXT	Dimensão	Campaign Channel
`campaign_id`	TEXT	Dimensão	Campaign id
`created`	TEXT	Dimensão	Campaign creation time
`from_email`	TEXT	Dimensão	From e-mail
`from_name`	TEXT	Dimensão	From name
`message_channel`	TEXT	Dimensão	Message Channel
`sent_at`	TEXT	Dimensão	Campaign sent time
`status`	TEXT	Dimensão	Campaign status
`subject`	TEXT	Dimensão	Campaign subject
`subscription_status`	TEXT	Dimensão	Email subscriptions status
`card_last_four`	TEXT	Dimensão	Last four digits of the card used for the payment, from Stripe Successful Payment and Failed Payment events
`card_type`	TEXT	Dimensão	Card brand used for the payment (e.g. visa, mastercard), from Stripe Successful Payment and Failed Payment events
`event_datetime`	TEXT	Dimensão	Time the event occurred, in ISO8601 format
`event_name`	TEXT	Dimensão	Name of the metric the event was tracked for
`event_uuid`	TEXT	Dimensão	Klaviyo's unique identifier of the event
`order_id`	TEXT	Dimensão	Identifier of the order the event belongs to, for events tracked by an ecommerce or shipping integration
`payment_failure_reason`	TEXT	Dimensão	Reason a payment failed (e.g. card declined), from Stripe Failed Payment events
`profile_email`	TEXT	Dimensão	Email address of the profile the event is associated with
`profile_firstname`	TEXT	Dimensão	First name of the profile the event is associated with
`profile_id`	TEXT	Dimensão	Klaviyo profile/member id the event is associated with; joins with the Members table 'id' field
`profile_lastname`	TEXT	Dimensão	Last name of the profile the event is associated with
`refund_amount`	NUMERIC	Métrica	Amount refunded, from Stripe Refunded Payment events
`flow_archived`	TEXT	Dimensão	Flow Archived
`flow_average_order_value`	NUMERIC	Métrica	Flow Average order value
`flow_bounce_rate`	PERCENT	Métrica	Flow Bounce rate
`flow_bounced`	NUMERIC	Métrica	Flow Bounced
`flow_bounced_or_failed`	NUMERIC	Métrica	Flow Bounced or failed
`flow_bounced_or_failed_rate`	PERCENT	Métrica	Flow Bounced or failed rate
`flow_click_rate`	PERCENT	Métrica	Flow Click rate
`flow_click_to_open_rate`	PERCENT	Métrica	Flow Click to open rate
`flow_clicks`	NUMERIC	Métrica	Flow Clicks
`flow_clicks_unique`	NUMERIC	Métrica	Flow Clicks unique
`flow_conversion_rate`	PERCENT	Métrica	Flow Conversion rate
`flow_conversion_uniques`	NUMERIC	Métrica	Flow Conversion uniques
`flow_conversion_value`	NUMERIC	Métrica	Flow Conversion value
`flow_conversions`	NUMERIC	Métrica	Flow Conversions
`flow_created_time`	TIMESTAMP	Dimensão	Flow Created Time
`flow_delivered`	NUMERIC	Métrica	Flow Delivered
`flow_delivery_rate`	PERCENT	Métrica	Flow Delivery rate
`flow_failed`	NUMERIC	Métrica	Flow Failed
`flow_failed_rate`	PERCENT	Métrica	Flow Failed rate
`flow_id`	TEXT	Dimensão	Flow ID
`flow_message_id`	TEXT	Dimensão	Flow Message ID
`flow_message_name`	TEXT	Dimensão	Flow Message Name
`flow_name`	TEXT	Dimensão	Flow Name
`flow_open_rate`	PERCENT	Métrica	Flow Open rate
`flow_opens`	NUMERIC	Métrica	Flow Opens
`flow_opens_unique`	NUMERIC	Métrica	Flow Opens unique
`flow_recipients`	NUMERIC	Métrica	Flow Recipients
`flow_revenue_per_recipient`	NUMERIC	Métrica	Flow Revenue per recipient
`flow_spam_complaint_rate`	PERCENT	Métrica	Flow Spam complaint rate
`flow_spam_complaints`	NUMERIC	Métrica	Flow Spam complaints
`flow_status`	TEXT	Dimensão	Flow Status
`flow_trigger_type`	TEXT	Dimensão	Flow Trigger Type
`flow_unsubscribe_rate`	PERCENT	Métrica	Flow Unsubscribe rate
`flow_unsubscribe_uniques`	NUMERIC	Métrica	Flow Unsubscribe uniques
`flow_unsubscribes`	NUMERIC	Métrica	Flow Unsubscribes
`flow_updated_time`	TIMESTAMP	Dimensão	Flow Updated Time
`flow_url`	TEXT	Dimensão	Flow Url
`account_id`	TEXT	Dimensão	Klaviyo account ID
`account_name`	TEXT	Dimensão	Klaviyo account name
`date`	DATE	Dimensão	Date of metric type data
`address1`	TEXT	Dimensão	The primary address line of the object
`address2`	TEXT	Dimensão	The secondary address line of the object
`city`	CITY	Dimensão	The city of the object
`country`	COUNTRY	Dimensão	The country of the object
`created_at`	DATE	Dimensão	The date and time the object was created
`dimension_member_count`	NUMERIC	Métrica	Member count for current dimension values
`email`	TEXT	Dimensão	The email address of the object
`firstname`	TEXT	Dimensão	The first name of the object
`id`	TEXT	Dimensão	The ID of the object
`lastname`	TEXT	Dimensão	The last name of the object
`latitude`	TEXT	Dimensão	The latitude of the object
`list_created`	TIMESTAMP	Dimensão	List Create Date
`list_id`	TEXT	Dimensão	List Id
`list_name`	TEXT	Dimensão	List Name
`list_profile_count`	NUMERIC	Métrica	Total number of profiles in the list
`list_updated`	TIMESTAMP	Dimensão	List Update Date
`locale`	TEXT	Dimensão	The locale of the profile
`longitude`	TEXT	Dimensão	The longitude of the object
`members_count`	NUMERIC	Métrica	Total number of members for the whole account
`object`	TEXT	Dimensão	The type of the object (e.g. Person)
`organization_name`	TEXT	Dimensão	The organization of the object
`phone`	TEXT	Dimensão	The phone number of the object
`region`	REGION	Dimensão	The region of the object
`segment_created`	TIMESTAMP	Dimensão	Segment Create Date
`segment_id`	TEXT	Dimensão	Segment Id
`segment_name`	TEXT	Dimensão	Segment Name
`segment_profile_count`	NUMERIC	Métrica	Total number of profiles in the segment
`segment_updated`	TIMESTAMP	Dimensão	Segment Update Date
`timezone`	TEXT	Dimensão	The time zone of the object
`title`	TEXT	Dimensão	The title of the object
`updated_at`	DATE	Dimensão	The date and time the object was last updated
`zip`	TEXT	Dimensão	The zip code of the object
`added_to_cart`	NUMERIC	Métrica	Total number of Added to Cart events
`bounced_email`	NUMERIC	Métrica	Bounced Email
`bounced_email_rate`	NUMERIC	Métrica	Bounced Email Rate
`cancelled_order`	NUMERIC	Métrica	Total amount of Cancelled Order
`cancelled_order_value`	NUMERIC	Métrica	Cancelled Order value
`checkout_completed`	NUMERIC	Métrica	Checkout Completed
`checkout_start_to_order_rate`	NUMERIC	Métrica	Completed checkouts as ratio of checkout starts
`checkout_started`	NUMERIC	Métrica	Total amount of Checkout Started
`checkout_started_value`	NUMERIC	Métrica	Checkout Started value
`click_rate`	PERCENT	Métrica	Click rate of e-mails
`clicked_sms`	NUMERIC	Métrica	Number of unique SMS clicks
`clicks`	NUMERIC	Métrica	Number of unique e-mail clicks
`conversions`	NUMERIC	Métrica	Total Value of placed orders
`conversions_avg_value`	PERCENT	Métrica	Average value of placed orders
`dimensions`	TEXT	Dimensão	Flow dimensions
`failed_to_deliver_sms`	NUMERIC	Métrica	Number of SMS messages that failed to deliver
`fulfilled_order`	NUMERIC	Métrica	Total amount of Fulfilled Order
`fulfilled_order_value`	NUMERIC	Métrica	Fulfilled Order value
`fulfilled_partial_order`	NUMERIC	Métrica	Total amount of Fulfilled Partial Order
`fulfilled_partial_order_value`	NUMERIC	Métrica	Fulfilled Order value
`open_rate`	PERCENT	Métrica	Open rate of E-mails
`opens`	NUMERIC	Métrica	Number of unique e-mail opens
`ordered_product`	NUMERIC	Métrica	Total amount of Ordered product
`ordered_product_avg_value`	PERCENT	Métrica	Ordered product average value
`ordered_product_value`	NUMERIC	Métrica	Ordered product value
`received_emails`	NUMERIC	Métrica	Number of e-mails received
`received_sms`	NUMERIC	Métrica	Number of unique SMS messages received
`refunded_order`	NUMERIC	Métrica	Total amount of Refunded Order
`refunded_order_value`	NUMERIC	Métrica	Refunded Order value
`revenue`	NUMERIC	Métrica	Total Value of placed orders
`revenue_per_recipient`	NUMERIC	Métrica	The amount of revenue attributed to a campaign divided by the number of recipients
`sent_emails`	NUMERIC	Métrica	The number of recipients the email was sent to
`sent_sms`	NUMERIC	Métrica	Number of SMS messages sent
`shopify_cancelled_order`	NUMERIC	Métrica	This event is tracked when a customer creates an order in your Shopify store but then cancels the order before fulfillment
`shopify_checkout_started`	NUMERIC	Métrica	Shopify checkout completed
`shopify_confirmed_shipment`	NUMERIC	Métrica	Shopify Confirmed Shipment
`shopify_delivered_shipment`	NUMERIC	Métrica	Shopify Delivered Shipment
`shopify_fulfilled_order`	NUMERIC	Métrica	This event is tracked when an order is marked as 'fulfilled' in your Shopify store
`shopify_fulfilled_partial_order`	NUMERIC	Métrica	This event is tracked when an order is marked as 'fulfilled' in your Shopify store
`shopify_marked_out_for_delivery`	NUMERIC	Métrica	Shopify Marked Out for Delivery
`shopify_ordered_product`	NUMERIC	Métrica	The total quantity ordered of the product
`shopify_placed_order`	NUMERIC	Métrica	This event is tracked when a customer completes the checkout process and creates an order in your Shopify store
`shopify_refunded_order`	NUMERIC	Métrica	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_revenue`	NUMERIC	Métrica	Revenue value from Shopify Placed Order events.
`sms_click_rate`	PERCENT	Métrica	Unique SMS clicks divided by SMS received
`sms_unsubscribes`	NUMERIC	Métrica	Number of SMS marketing unsubscribes
`subscribed`	NUMERIC	Métrica	Subscribed to List
`total_clicked_sms`	NUMERIC	Métrica	Total number of SMS clicks
`total_clicks`	NUMERIC	Métrica	Total number of e-mail clicks
`total_conversions`	NUMERIC	Métrica	Total amount of placed orders
`total_opens`	NUMERIC	Métrica	Total number of e-mail opens
`unsubscribed`	NUMERIC	Métrica	Unsubscribed from list
`unsubscribed_from_list`	NUMERIC	Métrica	Unsubscribed from list
`unsubscribed_rate`	NUMERIC	Métrica	Unsubscribed from list Rate
`unsubscribed_rate_from_list`	NUMERIC	Métrica	Unsubscribed from list Rate
`viewed_product`	NUMERIC	Métrica	Total number of Viewed Product events
`campaign_report_conversion_metric_active_on_site`	TEXT	Dimensão	Campaign Report Conversion Metric Active on Site
`campaign_report_conversion_metric_bounced_email`	TEXT	Dimensão	Campaign Report Conversion Metric Bounced Email
`campaign_report_conversion_metric_clicked_email`	TEXT	Dimensão	Campaign Report Conversion Metric Clicked Email
`campaign_report_conversion_metric_clicked_sms`	TEXT	Dimensão	Campaign Report Conversion Metric Clicked SMS
`campaign_report_conversion_metric_dropped_email`	TEXT	Dimensão	Campaign Report Conversion Metric Dropped Email
`campaign_report_conversion_metric_failed_to_deliver_sms`	TEXT	Dimensão	Campaign Report Conversion Metric Failed to Deliver SMS
`campaign_report_conversion_metric_marked_email_as_spam`	TEXT	Dimensão	Campaign Report Conversion Metric Marked Email as Spam
`campaign_report_conversion_metric_opened_email`	TEXT	Dimensão	Campaign Report Conversion Metric Opened Email
`campaign_report_conversion_metric_received_email`	TEXT	Dimensão	Campaign Report Conversion Metric Received Email
`campaign_report_conversion_metric_sent_sms`	TEXT	Dimensão	Campaign Report Conversion Metric Sent SMS
`campaign_report_conversion_metric_subscribed_to_list`	TEXT	Dimensão	Campaign Report Conversion Metric Subscribed to List
`campaign_report_conversion_metric_unsubscribe_page_submit`	TEXT	Dimensão	Campaign Report Conversion Metric Unsubscribe Page Submit
`campaign_report_conversion_metric_unsubscribed`	TEXT	Dimensão	Campaign Report Conversion Metric Unsubscribed
`campaign_report_conversion_metric_unsubscribed_from_list`	TEXT	Dimensão	Campaign Report Conversion Metric Unsubscribed from List
`data_fetched_at`	TIMESTAMP	Dimensão	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
`datasource`	TEXT	Dimensão	The name of the Windsor connector returning the row
`day_of_month`	TEXT	Dimensão	Day of the month
`flow_conversion_metric_active_on_site`	TEXT	Dimensão	Active on Site - to be used for conversion metrics in flows stats
`flow_conversion_metric_bounced_email`	TEXT	Dimensão	Bounced Email - to be used for conversion metrics in flows stats
`flow_conversion_metric_clicked_email`	TEXT	Dimensão	Clicked Email - to be used for conversion metrics in flows stats
`flow_conversion_metric_clicked_sms`	TEXT	Dimensão	Clicked SMS - to be used for conversion metrics in flows stats
`flow_conversion_metric_opened_email`	TEXT	Dimensão	Opened Email - to be used for conversion metrics in flows stats
`flow_conversion_metric_received_sms`	TEXT	Dimensão	Received SMS - to be used for conversion metrics in flows stats
`flow_conversion_metric_sent_sms`	TEXT	Dimensão	Sent SMS - to be used for conversion metrics in flows stats
`flow_conversion_metric_subscribed_to_list`	TEXT	Dimensão	Subscribed to List - to be used for conversion metrics in flows stats
`flow_conversion_metric_unsubscribed`	TEXT	Dimensão	Unsubscribed - to be used for conversion metrics in flows stats
`month`	TEXT	Dimensão	Number of the month
`now`	TIMESTAMP	Dimensão	Current timestamp
`source`	TEXT	Dimensão	The name of the Windsor connector returning the row
`today`	DATE	Dimensão	Today's date
`week`	TEXT	Dimensão	Week (Sun-Sat).
`week_day`	TEXT	Dimensão	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
`week_day_iso`	TEXT	Dimensão	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
`week_iso`	TEXT	Dimensão	Week, ISO format (Mon-Sun).
`year`	TEXT	Dimensão	Year
`year_month`	TEXT	Dimensão	Year and month, e.g. 2024\|3
`year_month_name`	TEXT	Dimensão	Year and month with the month name written out, e.g. "Jan 2025".
`year_of_week`	TEXT	Dimensão	The year that contains first day of the week (Sun-Sat).
`year_of_week_iso`	TEXT	Dimensão	The year that contains first day of the ISO week (Mon-Sun).
`year_week`	TEXT	Dimensão	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
`year_week_iso`	TEXT	Dimensão	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20