Start of Content Area

Query Lead Management: Efficiency Reporting Locate the document in its SAP Library structure

Technical Name: 0MKTG_C01_Q0002

Based on InfoCube: Structure link0MKTG_C01

Use

This query is used to analyze the efficiency with which leads are qualified. By navigating to the sales organizations and the responsible employees for the leads, it is possible to assess how efficiently lead teams are working and to identify areas for improvement.

Free Characteristics

InfoObject

Description

0CALYEAR

Calendar year

0CALQUARTER

Calendar year/quarter

0CALMONTH

Calendar year/month

Structure link0CRM_LEAGUI__Structure link0CRM_SOURCE

Lead source

Structure link0CRM_LEAGUI__Structure link0CRM_LEATYP

Lead type

Variables Used

Variable

Description

0I_CMNTH

Calendar year/month

0S_ORGDA

Organizational data

Rows

InfoObjects

Description of the InfoObject (and restriction or calculation formula)

Structure link0CRMSA_OG_R

Responsible sales organization

Structure link0CRM_SALOFF

CRM sales office

Structure link0BP_RESPPER

Responsible employee

The navigation characteristic "Responsible employee" can be used to refine the query to level of the individual lead qualifier.

Columns

InfoObjects (key figures)

Description of the InfoObject (and restriction or calculation formula)

Structure link0CRM_NUMDOC

Counter for the number of headers

Structure link0CRM_LEAWON

Number of leads won

0MKTG_C01_CK001

Lead transformation rate

Structure link0CRM_NUMACT

Number of activities per lead

Structure link0CRM_NUMCHL

Number of times qualification level was changed

End of Content Area