The Activities table logs user- and system-generated changes to campaigns, ad sets, ads, integrations, surveys, annotations, and product variants. Querying this table helps surface what changed, when, and how, offering a clear view into operational activities, configuration changes, and historical edits that may impact performance or attribution.

📘
Note
event_date is a required field for queries on this table.

Dimensions

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

Title	ID	Type	Description
Event Date	`event_date`	date	The date the activity occurred. Based on the shop time zone at the moment of the event (or the user time zone, if no sales platform is connected).
Event Day	`event_date.day`	date	The day the event occurred. Derived from `event_date`.
Event Week	`event_date.week`	date	The Sunday of the week during which the event occurred. Derived from `event_date`.
Event Month	`event_date.month`	date	The month during which the event occurred. Derived from `event_date`.
Event Quarter	`event_date.quarter`	date	The first month of the quarter during which the event occurred. Derived from `event_date`.
Event Year	`event_date.year`	date	The year during which the event occurred. Derived from `event_date`.
Ad Changed Name From	`ad_changed_name_from`	string	The previous name of the ad before it was updated. Example value: `Spring Campaign A`
Ad Changed Name To	`ad_changed_name_to`	string	The updated name of the ad. Example value: `Spring Campaign A v2`
Ad Created	`ad_created`	boolean	Indicates whether a new ad was created. Possible values: `true`, `false`
Ad Status Changed From	`ad_status_changed_from`	string	The prior status of the ad before the change. Example values: `PAUSED`, `ACTIVE`, `IN_PROCESS`, `PENDING_REVIEW`
Ad Status Changed To	`ad_status_changed_to`	string	The new status of the ad. Example values: `PAUSED`, `ACTIVE`, `IN_PROCESS`, `PENDING_REVIEW`
Ad Set Changed Name From	`adset_changed_name_from`	string	The previous name of the ad set. Example values: `Interest - Teens`
Ad Set Changed Name To	`adset_changed_name_to`	string	The updated name of the ad set. Example: `Interest - Teen Girls`
Ad Set Created	`adset_created`	boolean	Indicates whether a new ad set was created. Possible values: `true`, `false`
Ad Set Status Changed From	`adset_status_changed_from`	string	The prior status of the ad set before the change. Example values: `PAUSED`, `ACTIVE`, `IN_PROCESS`
Ad Set Status Changed To	`adset_status_changed_to`	string	The updated status of the ad set. Example values: `PAUSED`, `ACTIVE`, `IN_PROCESS`
Annotation Author	`annotation_author`	string	The user who created the annotation.
Annotation Description	`annotation_description`	string	The message content of the annotation.
Annotation Title	`annotation_title`	string	The title of the annotation.
Campaign Changed Name From	`campaign_changed_name_from`	string	The prior campaign name. Example value: `June Evergreen`
Campaign Changed Name To	`campaign_changed_name_to`	string	The updated campaign name. Example value: `June Evergreen V2`
Campaign Created	`campaign_created`	boolean	Indicates whether a new campaign was created. Possible values: `true`, `false`
Campaign Status Changed From	`campaign_status_changed_from`	string	The prior status of the campaign. Example values: `Draft`, `ACTIVE`, `Sending`, `IN_PROCESS`, `Queued without Recipients`
Campaign Status Changed To	`campaign_status_changed_to`	string	The new status of the campaign. Example values: `Draft`, `ACTIVE`, `Sending`, `IN_PROCESS`, `Queued without Recipients`
CDP Sync to Facebook Status	`cdp_segment_sync_to_facebook_status`	string	The result of syncing the CDP segment to Facebook. Example values: `disconnect_sync_to_facebook`, `sync_to_facebook`
CDP Sync to Klaviyo Status	`cdp_segment_sync_to_klaviyo_status`	string	The result of syncing the CDP segment to Klaviyo. Example values: `disconnect_sync_to_klaviyo`, `sync_to_klaviyo`
Created At	`created_at`	timestamp	The timestamp when the activity occurred. Example: `2025-05-28 17:17:34`
Created CDP Segment	`created_cdp_segment`	boolean	Indicates whether a CDP segment was created. Possible values: `true`, `false`
Created Survey Description	`created_post_purchase_survey_description`	string	A message indicating that a post-purchase survey was created. Example value: `Post Purchase Survey Created`
Deleted Survey Description	`deleted_post_purchase_survey_description`	string	A message indicating that a post-purchase survey was deleted. Example value: `Post Purchase Survey Deleted`
Activity ID	`id`	string	Unique identifier for the activity log entry. Example: `23844267499760291`
Integration ID	`integration_id`	string	The unique ID of the integration involved in the activity.
Activity Name	`name`	string	Name of the activity.
Provider Account	`provider_account`	string	The platform account associated with the activity.
Provider ID	`provider_id`	string	The platform or channel that the activity occurred in. Example values: `facebook-ads`, `shopify`, `triple-whale`
Updated Integration Description	`updated_integration_description`	string	A message indicating that an integration was updated. Example value: `Facebook Ads Disconnected`
Updated Integration Source	`updated_integration_source`	string	The integration source that was updated. Example value: `facebook-ads`
Updated Integration Title	`updated_integration_title`	string	The title of the message indicating that an integration was updated. Example: `Integrations Updated`
Updated New User Description	`updated_new_user_description`	string	A message indicating that a user was updated.
Updated Survey Description	`updated_post_purchase_survey_description`	string	A message indicating that a post-purchase survey was updated. Example value: `Post Purchase Survey Updated`
Variant Stock Status	`variant_stock_status`	string	The inventory status of a product variant. Example values: `out of stock`, `back in stock`

Measures

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

Title	ID	Type	Description
Ad Set Bid Amount Changed From	`adset_bid_amount_changed_from`	numeric	The previous bid amount (in cents) for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Bid Amount Changed To	`adset_bid_amount_changed_to`	numeric	The updated bid amount (in cents) for the ad set, after the most recent change. By default shown in the shop's currency.
Ad Set Daily Budget Changed From	`adset_daily_budget_changed_from`	numeric	The previous daily budget (in cents) set for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Daily Budget Changed To	`adset_daily_budget_changed_to`	numeric	The updated daily budget (in cents) set for the ad set, after the most recent change. By default shown in the shop's currency.
Ad Set Target ROAS Changed From	`adset_target_roas_changed_from`	numeric	The previous target ROAS for the ad set, before the most recent change. By default shown in the shop's currency.
Ad Set Target ROAS Changed To	`adset_target_roas_changed_to`	numeric	The updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency.
Campaign Bid Amount Changed From	`campaign_bid_amount_changed_from`	numeric	The previous bid amount (in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Bid Amount Changed To	`campaign_bid_amount_changed_to`	numeric	The updated bid amount (in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Daily Budget Changed From	`campaign_daily_budget_changed_from`	numeric	The previous daily budget in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Daily Budget Changed To	`campaign_daily_budget_changed_to`	numeric	The updated daily budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Lifetime Budget Changed From	`campaign_lifetime_budget_changed_from`	numeric	The previous lifetime budget in cents) for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Lifetime Budget Changed To	`campaign_lifetime_budget_changed_to`	numeric	The updated lifetime budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Target ROAS Changed From	`campaign_target_roas_changed_from`	numeric	The previous target ROAS for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Target ROAS Changed To	`campaign_target_roas_changed_to`	numeric	The updated target ROAS for the campaign, after the most recent change. By default shown in the shop's currency.
Variant Price Changed From	`variant_price_changed_from`	numeric	The previous price of the product variant, before the most recent change. By default shown in the shop's currency.
Variant Price Changed To	`variant_price_changed_to`	numeric	The updated price of the product variant, after the most recent change. By default shown in the shop's currency.