Campaigns

The campaigns model represents the Thanx marketing campaigns. This model contains basic configuration information as well as aggregated campaign result data.

SFTP Exports

Sample campaigns.csv

Thanx Connex

Table name: campaigns

Attributes

Column	Data Type	Description
`campaign_id`	`string`	The unique identifier of the campaign in Thanx.
`merchant_id`	`string`	The unique identifier of the merchant in Thanx.
`name`	`string`	The name of the campaign. This is defined by the merchant.
`start_earn_at`	`timestamp`	The date and time the campaign can start engaging customers. This is in UTC.
`end_earn_at`	`timestamp`	The date and time the campaign will stop engaging customers. This is in UTC.
`start_redeem_at`	`timestamp`	The date and time the reward starts being redeemable. This is in UTC.
`end_redeem_at`	`timestamp`	The date and time the reward stops being redeemable. This is in UTC.
`net_revenue`	`number`	The net revenue was generated from customers who received the campaign and made a purchase in the following 14 days.
`unique_sent_email_users`	`number`	The number of users that were sent an email.
`unique_delivered_email_users`	`number`	The number of users that were successfully delivered an email.
`unique_clicked_email_users`	`number`	The number of users that clicked a link in the email.
`unique_opened_email_users`	`number`	The number of users that opened the email.
`unique_sent_push_users`	`number`	The number of users that were sent a push notification.
`unique_delivered_push_users`	`number`	The number of users that were successfully delivered a push notification.
`unique_sent_sms_users`	`number`	The number of users that were sent an SMS. (Deprecated)
`unique_delivered_sms_users`	`number`	The number of users that were successfully delivered an SMS. (Deprecated)
`unique_sent_email_variant_a_users`	`number`	The number of users that were sent an email for Variant A of the campaign.
`unique_delivered_email_variant_a_users`	`number`	The number of users that were successfully delivered an email for Variant A of the campaign.
`unique_clicked_email_variant_a_users`	`number`	The number of users that clicked a link in the email for Variant A of the campaign.
`unique_opened_email_variant_a_users`	`number`	The number of users that opened the email for Variant A of the campaign.
`unique_sent_email_variant_b_users`	`number`	The number of users that were sent an email for Variant B of the campaign.
`unique_delivered_email_variant_b_users`	`number`	The number of users that were successfully delivered an email for Variant B of the campaign.
`unique_clicked_email_variant_b_users`	`number`	The number of users that clicked a link in the email for Variant B of the campaign.
`unique_opened_email_variant_b_users`	`number`	The number of users that opened the email for Variant B of the campaign.
`unique_sent_email_variant_c_users`	`number`	The number of users that were sent an email for Variant C of the campaign.
`unique_delivered_email_variant_c_users`	`number`	The number of users that were successfully delivered an email for Variant C of the campaign.
`unique_clicked_email_variant_c_users`	`number`	The number of users that clicked a link in the email for Variant C of the campaign.
`unique_opened_email_variant_c_users`	`number`	The number of users that opened the email for Variant C of the campaign.
`unique_sent_email_variant_d_users`	`number`	The number of users that were sent an email for Variant D of the campaign.
`unique_delivered_email_variant_d_users`	`number`	The number of users that were successfully delivered an email for Variant D of the campaign.
`unique_clicked_email_variant_d_users`	`number`	The number of users that clicked a link in the email for Variant D of the campaign.
`unique_opened_email_variant_d_users`	`number`	The number of users that opened the email for Variant D of the campaign.
`unique_sent_push_variant_a_users`	`number`	The number of users that were sent a push notification for Variant A of the campaign.
`unique_delivered_push_variant_a_users`	`number`	The number of users that were successfully delivered a push notification for Variant A of the campaign.
`unique_sent_push_variant_b_users`	`number`	The number of users that were sent a push notification for Variant B of the campaign.
`unique_delivered_push_variant_b_users`	`number`	The number of users that were successfully delivered a push notification for Variant B of the campaign.
`unique_sent_push_variant_c_users`	`number`	The number of users that were sent a push notification for Variant C of the campaign.
`unique_delivered_push_variant_c_users`	`number`	The number of users that were successfully delivered a push notification for Variant C of the campaign.
`unique_sent_push_variant_d_users`	`number`	The number of users that were sent a push notification for Variant D of the campaign.
`unique_delivered_push_variant_d_users`	`number`	The number of users that were successfully delivered a push notification for Variant D of the campaign.
`unique_sent_sms_variant_a_users`	`number`	The number of users that were sent an SMS for Variant A of the campaign.
`unique_delivered_sms_variant_a_users`	`number`	The number of users that were successfully delivered an SMS for Variant A of the campaign.
`unique_sent_sms_variant_b_users`	`number`	The number of users that were sent an SMS for Variant B of the campaign.
`unique_delivered_sms_variant_b_users`	`number`	The number of users that were successfully delivered an SMS for Variant B of the campaign.
`unique_sent_sms_variant_c_users`	`number`	The number of users that were sent an SMS for Variant C of the campaign.
`unique_delivered_sms_variant_c_users`	`number`	The number of users that were successfully delivered an SMS for Variant C of the campaign.
`unique_sent_sms_variant_d_users`	`number`	The number of users that were sent an SMS for Variant D of the campaign.
`unique_delivered_sms_variant_d_users`	`number`	The number of users that were successfully delivered an SMS for Variant D of the campaign.
`unique_sent_variant_a_users`	`number`	The number of users that were sent any communication (email, push, and/or SMS) for Variant A of the campaign.
`unique_delivered_variant_a_users`	`number`	The number of users that successfully received any communication (email, push, and/or SMS) for Variant A of the campaign.
`unique_sent_variant_b_users`	`number`	The number of users that were sent any communication (email, push, and/or SMS) for Variant B of the campaign.
`unique_delivered_variant_b_users`	`number`	The number of users that successfully received any communication (email, push, and/or SMS) for Variant B of the campaign.
`unique_sent_variant_c_users`	`number`	The number of users that were sent any communication (email, push, and/or SMS) for Variant C of the campaign.
`unique_delivered_variant_c_users`	`number`	The number of users that successfully received any communication (email, push, and/or SMS) for Variant C of the campaign.
`unique_sent_variant_d_users`	`number`	The number of users that were sent any communication (email, push, and/or SMS) for Variant D of the campaign.
`unique_delivered_variant_d_users`	`number`	The number of users that successfully received any communication (email, push, and/or SMS) for Variant D of the campaign.
`unique_sent_users`	`number`	The number of users that were sent any communication (email, push, and/or SMS).
`unique_delivered_users`	`number`	The number of users that successfully received any communication (email, push, and/or SMS).

Data Exports

Snowflake Data Sharing

Thanx Connex

Models

SFTP Exports

Thanx Connex

Attributes

SFTP Exports

Thanx Connex

​Attributes

Attributes