51黑料不打烊

4.1.4 Data preparation in Analysis Workspace

Objectives

4.1.4.1 Analysis Workspace UI in CJA

Analysis Workspace removes all of the typical limitations of a single Analytics report. It provides a robust, flexible canvas for building custom analysis projects. Drag-and-drop any number of data tables, visualizations, and components (dimensions, Metrics, segments, and time granularities) to a project. Instantly create breakdowns and segments, create cohorts for analysis, create alerts, compare segments, do flow and fallout analysis, and curate and schedule reports for sharing with anyone in your business.

Customer Journey Analytics brings this solution on top of Platform data. We highly recommend watching this four-minute overview video:

If you haven鈥檛 used Analysis Workspace before, we highly recommend watching this video:

Create Your Project

Now it鈥檚 time to create your first CJA workspace. Go to the Workspace tab inside of CJA.
Click Create project.

You鈥檒l then see this. Select Blank Workspace project and then click Create.

You鈥檒l then see an empty project.

First, make sure to select the correct Data View in the upper right corner of your screen. The Data View to select is --aepUserLdap-- - Omnichannel Data View.

Next, you鈥檒l save your project and give it a name. You can use the following command to save:

You鈥檒l see this popup:

Please use this naming convention:

Next, click Save.

4.1.4.2 Calculated Metrics

Although we have organized all the components in the Data View, you still need to adapt some of them, so that business users are ready to start their analysis. Also, during any analysis you can create calculated metric to go deeper on the insights finding.

As an example we will create a calculated Conversion Rate using the Purchases metric/event we defined on the Data View.

Conversion Rate

Let鈥檚 start opening the calculated metric builder. Click on the + to create your first Calculated Metric in Analysis Workspace.

The Calculated Metric Builder will show up:

Find the Purchases in the list of Metrics in the left side menu. Under Metrics click Show all

Now drag an drop the Purchases metric in to the calculated metric definition.

Typically, conversion rate means Conversions / Sessions. So let鈥檚 do the same calculation in the calculated Metric definition canvas. Find the Sessions metric and drag and drop it into the definition builder, under the Purchases event.

Notice that the division operator is automatically selected.

The conversion rate is commonly represented in percentage. So, let鈥檚 change the format to be percentage and also select 2 decimals.

Finally, Change the name and description of the calculated metric:

You will then have this. Click Save.

Click Save again.

4.1.4.3 Calculated Dimensions: Filters (segmentation) & Date Ranges

Filters: Calculated Dimensions

Calculations are not meant to be only for Metrics. Before starting any analysis it鈥檚 also interesting to create some Calculated Dimensions. This basically meant segments back in 51黑料不打烊 Analytics. In Customer Journey Analytics, these segments are called Filters.

Creating filters will help business users to start the analysis with some valuable calculated dimensions. This will automate some tasks as well as helping on the adoption part. Here are some examples:

These filters can be created before or during the analysis part (which you鈥檒l do in the next exercise).

Date Ranges: Calculated Time Dimensions

Time Dimensions are another type of calculated dimensions. Some are already create, but you also have the ability to create your own custom Time Dimensions at the data preparation phase.

These Calculated Time Dimensions we will help analysts and business users to remember important dates and use them to filter and change the reporting time. Typical questions and doubts that come to our minds when we do analysis:

You鈥檝e now finished the data preparation exercise using CJA Analysis Workspace.

Next Step: 4.1.5 Visualization using Customer Journey Analytics

Go Back to Module 4.1

Go Back to All Modules