Activities Table

The Activities table logs user- and system-generated operational changes, such as campaign, ad set, ad, integration, and annotation changes. One row per deduplicated activity or change event.

📋

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

Key Relationships

TableJoin KeyUse This Join To
Adsentity_id to campaign_id, adset_id, or ad_idAnalyze whether campaign, ad set, or ad changes affected results

View the full Triple Whale Data Ontology →


Dimensions

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

TitleIDTypeDescription
Event Dateevent_datedateThe 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 Dayevent_date.daydateThe day the event occurred. Derived from event_date.
Event Weekevent_date.weekdateThe Sunday of the week during which the event occurred. Derived from event_date.
Event Monthevent_date.monthdateThe month during which the event occurred. Derived from event_date.
Event Quarterevent_date.quarterdateThe first month of the quarter during which the event occurred. Derived from event_date.
Event Yearevent_date.yeardateThe year during which the event occurred. Derived from event_date.
Account IDaccount_idstring

The unique ID for the platform or channel account associated with the activity.

Example values: act_2168791943307744, 18ce55770zl, 1986494684391480

Action Sourceaction_sourcestring

The source or interface from which the action was initiated.

Example values: Moby

Ad Changed Name Fromad_changed_name_fromstring

The previous name of the ad before it was updated.

Example value: Spring Campaign A

Ad Changed Name Toad_changed_name_tostring

The updated name of the ad.

Example value: Spring Campaign A v2

Ad Createdad_createdboolean

Indicates whether a new ad was created.

Possible values: true, false

Ad Status Changed Fromad_status_changed_fromstring

The prior status of the ad before the change.

Example values: PAUSED, ACTIVE, IN_PROCESS, PENDING_REVIEW

Ad Status Changed Toad_status_changed_tostring

The new status of the ad.

Example values: PAUSED, ACTIVE, IN_PROCESS, PENDING_REVIEW

Ad Set Bid Amount Changed Fromadset_bid_amount_changed_fromstringThe 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_tostringThe 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 Fromadset_changed_name_fromstring

The previous name of the ad set.

Example values: Interest - Teens

Ad Set Changed Name Toadset_changed_name_tostring

The updated name of the ad set.

Example: Interest - Teen Girls

Ad Set Createdadset_createdboolean

Indicates whether a new ad set was created.

Possible values: true, false

Ad Set Daily Budget Changed Fromadset_daily_budget_changed_fromstringThe 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_tostringThe 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 Fromadset_status_changed_fromstring

The prior status of the ad set before the change.

Example values: PAUSED, ACTIVE, IN_PROCESS

Ad Set Status Changed Toadset_status_changed_tostring

The updated status of the ad set.

Example values: PAUSED, ACTIVE, IN_PROCESS

Ad Set Target ROAS Changed Fromadset_target_roas_changed_fromstringThe 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_tostringThe updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency.
Annotation Authorannotation_authorstringThe user who created the annotation.
Annotation Descriptionannotation_descriptionstringThe message content of the annotation.
Annotation Titleannotation_titlestringThe title of the annotation.
Campaign Bid Amount Changed Fromcampaign_bid_amount_changed_fromstringThe 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_tostringThe updated bid amount (in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Changed Name Fromcampaign_changed_name_fromstring

The prior campaign name.

Example value: June Evergreen

Campaign Changed Name Tocampaign_changed_name_tostring

The updated campaign name.

Example value: June Evergreen V2

Campaign Createdcampaign_createdboolean

Indicates whether a new campaign was created.

Possible values: true, false

Campaign Daily Budget Changed Fromcampaign_daily_budget_changed_fromstringThe 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_tostringThe 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_fromstringThe 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_tostringThe updated lifetime budget in cents) for the campaign, after the most recent change. By default shown in the shop's currency.
Campaign Status Changed Fromcampaign_status_changed_fromstring

The prior status of the campaign.

Example values: Draft, ACTIVE, Sending, IN_PROCESS, Queued without Recipients

Campaign Status Changed Tocampaign_status_changed_tostring

The new status of the campaign.

Example values: Draft, ACTIVE, Sending, IN_PROCESS, Queued without Recipients

Campaign Target ROAS Changed Fromcampaign_target_roas_changed_fromstringThe 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_tostringThe updated target ROAS for the campaign, after the most recent change. By default shown in the shop's currency.
CDP Sync to Facebook Statuscdp_segment_sync_to_facebook_statusstring

The result of syncing the CDP segment to Facebook.

Example values: disconnect_sync_to_facebook, sync_to_facebook

CDP Sync to Klaviyo Statuscdp_segment_sync_to_klaviyo_statusstring

The result of syncing the CDP segment to Klaviyo.

Example values: disconnect_sync_to_klaviyo, sync_to_klaviyo

Channelchannelstring

The platform or channel that the activity occurred in.

Example values: facebook-ads, shopify, triple-whale

Created Atcreated_attimestamp

The timestamp when the activity occurred.

Example: 2025-05-28 17:17:34

Created CDP Segmentcreated_cdp_segmentboolean

Indicates whether a CDP segment was created.

Possible values: true, false

Created Survey Descriptioncreated_post_purchase_survey_descriptionstring

A message indicating that a post-purchase survey was created.

Example value: Post Purchase Survey Created

Deleted Survey Descriptiondeleted_post_purchase_survey_descriptionstring

A message indicating that a post-purchase survey was deleted.

Example value: Post Purchase Survey Deleted

Entity Typeentitysting

The type of entity that the activity occurred on.

Example values: adset, ad, campaign, variant, cdp_segment

Entity IDentity_idstring

Unique identifier for the activity log entry.

Example value: 23844267499760291

Entity Nameentity_namestring

Name of the entity that the activity occurred on.

Example values: Natural Woven Bundle, Meta Monday, BFCM Lost

Shop IDshop_idstring

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 Nameshop_namestring

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 Descriptionupdated_integration_descriptionstring

A message indicating that an integration was updated.

Example value: Facebook Ads Disconnected

Updated Integration Sourceupdated_integration_sourcestring

The integration source that was updated.

Example value: facebook-ads

Updated Integration Titleupdated_integration_titlestring

The title of the message indicating that an integration was updated.

Example: Integrations Updated

Updated New User Descriptionupdated_new_user_descriptionstringA message indicating that a user was updated.
Updated Survey Descriptionupdated_post_purchase_survey_descriptionstring

A message indicating that a post-purchase survey was updated.

Example value: Post Purchase Survey Updated

Variant Price Changed Fromvariant_price_changed_fromstringThe 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_tostringThe updated price of the product variant, after the most recent change. By default shown in the shop's currency.
Variant Stock Statusvariant_stock_statusstring

The inventory status of a product variant.

Example values: out of stock, back in stock