Activities Table
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 |
| 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 |
| date | The day the event occurred. Derived from |
Event Week |
| date | The Sunday of the week during which the event occurred. Derived from |
Event Month |
| date | The month during which the event occurred. Derived from |
Event Quarter |
| date | The first month of the quarter during which the event occurred. Derived from |
Event Year |
| date | The year during which the event occurred. Derived from |
Account ID |
| string | The unique ID for the platform or channel account associated with the activity. Example values: |
Action Source |
| string | The source or interface from which the action was initiated. Example values: |
Ad Changed Name From |
| string | The previous name of the ad before it was updated. Example value: |
Ad Changed Name To |
| string | The updated name of the ad. Example value: |
Ad Created |
| boolean | Indicates whether a new ad was created. Possible values: |
Ad Status Changed From |
| string | The prior status of the ad before the change. Example values: |
Ad Status Changed To |
| string | The new status of the ad. Example values: |
Ad Set 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 |
| 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 |
| string | The previous name of the ad set. Example values: |
Ad Set Changed Name To |
| string | The updated name of the ad set. Example: |
Ad Set Created |
| boolean | Indicates whether a new ad set was created. Possible values: |
Ad Set 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 |
| 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 |
| string | The prior status of the ad set before the change. Example values: |
Ad Set Status Changed To |
| string | The updated status of the ad set. Example values: |
Ad Set 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 |
| string | The updated target ROAS for the ad set, after the most recent change. By default shown in the shop's currency. |
Annotation Author |
| string | The user who created the annotation. |
Annotation Description |
| string | The message content of the annotation. |
Annotation Title |
| string | The title of the annotation. |
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 |
| 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 |
| string | The prior campaign name. Example value: |
Campaign Changed Name To |
| string | The updated campaign name. Example value: |
Campaign Created |
| boolean | Indicates whether a new campaign was created. Possible values: |
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 |
| 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 |
| 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 |
| 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 |
| string | The prior status of the campaign. Example values: |
Campaign Status Changed To |
| string | The new status of the campaign. Example values: |
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 |
| 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 |
| string | The result of syncing the CDP segment to Facebook. Example values: |
CDP Sync to Klaviyo Status |
| string | The result of syncing the CDP segment to Klaviyo. Example values: |
Channel |
| string | The platform or channel that the activity occurred in. Example values: |
Created At |
| timestamp | The timestamp when the activity occurred. Example: |
Created CDP Segment |
| boolean | Indicates whether a CDP segment was created. Possible values: |
Created Survey Description |
| string | A message indicating that a post-purchase survey was created. Example value: |
Deleted Survey Description |
| string | A message indicating that a post-purchase survey was deleted. Example value: |
Entity Type |
| sting | The type of entity that the activity occurred on. Example values: |
Entity ID |
| string | Unique identifier for the activity log entry. Example value: |
Entity Name |
| string | Name of the entity that the activity occurred on. Example values: |
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 |
| 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 |
| string | A message indicating that an integration was updated. Example value: |
Updated Integration Source |
| string | The integration source that was updated. Example value: |
Updated Integration Title |
| string | The title of the message indicating that an integration was updated. Example: |
Updated New User Description |
| string | A message indicating that a user was updated. |
Updated Survey Description |
| string | A message indicating that a post-purchase survey was updated. Example value: |
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 |
| string | The updated price of the product variant, after the most recent change. By default shown in the shop's currency. |
Variant Stock Status |
| string | The inventory status of a product variant. Example values: |
Updated 2 months ago