Analysing Cross Channel Data
We will learn how to work with data from multiple sources.
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;
- set the date range to Last 3 Full Months;
- add a new Freeform table;
- pull in "Events", "Sessions", "Event: Call center dial-ins" and "Event: Page Views" metrics.
The Event: Call center dial-ins metric represents rows of data that come from the call center dataset.
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".
The resulting table should look like this:
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.
- 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.
This is the reason for a call that a call center agent entered when they spoke with a customer on the phone.
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.
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".
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.
- Click on the "+" icon to the right of the Filters in the Components menu to open up the Filter Builder.
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
- Click Save.
This filter will allow us to filter by Sessions that have at least on Page View in them.
Notice the new Web Sessions Filter in the Components menu.
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.
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.
This filter will find sessions where a customer had at least one Page View and at least one Call in a session.
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.
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.
This provides an interesting view: we can see there are Web Sessions with calls, and Call Sessions with page views.
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, in the first "Day" table you created, until the blue pop-up says "Filter By", and drop the filters.
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.
Congratulations, this completes the Analytics Cross Channel Data exercise!