Ingest data
Mix Modeler works with event level data, aggregate oe 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 Adobe Analytics source connector and transformed into datasets conforming to the default or a custom version of the Adobe 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-12 1-row-12 2-row-12 3-row-12 4-row-12 5-row-12 2-align-left 4-align-center 6-align-right 8-align-right 12-align-right 15-align-left 17-align-center 19-align-right 21-align-right 25-align-right 28-align-left 30-align-center 32-align-right 34-align-right 38-align-right 41-align-left 43-align-center 45-align-right 47-align-right 51-align-right 54-align-left 56-align-center 58-align-right 60-align-right 64-align-right 67-align-left 69-align-center 71-align-right 73-align-right 77-align-right layout-auto | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Geo | Date | Date Type | Channel | Campaign | Click | Earned | Engagement | Impression | Open | Owned | Sent |
| AMER | 2021-10-31 | day | 12752 | 1132945 | |||||||
| AMER | 2021-10-31 | day | FB | 148844 | |||||||
| AMER | 2021-10-31 | day | YT | 2314452 | |||||||
| JPN | 2021-10-21 | day | 21089 | 3283626 | |||||||
| JPN | 2021-10-21 | day | SOCIAL | 621 |
| 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.