Start of Content Area

Query Lead Management: Channel Analysis Locate the document in its SAP Library structure

Technical name: 0MKTG_C01_Q0001

Based on InfoCube: Structure link0MKTG_C01

Use

This query is used to determine the best channels by which business partners are contacted in the context of a marketing campaign. Following each marketing campaign, the lead manager can compare the success of a given channel to those of others.

Free Characteristics

InfoObject

Description

Structure link0CRMSA_OG_R

Responsible sales organization

Structure link0CRM_SALOFF

CRM sales office

Structure link0CRM_SALGRP

CRM sales group

Variables Used

InfoObject

Description

0I_CALMO

Calendar year/month

0S_ORGDA

Organizational data

Rows

InfoObjects

Description of the InfoObject (and restriction or calculation formula)

Structure link0CRM_LEAGUI__Structure link0CRM_PRCCAT

Process category

0CALYEAR

Calendar year

0CALMONTH

Calendar year/month

Columns

InfoObjects (all 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

Transformation rate for leads

End of Content Area