---
title: Analysing Cross Channel Data
slug: belfius-hol/analysing-cross-channel-data
docTags: 
createdAt: 2024-01-09T14:40:23.256Z
---

# Objectives

We will learn how to work with data from multiple sources.

# Context&#x20;

In this exercise you will use Analysis Workspace within Customer Journey Analytics to analyse product views, product funnels, churn etc.

Let’s use the project you just created. Open your project.

With your project opened and the Data View selected, you're ready to start building your first cross-channel visualisation:

- add a new panel into your Workspace, by clicking on the "plus" icon at the bottom of the panel;

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/_eZRXB0R2BjmTxq0sKAv__image.png)

- set the date range to **Last 30 Days**;
- add a new **Freeform table**;
- pull in "Events", "Sessions", "Event: Call center dial-ins" and "Event: Page Views" metrics.

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-1TNV5VQ9dxn6RqMzEOMO0-20250108-170956.png)

The **Event: Call center dial-ins** metric represents rows of data that come from the call center dataset.&#x20;

The **Event: Page views** metrics represents rows of data from the Web Analytics Data.

Let's analyse the same metrics, with a different dimension:

- search for the **Page Name** dimension in the Components;
- replace the **Day** dimension with the **Page Name** dimension by dragging it over "Day" in the table and drop to replace "Day" with "Page Name".

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/8aREdBjpt6ea6zUkegLGT_screen-recording-2024-01-15-at-112833.gif)

The resulting table should look like this:

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-_XF1jD_6TTXF8A-vkUdSV-20250108-171245.png)

You'll see in the resulting data that there are Events and Sessions associated with each page and there are Page Views associated with each page (which equals the "Events" metric), but there are no Calls associated with each Page. This is because there are no rows that are both Web and Call rows, they originate from entirely separate datasources and are ingested into separate datasets in Adobe Experience Platform.&#x20;

- Duplicate this table by right clicking at the top of the Freeform table to duplicate;
- rename it as **Call Reason Analysis**;
- On the duplicated table, replace the Page Name dimension with the **Call Reason** dimension.

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-3BgjmLWoLu4dp7P_A3mA4-20250108-171408.png)

This is the reason for a call that a call center agent entered when they spoke with a customer on the phone.&#x20;

:::hint{type="info"}
*Notice how there are now Call Reasons that have Events and Sessions and Calls associated with them but no Page Views. Again, this makes sense.*
:::

# Building a Filter

Filters are the same as Segments in Adobe Analytics, just renamed. And once these filters are built in CJA, they can be shared with Experience Platform, so you can use them in CDP for example.

Using filters is one way that we can gain more insight into our cross channel data.  We can create filters to understand which sessions were "web" only sessions, which were "call center" only and which were in fact "cross channel". &#x20;

:::hint{type="info"}
Keep in mind for CJA, there is no concept of "browser" session, the session calculation is controlled by the event timeout set in your data view.  As long as the customers interacts on both channels within the timeout window their events will be considered part of the same session in CJA.&#x20;
:::

## Filter - Web sessions

1. Click on the "**+**" icon to the right of the **Filters** in the Components menu to open up the Filter Builder.

::Image[]{src="https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/1tENywjI0EnnXDw3OBOA0_image.png" size="32" width="203" height="707" position="center" showCaption="false"}

We'll build a filter for "Web Sessions" first.

- Drag the **Event: Page Views** metric into the drop zone.
- Change the Rule from **Page Views = 1** to **"exists".**
- Change the "include" drop-down from **Event** to **Session.**
- Name your Filter, `[your name] - Web sessions`
- Clic&#x6B;**&#x20;Save.**

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/4nnm1ukj0k50E_H1XY8D8_image.png)

This filter will allow us to filter by Sessions that have at least on Page View in them.

:::hint{type="info"}
*Notice the new Web Sessions Filter in the Components menu.*
:::

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-MfDpFaZzpWThBU7Wq9_g8-20250108-171835.png)

## Filter - Cross-channel sessions

Now let's use this filter as starting point for the new one:

- hover over the filter name;
- Click on the "i" icon to bring up the filter details;
- click on the *pencil* icon to bring up the Filter Builder.

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-MfDpFaZzpWThBU7Wq9_g8-20250108-171835.png)

We're going to make a few changes and save as a new Cross-Channel Sessions filter.

- Drag the **Event: Call Center Dial-ins** metric, and drop it below the **Page Views** metric.
- Change the criteria for the Calls metric from **Equals 1** to **Exists.**
- Name your Filter, `[your name] - Cross-channel sessions`
- Click **Save As.**

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-jVJ3Kxee5Q98HPtV1Sn73-20250108-230735.png)

This filter will find sessions where a customer had at least one Page View and at least one Call in a session.

## Filter - Call sessions

Let's create the last filter:

- hover over the Cross-Channel Sessions filter in the Components menu, click on the "**i**" next to the filter and click on the pencil icon;
- once in the Filter Builder again, **remove** the criteria that  **Event: Page View exists**;
- Name your Filter, `[your name] - Call sessions`
- Click **Save As**.

# Analysis

We now have the 3 filters and we can do some interesting cross-channel analysis.

- Duplicate the table "Call Reason Analysis";
- rename it as "Analysis by Filters";
- multi-select the 3 filters you just built and drag them over the **Call Reason** dimension;
- release the filters and this will *Replace* that dimension with those 3 filters.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/039CuDtdNKoDFikB9GN8o_screen-recording-2024-01-11-at-110935.gif)

This provides an interesting view: we can see there are Web Sessions with calls, and Call Sessions with page views.

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-aHdQPusM8_EdcxpnPLhrl-20250108-230855.png)

Now:

- Duplicate the table "Call Reason Analysis";
- rename it as "Call Reason Analysis - advanced";
- take the 3 filters and drag them under the **Sessions** metric, until the blue pop-up says "**Filter By**", and drop the filters.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/0hMeNQV8U-x9uCGdKn4Lj_screen-recording-2024-01-15-at-151506.gif)

![](https://api.archbee.com/api/optimize/Kr9jNQk3X89PNSZafWHK9-UsVpGaXWhuY4koOjiASkC-20250108-231035.png)

This will break out the **Sessions** metric by the various Session types the filters represent. A great way to analyse the types of Sessions customers are having.

:::hint{type="success"}
Congratulations, this completes the Analytics Cross Channel Data exercise!
:::

&#x20;
