MarketingEvents
Create, update, delete, and query marketing events.
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM MarketingEvents
SELECT * FROM MarketingEvents WHERE Id='123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
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. |