On March 1, 2021, Ad Hoc Analysis reached end-of-life and all of its projects and schedules stopped working at that time. This site includes resources to help you transition to Analysis Workspace.
While most terminology and features remain the same between products, there are some new terms and approaches to analysis in Analysis Workspace. This section highlights some of the more common Ad Hoc Analysis workflows and how they translate to Analysis Workspace. Each of these workflows were also demonstrated in the Ad Hoc Analysis EOL webinar.
Analysis and segmentation
- Multiple breakdowns: Enable Table Builder on any freeform table to apply many breakdowns at once. Table builder enables you to drag & drop in many dimensions, breakdowns, metrics and segments to build tables that answer complex business questions. Data will not update on-the-fly; instead, it will update once you click "Build" which saves you time since the table only updates once. Watch the video.
- Temporary segment creation: Create temporary segments quickly by dragging any component into the panel drop zone. Segments created in this way won't appear in your left rail and are not saved. Watch the video.
- Adding many temporary segments at once: Add dropdown filters in the panel drop zone to enable controlled project interactions, without having to create & save many segments. Watch the video.
- Linear & Participation metrics: Adjust metric attribution directly in freeform table columns or within calculated metrics. Learn more about the models available in Analysis Workspace and watch the videos on Freeform and Calculated Metrics.
- Flow: Flow visualizations display exact journeys your visitors are taking through your properties. Repeat instances are removed by default, with the option to show them. Additionally, Flow can be multi-dimensional and segmented by the panel drop zone. Watch the video.
- Fallout (Funnels): Fallout visualizations enable checkpoint analysis, which is commonly used to refine checkout or application processes. You are able to mix & match dimensions & events, trend all touchpoints, and see what next steps visitors take if they don't continue. Watch the video.
- Cohort (Retention, Churn): Cohort Tables allow you to group visitors based on a common behavior and then examine their retention and churn over time. You are also able to conduct latency analysis and customize your cohort dimension. Watch the video.
Project sharing and scheduling
- Sharing: You can create a project link or share your project to recipients. Recipients can be placed in edit, duplicate or view roles, depending on the project experience you want them to have. Watch the video.
- Scheduling: You are able to send a CSV or PDF of your project to recipients under Share > Send Now. You can also send a CSV or PDF on a regular schedule under Share > Send File on Schedule. Learn more
- Copying data: Freeform table data can be copied for use outside of Analysis Workspace. Highlight cells within a table and hit Ctrl/Cmd+C or right-click > Copy to selection clipboard. To copy a full table, right-click on the table header and choose Copy data to clipboard. Learn more
- Download 50,000 rows: You can download the displayed data in a table by right-clicking > Download data as CSV. You can also download up to 50,000 items for a dimension, with segments and filters applied, by right-clicking > Download items as CSV. Watch the video.
- If you need more data than what Analysis Workspace supports, the 2.0 Analytics API is available and allows for pagination to more items. Report Builder and Data Warehouse are additional export methods, but will have limitations compared to the data in Analysis Workspace.
The Adobe Analytics YouTube channel (adobe.ly/aayoutube) offers an organized training guide that enables you to build your Analysis Workspace skillset at your own pace.
You can also visit our other Spark pages and documentation for even more Analysis Workspace resources:
Copyright © 2021 Adobe. All rights reserved.