| Dimension Name | Type | Description |
|---|---|---|
| IO Key | Text | A unique identification for the specific IO |
| IO Name | Text | The name that will help describe and identify the IO in Marketing Cloud Intelligence |
| IO Cost Type | Text |
Can be one of the following types which will define how Recalculated Cost (see further down) will be calculated for the relevant IO items (see below):
This list can also contain custom cost types as defined in the workspace Settings > Media Transparency Center > Custom Cost Types The following formula can be used in as part of the mapping process in order to match a cost type to the preset ones in Marketing Cloud Intelligence: IF(csv['RATE_TYPE'] == "Flat Rate","FLAT",csv['RATE_TYPE']) Where:
|
| IO Start Date | Date | The start date of the IO. The calculations defined by this IO will be relevant for delivery data after this date. |
| IO End Date | Date | The end date of the IO. The calculations defined by this IO will be relevant for delivery data before this date. |
| IO Target Type | Text |
Can be one of the following types which will define the target for the IO in the Margin Adjustment tab.
This list can also contain custom target types as defined in the workspace Settings > Media Transparency Center > Custom Target Types |
| IO Target Value | Number | The target value that will be used to measure the actual value against in the Margin Adjustment tab for an IO. |
| IO Rate | Number | The rate that will be used for most cost types calculations (as described above) |
| IO Capped Cost | Number | The planned budget for this IO |
| IO Group Capped Cost | Number | An IO Group planned budget, separate from the IO capping. |
| IO Booked Units | Number | The booked units for this IO — the amount of booked impressions for a CPM based IO |
| IO Fixed Cost | Number | The fixed cost that will be used for Flat cost type calculation only. |
| IO Margin Rate | Number |
The margin that will be used on top of the recalculated cost. Note: When Margin Rate is uploaded as part of a TotalConnect Data Stream, it must be a numeric value between 0 and 1. For example to apply a 10% margin the uploaded value should be 0.1. |
| IO Custom Attribute 1,2,...,60 | Text | These additional attributes can contain any additional information to group and filter the IOs. |
| Conversion Tag Key | Text | List of Conversion Tag Keys which if set will define the conversions that will attributed to the IO, this will be used to calculate cost for CPA IOs |
| Items | Text | List of Media Buy Keys or Campaign and Site Keys that will define the delivery data that will be attributed to this IO |
| Measurement Name | Type |
Aggregation Function |
Description |
|---|---|---|---|
| IO Actualized Cost (Accumulative) | The sum of the IO Actualized cost up until the row’s date. | ||
| Actualized Cost |
IO Share of Total * IO Actualized Cost (Accumulative) will give the assumed actual cost of the delivery item. Calculation: IO Actualized Cost * (Recalculated cost/Recalculated Cost (total)) If the IO has a FLAT rate the calculation will be: IO Actualized Cost * (Impression/Impressions (total)) In other words, if there are no Impressions the value will be "0" Can be used with: IO dimensions, Dates, IO items (Media Buy, Site, Campaign) |
||
| IO Actualized Cost By Day | Currency |
The daily cost up to the point where the IO Capped Cost was reached. On the specific day when that happened it will contain the remaining budget up to the capped cost. On the next days, the measurement will contain zero cost. The idea behind this metric is to show the IO’s total cost up to a given day. The formula behind this measurement is: Recalculated Cost - Recalculated Cost (Accumulative) + Actualized Cost (Accumulative) Returns 0 if the calculation results in a negative value. Can be used with: IO Dimensions, Dates, IO items (Media Buy, Site, Campaign) |
|
| IO Group Actualized Cost | Currency |
IO Group Share of Total * IO Group Actualized Cost (Accumulative) gives the assumed actual cost of the delivery item when looking at the IO group level. Can be used with: IO dimensions, delivery entities, Dates |
|
| IO Group Actualized Cost (Accumulative) | Currency |
The sum of the IO Group’s Actualized cost up until the row’s date. Can be used with: IO dimensions, Dates |
|
| IO Group Actualized Cost (Total) - | Currency | The total of IO Group Actualized Cost. Used for calculations | |
| IO Booked Units | Number | LIFETIME |
Always includes the booked units as defined on the IO Can be used with: IO dimensions, Dates, IO items (Media Buy, Site, Campaign) |
| IO Booked Units (Accumulative) | Number | LIFETIME |
The IO Booked Units, divided by the amount of days between IO Start Date and IO End Date, multiplied by the amount of elapsed days from IO Start Day to a given day. Can be used with: IO dimensions, Dates |
| IO Capped Cost | Currency | LIFETIME |
Always includes the capped cost as defined on the IO. Can be used with: IO dimensions, Dates |
| IO Group Capped Cost | currency | LIFETIME |
Always includes the group capped cost as defined on the IO level, at the IO Group Capped Cost field. This is a separate value from the IO capped cost, meaning it will not sum up the IO capped Costs, but apply a separate capping at the IO Group level. Can be used with: IO dimensions, Dates |
| IO days | Number | MIN | Total amount of days between the IO start date and end date |
| IO Expected Cost (Accumulative) | Currency | LIFETIME |
The IO Capped Cost, divided by the amount of days between IO Start Date and IO End Date, multiplied by the amount of elapsed days from IO start day to a given day. Can be used with: IO dimensions, Dates |
| IO Expected Cost (Daily) | Currency | Is calculated as [Capped Cost]/ [IO Days] | |
| IO Margin Rate (Daily) | Number | AVG | The IO’s Daily Margin as set in the Margin Adjustment tab |
| IO Media Cost Margin | Currency | SUM |
The margin per media buy, data uploaded by the user. When this data is mapped the recalculated cost is calculated - cost/(1- IO Margin Rate) + Media Buy Margin |
| IO Total Margin | Currency | SUM | Is calculated- [Media Buy Margin (currency) + IO Margin Rate (currency)]/recalculated cost (no margin) |
| IO Media Cost (Accumulative) | Currency | LIFETIME |
The sum of the Media Cost up until the row’s date. Can be used with: IO dimensions, Dates |
| IO Group Media Cost (Accumulative) | Currency | LIFETIME |
The sum of the IO Group’s Media Cost cost up until the row’s date. Can be used with: IO dimensions, Dates |
| IO Recalculated Cost (no margin) | Currency | SUM |
The IO Recalculated Cost without the addition of the margin. Depends on the cost type that was defined in the IO Cost Type (see above) and is calculated for the relevant IO items:
If a value exists in the IO Margin field, this Margin will be added to the above calculated cost. Can be used with: IO dimensions, IO items (Media Buy, Site, Campaign), Dates |
| IO Recalculated Cost | Currency | SUM |
The IO Recalculated Cost (No Margin) including the margin: IO Recalculated Cost (No Margin) / (1 - Margin) |
| IO Recalculated Cost (Accumulative) | Currency | LIFETIME |
The sum of the IO Recalculated cost from the IO’s start date, up until the current row’s date or the IO’s end date. Can be used with: IO dimensions, Dates |
| IO Group Recalculated Cost (Accumulative) | Currency | LIFETIME |
The sum of the IO Group Recalculated cost up until the row’s date Can be used with: IO dimensions, Dates |
| IO Group Recalculated Cost (Total) | Currency |
The total of the IO Group Recalculated Cost (Accumulative). Used for calculations. |
|
| IO Remaining Budget | Currency |
The IO's remaining budget for a given point in time. The formula behind this measurement is: IO Capped Cost - Actualized Cost (Accumulative) Can be used with: IO dimensions, Dates |
|
| IO Share Of Total |
Recalculated Cost of the Table Item (each row) / IO Recalculated Cost (Total) For FLAT rate: Impressions for the Delivery Unit/ Total Impression of the IO |
||
| IO Group Share Of Total | Recalculated Cost of the item/IO Group Recalculated Cost (Total) |