Closed-loop reporting
The following reports for closed-loop reporting show the opportunities, the cost and revenue associated with campaigns within a specified time frame, and help you answer the following questions:
- Campaign Cost Metrics: How much did this campaign cost?
- Campaign Revenue Analysis: How much revenue did it create?
- Opportunity Overview: What campaigns are driving the greatest ROI?
Learn more by watching the video!
Folder location:
- Catalog/Shared Folders/Closed-Loop Reporting
Subject areas:
- Opportunity by Created Date, Campaign Revenue Analysis
Salesforce and CRM
Important: The setup of Salesforce and CRM is important to reporting functions, so a services organization should set them up. However, Oracle Eloqua does not offer support for the creation of custom attribution models. For more details, see Closed-loop reporting with Salesforce.
Oracle CX Sales
Important: Oracle Sales was formerly known as Oracle Sales Cloud. All instances of Oracle Sales Cloud have been changed to Oracle Sales across the app user interface.
Data imported by the Oracle CX Sales Integration app is required to populate closed-loop reporting data for Oracle CX Sales opportunities.
Learn more: For more details about setting up CRM integration, see Campaign response rules for CRM integration.
Metrics
| Metric | Description | Subject area | Report availability |
|---|---|---|---|
| Attributed Revenue | The total revenue attributed to a campaign | Opportunity by Created Date | |
| Influenced Revenue | The total revenue of an opportunity, which is evenly distributed to all the campaigns associated with that opportunity | Opportunity by Created Date | |
| Total Opportunity Amount | The opportunity amount as configured by your organization | Opportunity by Created Date | Opportunity Overview |
| Average Responses | The total count of activities divided by the number of campaigns (Total Responses/Campaign Count) | Campaign Revenue Analysis | |
| Campaign Count | The number of campaigns. Reporting at the campaign level, it would be 1 campaign. If reporting at the opportunity level, it could be multiple campaigns. | Campaign Revenue Analysis | |
| Campaign Members | A contact that responded to a campaign. Your organization defines what a response is and the priority of the response using response rules. | Campaign Revenue Analysis | Campaign Revenue Analysis |
| New Contacts | The total new contacts. A contact is considered new if the contact record was created as a result of a campaign response. Your organization defines what a response is and the priority of the response using response rules. | Campaign Revenue Analysis | |
| New Leads | The number of new leads generated by a specific campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total External Activities | The amount of activity that occurred outside of Oracle Eloqua. For example, attending a trade show, or interacting with an app such as WeChat. The data associated with an external activity is either uploaded to Oracle Eloqua or generated by an app. For more information, see External assets and activities. | Campaign Revenue Analysis | |
| Total Inbound Activities | The amount of inbound activity. Inbound activities include email opens, clickthroughs, form submissions, and so on. This counts all of the activity including multiple activities by the same campaign member. An inbound activity can be generated by a contact that was initially targeted by the campaign or by a contact that performed an inbound activity (for example, via a forwarded email). |
Campaign Revenue Analysis | |
| Total Leads | The total number of leads attributed to a campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total Outbound Activities | The amount of outbound activity. Outbound activities include emails sent, emails delivered, and surveys sent. This counts all of the activity including multiple activities by the same campaign member. An outbound activity can be generated by a contact that was initially targeted by the campaign or by a contact that performed an outbound activity (for example, via a forwarded email). |
Campaign Revenue Analysis | |
| Total Responses | The total response activity for the campaign. Your organization defines what a response is and the priority of the response using response rules. Although a campaign member might respond in many ways to a campaign (for example, clicking through an email or submitting a form), Oracle Eloqua records only the response deemed by your organization as the highest priority response. For example, a form submit at your organization might be considered a higher priority response than an email click-through. So, even if a contact performed both of these responses, Oracle Eloqua records the form submit as a response to the campaign. Responses are captured for a campaign only after the campaign's reporting start date. |
Campaign Revenue Analysis | |
| Unique Inbound Activities | The amount of unique inbound activity. This counts one inbound activity for a campaign member even if the campaign member performed multiple inbound activities. | Campaign Revenue Analysis | |
| Unique Leads | The total number of leads attributed to a campaign or campaigns. | Campaign Revenue Analysis | |
| Unique Outbound Activities | The amount of unique outbound activity. For example, if a campaign member received multiple emails in a campaign, only a single unique outbound activity is counted. | Campaign Revenue Analysis | |
| Unique Responses | The amount of unique responses. This counts one response for a campaign member even if the member responded multiple times. | Campaign Revenue Analysis | |
| Actual Cost | The actual cost of the campaign as configured by your organization | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Budgeted Cost | The budgeted cost of the campaign as configured by your organization | Campaign Revenue Analysis | |
| Cost/Influenced Revenue | The actual cost of the campaign divided by the total revenue of an opportunity which is evenly distributed to all the campaigns associated with that opportunity (Actual Cost/Influenced Revenue) | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Cost/Attributed Opportunity | The actual cost of the campaign divided by the total count of opportunities attributed to a campaign or campaigns (Actual Cost/Attributed Opportunity) | Campaign Revenue Analysis | Campaign Cost Metrics |
| Cost/Attributed Opportunity Won | The actual cost of the campaign divided by the total count of Closed Won opportunities attributed to a campaign or campaigns (Actual Cost/Attributed Opportunity Won) | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Cost/Attributed Revenue | The actual cost of the campaign as configured by your organization divided by the total revenue attributed to a campaign (Actual Cost/Attributed Revenue) | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Cost/Inbound Activity | The actual cost of the campaign divided by the amount of inbound activity. (Actual Cost/Inbound Activity) | Campaign Revenue Analysis | Campaign Cost Metrics |
| Cost/Influenced Opportunity | The actual cost of the campaign divided by the total count of opportunities attributed to a campaign or campaigns (Actual Cost/Influenced Opportunity) | Campaign Revenue Analysis | Campaign Cost Metrics |
| Cost/Influenced Opportunity Won | The actual cost of the campaign divided by the total count of Closed Won opportunities attributed to a campaign or campaigns (Actual Cost/Influenced Opportunity Won) | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Cost/Lead | The actual cost of the campaign divided by the total number of leads attributed to a campaign or campaigns (Actual Cost/Lead) | Campaign Revenue Analysis | |
| Cost/Response | The actual cost of the campaign as configured by your organization divided by the total response activity for the campaign (Actual Cost/Response) | Campaign Revenue Analysis | Campaign Cost Metrics, Campaign Revenue Analysis |
| Cost/Response by New Leads | The actual cost of the campaign divided by the number of new leads generated by a specific campaign or campaigns (Actual Cost/Response by New Leads) | Campaign Revenue Analysis | Campaign Cost Metrics |
| Cost/Unique Inbound Activity | The actual cost of the campaign as configured by your organization divided by the amount of unique inbound activity (Actual Cost/Unique Inbound Activity) | Campaign Revenue Analysis | |
| Cost/Unique Lead | The actual cost of the campaign divided by the total number of leads attributed to a campaign or campaigns (Actual Cost/Unique Lead) | Campaign Revenue Analysis | |
| Attributed Custom Revenue | The campaign revenue defined at the attribution model. Your organization sets this at the Opportunity level in your CRM. This data is imported to Oracle Eloqua from your CRM. | Campaign Revenue Analysis | |
| Attributed First Touch Revenue | An attribution model that attributes revenue to the first campaign touched. An opportunity can touch several campaigns, this attribution model attributes revenue to the first campaign touched. | Campaign Revenue Analysis | |
| Attributed Last Touch Revenue | An attribution model that attributes revenue to the last campaign touched. An opportunity can touch several campaigns, this attribution model attributes revenue to the last campaign touched. | Campaign Revenue Analysis | |
| Attributed Revenue | The total revenue attributed to a campaign | Campaign Revenue Analysis | |
| Attributed Revenue Lost | The total revenue attributed to a campaign for all opportunities with a Closed/Lost status | Campaign Revenue Analysis | |
| Attributed Revenue Open | The total revenue attributed to a campaign for all opportunities with an open status. This is only populated if your revenue attribution is set up to include Open and Closed Won status opportunities. | Campaign Revenue Analysis | |
| Attributed Revenue Won | The total revenue attributed to a campaign for all opportunities with an Closed Won status | Campaign Revenue Analysis | |
| Attributed ROI | The sum of the actual cost of the campaign as configured by your organization subtracted from the total revenue attributed to a campaign divided by the actual cost of the campaign as configured by your organization (Attributed Revenue - Actual Cost / Actual Cost) | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Influenced Revenue | The total revenue of an opportunity which is evenly distributed to all the campaigns associated with that opportunity | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Influenced Revenue Lost | The total revenue of a Closed/Lost opportunity which is evenly distributed to all the campaigns associated with that opportunity | Campaign Revenue Analysis | |
| Influenced Revenue Open | The total revenue of an Open status opportunity which is evenly distributed to all the campaigns associated with that opportunity. This is only populated if your revenue attribution is set up to include Open and Closed Won status opportunities. | Campaign Revenue Analysis | |
| Influenced Revenue Won | The total revenue of a Closed Won opportunity which is evenly distributed to all the campaigns associated with that opportunity | Campaign Revenue Analysis | |
| Influenced ROI | The sum of the actual cost of the campaign subtracted from the total revenue of an opportunity which is evenly distributed to all the campaigns associated with that opportunity divided by the actual cost of the campaign (Influenced Revenue - Actual Cost / Actual Cost) | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total Attributed Opportunities | The total count of opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total Attributed Opportunities Lost | The total count of Closed/Lost opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | |
| Total Attributed Opportunities Open | The total count of open status opportunities attributed to a campaign or campaigns. This is only populated if your revenue attribution is set up to include Open and Closed Won status opportunities. | Campaign Revenue Analysis | |
| Total Attributed Opportunities Won | The total count of Closed Won opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total Influenced Opportunities | The total count of opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Total Influenced Opportunities Lost | The total count of Closed/Lost opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | |
| Total Influenced Opportunities Open | The total count of open status opportunities attributed to a campaign or campaigns. This is only populated if your revenue attribution is set up to include Open and Closed Won status opportunities. | Campaign Revenue Analysis | |
| Total Influenced Opportunities Won | The total count of Closed Won opportunities attributed to a campaign or campaigns | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Weighted Attributed Revenue | The total revenue attributed to a campaign multiplied by the probability of closing (Attributed Revenue * Probability of Closing) | Campaign Revenue Analysis | Campaign Revenue Analysis |
| Weighted Influenced Revenue | The total revenue of an opportunity which is evenly distributed to all the campaigns associated with that opportunity multiplied by the probability of closing (Influenced Revenue * Probability of Closing) | Campaign Revenue Analysis | Campaign Revenue Analysis |