CRM Deal-Contact Associations
CRM deal-to-contact associations where native contact IDs are available
Deal Amount
CRM deal amount for monetary CRM opportunities; FranConnect lead rows have no amount
Deal Count
CRM deals or franchise-sales leads at deal grain
Weighted Pipeline
Pipeline amount weighted by stage probability
Win Rate
Closed-won deals divided by all closed deals
Won Deals
Deals marked closed-won at the CRM stage outcome
Deal-Account Associations
CRM deal-to-account associations where native account IDs are available
Deal Associations
CRM deal association rows or summary counts, summed per deal
Deal-Contact Associations
CRM deal-to-contact associations where native contact IDs are available
Average Lead Score
Average native lead score across CRM leads that provide a score
Converted Leads
CRM leads or contacts marked converted by native or inferred lifecycle evidence
Customer-Matched Leads
CRM leads or contacts that resolve to ecommerce customer identity
Lead Conversion Rate
Converted CRM leads divided by all CRM leads
Lead Count
CRM leads or contacts at lead/contact grain
Lead Customer Match Rate
CRM leads matched to ecommerce customers divided by all CRM leads
Lead Qualification Rate
Qualified CRM leads divided by all CRM leads
MQL Leads
CRM leads or contacts whose conformed lifecycle stage is marketing-qualified lead
MQL Rate
Marketing-qualified CRM leads divided by all CRM leads
Qualified Leads
CRM leads or contacts marked qualified by native or inferred lifecycle evidence
SQL Leads
CRM leads or contacts whose conformed lifecycle stage is sales-qualified lead
SQL Rate
Sales-qualified CRM leads divided by all CRM leads
CRM Current Stage Observations
Current-stage snapshot observations in the CRM stage history surface
CRM Stage Events
CRM stage/property history events plus current-stage observations
Snapshot Closed Amount
Cumulative closed deal amount as of the snapshot date.
Snapshot Deal Count
Deals in the stage as of the snapshot date.
Lost Deals (Snapshot)
Cumulative closed-lost deals as of each snapshot date
Open Pipeline Value
Open deal amount in the pipeline as of each snapshot date
Open Deals (Snapshot)
Open deals in the pipeline as of each snapshot date
Weighted Pipeline (Snapshot)
Probability-weighted open pipeline value as of each snapshot date
Won Deals (Snapshot)
Cumulative closed-won deals as of each snapshot date
Attributed Closed CRM Deals
Closed CRM deals with deterministic campaign attribution matched to paid delivery
Attributed CRM Deals
CRM deals with deterministic campaign attribution matched to paid delivery
Attributed Won CRM Deals
Won CRM deals with deterministic campaign attribution matched to paid delivery
Paid CRM Clicks
Paid-media clicks represented in the paid-to-CRM surface
Paid CRM Cost per Deal
Paid spend divided by attributed CRM deals
Paid CRM Cost per Won Deal
Paid spend divided by attributed won CRM deals
Deterministically Matched CRM Deals
Attributed deals backed by a deterministic identity match
Paid CRM Impressions
Paid-media impressions represented in the paid-to-CRM surface
Paid CRM Spend
Paid-media spend on campaign-day rows with CRM attribution coverage; group or filter by spend_currency
Attributed Closed Deals
Closed CRM deals with deterministic campaign attribution matched to paid delivery
Attributed Deals
CRM deals with deterministic campaign attribution matched to paid delivery
Attributed Won Deals
Won CRM deals with deterministic campaign attribution matched to paid delivery
Deterministically Matched Deals
Attributed deals backed by a deterministic identity match
Email Attributed Orders
Orders attributed to the send by the email platform.
Email Attributed Revenue
Revenue attributed to the send by the email platform.
Email Bounces
Bounced emails from connected email send performance rows
Click Rate
Unique clicks divided by emails delivered
Email Clicks
Email clicks including repeat clicks at send grain
Open Rate
Unique opens divided by emails delivered
Email Opens
Email opens including repeat opens at send grain
Email Replies
Replies received from connected email send performance rows.
Email Spam Reports
Spam or abuse reports from connected email send performance rows.
Unique Clicks
Unique recipients or profiles that clicked at send grain
Unique Opens
Unique recipients or profiles that opened at send grain
Email Unsubscribes
Unsubscribes from connected email send performance rows
Emails Delivered
Emails delivered by connected email platforms at send grain
Emails Sent
Emails sent by connected email platforms at send grain
Iterable Conversions
Conversions reported by Iterable
Iterable Message Bounces
Message bounces reported by Iterable
Iterable Message Clicks
Message clicks reported by Iterable
Iterable Message Opens
Message opens reported by Iterable
Iterable Messages Sent
Messages sent by Iterable
Iterable Revenue
Revenue attributed by Iterable
Iterable SMS Bounces
SMS bounces reported by Iterable
Iterable Unsubscribes
Unsubscribes reported by Iterable
Push Message Bounces
Push bounces across connected messaging platforms
Push Message Opens
Push opens across connected messaging platforms
Push Messages Sent
Push messages sent across connected messaging platforms
SMS Messages Received
SMS messages received across connected messaging platforms
SMS Messages Sent
SMS messages sent across connected messaging platforms
Message Unsubscribe Event Count
SMS Attributed Orders
Orders attributed to SMS sends
SMS Attributed Revenue
Revenue attributed to SMS sends
SMS Bounces
SMS message bounces across connected messaging platforms
SMS Clicks
SMS message clicks across connected messaging platforms
SMS Delivered
SMS messages delivered across connected messaging platforms
SMS Unsubscribes
SMS unsubscribes across connected messaging platforms
Message Attributed Orders
Orders attributed to the send by the messaging platform. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Email and SMS platforms report attributed ecommerce orders; Iterable rows use Iterable purchases.
Message Attributed Revenue
Revenue attributed to the send by the messaging platform. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider.
Message Bounces
Bounced messages at send grain across email, SMS and push. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider.
Message Clicks
Clicks including repeat clicks at send grain across email, SMS and push. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider.
Message Conversions
Conversions reported by the messaging platform. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Definitions differ by provider: Iterable email rows carry Iterable custom conversion events, while email-platform and SMS-platform rows carry attributed orders (equal to message_attributed_orders). Filter platform = iterable for Iterable conversions.
Message Opens
Opens including repeat opens at send grain. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Email opens are pixel opens (inflated by privacy proxies such as Apple MPP); push opens are app opens from a notification; SMS rows carry no opens. Do not compare open counts across channels; filter channel = email for email opens.
Message Replies
Replies received from connected send performance rows. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Only email-platform rows populate replies.
Message Spam Reports
Spam or abuse reports (complaints) from connected send performance rows. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Iterable complaints are reported as spam reports; SMS and push rows carry none.
Unique Clicks
Unique recipients or profiles that clicked at send grain. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. SMS-platform rows report no unique clicks and carry total clicks instead (unique_clicks = clicks), and Iterable rows are 0; filter channel = email for true email unique clicks.
Unique Opens
Unique recipients or profiles that opened at send grain. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Only email-platform rows populate unique opens (Iterable, SMS and push rows are 0), so the total equals email unique opens.
Message Unsubscribes
Unsubscribes attributed to sends across email, SMS and push. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Counts unsubscribers, not unsubscribe events (see message_unsubscribe_event_count).
Messages Delivered
Messages delivered at send grain across email, SMS and push. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Email-platform and SMS-platform rows report native delivered counts; Iterable email, SMS and push rows derive delivered as sent minus bounces.
Messages Received
Inbound SMS messages received across connected messaging platforms. Only SMS rows populate this measure. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider.
Messages Sent
Messages sent at send grain across email, SMS and push. channel (email|sms|push) and platform are dimensions: filter or group by them for a single channel or provider. Filter channel = email for emails sent.
List Campaigns
Campaigns associated with the current provider lists
Cleaned Contacts
Current cleaned or invalid contacts represented by provider lists
Highly Engaged Contacts
Current contacts in the provider highly-engaged segment
Email List Leads
Current contacts classified as leads by the provider
Low-engaged Contacts
Current contacts in the provider low-engagement segment
Moderately Engaged Contacts
Current contacts in the provider moderately-engaged segment
Never-engaged Contacts
Current contacts with no observed engagement in the provider list
Opted-out Contacts
Current opted-out or suppressed contacts represented by provider lists
Subscribed Contacts
Current subscribed contacts represented by provider lists
List Contacts
Current contacts represented by provider lists
Unsubscribed Contacts
Current unsubscribed contacts represented by provider lists
VIP Contacts
Current contacts marked VIP by the provider
Conversion Weight (First Touch)
Fractional conversion credit under the first-touch model by conversion touchpoint
Conversion Weight (Last Touch)
Fractional conversion credit under the last-touch model by conversion touchpoint
Conversion Weight (Linear)
Fractional conversion credit under the linear model by conversion touchpoint
Conversion Weight (Markov)
Fractional conversion credit under the data-driven Markov removal-effect model by conversion touchpoint
Conversion Weight (Position Based)
Fractional conversion credit under the position-based model by conversion touchpoint
Conversion Weight (Shapley)
Fractional conversion credit under the data-driven Shapley-value model by conversion touchpoint
Conversion Weight (Time Decay)
Fractional conversion credit under the time-decay model by conversion touchpoint
Conversion Events
Canonical conversion/lead events counted through normalized last-touch weights
Answered Interactions
Source-neutral interactions that were answered
Average Answered Interaction Duration
Average duration in seconds among answered interactions
Avg Session Duration (s)
Average session duration in seconds with each session counted once
First-Touch Events
Touchpoints that opened a session
Interaction Answer Rate
Share of represented interactions that were answered
Interactions
Source-neutral interactions represented as attribution touchpoints
Last-Touch Events
Touchpoints that closed a session
Missed Interactions
Phone interactions that were neither answered nor sent to voicemail
Total Interaction Duration
Total interaction duration in seconds
Touchpoints
Journey touchpoint events recorded before conversion credit allocation
Voicemail Interactions
Source-neutral interactions that reached voicemail