This query provides you with an overview of all the personalized mails (for any communication channel) sent in a campaign. The query contains characteristics and key figures that are available for interactive reporting in SAP Customer Relationship Management (SAP CRM) for the report area Marketing Contact Tracking (Based on SAP HANA VDM)
.
For information about the report areas in SAP CRM, see Report Areas for Interactive Reports Based on SAP HANA VDM
This query is based on the InfoProvider /CRMBW/MCT_V01.
To use this query, you must activate the business functions SAP BusinessObjects Integration and CRM Interactive Reporting (CRM_ANA_BOB) and Interactive Reporting Based on SAP HANA VDM (CRM_ANA_VDM) .
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Selection GUID |
/CRMBW/SELGUID |
Technical filter that is generated at runtime |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Campaign ID |
/CRMBW/CAMPAIG |
SAP HANA VDM Field: Campaign |
Characteristic | Campaign Element |
/CRMBW/CPGE_ID |
SAP HANA VDM Field: CampaignElement |
Characteristic | Day (Campaign Created On) |
0CALDAY |
SAP HANA VDM Field: CreationDate |
Characteristic | Week (Campaign Created On) |
0CALWEEK |
SAP HANA VDM Field: CreationDateYearWeek |
Characteristic | Month (Campaign Created On) |
0CALMONTH |
Calendar Year (0CALYEAR) Valid From (0DATEFROM) SAP HANA VDM Field: CreationDateYearMonth |
Characteristic | Quarter (Campaign Created On) |
0CALQUARTER |
Quarter (0CALQUART1) SAP HANA VDM Field: CreationDateYearQuarter |
Characteristic | Year (Campaign Created On) |
0CALYEAR |
SAP HANA VDM Field: CreationDateYear |
Characteristic | Communication Channel |
/CRMBW/CHANNEL |
SAP HANA VDM Field: CommunicationChannel |
Characteristic | Contact Status |
/CRMBW/CT_STAT |
SAP HANA VDM Field: ContactTrackingStatus |
Characteristic | Campaign Created On |
/CRMBW/CREATON |
SAP HANA VDM Field: CreationDate |
Characteristic | Mail Form |
/CRMBW/MF_ID |
SAP HANA VDM Field: MailForm |
Characteristic | Target Group |
/CRMBW/TG_ID |
SAP HANA VDM Field: TargetGroup |
Characteristic | Business Partner |
/CRMBW/BP_ID |
SAP HANA VDM Field: BusinessPartner |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Number of Planned Outbounds |
/CRMBW/PLANOB |
SAP HANA VDM Field: NumberOfPlannedOutboundCtcts |
Key Figure | Number of Successful Outbounds |
/CRMBW/SUCCOB |
SAP HANA VDM Field: NumberOfSuccssflOutboundCtcts |
Key Figure | Number of Failed Outbounds |
/CRMBW/FAILOB |
SAP HANA VDM Field: NumberOfFailedOutboundContacts |
Key Figure | Number of Link Accesses |
/CRMBW/LINKACC |
SAP HANA VDM Field: NumberOfLinkAccesses |