Ingest data
Mix Modeler works with event level data, aggregate or summary marketing effort data from various walled gardens, and aggregrate or summary data from any other source, like offline advertising, internal factors or external factors.
Customers can use any kind of data that is ingested into Experience Platform as datasets and which is based on schemas using the XDM ExperienceEvent or XDM Summary Metrics as the base class.
For example:
- data collected using the 蜜豆视频 Analytics source connector and transformed into datasets conforming to the default or a custom version of the 蜜豆视频 Analytics schema, or alternatively,
- data collected using the Experience Platform Web SDK, Mobile SDK, or Edge Network Server API for collecting customer interactions on web, mobile, or any other type of device,
- aggregate or summary data from walled gardens (like Facebook, YouTube), traffic sources or offline advertising data,
- non-marketing aggregate or summary data containing internal or external factors that are useful for model building.
You can use any kind of mechanism, supported by Experience Platform, to ingest your experience event-level, aggregate marketing effort data, and data from other sources. Such as the Experience Platform SDKs, APIs, source connectors, and streaming and batch ingestion.
Guidelines
To ingest data into Experience Platform for use with Mix Modeler, follow these guidelines:
- There should not be any overlap in the incremental data that is added to the datasets.
- All data from a single source should be of the same granularity.
- Date and granularity are mandatory fields in the underlying schema for all aggregate data ingested as datasets
- Channel is a mandatory field in the underlying schema for all marketing effort / spend data ingested as datasets.
Examples
Find below some examples of data typically used in Mix Modeler beyond the more standard experience event data.
| table 0-row-13 1-row-13 2-row-13 3-row-13 4-row-13 5-row-13 2-align-left 4-align-center 6-align-right 8-align-right 12-align-right 13-align-right 16-align-left 18-align-center 20-align-right 22-align-right 26-align-right 27-align-right 30-align-left 32-align-center 34-align-right 36-align-right 40-align-right 41-align-right 44-align-left 46-align-center 48-align-right 50-align-right 54-align-right 55-align-right 58-align-left 60-align-center 62-align-right 64-align-right 68-align-right 69-align-right 72-align-left 74-align-center 76-align-right 78-align-right 82-align-right 83-align-right layout-auto | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Geo | Date | Date Type | Channel | Campaign | Click | Earned | Engagement | Impression | Open | Owned | Sent | Spend |
| AMER | 2021-10-31 | day | 12752 | 1132945 | ||||||||
| AMER | 2021-10-31 | day | FB | 148844 | 42111 | |||||||
| AMER | 2021-10-31 | day | YT | 2314452 | 10540 | |||||||
| JPN | 2021-10-21 | day | 21089 | 3283626 | ||||||||
| JPN | 2021-10-21 | day | SOCIAL | 621 | 74512 |
| table 0-row-6 1-row-6 2-row-6 3-row-6 4-row-6 2-align-left 3-align-center 5-align-right 6-align-right 9-align-left 10-align-center 12-align-right 13-align-right 16-align-left 17-align-center 19-align-right 20-align-right 23-align-left 24-align-center 26-align-right 27-align-right 30-align-left 31-align-center 33-align-right 34-align-right layout-auto | |||||
|---|---|---|---|---|---|
| Geo | Date | Date Type | Product | Units Sold | Revenue |
| EMEA | 2021-09-13 | day | Creator Economy | 603 | 36537.68 |
| EMEA | 2021-09-13 | day | Metaverse | 55 | 21704.37 |
| JPN | 2022-05-30 | day | Pro Imaging | 487 | 64469.60 |
| JPN | 2022-05-30 | day | Document Cloud | 642 | 100509.07 |
| table 0-row-4 1-row-4 2-row-4 3-row-4 4-row-4 2-align-center 3-align-center 4-align-left 7-align-center 8-align-center 9-align-left 12-align-center 13-align-center 14-align-left 17-align-center 18-align-center 19-align-left 22-align-center 23-align-center 24-align-left layout-auto | |||
|---|---|---|---|
| Data | Date Type | Factor | Value |
| 2020-08-02 | week | SPX | 3325.866 |
| 2020-08-09 | week | SPX | 3364.158 |
| 2020-08-16 | week | SPX | 3385.858 |
| 2020-08-23 | week | SPX | 3497.965 |
To work with data in Mix Modeler, you need data collected in datasets and modeled after schemas in Experience Platform. The Mix Modeler interface provides easy access to both the Experience Platform Schemas and Datasets UI.