B2B Analytics playbook
Oracle Unity analytics widgets have multiple metrics for calculating analytics data. These widgets need to bring in data for the metrics from various data objects and attributes in the Oracle Unity data model. To properly display data for these widgets and metrics, you need to map out how to link your organization's customer data to Oracle Unity data model objects and attributes. This document explains how the data needs to be mapped.
Note: The campaign data used for creating the widgets is imported from Oracle Eloqua.
Once the data is properly configured, it will be displayed in the following pages: Home page, One time campaigns, Recurring campaigns, Campaign analysis.
To learn more about importing data into Oracle Unity, refer to the following:
Subtype attribute
The Order Item data object uses the Subtype attribute to identify the status of an order.
There are four attribute values for Subtype:
- Demand (an order was placed but not shipped),
- Shipped (item was sent to customer),
- Canceled (order was canceled before it was shipped),
- Returned (order was received then canceled).
To correctly configure the data for this attribute, every change in order status needs to generate a new record and not override an older order status record. For example, for every Returned value, there will also have to be a record for Demand and Shipped.
Medium, Target, and Type attributes
Email is a ready-to-use attribute value for the Medium and Target attributes.
The Type attribute has the following ready-to-use attribute values:
- Sent
- Opened
- Clicked
- Bounced
- Subscribed
- Unsubscribed
- Spam
Key metrics widget
The Key metrics widget displays important customer metrics to your organization and allows you to assess the current state of your customer base.
To display six time periods in the widget, at least six months of historical data needs to be imported into Oracle Unity.
Data requirements
You can select to map out any of the following metrics so that they appear in the widget.
| Metric | Data object | Attributes | Attribute values | Calculation |
|---|---|---|---|---|
| Bounce rate (email) | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
Bounced/Sent x 100 |
| Click rate (email) | Event | Medium Target Type |
Email for Medium and Target Clicked and Sent for Type |
Clicked/Sent x 100 |
| Click to open rate | Event | Medium Target Type |
Email for Medium and Target Opened and Clicked for Type |
Clicked/Opened x 100 |
| Delivery rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
TotalDelivered/forSentCount x 100 |
| Engaged contacts | Event | Type | Opened, Clicked, Viewed, Subscribed, Downloaded, Added, Liked, and Created for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forEngagedCustomers) |
| Form submission rate | Event | Medium Target Type |
Form and Email for Target Web and Email for Medium Submitted and Sent for Type |
COUNT(DISTINCT forFormSubmitCount)/COUNT(DISTINCT forTargetedCount) x 100 |
| Open rate (email) | Event | Medium Target Type |
Email for Medium and Target Sent and Opened for Type |
Opened/Sent x 100 |
| Page views | Event | Medium Target Type |
Page for Target Web for Mediumt Viewed for Type |
COUNT(DISTINCT forPageViewCount) |
| Productive clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
SUM(forClickedCount) - COUNT(DISTINCT forOptOutCount) |
| Subscribed | Event | Medium Target Type |
Email for Medium and Target Subscribed for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forOptInCount) |
| Total clicks | Event | Medium Target Type |
Email for Medium and Target Clicked for Type |
SUM(forClickedCount) |
| Total completed forms | Event | Medium Target Type |
Form for Target Web for Mediumt Submitted for Type |
COUNT(forFormSubmitCount) |
| Total delivered | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
SUM(forSentCount) - COUNT(forBouncedCount) |
| Unique clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
COUNT(DISTINCT forClickCount) - COUNT(DISTINCT forOptOutCount) |
| Unique opens | Event | Medium Target Type |
Email for Medium and Target Opened for Type |
COUNT(DISTINCT forReachedCount) |
| Unsubscribed | Event | Medium Target Type |
Email for Medium and Target Unsubscribed for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forOptOutCount) |
| Web visitors | Event | Medium Target Type |
Site for Target Web for Mediumt Visited for Type |
COUNT(DISTINCT forWebVisitCount) |
| Web visits | Event | Medium Target Type |
Site for Target Web for Mediumt Visited for Type |
SUM( forWebVisitedCount) |
One time campaigns data
One time campaigns data is available in the following areas: the One time campaigns widget on the Analytics dashboard, the One time campaigns page, and the Campaign analysis page.
One time campaigns widget
The One time campaigns widget displays the performance of the 10 most recent one time campaigns that occurred in the past 90 days.
A one-time campaign is a campaign that is created for a specific marketing event, and all sent events are sent within seven days of the campaign launch date. The launch date is determined by the date the first event was sent.
The One time campaigns widget has the following metrics:
-
Bounce rate
-
Click rate
-
Click to open rate
-
Contact count
-
Delivery rate
-
Form submission rate
-
Open rate
-
Productive clicks
-
Total clicks
-
Total delivered
-
Unique clicks
-
Unique opens
One time campaigns page
The One time campaigns page gives a more expansive look at metrics for each one time campaign.
The One time campaigns page has the following metrics:
-
Bounce rate
-
Channel
-
Click rate
-
Click to open rate
-
Contact count
-
Delivery rate
-
Form submission rate
-
Open rate
-
Productive clicks
-
Total clicks
-
Total delivered
-
Unique clicks
-
Unique opens
Campaign analysis page
The Campaign analysis page allows you to investigate problematic campaigns, identify the groups of contacts that are responsible for the poor performance, and re-target the problematic contacts.
The Campaign analysis page has the following metrics:
-
Click rate
-
Click to open rate
-
Form submission rate
-
Open rate
-
Productive clicks
-
Total clicks
-
Unique clicks
-
Unique opens
One time campaign metrics
Review the requirements for one time campaign metrics.
| Metric | Data object | Attributes | Attribute values | Calculation |
|---|---|---|---|---|
| Bounce rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
Bounced/Sent x 100 |
| Channel | Event | Channel | Channel | |
| Click rate (email) | Event | Medium Target Type |
Email for Medium and Target Clicked and Sent for Type |
Clicked/Sent x 100 |
| Click to open rate (email) | Event | Medium Target Type |
Email for Medium and Target Opened and Clicked for Type |
Clicked/Opened x 100 |
| Contact count | Event | Medium Target Type |
Email for Medium and Target Sent for Type |
COUNT(DISTINCT ForTargetedCount) |
| Delivery rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
TotalDelivered/forSentCount x 100 |
| Form submission rate | Event | Medium Target Type |
Form and Email for Target Web and Email for Mediumt Submitted and Sent for Type |
COUNT(DISTINCT forFormSubmitCount)/COUNT(DISTINCT forTargetedCount) x 100 |
| Open rate (email) | Event | Medium Target Type |
Email for Medium and Target Sent and Opened for Type |
Opened/Sent x 100 |
| Productive clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
SUM(forClickedCount) - COUNT(DISTINCT forOptOutCount) |
| Total clicks | Event | Medium Target Type |
Email for Medium and Target Clicked for Type |
SUM(forClickedCount) |
| Total delivered | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
SUM(forSentCount) - COUNT(forBouncedCount) |
| Unique clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
COUNT(DISTINCT forClickCount) - COUNT(DISTINCT forOptOutCount) |
| Unique opens | Event | Medium Target Type |
Email for Medium and Target Opened for Type |
COUNT(DISTINCT forReachedCount) |
Recurring campaigns data (widget and performance page)
Recurring campaigns data is available in the following areas: the Recurring campaigns widget on the Analytics dashboard and the Recurring campaigns page.
Recurring campaigns widget
The Recurring campaigns widget displays the performance of active recurring campaigns, which are campaigns that have had triggered events in the time period selected and also the time period prior to that triggered event. The launch date is determined by the date the first event was sent.
A recurring campaign is a campaign whose marketing messages are sent based on triggers of a customer's behavior or their profile.
The Recurring campaigns widget has the following metrics:
-
Bounce rate
-
Click rate
-
Click to open rate
-
Contact count
-
Delivery rate
-
Open rate
-
Productive clicks
-
Total clicks
-
Total delivered
-
Unique clicks
-
Unique opens
Recurring campaigns page
The Recurring campaigns page gives a more expansive look at metrics for each active recurring campaign.
The Recurring campaigns page has the following metrics:
-
Click rate
-
Delivery rate
-
Open rate
-
Productive clicks
Recurring campaign metrics
Review the requirements for recurring campaign metrics.
| Metric | Data object | Attributes | Attribute values | Calculation |
|---|---|---|---|---|
| Bounce rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
Bounced/Sent x 100 |
| Click rate | Event | Medium Target Type |
Email for Medium and Target Clicked and Sent for Type |
Clicked/Sent x 100 |
| Click to open rate | Event | Medium Target Type |
Email for Medium and Target Opened and Clicked for Type |
Clicked/Opened x 100 |
| Contact count | Event | Medium Target Type |
Email for Medium and Target Sent for Type |
COUNT(DISTINCT ForTargetedCount) |
| Delivery rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
TotalDelivered/forSentCount x 100 |
| Open rate | Event | Medium Target Type |
Email for Medium and Target Sent and Opened for Type |
Opened/Sent x 100 |
| Productive clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
SUM(forClickedCount) - COUNT(DISTINCT forOptOutCount) |
| Total clicks | Event | Medium Target Type |
Email for Medium and Target Clicked for Type |
SUM(forClickedCount) |
| Total delivered | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
SUM(forSentCount) - COUNT(forBouncedCount) |
| Unique clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
COUNT(DISTINCT forClickCount) - COUNT(DISTINCT forOptOutCount) |
| Unique opens | Event | Medium Target Type |
Email for Medium and Target Opened for Type |
COUNT(DISTINCT forReachedCount) |
Comparative Trends widget
The Comparative trends widget widget displays trends of up to four metrics over time. The graph in the widget displays the percentage change of the metric compared to the previous time period.
| Metric | Data objects | Attributes | Attribute values | Calculation |
|---|---|---|---|---|
| Bounce rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
Bounced/Sent x 100 |
| Click rate | Event | Medium Target Type |
Email for Medium and Target Clicked and Sent for Type |
Clicked/Sent x 100 |
| Click to open rate | Event | Medium Target Type |
Email for Medium and Target Opened and Clicked for Type |
Clicked/Opened x 100 |
| Contact count | Event | Medium Target Type |
Email for Medium and Target Sent for Type |
COUNT(DISTINCT ForTargetedCount) |
| Delivery rate | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
TotalDelivered/forSentCount x 100 |
| Engaged contacts | Event | Type | Opened, Clicked, Viewed, Subscribed, Downloaded, Added, Liked, and Created for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forEngagedCustomers) |
| Open rate | Event | Medium Target Type |
Email for Medium and Target Sent and Opened for Type |
Opened/Sent x 100 |
| Page views | Event | Medium Target Type |
Page for Target Web for Medium Viewed for Type |
COUNT(DISTINCT forPageViewCount) |
| Productive clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
SUM(forClickedCount) - COUNT(DISTINCT forOptOutCount) |
| Subscribed | Event | Medium Target Type |
Email for Medium and Target Subscribed for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forOptInCount) |
| Total clicks | Event | Medium Target Type |
Email for Medium and Target Clicked for Type |
SUM(forClickedCount) |
| Total completed forms | Event | Medium Target Type |
Form for Target Web for Medium Submitted for Type |
COUNT(forFormSubmitCount) |
| Total delivered | Event | Medium Target Type |
Email for Medium and Target Bounced and Sent for Type |
SUM(forSentCount) - COUNT(forBouncedCount) |
| Unique clicks | Event | Medium Target Type |
Email for Medium and Target Clicked and Unsubscribed for Type |
COUNT(DISTINCT forClickCount) - COUNT(DISTINCT forOptOutCount) |
| Unique opens | Event | Medium Target Type |
Email for Medium and Target Opened for Type |
COUNT(DISTINCT forReachedCount) |
| Unsubscribed | Event | Medium Target Type |
Email for Medium and Target Unsubscribed for Type You can create custom events with custom attribute values for your remaining marketing channels |
COUNT(DISTINCT forOptOutCount) |
| Web visitors | Event | Medium Target Type |
Site for Target Web for Medium Visited for Type |
COUNT(DISTINCT forWebVisitCount) |
| Web visits | Event | Medium Target Type |
Site for Target Web for Medium Visited for Type |
SUM( forWebVisitedCount) |
Top Products widget
The Top products widget widget displays information on the top-performing products based on the metric and time period selected.
For the Revenue metric, two data objects are needed: Organization and Order Item. The Order Item data object has a relationship with the Organization data object and they are both linked through the SourceOrganizationID attribute. Make sure that the SourceOrganization attribute in the Order Item data object has up-to-date records so that the data between the two data objects is properly linked.
| Metric | Data objects | Attributes | Attribute values | Calculation |
|---|---|---|---|---|
| Average order value | Order Item |
Subtype Extended price |
Shipped for Subtype Total amount for Extended price |
Sum of Total amount/Sum of Shipped values |
| Orders | Organization Order Item |
Type for Organization Subtype for Order Item |
Online and In-store for Type Shipped or Demand for Subtype |
Sum of Shipped or Demand values |
| Returns | Order Item | Subtype | Returned | Derived from total_return_count from MasterCustomer total_return_count is derived as a metric from total_return_count from CA_OrderItem cube total_return_count metric in the cube is calculated as COUNT_DISTINCT(return_orderid) return_orderid is OrderItem.orderid when OrderItem.SubType = Returned |
| Revenue | Organization Order Item |
Type for Organization Extended Price and Subtype for Order Item |
Online and In-store for Type Shipped and Returned for Subtype Total amount for Extended Price |
Sum of Total amount values with Shipped and Returned attribute values |