Yotpo SMS&Email Analytics: Most-used fields

The table below gives information about most-used fields that you can import from Yotpo SMS&Email Analytics. Other fields might also be available in Adverity.

The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.

API name	Adverity UI name	Description	Use in Adverity
all_clicks	all_clicks	The total number of clicks on links within SMS and email messages.	metric
all_orders	all_orders	The total number of orders attributed to SMS and email campaigns or flows.	metric
all_revenue	all_revenue	The total revenue generated from orders attributed to SMS and email campaigns or flows.	metric
all_sent	all_sent	The total number of SMS and email messages that were successfully sent.	metric
all_spent	all_spent	The total spend on messages sent via Yotpo SMS & Email.	metric
all_x_roi	all_x_roi	Represents the Return on Investment (ROI) across all SMS and email marketing activities. This metric indicates the profitability or efficiency of campaigns and flows by comparing the total revenue generated (all_revenue) against the total expenditure (all_spent).	metric
arrived_at_hour	arrived_at_hour	The specific hour (in UTC) when the data aggregation occurred or the marketing message was executed.	dimension
arrived_at_hour_date	arrived_at_hour_date	The specific date when the data aggregation occurred or the marketing message was executed.	dimension
average_order_value	average_order_value	The average value of orders attributed to SMS and email campaigns or flows.	metric
click_through_rate	click_through_rate	The percentage of unique clicks out of all delivered SMS and email messages.	metric
source_id	source_id	A unique identifier for the specific campaign, flow, or automation that generated the data.	dimension
source_name	source_name	The name of the campaign, flow, or automation that generated the data.	dimension
source_type	source_type	The type of marketing source, such as ‘campaign’ or ‘flow’, which generated the data.	dimension
unsubscribe_rate	unsubscribe_rate	The percentage of total unsubscribe events out of all delivered SMS and email messages.	metric