Marketing Cloud Intelligence Data Pipelines calculates popular industry measurements that you can use as data in 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 Impressions and Media Cost data, CPM appears. This table describes the available system calculated measurements and their formulas.
|
System Calculated Measurement |
Expression |
|---|---|
| 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 |
| 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 |