Show TOC

Lost Revenue by Quarter Locate this document in the navigation structure

Query Query: 0CRM_C04_Q3031

 

This query provides you with an overview of the lost revenue and the loss rate for each quarter over the last 8 months.

This query is based on the MultiProvider 0CRM_C04.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

User Name

0BP_RESPPER__0USER_NAME

User Name: 0P_USER

Characteristic Characteristic

System of User Name

0BP_RESPPER__0USER_SYST

System of User Name: 0P_USSYS

Characteristic Characteristic

Resp. Sales Org.

0CRMSA_OG_R

Determine Manager's Sales Organization: 0CXPMOM

Characteristic Characteristic

Calendar Year/Quarter Closing Date

0CALQURT_CL

Current Quarter (0CQUART) minus 7
Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

CRM Sales Org.

0CRM_SALORG

Characteristic Characteristic

Industry Code

0CRM_PROSPE__0IND_CODE

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Calendar Year/Quarter Closing Date

0CALQURT_CL

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Number of Lost (Competitive) Opportunities

Number of document headers (0CRM_NUMDOC) with opportunity/lead status Lost and assignment to a competitor (0CRM_COMPET)

Key Figure Key Figure

Number of Won and Lost (Competitive) Opportunities

Number of document headers (0CRM_NUMDOC) with opportunity/lead status Won or Lost and assignment to a competitor (0CRM_COMPET)

Key Figure Key Figure

Lost Revenue

Expected revenue (0CRMREVEXPC) with opportunity/lead status Lost

Key Figure Key Figure

Loss Rate

Number of lost opportunities/number of won and lost opportunities