There are two ways to Integrate with Mortar MMM:
API Connectors in Mortar MMM: Integrate with all of your platforms directly in minutes and forget about it - In Development (speak to your Customer Success Representative)
Manually uploading CSVs exports: You can manually export CSVs from each and every platforms and upload them in Mortar MMM one by one to create your dataset.
A combination of both is as well possible, for instance by using API Connectors for the Digital Platforms and manual exports for Offline Campaigns such as TV.
API Connectors in Mortar MMM (In Development)
With the API connectors integrated into Mortar MMM, you will only need to connect to the desired platform, and Mortar MMM will automatically download and update the data.
Manual CSV Exports
If you have any of this data tracked in a CSV file or if you decide not to use the API connectors and therefore export your CSVs manually from each platform, you can upload them one by one in Mortar MMM and receive the complete Dataset automatically.
Important: note that this method will require you to repeat the process of exporting data from the platforms and then uploading it to Mortar MMM every time you want to update the data.
File Format Requirements
File Type: Only CSV files are accepted
Date Distribution: The file should be structured with dates distributed across rows. Avoid having dates in a single row.
Date format: The date is usually formatted as YYYY-MM-DD
Invalid characters: The numeric columns in the CSV must be exclusively numeric and must not contain special characters such as percentages (%) or currencies (£, $)
Aggregated rows or columns: The presence of aggregated rows or columns is not allowed
How to Export CSVs from Media Platforms
How to Export CSVs from Media Platforms
In general, to perform an export, the following steps should be followed:
Go to the analytics interface of the respective platform from which you wish to extract data.
Navigate to the section that allows you to build a custom report.
Select the fields you want to extract.
Choose the date range you want to extract.
Export it as a CSV.
How to Upload your CSVs in Mortar MMM
How to Upload your CSVs in Mortar MMM
To upload your CSVs, you can log in to Mortar MMM, access your project, click on Data Integration -> Upload CSVs -> Add a new CSV