Activities

activities_table

The Activities table tracks key changes and actions related to ad campaigns, customer interactions, and data integrations. Querying this table helps users analyze activity trends over time, compare changes to campaign elements, and assess the impact of adjustments on customer behavior and business outcomes.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

ID	Type	Description
event_date	date	The date the activity event occurred. Based on the time zone of the shop at the moment of the activity event.
event_date.day	date	The day of the activity event. Derived from event_date.
event_date.week	date	The Sunday of the week during which the activity event occurred. Derived from event_date.
event_date.month	date	The month during which the activity event occurred. Derived from event_date.
event_date.quarter	date	The first month of the quarter during which the activity event occurred. Derived from event_date.
event_date.year	date	The year during which the activity event occurred. Derived from event_date.
ad_changed_name_from	string	The original name of the ad before a change occurred.
ad_changed_name_to	string	The new name of the ad after a change occurred.
ad_created	boolean	Indicates if a new ad was created.
ad_status_changed_from	string	The original status of the ad before a change occurred.
ad_status_changed_to	string	The new status of the ad after a change occurred.
adset_changed_name_from	string	The original name of the ad set before a change occurred.
adset_changed_name_to	string	The new name of the ad set after a change occurred.
adset_created	boolean	Indicates if a new ad set was created.
adset_status_changed_from	string	The original status of the ad set before a change occurred.
adset_status_changed_to	string	The new status of the ad set after a change occurred.
annotation_author	string	The author who made the annotation in the system.
annotation_description	string	A description of the annotation added.
annotation_title	string	The title of the annotation made in the system.
campaign_changed_name_from	string	The original name of the campaign before a change occurred.
campaign_changed_name_to	string	The new name of the campaign after a change occurred.
campaign_created	boolean	Indicates if a new campaign was created.
campaign_status_changed_from	string	The original status of the campaign before a change occurred.
campaign_status_changed_to	string	The new status of the campaign after a change occurred.
cdp_segment_sync_to_facebook_status	string	The status of a CDP segment synced to Facebook.
cdp_segment_sync_to_klaviyo_status	string	The status of a CDP segment synced to Klaviyo.
created_at	timestamp	The timestamp when the event or activity was created.
created_cdp_segment	boolean	Indicates if a new CDP segment was created.
created_post_purchase_survey_description	string	The description of a newly created post-purchase survey.
deleted_post_purchase_survey_description	string	The description of a deleted post-purchase survey.
id	string	The unique identifier for the event or activity.
integration_id	string	The unique identifier for the data integration.
name	string	The name associated with the event or activity.
provider_account	string	The account related to the service provider involved in the event.
provider_id	string	The unique identifier of the service provider involved in the event.
updated_integration_description	string	The updated description of a data integration.
updated_integration_source	string	The updated source of a data integration.
updated_integration_title	string	The updated title of a data integration.
updated_new_user_description	string	The updated description of a new user added to the system.
updated_post_purchase_survey_description	string	The updated description of a post-purchase survey.
variant_stock_status	string	The stock status of a product variant involved in the event.

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

ID	Type	Description
adset_bid_amount_changed_from	numeric	The original bid amount for an ad set before a change.
adset_bid_amount_changed_to	numeric	The new bid amount for an ad set after a change.
adset_daily_budget_changed_from	numeric	The original daily budget for an ad set before a change.
adset_daily_budget_changed_to	numeric	The new daily budget for an ad set after a change.
campaign_bid_amount_changed_from	numeric	The original bid amount for a campaign before a change.
campaign_bid_amount_changed_to	numeric	The new bid amount for a campaign after a change.
campaign_daily_budget_changed_from	numeric	The original daily budget for a campaign before a change.
campaign_daily_budget_changed_to	numeric	The new daily budget for a campaign after a change.
campaign_lifetime_budget_changed_from	numeric	The original lifetime budget for a campaign before a change.
campaign_lifetime_budget_changed_to	numeric	The new lifetime budget for a campaign after a change.
variant_price_changed_from	numeric	The original price of a product variant before a change.
variant_price_changed_to	numeric	The new price of a product variant after a change.