Understanding Data Sources
When an element is added to a dashboard, you can select the data source you’d like to use to populate that element. You can choose from suggested data sources, select Elements to use another element on the page as your source, or choose Tables and Datasets, then Shared with me to use the Omeda provided data models.
Omeda Essential Data Sources
Email Performance Data Model
This data model includes the fields necessary to analyze email performance and deliverability data. The data model has two elements:
Email Data
Columns | Type | Description |
|---|---|---|
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Modal Type | Text | A label defining the category of the modal interaction. Used to support "Send to Audience Builder" functionality in dashboards. |
Communication Id | Number | Unique identifier for a single communication event (e.g., an individual email sent to one recipient). |
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Deployment Id | Number | Unique identifier for a specific deployment of an email. |
Designation Name | Text | Indicates the purpose of the Deployment Type (e.g., newsletter, marketing, events, subscription, surveys) |
Tracking Number | Text | External-facing identifier for an email deployment. Used in reporting and visible in Email Builder. |
Email Address | Text | Recipient's email address associated with the deployment. |
Deployment Name | Text | User-defined name for the deployment, typically created during deployment setup. |
Deployment Type | Text | Classification of deployment aligned to content themes or purpose. Also governs unsubscribe handling (e.g., newsletters, alerts, 3rd party). |
Designation Id | Number | System ID used to map deployment types to a designation. |
Sent Date Time | Date | Timestamp indicating when the deployment was sent. |
Opened Count | Number | Total number of times a recipient opened a given communication. |
Is Clicked | Logical | Indicates whether the recipient clicked any link in a given communication. |
Is Unsubscribed | Logical | Indicates if the recipient unsubscribed from this deployment type via the communication. |
Is Complaint | Logical | Indicates if the recipient marked the email as spam or blocked it via the communication. |
Deployment Type Id | Number | Numeric ID corresponding to the deployment type. |
Status | Number | Delivery status of the Communication |
Sending Domain | Text | Domain used to send the email (e.g., "news.omeda.com"). Useful for deliverability analysis. |
Is Bounce | Logical | Indicates whether the communication bounced. |
Is Customer Active | Logical | Reflects if the customer is currently active in the database. |
Sent Date | Date | Deployment date (without timestamp). |
Email Domain | Text | The domain of an email recipient. |
Email Domain Type | Text | Specifies whether an email domain indicates that the email address is a consumer email or a business email |
Refresh Date
Columns | Type | Description |
|---|---|---|
Data Refresh Date | Date | The date the dashboard data was last refreshed. |
CDP Data Model
This data model includes the fields necessary to analyze web behaviors. The data model has several elements:
Table of Contents
User Agent Metadata
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Customer Behavior Visit Id | Number | Unique identifier for a specific visit or interaction instance. |
Behavior Name | Text | The name of the Olytics-defined behavior triggered during the visit. |
Visit Date | Date | The timestamp when the visit occurred. |
Browser | Text | Browser type derived from the user agent string. Useful for identifying technical constraints or trends by platform. |
Device | Text | Device category (e.g., Desktop, Mobile, Tablet) as inferred from the user agent. Helps analyze engagement patterns by device. |
OS | Text | Operating system used during the visit, supporting segmentation by technology environment. |
Referring Domain | Text | The origin domain that referred the visitor (e.g., Google, newsletter). Helps evaluate traffic sources and attribution. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
UTM Parameter Values
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Customer Behavior Visit Id | Number | Unique identifier for a specific visit or interaction instance. |
Behavior Name | Text | The name of the Olytics-defined behavior triggered during the visit. |
Visit Date | Date | The timestamp when the visit occurred. |
Parameter Name | Text | The UTM parameter key captured during the visit (e.g., utm_source, utm_medium). Used to analyze marketing attribution and campaign performance. |
Parameter Value | Text | The corresponding value assigned to the UTM parameter (e.g., newsletter, social). Helps trace traffic sources, understand user acquisition paths, and segment audience behavior by campaign. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Page Engagement
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Customer Behavior Visit Id | Number | Unique identifier for a specific visit or interaction instance. |
Behavior Name | Text | The name of the Olytics-defined behavior triggered during the visit. |
Visit Date | Date | The timestamp when the visit occurred. |
Visitor Type | Text | Classification of the visitor as either known (identified via email, login, or subscription data) or unknown (anonymous web activity). |
Base URL | Text | The full URL path (excluding query parameters) of the page visited. Useful for content performance analysis and filtering by page category. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Attribute Data
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Customer Behavior Visit Id | Number | Unique identifier for a specific visit or interaction instance. |
Behavior Name | Text | The name of the Olytics-defined behavior triggered during the visit. |
Visit Date | Date | The timestamp when the visit occurred. |
Attribute Type Name | Text | The name of the behavioral or contextual attribute captured during the visit (e.g., Olytics Category, Olytics Tag). Used to enrich visit data with marketing, content, or audience metadata. |
Attribute Value Name | Text | The value associated with the captured attribute (e.g., article, organic, sports). |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Refresh Date
Columns | Type | Description |
|---|---|---|
Data Refresh Date | Date | The date the dashboard data was last refreshed. |
Subscriptions Data Model
This data model includes the fields necessary to analyze magazine subscriptions. The data model has several elements:
Subscription Customer Data
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Verification Date | Date | Date the most recent subscription documentation or confirmation was received from the subscriber. Validates the recency and compliance of the subscription. |
Changed Date | Date | The current format the subscriber is receiving their subscription in. eg Print, Digital, Both. |
Active Version | Text | The current format of the subscription delivery, e.g., "Print", "Digital", or "Both". |
Payment Status | Text | Billing classification of the subscription, such as "Controlled", "Paid with Order", "Credit", or "Free Term". |
Quantity | Number | Number of subscription units associated with this record (typically 1 unless a bulk or group subscription). |
Subscription Type | Text | Indicates whether the subscription is a first-time subscription ("Add") or a renewal. |
Renewal Code | Text | Instructions for renewal treatment. For example, "No Renewal" signals exclusion from renewal campaigns. |
Class Definition | Text | Subscription classification code that determines the active/inactive status. Examples include:
|
Source | Text | Origin or method of acquisition for the subscription. |
Payment Status Category | Text | Simplified description of whether the subscription is paid or non-paid, derived from Payment Status. |
Paid | Number | Numeric flag where 1 indicates the subscription is paid. |
Non Paid | Number | Numeric flag where 1 indicates the subscription is non-paid. |
Product | Text | The name of the subscribed product (e.g., magazine or digital publication title). |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Renewal Data
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Product | Text | The name of the subscribed product (e.g., magazine or digital publication title). |
Active Version | Text | The current format of the subscription delivery, e.g., "Print", "Digital", or "Both". |
Class Definition | Text | Subscription classification code that determines the active/inactive status. Examples include:
|
Source | Text | Origin or method of acquisition for the subscription. |
Group Category | Text | Indicates whether the subscription is held by an individual or part of a group account. |
Expire Issue Name | Text | The name of the issue corresponding to the expiration of the subscription, typically formatted as YYYYMM. |
Expire Date | Date | The scheduled date when the subscription will expire. Used for renewal forecasting and campaign planning. |
Expire Year | Number | The year portion of the subscription expiration date. Useful for year-over-year reporting or cohort analysis. |
Expiring - Add | Number | Numeric flag where 1 means the subscription is expiring and is a first-time (Add) subscription. |
Expiring - Renewal | Number | Numeric flag where 1 means the subscription is expiring and has been renewed previously. |
Renewed - Add | Number | Numeric flag where 1 means the subscription was renewed and this is the subscriber's first renewal. |
Renewed - Renewal | Number | Numeric flag where 1 means the subscription was renewed and the subscriber had previously renewed. |
Not Renewed - Add | Number | Numeric flag where 1 means the subscription was not renewed, and it was a first-time (Add) subscription. |
Not Renewed - Renewal | Number | Numeric flag where 1 means the subscription was not renewed, and it had previously been renewed. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Demographic Data
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Demographic Name | Text | The label or type of the demographic attribute (e.g., Job Title, Industry, Company Size). |
Demographic Value | Text | The subscriber-specific value assigned to the Demographic Name (e.g., Editor, Healthcare, 100-499 employees). |
Active Version | Text | The current format of the subscription delivery, e.g., "Print", "Digital", or "Both". |
Product | Text | The name of the subscribed product (e.g., magazine or digital publication title). |
Class Definition | Text | Subscription classification code that determines the active/inactive status. Examples include:
|
Source | Text | Origin or method of acquisition for the subscription. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
Account Data
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Product | Text | The name of the subscribed product (e.g., magazine or digital publication title). |
Active Version | Text | The current format of the subscription delivery, e.g., "Print", "Digital", or "Both". |
Class Definition | Text | Subscription classification code that determines the active/inactive status. Examples include:
|
Source | Text | Origin or method of acquisition for the subscription. |
Earning Date | Date | The date the revenue was recognized from the subscriber’s transaction. |
Amount | Number | The monetary amount of recognized earnings from the subscriber. |
Issue Name | Text | The name of the issue for which the earnings were recorded, typically formatted as YYYYMM. Supports period-based revenue analysis. |
Earning Account | Text | The internal financial account (e.g., department, GL code) to which the earnings are attributed. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |
AI Tagging Data Model
This data model includes the fields necessary to analyze AI Powered Content Tagging data. The data model has several elements:
Tag Table
Columns | Type | Description |
|---|---|---|
Customer Id | Number | Unique identifier for a customer in the Omeda database. |
Content Type | Text | Indicates the source of the content tag interaction, such as “Email” (from campaign deployments) or “Web” (from tagged pages via CDP). |
Category | Text | The content tagging category that groups the tag under a shared dimension (e.g., Context, Tone, Industry, Job Title, etc.). These are the AI-defined dimensions generated during content analysis. |
Tag | Text | The specific tag value assigned within a category—for example, "Casual" under Tone or "Healthcare" under Industry. |
Engagement Level | Text | Qualitative measure reflecting the user's level of interaction with content carrying this tag. Represents how recently and frequently the tag has been engaged. |
Affinity Level | Text | Qualitative score of how strongly a user aligns with or prefers content associated with this tag, based on their behavior in the last 90 days. |
Tag Engagement Weight | Number | Quantitative score indicating the user’s relative engagement intensity for the given tag. |
Tag Affinity Weight | Number | Quantitative score showing the user’s overall affinity for the tag over time. |
Modal Id | Number | Unique ID linking a dashboard action with Audience Builder. Required to enable direct "Send to Audience Builder" from dashboards. |