MarketingEvents
Create, update, delete, and query marketing events.
Table-Specific Information
Select
The adapter processes all filters client-side within the adapter. The following queries are the only ones processed server side:
SELECT * FROM MarketingEvents
SELECT * FROM MarketingEvents WHERE Id='123'
Insert
You must specify the MarketingChannel, EventType, Paid, ReferringDomain, and StartedAt columns to create a marketing event. For example:
INSERT INTO MarketingEvents (MarketingChannel,EventType,Paid,ReferringDomain,StartedAt) VALUES ('social', 'ad',true,'facebook.com','2018-12-15')
Update
You must specify the Id to update a marketing event. You can modify only timestamps, RemoteId, and budget/currency. For example:
UPDATE MarketingEvents SET RemoteId='1000:2000',StartedAt='2018-02-02T00:00 +00:00',EndedAt='2018-02-03T00:00 +00:00',ScheduledToEndAt='2018-02-04T00:00 +00:00',Budget=11.1, BudgetType='daily', Currency='USD' WHERE Id='123'
Delete
You must specify the Id of the marketing event to delete it.
DELETE FROM MarketingEvents WHERE Id ='123'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the marketing event. | |
| RemoteId | String | False |
An optional remote identifier for a marketing event. | |
| BreadcrumbId | String | True |
An optional identifier for the breadcrumb of a marketing event. | |
| UTMCampaign | String | True |
A unique name for the UTM campaign. | |
| UTMSource | String | True |
The source of the UTM campaign. | |
| UTMMedium | String | True |
The medium of the UTM campaign. | |
| UTMContent | String | True |
The content of the UTM campaign. | |
| UTMTerm | String | True |
The term of the UTM campaign. | |
| EventTarget | String | True |
The target of the event. | |
| Description | String | True |
A description for the marketing event. | |
| MarketingChannel | String | False |
A broader marketing event type that is focused only on the channel. Must be one of the allowed values (`search`, `display`, `social`, `email`, `referral`). | |
| EventType | String | False |
The specific type of marketing event. Must be one of the allowed values (`ad`, `post`, `message`, `retargeting`, `transactional`, `affiliate`, `loyalty`, `newsletter`, `abandoned_cart`, `receipt`). | |
| Budget | Decimal | False |
The budget of the ad campaign. | |
| Paid | Boolean | False |
A boolean field to specify whether this event is paid or organic. | |
| BudgetType | String | False |
The type of the budget; must be either `daily` or `lifetime`. | |
| Currency | String | False |
The currency for the budget. | |
| ManageUrl | String | True |
A link to manage the marketing event, generally in the Shopify app's interface. | |
| PreviewUrl | String | True |
A link to view the live version of the post/ad, or to view a rendered preview of the post/ad/email in the Shopify app. | |
| ReferringDomain | String | False |
The destination domain of the marketing event. Required unless MarketingChannel is one of email/referral/display. | |
| MarketedResources | String | True |
A list of the items that were marketed in the marketing event. It's a list of dictionaries with type keys and id keys. Valid values for type are: (`product`, `collection`, `price_rule`, `page`, `article`, `homepage`). All types, other than homepage, also require an id. | |
| StartedAt | Datetime | False |
The timestamp when the marketing action was started, or when the email was sent, or when the Facebook post was made live, etc. | |
| EndedAt | Datetime | False |
For events with a duration, when the event actually ended. This may differ from ScheduledToEndAt, if the ad was stopped early, etc. | |
| ScheduledToEndAt | Datetime | False |
For events with a duration, when the event was supposed to end. |