--- title: "Automation Setup" slug: "sfmc-triggered-push-reusable-data-extension-setup" updated: 2025-07-23T20:27:02Z published: 2025-07-23T20:27:02Z canonical: "support.jacquard.com/sfmc-triggered-push-reusable-data-extension-setup" --- > ## 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. # Automation Setup ## Overview This automation is intended to populate a Salesforce Marketing Cloud (SFMC) data extension with all the message open events from a push data extract. It then queries the data to populate individual Jacquard experiment **-opens** data extensions which have been created automatically by the Jacquard integration. Because this automation has steps to add queries that are created for each experiment, it is suggested you create a test experiment in Jacquard and click **Start optimisation** to create some queries as placeholders for now. For every Automation Studio activity or data extension you manually create, ensure the name and the external key are named the same. [![](https://downloads.intercomcdn.com/i/o/872499347/0c54b62ef8035d37f682ab4f/image.png?expires=1749657600&signature=f23de63d7dab691a3da032b03ed2427d9ad5dc40127ed381d4e0c14764d25de4&req=fCclEsB3noVYFb4f3HP0gNaM5OBPlJ2CsY%2BlT2qGg%2BDE26N9cpRP2CBk4zYM%0AxnWy%2F%2Ft%2BUdWd2oikrQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872499347/0c54b62ef8035d37f682ab4f/image.png?expires=1749657600&signature=f23de63d7dab691a3da032b03ed2427d9ad5dc40127ed381d4e0c14764d25de4&req=fCclEsB3noVYFb4f3HP0gNaM5OBPlJ2CsY%2BlT2qGg%2BDE26N9cpRP2CBk4zYM%0AxnWy%2F%2Ft%2BUdWd2oikrQ%3D%3D%0A) To start, you should have already [created a data extension](/v1/docs/sfmc-triggered-push-reusable-data-extension-setup-1) called **phraseePushResults-dataextract**. This name is important as the queries the Jacquard integration creates will use this name. ## Creating the automation Ideally, this automation will run once a day and will have 11 steps, including one-minute Waits between seven activity steps. [![](https://downloads.intercomcdn.com/i/o/872158820/9f4254ba8b9e6b458a938823/image.png?expires=1749657600&signature=fbca700f70de556aa577416b084c4348bc2de452e1bd7cf5b7ec72e5af362c71&req=fCclF8x2lYNfFb4f3HP0gBalMaZpCsyY%2BYaCTOeoCexNRSKydd29dazam6xC%0AKw8M11pJt7njyOA3gQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872158820/9f4254ba8b9e6b458a938823/image.png?expires=1749657600&signature=fbca700f70de556aa577416b084c4348bc2de452e1bd7cf5b7ec72e5af362c71&req=fCclF8x2lYNfFb4f3HP0gBalMaZpCsyY%2BYaCTOeoCexNRSKydd29dazam6xC%0AKw8M11pJt7njyOA3gQ%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872159661/3857df821af79dbc9ac55d32/image.png?expires=1749657600&signature=75e1249683115a2112df612b8355288ebe38ae9695f01f5ecbcc97fd04981507&req=fCclF8x3m4deFb4f3HP0gMUX6zoS6utVGwpQxt%2B1K8UcUgnA1vIuRBsJXkMg%0APSlK1ozSo8%2BVZHX8eg%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872159661/3857df821af79dbc9ac55d32/image.png?expires=1749657600&signature=75e1249683115a2112df612b8355288ebe38ae9695f01f5ecbcc97fd04981507&req=fCclF8x3m4deFb4f3HP0gMUX6zoS6utVGwpQxt%2B1K8UcUgnA1vIuRBsJXkMg%0APSlK1ozSo8%2BVZHX8eg%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872160418/f82cd919e00cba1af745b441/image.png?expires=1749657600&signature=f8b7c5afa37e8e75bc73ff2e3e5eaa0a4d66aae7b299ca792c003a3aa91e7d90&req=fCclF89%2BmYBXFb4f3HP0gOQUpU7vFdfdzQ88BYgjrOJImoafv2UhOkwAGr7W%0A8aZO0xcICdew7W8RQQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872160418/f82cd919e00cba1af745b441/image.png?expires=1749657600&signature=f8b7c5afa37e8e75bc73ff2e3e5eaa0a4d66aae7b299ca792c003a3aa91e7d90&req=fCclF89%2BmYBXFb4f3HP0gOQUpU7vFdfdzQ88BYgjrOJImoafv2UhOkwAGr7W%0A8aZO0xcICdew7W8RQQ%3D%3D%0A) ### Step 1 - Data extract File Naming Pattern: **PhraseePushResults_%%Year%%%%Month%%%%Day%%.zip** [![](https://downloads.intercomcdn.com/i/o/872166253/3a38dbe75b9d99e54448e6a9/image.png?expires=1749657600&signature=367ef70f415cb34239d7b27052392260f8605a4ef7900e16810b20fa78a7ca30&req=fCclF894n4RcFb4f3HP0gGstxbS1To6lzbf1ZlNuWTsdc0kHxry18JsKN46A%0AlN9AvfkkqlEJiOkSFA%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872166253/3a38dbe75b9d99e54448e6a9/image.png?expires=1749657600&signature=367ef70f415cb34239d7b27052392260f8605a4ef7900e16810b20fa78a7ca30&req=fCclF894n4RcFb4f3HP0gGstxbS1To6lzbf1ZlNuWTsdc0kHxry18JsKN46A%0AlN9AvfkkqlEJiOkSFA%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872167848/a5f2322f53323903a2846f06/image.png?expires=1749657600&signature=fbc9d0bee607282d8b4341a249f2ac73c2a2964fc0b242597630f05edbade659&req=fCclF895lYVXFb4f3HP0gCEhoJJnxLZOunYeap2J9%2BaB%2FE4sMTYNNX4SCBHg%0A8Jg6l7fHs9Ar9ke90w%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872167848/a5f2322f53323903a2846f06/image.png?expires=1749657600&signature=fbc9d0bee607282d8b4341a249f2ac73c2a2964fc0b242597630f05edbade659&req=fCclF895lYVXFb4f3HP0gCEhoJJnxLZOunYeap2J9%2BaB%2FE4sMTYNNX4SCBHg%0A8Jg6l7fHs9Ar9ke90w%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872168746/606470c816babb4c05203b15/image.png?expires=1749657600&signature=ac8faeaf3c5b0cb3f853af670bff494b94579f880c457ad40b1d0010a6cb6ef1&req=fCclF892moVZFb4f3HP0gBO%2B9M5tLzKlsVZ6vE6MR4wBYmilqkwrtJSa9gYA%0ANWTPCEBGKRyccQbiXQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872168746/606470c816babb4c05203b15/image.png?expires=1749657600&signature=ac8faeaf3c5b0cb3f853af670bff494b94579f880c457ad40b1d0010a6cb6ef1&req=fCclF892moVZFb4f3HP0gBO%2B9M5tLzKlsVZ6vE6MR4wBYmilqkwrtJSa9gYA%0ANWTPCEBGKRyccQbiXQ%3D%3D%0A) ### Step 3 - File transfer (move) [![](https://downloads.intercomcdn.com/i/o/872169400/4a213587c2268ea22d88af41/image.png?expires=1749657600&signature=5ff6043a84d310e7d11850ef9c41c59dfb298230b12fef225642619f79b96a58&req=fCclF893mYFfFb4f3HP0gJMRDXRlz37zUBfir9EqwC1AAqbNLZ6%2BblZiS6bx%0Avzc8XvPk61xfOt96dg%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872169400/4a213587c2268ea22d88af41/image.png?expires=1749657600&signature=5ff6043a84d310e7d11850ef9c41c59dfb298230b12fef225642619f79b96a58&req=fCclF893mYFfFb4f3HP0gJMRDXRlz37zUBfir9EqwC1AAqbNLZ6%2BblZiS6bx%0Avzc8XvPk61xfOt96dg%3D%3D%0A) File Naming Pattern: **PhraseePushResults_%%Year%%%%Month%%%%Day%%.zip** [![](https://downloads.intercomcdn.com/i/o/872171763/b1d70d2fa0dca300e33a247d/image.png?expires=1749657600&signature=87ee1ad72ffb835ef30e8b049430f8bdd55265094323f4c570c5053bffb00de8&req=fCclF85%2FmodcFb4f3HP0gGYek%2FCbJOjSKIYC3HQjKKMsP7PVTQco8H1WZCn4%0ALVbWSFc095GyoODGnQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872171763/b1d70d2fa0dca300e33a247d/image.png?expires=1749657600&signature=87ee1ad72ffb835ef30e8b049430f8bdd55265094323f4c570c5053bffb00de8&req=fCclF85%2FmodcFb4f3HP0gGYek%2FCbJOjSKIYC3HQjKKMsP7PVTQco8H1WZCn4%0ALVbWSFc095GyoODGnQ%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872173329/f9219b6b61adb20918355d74/image.png?expires=1749657600&signature=2f221893ba79a06dacc8f59547d1972ba08bcea75a81bdd763df42e47ff182fc&req=fCclF859noNWFb4f3HP0gKuWJ3rJl7ocw4eFgMwMoEuJUoQuYaZHOXzlZbIQ%0A1t043fUQH66KV%2FVUow%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872173329/f9219b6b61adb20918355d74/image.png?expires=1749657600&signature=2f221893ba79a06dacc8f59547d1972ba08bcea75a81bdd763df42e47ff182fc&req=fCclF859noNWFb4f3HP0gKuWJ3rJl7ocw4eFgMwMoEuJUoQuYaZHOXzlZbIQ%0A1t043fUQH66KV%2FVUow%3D%3D%0A) ### Step 5 - File transfer (unzip) [![](https://downloads.intercomcdn.com/i/o/872175851/5166845ecd138900e6b0a409/image.png?expires=1749657600&signature=cb0bc405cd686119636eb1c3517ff3628ec82238b12c0767cc3ae02028f7e515&req=fCclF857lYReFb4f3HP0gA71ftIRTnm3l8IRsAUW98rjdMsPzoHCKLjpJlrL%0AAbSgYyNiqOZaQoGmBA%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872175851/5166845ecd138900e6b0a409/image.png?expires=1749657600&signature=cb0bc405cd686119636eb1c3517ff3628ec82238b12c0767cc3ae02028f7e515&req=fCclF857lYReFb4f3HP0gA71ftIRTnm3l8IRsAUW98rjdMsPzoHCKLjpJlrL%0AAbSgYyNiqOZaQoGmBA%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872176237/00d2cc32a5562e3c829cbce7/image.png?expires=1749657600&signature=ff979a24ba44ed23fc9ae2ec6caca6fd74daec6d10478a5dc5abac5471f2d2e9&req=fCclF854n4JYFb4f3HP0gKxrzd1xyDKqCih44rgqX809e5sFkNj82c6BDsJI%0AlE7GMJhMVy6fmEYt5Q%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872176237/00d2cc32a5562e3c829cbce7/image.png?expires=1749657600&signature=ff979a24ba44ed23fc9ae2ec6caca6fd74daec6d10478a5dc5abac5471f2d2e9&req=fCclF854n4JYFb4f3HP0gKxrzd1xyDKqCih44rgqX809e5sFkNj82c6BDsJI%0AlE7GMJhMVy6fmEYt5Q%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872176839/9cb8b74b62d900a2c5f66b0f/image.png?expires=1749657600&signature=3aa35beb7262cce21db1f45fcf371c06edaff9d07906c147024fad2807d57a7a&req=fCclF854lYJWFb4f3HP0gKRcxF8hoyvsxre%2Bu0WwjCmeoRhyjGiRYx0VNU%2FQ%0A%2FHK8yvTOptsCfTdm5g%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872176839/9cb8b74b62d900a2c5f66b0f/image.png?expires=1749657600&signature=3aa35beb7262cce21db1f45fcf371c06edaff9d07906c147024fad2807d57a7a&req=fCclF854lYJWFb4f3HP0gKRcxF8hoyvsxre%2Bu0WwjCmeoRhyjGiRYx0VNU%2FQ%0A%2FHK8yvTOptsCfTdm5g%3D%3D%0A) ### Step 7 - Import file [![](https://downloads.intercomcdn.com/i/o/872180197/4e442b305d071f0b2415c5d7/image.png?expires=1749657600&signature=2b162d1d8e7dc8fa74610e3540ad71107cfafebf1863d0d4306eef5d752accb6&req=fCclF8F%2BnIhYFb4f3HP0gMG9LbENFD1xvTinb6T5ezu84RQucW3zVGXrp6TT%0A1bkdb05fgztPuCKBYQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872180197/4e442b305d071f0b2415c5d7/image.png?expires=1749657600&signature=2b162d1d8e7dc8fa74610e3540ad71107cfafebf1863d0d4306eef5d752accb6&req=fCclF8F%2BnIhYFb4f3HP0gMG9LbENFD1xvTinb6T5ezu84RQucW3zVGXrp6TT%0A1bkdb05fgztPuCKBYQ%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872181016/7ca069b5691ee15bdfe5c625/image.png?expires=1749657600&signature=7123a2d0d45ab7c18add961755d8f7098045e03aee26451b0d6944d5ca41e2de&req=fCclF8F%2FnYBZFb4f3HP0gKFgGIkCTu07dhwQ%2F0dF7dTjPHLketJfEbzT4WE%2B%0AVLwOTjsZ2DN4K2xkwg%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872181016/7ca069b5691ee15bdfe5c625/image.png?expires=1749657600&signature=7123a2d0d45ab7c18add961755d8f7098045e03aee26451b0d6944d5ca41e2de&req=fCclF8F%2FnYBZFb4f3HP0gKFgGIkCTu07dhwQ%2F0dF7dTjPHLketJfEbzT4WE%2B%0AVLwOTjsZ2DN4K2xkwg%3D%3D%0A) Select the **phraseePushResults-dataextract** data extension created you created. This data extension can get quite large over a period of time and should be cleared out on a schedule. [![](https://downloads.intercomcdn.com/i/o/872263030/0f92b50bdfee48626aa54ebf/image.png?expires=1749657600&signature=84ce7a36d63c1a3ed566fa844cc17895b03d73060be60f858d06f9468b384492&req=fCclFM99nYJfFb4f3HP0gKAxO0KLQYhlQS%2BCuLHzIanJFAbneDT5Hyw6zegL%0AHALeOiSvQ0zfjewycg%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872263030/0f92b50bdfee48626aa54ebf/image.png?expires=1749657600&signature=84ce7a36d63c1a3ed566fa844cc17895b03d73060be60f858d06f9468b384492&req=fCclFM99nYJfFb4f3HP0gKAxO0KLQYhlQS%2BCuLHzIanJFAbneDT5Hyw6zegL%0AHALeOiSvQ0zfjewycg%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/873577113/dac1e6c1c2cebb9e254f12a3/image.png?expires=1749657600&signature=16b68a3f6d7d8b3ef2d34a7b079f37c1e21e45b159c57a9417cb8ebde1db75a7&req=fCckE855nIBcFb4f3HP0gItG%2BSaa%2FBtlTK1RE32%2FORSLqaLlW45Katde8nSn%0Aw0m9L3VnyEJWjDZK8w%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/873577113/dac1e6c1c2cebb9e254f12a3/image.png?expires=1749657600&signature=16b68a3f6d7d8b3ef2d34a7b079f37c1e21e45b159c57a9417cb8ebde1db75a7&req=fCckE855nIBcFb4f3HP0gItG%2BSaa%2FBtlTK1RE32%2FORSLqaLlW45Katde8nSn%0Aw0m9L3VnyEJWjDZK8w%3D%3D%0A)[![](https://downloads.intercomcdn.com/i/o/872270953/b9d1bfb034317fb6dde8152a/image.png?expires=1749657600&signature=4e7dd3462e16afe48aa05a02c710a39a63235e5df35b9f80cba0df06a22873f1&req=fCclFM5%2BlIRcFb4f3HP0gAwaeIfYXKjXWWKF19hkLLFr8CB%2F5hmbpER97ddc%0ARsOXBq4%2Ffj2Guj%2BOlQ%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872270953/b9d1bfb034317fb6dde8152a/image.png?expires=1749657600&signature=4e7dd3462e16afe48aa05a02c710a39a63235e5df35b9f80cba0df06a22873f1&req=fCclFM5%2BlIRcFb4f3HP0gAwaeIfYXKjXWWKF19hkLLFr8CB%2F5hmbpER97ddc%0ARsOXBq4%2Ffj2Guj%2BOlQ%3D%3D%0A) ### Step 9 - SQL query Add the **_AR** query that was created for the experiment. You will add one query per experiment to this step in the automation. [![](https://downloads.intercomcdn.com/i/o/872192050/66eac6e577afcf7f07a1f061/image.png?expires=1749657600&signature=fab4c9b93000eca294b1e7c3f28af4c39a6a3156f9d48c9177363a26b5a02d75&req=fCclF8B8nYRfFb4f3HP0gFMAOUo5yrrm5XjsCL3CuXTpsF6djPTfNnDah9o0%0AzWeSs9G2KDczZ20YXA%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872192050/66eac6e577afcf7f07a1f061/image.png?expires=1749657600&signature=fab4c9b93000eca294b1e7c3f28af4c39a6a3156f9d48c9177363a26b5a02d75&req=fCclF8B8nYRfFb4f3HP0gFMAOUo5yrrm5XjsCL3CuXTpsF6djPTfNnDah9o0%0AzWeSs9G2KDczZ20YXA%3D%3D%0A) ### Step 11 - SQL Query Add the **_opens_query** query that was created for the experiment. As mentioned before, multiple experiment queries can be added to this step. [![](https://downloads.intercomcdn.com/i/o/872194395/f901a41ca72686ceca8f3d1b/image.png?expires=1749657600&signature=c55be4130a3632ce6ad37afe99f567ff301a31eef5c242a65fd30bf1e06cae9d&req=fCclF8B6nohaFb4f3HP0gL7ZurUEqjX%2BCk8uy4p4Jn1tTe0lWaZqHvZUrJKU%0A%2BOSg%2FOgZzoOi3jzvfw%3D%3D%0A)](https://downloads.intercomcdn.com/i/o/872194395/f901a41ca72686ceca8f3d1b/image.png?expires=1749657600&signature=c55be4130a3632ce6ad37afe99f567ff301a31eef5c242a65fd30bf1e06cae9d&req=fCclF8B6nohaFb4f3HP0gL7ZurUEqjX%2BCk8uy4p4Jn1tTe0lWaZqHvZUrJKU%0A%2BOSg%2FOgZzoOi3jzvfw%3D%3D%0A) Once this is all configured, add a daily schedule to the automation and activate it.