Extensibility in Marketing Analytics

Objective

After completing this lesson, you will be able to create custom queries and analytics stories

Marketing Analytics Extensibility Overview

Note

Depending on your license, you have either SAP Analytics Cloud or SAP Analytics Cloud, embedded edition. Check out the documentation to know how to identify your SAP Analytics Cloud version.

Graphic displaying the analytics extensibility options for SAP Marketing Cloud and SAP Analytics Cloud. For SAP Marketing Cloud, two options are displayed: CDS Views and Analytical Queries. For SAP Analytics Cloud, one option is displayed: Custom Stories.

In this lesson, let’s learn about the extensibility options for marketing analytics and see how to create and use custom queries for reporting and analysis in SAP Marketing Cloud.

SAP Marketing Cloud enables you to extend standard pre-delivered analytics content. There are three ways to enhance pre-delivered content for your specific business requirements:

  • adding your own analytic CDS views in SAP Marketing Cloud
  • adding analytical queries in SAP Marketing Cloud
  • and creating your own custom stories in SAP Analytics Cloud

The apps to customize queries in SAP Marketing Cloud:

  • Custom CDS Views: to create custom composite views based on delivered CDS views, both composite and consumption views. Those act as a data source to create new composite views (cubes).
  • Custom Analytical Queries: to create consumption views (queries) based on the SAP delivered and custom composite views (cubes).
  • View Browser: to create analytical query applications or browse the different consumption and composite views that are available It lists both custom CDS views built by the administrator and the standard CDS views delivered by SAP.
  • Custom Catalog Extensions: to publish the custom analytical query by means of the analytical query application to the desired business catalog.

Marketing Analytics Extensibility Options

Let’s take a look at each extensibility option in more detail.

Custom CDS Views

If you need to combine multiple standard data sources, you can create your own custom CDS view as the basis for your query.

Use the Custom CDS Views app to create or modify a custom CDS View by:

  • Adding fields from multiple data sources
  • Creating your own calculated fields
  • Refining the properties of the selected fields
  • Creating and maintaining parameters for the usage within your view
  • Adding filters to refine the result set

Custom Analytical Queries

The Custom Analytical Query tool is used for reporting and analysis. It offers an additional query layer atop the CDS Views.

You can perform various tasks using custom queries, including:

  • Searching for a query
  • Creating a new query
  • Creating queries from predefined SAP queries or from packages for which you don’t have permissions
  • Adding Dimensions and Measures from the Data View
  • Configuring fields of the query
  • Defining filters
  • Preview

Custom Analytical Stories

You can create your own analytical stories if the pre-defined standard stories in the Analytics and Report Gallery do not cover your use cases.

Creating CDS Views and Custom Stories with SAP Analytics Cloud

If you have SAP Marketing Cloud with the SAP Analytics Cloud license, you can create your own operational report or analytics story in SAP Analytics Cloud.

To learn how to do that, watch this Marketing Analytics Extensibility video series to learn more about marketing analytics extensibility features and see the demos.

The series consists of four parts:

Part 1

Learn how to create custom CDS views in SAP Marketing Cloud:

Part 2

Learn how to create custom queries and how to use the View Browser efficiently:

Part 3

Learn how to create SAP Analytics Cloud models and analytics stories in SAP Analytics Cloud and make them available in SAP Marketing Cloud:

Part 4

Learn about data migration:

Creating Custom Stories with SAP Analytics Cloud, Embedded Edition

If you have SAP Analytics Cloud, embedded edition, you can use the Marketing Custom Stories app to create your own analytics stories either from scratch or copy an existing story and change it to fit your needs.

Watch this video to learn about how to create a custom analytics stories in SAP Marketing Cloud:

Log in to track your progress & complete quizzes

Learning

SAP FacebookSAP YoutubeSAP LinkedIn