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 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.

TitleIDTypeDescription
Ad Set Bid Amount Changed Fromadset_bid_amount_changed_fromnumericThe 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 Toadset_bid_amount_changed_tonumericThe 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 Fromadset_daily_budget_changed_fromnumericThe 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 Toadset_daily_budget_changed_tonumericThe 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 Fromadset_target_roas_changed_fromnumericThe 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 Toadset_target_roas_changed_tonumericThe updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency.
Campaign Bid Amount Changed Fromcampaign_bid_amount_changed_fromnumericThe 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 Tocampaign_bid_amount_changed_tonumericThe 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 Fromcampaign_daily_budget_changed_fromnumericThe 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 Tocampaign_daily_budget_changed_tonumericThe 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 Fromcampaign_lifetime_budget_changed_fromnumericThe 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 Tocampaign_lifetime_budget_changed_tonumericThe 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 Fromcampaign_target_roas_changed_fromnumericThe previous target ROAS for the campaign, before the most recent change. By default shown in the shop's currency.
Campaign Target ROAS Changed Tocampaign_target_roas_changed_tonumericThe updated target ROAS for the campaign, after the most recent change. By default shown in the shop's currency.
Variant Price Changed Fromvariant_price_changed_fromnumericThe previous price of the product variant, before the most recent change. By default shown in the shop's currency.
Variant Price Changed Tovariant_price_changed_tonumericThe updated price of the product variant, after the most recent change. By default shown in the shop's currency.