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 GuideWhat 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_statusBefore You Query
- Required field:
event_dateKey Relationships
Table Join Key Use This Join To Ads entity_idtocampaign_id,adset_id, orad_idAnalyze whether campaign, ad set, or ad changes affected results
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: |
| Action Source | action_source | string | The source or interface from which the action was initiated. Example values: |
| Ad Changed Name From | ad_changed_name_from | string | The previous name of the ad before it was updated. Example value: |
| Ad Changed Name To | ad_changed_name_to | string | The updated name of the ad. Example value: |
| Ad Created | ad_created | boolean | Indicates whether a new ad was created. Possible values: |
| Ad Status Changed From | ad_status_changed_from | string | The prior status of the ad before the change. Example values: |
| Ad Status Changed To | ad_status_changed_to | string | The new status of the ad. Example values: |
| 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: |
| Ad Set Changed Name To | adset_changed_name_to | string | The updated name of the ad set. Example: |
| Ad Set Created | adset_created | boolean | Indicates whether a new ad set was created. Possible values: |
| 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: |
| Ad Set Status Changed To | adset_status_changed_to | string | The updated status of the ad set. Example values: |
| 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: |
| Campaign Changed Name To | campaign_changed_name_to | string | The updated campaign name. Example value: |
| Campaign Created | campaign_created | boolean | Indicates whether a new campaign was created. Possible values: |
| 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: |
| Campaign Status Changed To | campaign_status_changed_to | string | The new status of the campaign. Example values: |
| 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: |
| CDP Sync to Klaviyo Status | cdp_segment_sync_to_klaviyo_status | string | The result of syncing the CDP segment to Klaviyo. Example values: |
| Channel | channel | string | The platform or channel that the activity occurred in. Example values: |
| Created At | created_at | timestamp | The timestamp when the activity occurred. Example: |
| Created CDP Segment | created_cdp_segment | boolean | Indicates whether a CDP segment was created. Possible values: |
| Created Survey Description | created_post_purchase_survey_description | string | A message indicating that a post-purchase survey was created. Example value: |
| Deleted Survey Description | deleted_post_purchase_survey_description | string | A message indicating that a post-purchase survey was deleted. Example value: |
| Entity Type | entity | sting | The type of entity that the activity occurred on. Example values: |
| Entity ID | entity_id | string | Unique identifier for the activity log entry. Example value: |
| Entity Name | entity_name | string | Name of the entity that the activity occurred on. Example values: |
| 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: |
| 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: |
| Updated Integration Description | updated_integration_description | string | A message indicating that an integration was updated. Example value: |
| Updated Integration Source | updated_integration_source | string | The integration source that was updated. Example value: |
| Updated Integration Title | updated_integration_title | string | The title of the message indicating that an integration was updated. Example: |
| 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: |
| 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: |
Updated 1 day ago