Optimize Customer Journey Analytics and Analysis Workspace performance
Various factors can influence overall Customer Journey Analytics performance as well as the performance of a project within Analysis Workspace. In Workspace, you might get an error message that says
This query is too complex. Please review best practices for building Analysis Workspace queries.
These best practices discuss which factors might lead to this error and how to simplify the report/project.
Query factors query
These are the most common query factors that influence overall Customer Journey Analytics performance:
Additionally, minimize the number of year-over-year comparisons used in the project. When a year-over-year comparison is calculated, it looks across the full 13 months of data between the months of interest. This has the same impact as changing the panel date range to last 13 months.
Factors that add complexity to a filter (in descending order of impact) include:
- Operators of “contains,”, “contains any of”, “matches,” “starts with,” or “ends with”
- Sequential filtering, especially when dimension restrictions (Within/After) are used
- Number of unique dimension items within dimensions used in the filter (e.g., Page = ‘A’ when Page has 10 unique items will be faster than Page = ‘A’ when Page has 100000 unique items)
- Number of different dimensions used (e.g., Page = ‘Home’ and Page = ‘Search results’ will be faster than eVar 1 = ‘red’ and eVar 2 = ‘blue’)
- Many OR operators (instead of AND)
- Nested containers that vary in scope (e.g., “Event” inside of “Session” inside of “Person”)
While some of the complexity factors cannot be prevented, look for opportunities to reduce the complexity of your filters. In general, the more specific you can be with your filter criteria, the better. For example:
- With containers, using a single container at the top of the filter is faster than a series of nested containers.
- With operators, “equals” is faster than “contains”, and “equals any of” is faster than “contains any of”.
- With many criteria, AND operators is faster than a series of OR operators.
Look for opportunities to reduce many OR statements into a single “equals any of” statement.
Factors that add complexity to a visualization include:
- Range of data requested
- Number of filters applied; for instance, filters used as rows of a freeform table
- Use of complex filters
- Static item rows or columns in freeform tables
- Filters applied to rows in freeform tables
- Number of metrics included, especially calculated metrics that use filters
Help > Performance in Analysis Workspace
Various factors can influence the performance of a project within Analysis Workspace. It’s important to know what those contributors are before you start building a project so that you can plan and build the project in the most optimal way. This section includes a list of factors that impact performance and optimizations you can make to ensure peak performance in Analysis Workspace.
Under Analysis Workspace > Help > Performance, you can see factors that impact your project’s performance, including network, browser, and project factors. For the most accurate results, allow the project to fully load before opening the Performance page.
- The Current Project column displays the results for your current project and user environment.
- The Guideline column displays Adobe’s recommended threshold for each factor.
Additionally, you can Download as CSV the performance contents to easily share with Adobe Customer Care or your internal IT teams.
Network factors
Help > Performance network factors include:
Browser factors
Help > Performance browser factors include:
If those actions do not help, discuss hardware details with your IT team.
If those actions do not help, discuss hardware details with your IT team.
Project factors
Help > Performance project factors include: