Search Results num_of_orders

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:

• BIM_DIMV_MEDIA_CHANNELS — joined on MEDIA_ID and CHANNEL_ID, supplying media and channel names and media type attributes.
• BIM_DIMV_MARKET_SGMTS — joined on MARKET_SEGMENT_ID, supplying the market segment name.
• BIM_DIMV_SALES_CHANNELS — joined on SALES_CHANNEL_CODE, supplying the sales channel name.

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.

• CAMPAIGN_ID — identifier of the marketing campaign to which the metrics belong.
• PERIOD_NAME, START_DATE, END_DATE — the reporting period label and its start and end dates.
• MEDIA_ID, MEDIA_NAME, MEDIA_TYPE, MEDIA_TYPE_NAME — media attribution and its descriptive values.
• CHANNEL_ID, CHANNEL_NAME — the channel through which the activity occurred.
• MARKET_SEGMENT_ID, MARKET_SEGMENT_NAME — the targeted market segment.
• SALES_CHANNEL_CODE, SALES_CHANNEL_NAME — the sales channel attribution.
• GEOGRAPHY_CODE — the geographic dimension value.
• NUM_OF_ORDERS, NUM_OF_LEADS, NUM_OF_OPPORTUNITIES — the core funnel counts.
• NUM_OF_ORDERS_FROM_LEADS, NUM_OF_ORDERS_FROM_OPPS — orders attributed to leads and to opportunities respectively.

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.