A data extension is a table within Marketing Cloud Engagement that contains your data. Use that data in Data 360 by creating a data stream in Data 360 from a Marketing Cloud Engagement data extension.
Required Editions
| Available in: All Editions supported by Data 360. See Data 360 edition availability. |
| User Permissions Needed | |
|---|---|
| To create a data stream |
Permission set:
|
Before completing these steps, consider the frequency of data extracts since they can't be edited.
Marketing Cloud Engagement only processes full extracts daily. Since Data 360 checks hourly, you see 24 refreshes in the Data Stream tab, but only one extract processes.
Marketing CloudEngagagement process delta extracts hourly. If you create a data stream with a delta extract selected, a full extract and ingestion occurs on the first run. After that, only deltas have hourly extracts. For both extract modes, the remaining refreshes show zero rows processed due to no new data from Engagement.
- In Data Cloud, go to Data Streams, and click New.
- Select Marketing Cloud as the data source, and click Next.
- From Connections, select the Marketing Cloud Engagement connection you want to configure.
- For the connections business units, select the appropriate data spaces needing mapping.
- Choose a data extension.
- Select a business unit in the context filter dropdown to view its data extensions.
- Select the data extension to import.
- (Optional) Change the object label or object API name.
- Select the category and define the primary key.
- Review the field list, and optionally edit the field label, field API name, and data type.
- (Optional) To cleanse your source data or get new fields, add formula fields.
- Configure the data stream name, extract mode, and refresh mode.
If a data extension extracation has previously occurred, the extract mode and the refresh mode are unavailable. Deleting and recreating the stream doesn’t enable these modes. To extract data using a different method, create a data extension with a unique name to use with the new data stream.
Note Delta extracts require a number or date field. - Click Deploy.
- To map the data source object to the data model, go to Data Streams home page and click Start Data Mapping.
When the data extension is extracted for the first time, it takes up to 24 hours for data to be available in the system. After the first 24 hours, data is populated according to the frequency indicated in the data stream settings. Delta extracts load the previous 90 days of data when the data stream is initially configured. Subsequent runs load only new or updated records. For Engagement type, Data 360 extracts the last 90 days of data and for Profile type, the entire dataset is extracted.
- Data Extension Considerations for Data 360
If you ingest a data extension into Data 360, you should be aware of some core functionality within Marketing Cloud Engagement and how they operate within Data 360. - Extract Mode for a Marketing Cloud Engagement Data Extension in Data 360
Marketing Cloud Engagement Connector Extract mode dictates how Data 360 exports and imports data from Marketing Cloud Engagement. - Refresh for Data Extension Data Streams
For a data extension data stream with the refresh mode of upsert, you can choose to perform either an incremental or a full data refresh.