--- schema_version: "1" id: 0e7055bedb99b959e83969c6708d1c5be1ac3ce4c099ba8ac24b567de084b75f title: Send Promotion Data from Marketing Cloud to Marketing Cloud Personalization collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/interaction_studio_send_data.md canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.interaction_studio_send_data.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 510d2c2c7d8396d97ec52bc55b0f1f49691aa54ff4642ceac48dfe089ebe1454 description: After you prepare Marketing Cloud Personalization (formerly Interaction Studio) to receive Promotion, Promotion Market Segment, and other related object data, you must send the data to Marketing Cloud Personalization. Prepare a data extension that's compatible with Marketing Cloud Personalization's Promotion ETL, and then send it by using Automation Studio in Journey Builder. products: - Loyalty Management release: "264" --- # Send Promotion Data from Marketing Cloud to Marketing Cloud Personalization After you prepare Marketing Cloud Personalization (formerly Interaction Studio) to receive Promotion, Promotion Market Segment, and other related object data, you must send the data to Marketing Cloud Personalization. Prepare a data extension that's compatible with Marketing Cloud Personalization's Promotion ETL, and then send it by using Automation Studio in Journey Builder. ### Required Editions
Available in: Lightning Experience in Enterprise, Performance, Developer, and Unlimited Editions.
Available in: Orgs that have the B2C - Loyalty, B2C - Loyalty Plus, B2B - Loyalty, Loyalty Management - Growth, or Loyalty Management - Advanced license, Data Cloud, and Interaction Studio in Marketing Cloud enabled.
To send Promotion, Promotion Market Segment, and other related object data to Interaction Studio, complete these steps: 1. [Create a target data extension in Marketing Cloud Contact Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_cab_data_extensions.htm&language=en_US): 1. Provide these values to define the data extension: - Creation Method: Create from New - Name: PromotionTargetDE 2. On the Attributes tab, add these fields. | Name | Data Type | Required | Length | | --- | --- | --- | --- | | id | Text | ![Yes](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/resources-global/_corporate/images/checkmark.png) | 50 | | attribute:name | Text | ![Yes](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/resources-global/_corporate/images/checkmark.png) | 50 | | attribute:description | Text | — | 1000 | | inclusionSegments | Text | — | 100 | | attribute:url | Text | ![Yes](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/resources-global/_corporate/images/checkmark.png) | 1000 | | asset:imageUrl | Text | ![Yes](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/resources-global/_corporate/images/checkmark.png) | 1000 | | asset:contentZones | Text | ![Yes](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/resources-global/_corporate/images/checkmark.png) | 50 | | attribute:published | Text | — | 100 | | attribute:expiration | Text | — | 100 | | attribute:fulfillmentAction | Text | — | 50 | | attribute:promotable | Boolean | — | — | Select the id field as the primary key. 2. [Send data to Marketing Cloud Personalization by using Automation Studio of Journey Builder](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_marketing_cloud_send_data_from.htm&type=5&language=en_US). Complete these steps: 1. Create the starting source schedule. 2. Create an SQL query: 1. Provide this SQL query. ``` SELECT p.Id as id, p.Name as [attribute:name], CONVERT(VARCHAR, DATEADD(ss, 1, p.StartDate) , 126) as [attribute:published], CONVERT(VARCHAR, DATEADD(day, DATEDIFF(day, 0, p.EndDate), '23:59:59') , 126) as [attribute:expiration], p.Description as [attribute:description], p.URL__c as [attribute:url], p.ImageURL__c as [asset:imageUrl], p.ContentZones__c as [asset:contentZones], p.FulfillmentAction as [attribute:fulfillmentAction], p.IsActive as [attribute:promotable], STUFF((SELECT '|c360a-' + LEFT(m.MarketSegmentId, 15) FROM PromotionMarketSegment_Salesforce m WHERE p.Id = m.PromotionId FOR XML PATH('')), 1, 1, '') [inclusionSegments] From Promotion_Salesforce p JOIN PromotionMarketSegment_Salesforce pm ON p.id = pm.PromotionId WHERE p.SendToInteractionStudio__c = 'True' ``` ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/images/icon_note.png) Note If you don't add the Checkbox type custom field to filter promotions that must be sent to Marketing Cloud Personalization, remove references to the field in the SQL query. ![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-loyalty_management-264-0-0-production-enus/0590ce3e-5a09-45ab-8e5e-68f359c35886/images/icon_tip.png) Tip You can modify the SQL query based on your company's requirements and based on any fields that you've added in the Promotion object. 2. Select the target data extension that you created in step 1. 3. In Data Action, select **Overwrite**. 3. Convert the Data Extract from a data extension to a CSV file: 4. Convert the Data Extract from CSV to UTF-8. 5. Transfer the CSV file to the Marketing Cloud Personalization SFTP. In steps c-e, use the [file name format of Promotion ETL](https://help.salesforce.com/s/articleView?id=mktg.mc_pers_etl_promotion_data_feed.htm&type=5&language=en_US) for the file name. 6. Save the automation. 7. Run the automation once. The data is immediately sent to the inbound folder of Feed's SFTP Files in Marketing Cloud Personalization. Later, the data automatically moves from the inbound folder to the processed folder. After the data moves to the processed folder of SFTP Files, your Promotion records are available in the Catalog section of Marketing Cloud Personalization. In the records, you can find these items that are associated with the promotion: - Image - URL - Segments In Marketing Cloud Personalization, the Promotion records expire on the specified end date.