Search Results bim_sumv_lead_conv




Overview
Explore in AI Chat

Overview

The BIM_SUMV_LEAD_CONV view is a reporting and analytics object owned by the APPS schema within the BIM – Marketing Intelligence product family. Its documented purpose is to join the lead conversion summary table to the relevant dimension views, producing a single denormalized result set that presents campaign lead-conversion metrics alongside their descriptive dimension attributes. The view carries a status of VALID in the ETRM documentation for EBS 12.1.1 and 12.2.2.

The view is defined with the WITH READ ONLY clause, confirming that it is intended exclusively for query and reporting access and cannot be used as the target of DML operations. Because it exposes resolved names — such as media name, channel name, market segment name, and sales channel name — rather than raw identifiers, it abstracts the underlying star-schema relationships and presents the marketing lead-conversion data in a form suitable for direct consumption by reports, dashboards, and downstream integration queries.

Underlying Base Objects

The view is defined over four documented base objects. The fact source is BIM_LEAD_CONV_SUMM, referenced through a synonym, which supplies the campaign-level lead-conversion measures. Three dimension views supply descriptive attributes and are joined to the fact source on their respective keys:

The documented metadata also lists FND_GLOBAL (package) as a referenced object, which is consistent with the standard EBS practice of using FND_GLOBAL for session-level context such as responsibility, user, and organization security. The join predicates are inner joins, so a summary row is returned only when matching dimension records exist in all three dimension views.

Key Columns

The view exposes twenty columns. The most significant for the searched term num_of_orders is NUM_OF_ORDERS, which reports the count of orders associated with the lead-conversion summary for the given campaign, period, and dimensional context.

Common Use Cases and Queries

The view supports lead-conversion funnel analysis and campaign performance reporting. Typical queries aggregate the measures by campaign, period, media, or segment. For example, to retrieve order counts by campaign and period:

  • SELECT campaign_id, period_name, SUM(num_of_orders) FROM bim_sumv_lead_conv GROUP BY campaign_id, period_name;
  • SELECT media_name, sales_channel_name, SUM(num_of_orders) AS orders, SUM(num_of_leads) AS leads FROM bim_sumv_lead_conv WHERE period_name = :period GROUP BY media_name, sales_channel_name;
  • SELECT market_segment_name, SUM(num_of_orders_from_leads), SUM(num_of_orders_from_opps) FROM bim_sumv_lead_conv GROUP BY market_segment_name;

Because the view is read-only and pre-joined, it eliminates the need for report authors to reconstruct the dimension joins manually, and it is well suited to ad hoc analysis and to feeding marketing analytics extracts.