The Activities table logs user- and system-generated operational changes. One row per deduplicated activity or change event affecting campaigns, ad sets, ads, integrations, surveys, annotations, CDP segments, users, or product variants.

📋
Table Guide
What You Can Answer With This Table

What campaign, ad set, or ad settings changed during a period? — use entity, entity_name, created_at

Which changes were initiated through Moby or automation? — use action_source, entity, event_date

Which integrations, surveys, annotations, CDP segments, users, or product variants changed? — use entity, updated_integration_description, variant_stock_status

Before You Query

Required field: event_date

Consecutive duplicate activity rows are collapsed in the query layer, so this table is best for the deduplicated change history users see in Triple Whale, not for auditing every raw provider fetch row.

action_source identifies whether a change came from Moby, AmbAuto, Triple Whale, or the provider when that source is available.

Key Relationships

Table Join Key What the Join Enables
Ads entity_id to campaign_id, adset_id, or ad_id Ad-platform performance for the campaign, ad set, or ad that changed

When to Use a Different Table

Need ad-platform performance metrics instead of change history → Ads table. Ads has spend, clicks, impressions, and channel-reported conversion metrics; Activities records operational changes to entities and settings.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Ads	`entity_id` to `campaign_id`, `adset_id`, or `ad_id`	Ad-platform performance for the campaign, ad set, or ad that changed

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`.
Account ID	`account_id`	string	The unique ID for the platform or channel account associated with the activity. Example values: `act_2168791943307744`, `18ce55770zl`, `1986494684391480`
Action Source	`action_source`	string	The source or interface from which the action was initiated. Example values: `Moby`
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 Bid Amount Changed From	`adset_bid_amount_changed_from`	string	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`	string	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 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 Daily Budget Changed From	`adset_daily_budget_changed_from`	string	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`	string	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 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`
Ad Set Target ROAS Changed From	`adset_target_roas_changed_from`	string	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`	string	The updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency.
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 Bid Amount Changed From	`campaign_bid_amount_changed_from`	string	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`	string	The updated bid amount (in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
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 Daily Budget Changed From	`campaign_daily_budget_changed_from`	string	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`	string	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`	string	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`	string	The updated lifetime budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
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`
Campaign Target ROAS Changed From	`campaign_target_roas_changed_from`	string	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`	string	The updated target ROAS for the campaign, after the most recent change. By default shown in the shop's currency.
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`
Channel	`channel`	string	The platform or channel that the activity occurred in. Example values: `facebook-ads`, `shopify`, `triple-whale`
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`
Entity Type	`entity`	sting	The type of entity that the activity occurred on. Example values: `adset`, `ad`, `campaign`, `variant`, `cdp_segment`
Entity ID	`entity_id`	string	Unique identifier for the activity log entry. Example value: `23844267499760291`
Entity Name	`entity_name`	string	Name of the entity that the activity occurred on. Example values: `Natural Woven Bundle`, `Meta Monday`, `BFCM Lost`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
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 Price Changed From	`variant_price_changed_from`	string	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`	string	The updated price of the product variant, after the most recent change. By default shown in the shop's currency.
Variant Stock Status	`variant_stock_status`	string	The inventory status of a product variant. Example values: `out of stock`, `back in stock`