Activities Table

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.

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

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

Unique identifier for the activity log entry.

Example value: 23844267499760291

Entity Name

entity_name

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