Pivot data in Custom Reports

```mediawiki Navigation: Main_Page > Reports > Custom Reports > Pivot data in Custom Reports

Pivot data in Custom Reports

Introduction

The feature of Pivot Data in Custom Reports within ActiveCampaign enables users to rearrange the columns and rows of their reports. This capability is crucial for visualizing data from multiple perspectives, providing insights that are more nuanced and actionable. By utilizing pivots, you can examine data broken down by various dimensions, allowing for deeper analysis and better-informed decision-making.

Data pivoting is particularly important when seeking to identify trends over time or to compare different metrics side by side. This article will guide you through the process of accessing and utilizing this feature, including step-by-step instructions, available configuration options, best practices, and common use cases.

How to Access

To access the Pivot Data in Custom Reports feature, you must first navigate to the Custom Reports section within the Reports category of your ActiveCampaign account. Here’s how to do it:

1. Log in to your ActiveCampaign account. 2. From the main dashboard, click on the Reports section in the navigation menu. 3. Select Custom Reports from the dropdown options. 4. Here you will find the option to create or edit reports, where you can utilize the pivot functionality.

Step-by-Step Instructions

Follow these steps to effectively create a pivot report:

1. **Create a New Custom Report**:

  - Click on the Create a New Report button within the Custom Reports page.
 

2. **Select Data Dimensions**:

  - Choose the dimensions for your report. For example, you might pick Tag Name and Tag Application Date as your dimensions.

3. **Choose Measures**:

  - Select the measure you want to analyze. In many cases, this will be a Count of the selected dimension (e.g., how many tags were applied).

4. **Pivoting the Data**:

  - To pivot the data, look for the option labeled Pivot By:
    - Choose the dimension you wish to pivot first; in our example, this could be Tag Application Date.
    - Analyze the initial results displayed.

5. **Adjusting the Pivot**:

  - If the initial pivot does not provide the desired insights, you can switch your pivot dimension:
    - For instance, if you first pivoted by Tag Application Date, you can change it to pivot by Tag Name instead.

6. **Final Visualization**:

  - Review the new visualizations generated by your adjusted pivots. This will reveal trends and counts of tags applied at various time intervals.

By repeating steps 4 and 5, you can experiment with different pivot configurations until you achieve the visualization that meets your analytical needs.

Configuration Options and Settings

When setting up your pivot report, consider the following configuration options:

- **Dimensions**: Select relevant dimensions (e.g., Tag Name, Tag Application Date). - **Measures**: Determine which measures (e.g., Count) you want to track in relation to your dimensions. - **Pivot Options**: Choose which dimension should serve as the pivot point to analyze data across different perspectives.

These settings allow for flexibility in how data is represented and can significantly enhance the analysis you conduct.

Best Practices and Tips

- **Understand Your Data**: Prior to creating pivot reports, familiarize yourself with the data at hand to determine which dimensions and measures will provide the most useful insights. - **Experiment with Different Views**: Don't hesitate to pivot on different dimensions to unearth new perspectives. Different arrangements may highlight various trends or issues. - **Keep It Simple**: While it's tempting to add many dimensions and measures, focusing on the most relevant ones will yield clearer insights. - **Use Visual Aids**: Where possible, incorporate graphs or charts to complement your pivot tables for better visual data representation.

Common Use Cases with Examples

- **Tracking Tag Application Trends**: By using a pivot report to monitor how many tags are applied over time (pivoting by Tag Name vs. Tag Application Date), users can assess which campaigns are most effective or identify periods of increased engagement. - **Comparative Analysis**: Pivoting allows for comparing different metrics, such as the number of tags applied in different timeframes, assisting in understanding variations in user engagement.

Troubleshooting

If you encounter issues while utilizing the pivot functionality, consider the following troubleshooting tips:

- **Invalid Dimension/Measure Combinations**: Ensure that you are selecting dimensions and measures that logically relate to one another. - **Visualization Not Updating**: If the graph or table does not update after changing pivot settings, check to ensure that changes have been properly saved and reflected in the report view.

FAQ

1. **What plans include the Pivot Data feature?**

  The Pivot Data in Custom Reports feature is included with the Custom Reports add-on and available in the Enterprise plan. Users on Plus or Professional plans need to purchase this add-on.

2. **Can I pivot on multiple dimensions at once?**

  At this time, the pivot functionality allows you to pivot one dimension at a time. It’s advisable to experiment with different pivots for comprehensive analysis.

3. **What types of reports can I create using this feature?**

  You can create various types of reports, focusing on dimensions such as tags, segments, or custom fields depending on the data relevant to your needs.

4. **Is there a limit to the data I can pivot?**

  While there isn't a specific limit noted, performance may vary based on the size of your data set. Querying into extensive datasets might slow down report generation.

5. **How do I save a pivot view for future use?**

  Once the desired pivot configuration is displayed, ensure to click on the Save Report button to preserve your view and setup for later reference.

6. **What if I need further assistance with Pivot Data?**

  If you require additional help, consult the ActiveCampaign support documentation or reach out to their customer support team.

7. **Can I export pivot reports?**

  Yes, once you have finalized your pivot, you can typically find options to export the report in various formats, such as CSV or PDF, via the export function.

For more detailed guidance or additional resources, please refer to the ActiveCampaign documentation relevant to reports and custom reporting features. ```