v7

Get started with cubes

Exploration of data in the database is offered via the Marketing Analytics module. It enables you to analyze and measure data, calculate statistics, simplify and optimize report creation and calculation. In addition to this, Marketing Analytics enables you to create reports and build target populations. Once these are identified, they are stored in lists that can be used in Adobe Campaign (targeting, segmentation, etc.).

Cubes are used for generating certain built-in reports, including delivery reports (delivery tracking, clicks, opens, etc.). Reports based on cubes may only be used as a standard for data volumes under 5 million fact lines.

You can extend the database exploration and analysis capacities while making it easier for final users to configure reports and tables: all they need to do is select an existing (fully configured) cube when creating their report or table to process calculations, measures and statistics.

Once they have been created and configured, cubes are used in report query boxes and Web applications. They can be used and manipulated within pivot tables.

Use the Campaign Marketing Analytics module to:

1. Create cubes

   • aggregate and store data in a work table to pre-calculate indicators based on user needs,
   • reduce the volume of data involved in the various calculations used for reports and queries, thus significantly optimizing indicator calculation times,
   • simplify access to data, enable users to manipulate data (whether it is pre-aggregated or not) depending on various dimensions.

2. Create pivot tables

   • explore calculated data, configured measures,
   • select the data to display as well as its display mode,
   • personalize the measures and indicators used,
   • offer interactive analysis tools to users with a non-technical background.

3. Build a query using data calculated and aggregated in a Cube.

4. Identify populations and reference them in lists.

Learn how to create and use cubes in Adobe Campaign v8 documentation.