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 CX Sales was formerly known as Oracle Sales Cloud. All instances of Oracle Sales Cloud have been changed to Oracle CX 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

Learn more

Common reports

CRM integration

Oracle CX Sales Integration app

Insight

Insight frequently asked questions