Activities Table (BETA)

activities_table

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 time zone of the shop at the moment of the event.
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.

Updated 16 days ago