---
title: "Reusable Data Extension Setup"
slug: "sfmc-triggered-push-reusable-data-extension-setup-1"
updated: 2025-07-23T20:23:54Z
published: 2025-07-23T20:23:54Z
canonical: "support.jacquard.com/sfmc-triggered-push-reusable-data-extension-setup-1"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.jacquard.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Reusable Data Extension Setup

If you've [set up your server-to-server app](/v1/docs/sfmc-creating-a-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**.

[![](https://downloads.intercomcdn.com/i/o/594229940/b80f5c29f0659eabd3cb51e9/image.png?expires=1749657600&signature=f64fb34e8365942acf8e4af69a55b6602cb90fbe7dc792c453e1e31ae44500af&req=cSkjFMt3lIVfFb4f3HP0gKRfCn%2B5DImL3VNUL0BsrmdBPQPZN7xX20V4C94r%0AKz3SHyZSow7PeQDuLw%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/594229940/b80f5c29f0659eabd3cb51e9/image.png?expires=1749657600&signature=f64fb34e8365942acf8e4af69a55b6602cb90fbe7dc792c453e1e31ae44500af&req=cSkjFMt3lIVfFb4f3HP0gKRfCn%2B5DImL3VNUL0BsrmdBPQPZN7xX20V4C94r%0AKz3SHyZSow7PeQDuLw%3D%3D%0A)

Then, click **OK**. Ensure you've put **phraseePushResults-dataextract** under both the **Name** and **External Key** fields in the **Properties** panel.

[![](https://downloads.intercomcdn.com/i/o/594230588/b4278d0b44a2bda31c95d275/image.png?expires=1749657600&signature=5c3f33f8c2cf3975b0610fd377e7bc7d1969ea8b60f4bff2c664e8ea6a84844a&req=cSkjFMp%2BmIlXFb4f3HP0gF1uHHuceSSg8SEacNWRpw3RiZhUDL%2F7t5%2BkWi%2F6%0AX%2BMZMtlXM4FO9EoQWg%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/594230588/b4278d0b44a2bda31c95d275/image.png?expires=1749657600&signature=5c3f33f8c2cf3975b0610fd377e7bc7d1969ea8b60f4bff2c664e8ea6a84844a&req=cSkjFMp%2BmIlXFb4f3HP0gF1uHHuceSSg8SEacNWRpw3RiZhUDL%2F7t5%2BkWi%2F6%0AX%2BMZMtlXM4FO9EoQWg%3D%3D%0A)

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**.

[![](https://downloads.intercomcdn.com/i/o/594231561/4ef6bd42e69f11a77f35ff50/image.png?expires=1749657600&signature=64390b5aa4f58c761e30dc03c0dcde492521f4616ff40faf795ffe75faf9f9e9&req=cSkjFMp%2FmIdeFb4f3HP0gCBSHzdOwc99O9tPJEanedXNoFDcTGsMfHGKsbT0%0Ah0hVAw4kfQBx7Oowhw%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/594231561/4ef6bd42e69f11a77f35ff50/image.png?expires=1749657600&signature=64390b5aa4f58c761e30dc03c0dcde492521f4616ff40faf795ffe75faf9f9e9&req=cSkjFMp%2FmIdeFb4f3HP0gCBSHzdOwc99O9tPJEanedXNoFDcTGsMfHGKsbT0%0Ah0hVAw4kfQBx7Oowhw%3D%3D%0A)

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:

[![](https://downloads.intercomcdn.com/i/o/594236413/126d94e967960b56adfe0b01/image.png?expires=1749657600&signature=6979b3fd140a2d52c30ca741b77b18f2b61c6efbf09af90e4d85f66e7cd02eb8&req=cSkjFMp4mYBcFb4f3HP0gAoFLuJp3xjLeR4nEBx8irAR4fDnGVOwEtHZnytE%0AQhIuvMsG2%2FEjowGR8g%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/594236413/126d94e967960b56adfe0b01/image.png?expires=1749657600&signature=6979b3fd140a2d52c30ca741b77b18f2b61c6efbf09af90e4d85f66e7cd02eb8&req=cSkjFMp4mYBcFb4f3HP0gAoFLuJp3xjLeR4nEBx8irAR4fDnGVOwEtHZnytE%0AQhIuvMsG2%2FEjowGR8g%3D%3D%0A)