Adobe Ad Hoc Analysis Tutorial: A Step-by-Step Guide

Adobe Ad Hoc Analysis is a powerful feature within Adobe Analytics that allows you to perform deep, exploratory data analysis. It enables you to dissect your data in real-time, uncover trends, and make informed decisions quickly. Although Adobe has transitioned much of Ad Hoc Analysis functionality into Analysis Workspace, understanding how to perform ad hoc analysis remains valuable. This tutorial will guide you through using Analysis Workspace to conduct effective ad hoc analyses.

Getting Started with Adobe Analysis Workspace

Begin by logging into your Adobe Analytics account through the Adobe Experience Cloud. Once logged in, navigate to Analysis Workspace, which is now the primary tool for ad hoc analysis in Adobe Analytics.

Before diving into data, define the objectives of your analysis. Knowing what questions you want to answer helps focus your efforts. For example, you might want to understand which marketing channels drive the most conversions or how user behavior varies between mobile and desktop devices.

Creating a New Project

In Analysis Workspace, create a new project by clicking on Create New Project. This opens a blank workspace where you can customize your analysis environment.

Add a Freeform Table to the workspace by dragging it from the left panel onto the canvas. The Freeform Table is a flexible component that allows you to display and manipulate data according to your needs.

Selecting Dimensions and Metrics

Choose the dimensions and metrics relevant to your analysis. In the left panel, under Components, you’ll find a list of dimensions (such as Pages, Products, Marketing Channels) and metrics (like Page Views, Visits, Revenue).

Drag the desired dimensions into the rows of your Freeform Table and the metrics into the columns. For instance, to analyze site traffic by page, drag Page into the rows and Visits and Bounce Rate into the columns. This setup provides a clear view of how each page performs.

Applying Segments for Deeper Insights

Segments allow you to focus on specific subsets of your data. To apply a segment, simply drag it onto the workspace or the specific component you want to filter.

To create a custom segment, click on the Segments icon and select Create Segment. Define the criteria for your segment based on conditions like visitor behavior, traffic sources, or technology used. For example, you might create a segment for Returning Mobile Visitors to analyze how this group interacts with your site differently from new desktop visitors.

Visualizing Your Data

Visual representations make complex data easier to understand. To add a visualization, drag a chart type (such as a line graph, bar chart, or heat map) from the left panel onto the canvas.

Assign data to your visualization by dragging metrics and dimensions onto it. For example, create a line graph to display Visits over time. Customize the visualization by adjusting settings like colors, labels, and date ranges to enhance readability and focus on key insights.

Creating Calculated Metrics

Calculated metrics enable you to derive new insights by performing calculations on existing metrics. To create one, select Create Metric from the Metrics panel.

Define your calculated metric using the formula editor. For example, calculate Average Revenue per Visit by dividing Revenue by Visits. Give your calculated metric a descriptive name and save it. It will then be available for use in your analysis.

Performing Data Breakdowns

Data breakdowns help you explore relationships between different dimensions. To perform a breakdown, right-click on a data point in your Freeform Table and select Breakdown by, then choose the dimension you want to drill into.

For instance, break down Visits by Device Type to see how desktop and mobile users contribute to your traffic. This action expands your table to show detailed data for each category within the selected dimension, revealing patterns and trends.

Example Use Case: Analyzing Conversion Rates by Channel

Suppose you want to understand which marketing channels are driving the highest conversion rates.

1. Set Up Your Freeform Table: Add Marketing Channel to the rows and Visits, Orders, and a calculated metric for Conversion Rate (Orders divided by Visits) to the columns.
   
2. Apply a Date Range: Focus on a relevant time frame, such as the past month.
   
3. Use Segmentation: Apply a segment like New Visitors to analyze how first-time visitors convert across channels.
   
4. Visualize the Data: Create a bar chart to compare conversion rates by marketing channel visually.
   

This analysis helps identify which channels are most effective in converting new visitors, informing your marketing strategy.

Best Practices

• Set Clear Objectives: Define what you want to achieve with your analysis to stay focused and efficient.
• Organize Your Workspace: Use logical layouts and naming conventions to make your analysis easier to navigate.
• Leverage Segmentation: Utilize segments to isolate and examine specific subsets of data for more targeted insights.
• Regularly Save Your Work: Prevent data loss by saving your project frequently as you build and refine your analysis.
• Document Findings: Use notes and annotations within the workspace to record insights and observations.

Common Mistakes to Avoid

• Overcomplicating Your Analysis: Including too many metrics or dimensions can overwhelm and obscure key insights. Keep it focused.
• Neglecting Data Quality: Always ensure the data you’re analyzing is accurate and up-to-date to make reliable conclusions.
• Ignoring Date Ranges: Be mindful of the time periods you’re analyzing to ensure relevance to your objectives.
• Not Sharing Insights: Failing to communicate your findings with stakeholders can limit the impact of your analysis.
• Overlooking Visualization Clarity: Ensure your charts and graphs are clear and appropriately labeled to convey information effectively.

Conclusion

Adobe Ad Hoc Analysis, now integrated within Analysis Workspace, provides a robust platform for in-depth data exploration. By following this step-by-step guide, you can harness its capabilities to uncover meaningful insights, optimize strategies, and drive informed decision-making. Remember to define clear objectives, keep your analysis organized, and share your findings to maximize the value of your work.