| ID |
NUMBER(38,0) |
Campaign ID |
|
| APP_ID |
VARCHAR(128) |
Application ID |
|
| NAME |
VARCHAR(255) |
Campaign Name |
|
| MESSAGE_TYPE |
VARCHAR(10) |
Campaign Type |
push, in-app, places, inbox, push-api |
| BEGIN_DATE |
TIMESTAMP_LTZ(3) |
Campaign Begin Bate (UTC) |
|
| END_DATE |
TIMESTAMP_LTZ(3) |
Campaign End Date (UTC) |
|
| STATUS |
VARCHAR(255) |
Campaign Activation Status |
active, deactive, draft, test, new, null (push-api) |
| PLATFORM |
VARCHAR(10) |
App Platform |
ios, android, null |
| GOAL |
VARCHAR(255) |
Campaign Goal, if applicable |
notify, nurture, unknown, drive_behavior, reengage, activate, monetize, null |