You are here:
Creating an IO in the Media Transparency Center
Learn how to create an IO in the Media Transparency Center.
Marketing Cloud Intelligence Media Transparency Center allows integration of media buying information from a media buying system into your Marketing Cloud Intelligence account.
After the data is added to your account, Intelligence does all the complicated calculations for the defined date ranges, according to the specified cost type and given rate, taking into account parameters like monthly budget, booked units, and margins. This financial information is stored as IOs in Intelligence and uses the data that comes from the various delivery systems to recalculate the actual media cost.
There are two ways to create an IO key in the platform:
- Add it through the IO Management sub tab under the Media Transparency Center tab.
- Uploading Buy Data into the platform, through TotalConnect
Method 1: IO Management
- From the Connect & Mix tab, click Media Transparency Center.
- Select the IO Management sub tab.
- Click Add New.
In the General, Target Configuration, and Data sections:
- Enter the IO Key. The IO key is the unique id according to which the platform identifies the IO.
- Enter the IO Name.
- Choose the IO Cost Type – This is how your recalculated cost is calculated for the relevant delivery items.
- IO Start Date — The start and end date determines the time period of the delivery data to which the calculations in the IO are relevant. You can’t set a time range of more than three years for the IO — the date picker won’t allow you to set an end date that exceeds this time range.
- Select the IO Target Type - This defines the target for the IO.
- Enter the IO Target Value that is used to measure the actual value against the margin.
- IO Rate — Enter the rate that defines the cost of a single unit your cost type refers to (for example, a Click in the case of a CPC). However, if your cost type is dCPM or dCPC you don't need to add a rate value.
- IO Capped Cost — Enter the capped cost for this IO that defines its budget limits.
- IO Booked Units — Enter the booked units for this IO. This sets its delivery limits (for example, booked impressions).
- IO Margin Rate — If a margin exists in your calculations, add it here. This margin is applied on top of the recalculated cost.
- IO Group Name — If you want to include this IO in a group, enter the group name here. Groups allow you to view the IO Measurements on a higher level using IO Group Measurements.
- IO Group Capped Cost is the Capped Cost of the group level. It’s unrelated to the IO Capped Cost, meaning it won’t sum up the IO capped Costs, but apply a separate capping at the IO Group level.
Method 2: Upload Buy Data with TotalConnect
- From the Connect & Mix tab, add a data stream through Total Connect.
- For Data Stream type select Buy Data.
- Enter the Data Stream Source. The file should have the fields specified in the IO Management subtab as described earlier.
- Concerning the IO start and end dates, the limit for three years’ time range for an IO still stands. If the source file contains IO with a time range that exceeds three years, the processing of the file will be successful, however, the Problematic end date will be altered.
The Buy Data bucket maps the IO fields and create the IO entities automatically in the Media Transparency Center.
Sometimes the cost type value in the original file doesn’t match the preset ones in the platform. In these cases you can use the following formula (in this example for FLAT cost type):
IF(csv['RATE_TYPE'] == 'Flat Rate','FLAT',csv['RATE_TYPE'])
Where:
- RATE_TYPE: is the name of the field in your file.
- "Flat Rate": is how it appears in your file.
- "FLAT": is the Marketing Cloud Intelligence value to convert to.
Now you can:
- Create an IO in the Media Transparency Center IO Management screen.
- Create an IO in the Media Transparency Center using a file upload.
