If you've set up your server-to-server app, you're ready to build your reusable data extension. We'll use this data extension to store your push data extracts so Jacquard can properly optimise on your subscribers' engagement with your triggered push messages.
You'll need to make a new data extension named phraseePushResults-dataextract. You should place this someplace where you'll be able to find it again later. It's usually best to make a new folder that will only house this data extension.
When creating your new data extension, you should choose Standard Data Extension.
Then, click OK. Ensure you've put phraseePushResults-dataextract under both the Name and External Key fields in the Properties panel.
You should also ensure you've chosen the correct Location for your data extensions and you leave Is Sendable? unchecked. Click Next.
Leave the Retention Setting toggled to Off. Click Next.
In the Fields panel, create the following fields exactly as shown below:
Name | Data Type | Length | Primary Key | Nullable | Default Value |
MessageName | Text |
|
|
|
|
MessageID | Text |
|
|
|
|
DateTimeSend | Text |
|
|
|
|
MessageOpened | Boolean |
|
|
|
|
OpenDate | Date |
|
| β |
|
Status | Text |
|
|
|
|
PushJobId | Text |
|
|
|
|
ContactKey | Text |
|
|
|
|
DeviceId | Text |
|
|
|
|
Then, click Create. Your data extension fields should look like the below when you're done:
That's it for the data extension creation. It's time to move on to building your reusable automation.