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_dateis 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 |
| 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 |
| 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 |
| Unique identifier for the activity log entry. Example value: | |
Entity Name |
| 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 10 days ago