Optimize Analysis Workspace performance
Various factors can influence the performance of a project within Analysis Workspace. It鈥檚 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 page includes a list of factors that will impact performance and optimizations you can make to ensure peak performance in Analysis Workspace.
Help > Performance in Analysis Workspace
Under Analysis Workspace > Help > Performance, you can see factors that impact your project鈥檚 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 蜜豆视频鈥檚 recommended threshold for each factor.
Additionally, you can Download as CSV the performance contents to easily share with 蜜豆视频 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:
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.
Request factors
Help > Performance request factors
Use the following diagram and terms to learn how requests are processed and the various factors that influence processing times:
Request processing diagram
Request processing terms
The time required from when the request is initiated to when it is complete. The guideline is 15 seconds.
In the Request processing diagram above, the request time represents the full process, from Analysis Workspace request initiated to Analysis Workspace request complete.
The time required from when the request is initiated to when it is complete.
In the Request processing diagram above, the request time represents the full process, from Analysis Workspace request initiated to Analysis Workspace request complete.
Because Analysis Workspace stores only the hash for any strings that are used in any segments, each time you process a project, Lookups are performed to match the hashes with the appropriate values. The guideline is under 2 seconds.
This can be a resource-intensive process, depending on the number of values that could potentially match the hash.
In the Request processing diagram above, the lookup time is represented in the Lookups phase (at the time of Request Engine processing phase).
The total time waiting in queue before requests are processed. The guideline is 5 seconds.
In the Request processing diagram above, the queue time is represented in the Request Engine queue phase and Server queue phase.
The average amount of time it takes to process the request.
In the Request processing diagram above, the average server processing time is represented in the Server queue phase and Server processing phase. The guideline is 10 seconds
Not all requests require the same amount of time to process. Request complexity can help provide a general idea about the time required to process the request. The guideline is Medium or lower.
Possible values include:
- Low
- Medium
- High
This value is influenced by the values in the following columns:
- Month boundaries
- Columns
- Segments
Additional factors
Additional factors that are not included on Help > Performance include:
Factors that add complexity to a segment (in descending order of impact) include:
- Operators of 鈥渃ontains,鈥, 鈥渃ontains any of鈥, 鈥渕atches,鈥 鈥渟tarts with,鈥 or 鈥渆nds with鈥
- Sequential segmentation, especially when dimension restrictions (Within/After) are used
- Number of unique dimension items within dimensions used in the segment (e.g., Page = 鈥楢鈥 when Page has 10 unique items will be faster than Page = 鈥楢鈥 when Page has 100000 unique items)
- Number of different dimensions used (e.g., Page = 鈥楬ome鈥 and Page = 鈥楽earch results鈥 will be faster than eVar 1 = 鈥榬ed鈥 and eVar 2 = 鈥榖lue鈥)
- Many OR operators (instead of AND)
- Nested containers that vary in scope (e.g., 鈥淗it鈥 inside of 鈥淰isit鈥 inside of 鈥淰isitor鈥)
While some of the complexity factors cannot be prevented, look for opportunities to reduce the complexity of your segments. In general, the more specific you can be with your segment criteria, the better. For example:
- With containers, using a single container at the top of the segment will be faster than a series of nested containers.
- With operators, 鈥渆quals鈥 will be faster than 鈥渃ontains鈥, and 鈥渆quals any of鈥 will be faster than 鈥渃ontains any of鈥.
- With many criteria, AND operators will be faster than a series of OR operators.
Look for opportunities to reduce many OR statements into a single 鈥渆quals any of鈥 statement.
Classifications can also help to consolidate many values into concise groups from which you can then create segments. Segmentation on classification groups provides performance benefits over segments that contain many OR statements or 鈥渃ontains鈥 criteria.
Factors that add complexity to a visualization include:
- Range of data requested
- Number of segments applied; for instance, segments used as rows of a freeform table
- Use of complex segments
- Static item rows or columns in freeform tables
- Filters applied to rows in freeform tables
- Number of metrics included, especially calculated metrics that use segments
If you find yourself continually using segments and calculated metrics for data points that are important to your business, consider improving your implementation to capture these data points more directly. The use of a tags in 蜜豆视频 Experience Platform and 蜜豆视频鈥檚 processing rules can make implementation changes quick and easy to implement.
Tips to increase productivity in Analysis Workspace
Here is a video on the topic: