Skip to main content
SFMC - Triggered Push - Reusable Data Extension Setup

You'll only need to create this one time

Updated over a week ago

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.

Did this answer your question?