Marketing Cloud Intelligence calculates popular industry measurements that you can use as data in widgets, reports, and pivot tables. The measurements are calculated using fixed formulas using your workspace’s data. A measurement is available only if its formula’s components are mapped in an existing data stream. For example, if you uploaded a data source with MTC data, the MTC system calculated measurements appear. This table describes the available system calculated measurements and their formulas.
| System Calculated Measurement | Expression |
|---|---|
| buy data actualized cost daily | buy data recalculated_cost - buy data recalculated cost accumulative + delivery buy data actualized cost |
| buy data actualized cost share | buy data actualized cost * buy data share of total |
| buy data actualized cost total | buy data recalculated cost total +buy data fixed cost |
| buy data expected cost daily | buy data capped cost /buy data IO days |
| buy data remaining budget | buy data capped cost - buy data recalculated cost accumulative |
| company count | countdistinct('company_id') |
| conversion CPA | media cost / conversion total conversions |
| conversion rate | total conversions / impressions |
| conversion ROAS | conversion revenue / delivery media cost |
| conversion ROI | (conversion revenue - delivery media cost) / delivery media cost |
| CPC | media cost / clicks |
| CPE | media cost / total engagements |
| CPM | (media cost / impressions) * 1000 |
| CRM lead count | countdistinct('real_crm_lead_id') |
| CRM opportunity count | countdistinct('real_crm_opportunity_id') |
| CTR | clicks / impressions |
| customer count | countdistinct('customer_id') |
| data vendor cost total | media cost + data vendor cost 1 + data vendor cost 2 + data vendor cost 3 + data vendor cost 4 + data vendor cost 5 |
| dwell rate | impressions with dwell / impressions |
| interactions rate | interactions / impressions |
| page content count | countdistinct('competitive_page_content_key') |
| positions weighted | positions computed /delivery impressions |
| social engagement rate | social total engagement / impressions |
| social post engagement rate | social organic total engagement / social post impressions |
| social view duration | social minutes watched / social social views) * 60 |
| time on site average | time on site total / website visits |
| video completion 25% rate | video completions 25% / delivery impressions |
| video completion 50% rate | video completions 50% / impressions |
| video completion 75% rate | video completions 75% / impressions |
| video fully played rate | video fully played / impressions |
| video views rate | video views / impressions |
| viewability rate | viewed IAB impressions / measured IAB impressions |
| visitor bounce rate | visitor bounce / site visits |
| web analytics position weighted | web analytics position computed / search results impressions |
Depending on when your workspace was created, you could see email measurements or messaging measurements.
| System Calculated Measurement | Expression |
|---|---|
| email bounces rate daily | email total bounces daily / email send daily |
| email CTR | email clicked / email delivered |
| email CTR daily | email clicked daily / email delivered daily |
| email CTR to open | email clicks / email opened |
| email ctr to open daily | email clicked daily/ email opened daily |
| email delivery rate | email delivered / email sent |
| email delivery rate daily | email delivered daily / email send daily |
| email open rate | email opened / email delivered |
| email open rate daily | email opened daily/ email delivered daily |
| email total bounces | email soft bounces + email hard bounces |
| email total bounces daily | email soft bounces daily + email hard bounces daily |
| email unsubscribe rate | email unsubscribe / email delivered |
| email unsubscribes rate daily | email unsubscribe daily / email delivered daily |
| message CTOR | message users clicked / message users opened |
| message CTOR (lifetime) | email clicks / email opens |
| message CTR | message users clicked / email delivered daily |
| message CTR lifetime | email clicks/email delivered |
| message open rate lifetime | email opens / emails delivered |
| buy data group actualized cost | buy data group actualized cost * buy data group share of total |
| cost per engagement | media cost / social total engagement |
| cost per follow | media cost / social follows |
| cost per like | media cost / social page likes |
| CPCV | media cost / video fully played |
| CPV | media cost / video views |
| email bounce % | email total bounces / emails sent |
| net new fans | added fans - removed fans |
| post consumption frequency | social post consumptions (lifetime) / social post consumers (lifetime) |
| search CTR | search results clicks / search results impressions |
| social monitor total count | social monitor positive count + social monitor negative count + social monitor neutral count |
| viewable human impressions | human view impressions / view measurable impressions |
| viewable impressions | view impressions / view measurable impressions |
| views frequency | views /unique views |