Custom Reports: Difference between revisions

From Activepedia
Jump to navigation Jump to search
(SEO-optimized content from ActiveCampaign documentation)
 
(SEO-optimized content from ActiveCampaign documentation)
 
Line 1: Line 1:
```mediawiki
```mediawiki
'''Navigation:''' [[Main_Page]] > [[Reporting]] > [[Custom Reporting]] > Custom Reports
'''Navigation:''' [[Main_Page]] > [[Reports]] > [[Custom Reports]] > Custom Reports


== Intro to Custom Reports ==
== How to view custom objects in Custom Reports ==


Custom Reports in ActiveCampaign provide a powerful tool for users to analyze specific data points and make informed business decisions. By leveraging these reports, businesses can gain valuable insights into marketing and sales efforts, identify trends, and uncover areas of opportunity. This feature allows you to create reports tailored to your specific needs, which can be saved, accessed, and shared with ease.
Custom Reports in ActiveCampaign allow users to analyze and visualize data by incorporating custom objects. This feature is crucial for businesses looking to extract actionable insights and foster growth through precise data comparison. By integrating custom object data with existing ActiveCampaign information, users can identify trends, areas of opportunity, and strategize effectively.


The ability to generate detailed, accurate reports is crucial for making data-driven decisions. Custom Reports ensure that you have a clear view of your marketing and sales activities, enabling better performance and results.
== How to access this feature ==
To utilize Custom Reports effectively, users must have access to a suitable ActiveCampaign plan. The Custom Reports feature is included in the Enterprise plan, while the custom reports add-on is available for Plus and Professional plans. Users need to ensure they have created a custom object using the ActiveCampaign API or through the '''Manage Data''' page in their account before proceeding.


== How to Access Custom Reports ==
== Step-by-step instructions ==


To access the Custom Reports feature in ActiveCampaign, follow these steps:
=== Step 1: Create or integrate custom objects ===
To begin using Custom Reports, you must first create a custom object template or schema. This can be done either through the ActiveCampaign API or by accessing the '''Manage Data''' page in your ActiveCampaign account. Additionally, connecting integrations like '''Zendesk Support''' or '''Calendly''' that come with a custom object will allow you to utilize their data as well.


# Log into your ActiveCampaign account.
*Note:* Newly created custom objects will only show up in Custom Reports after the data refresh cycle, which occurs daily around 5:30 AM CST.
# Click on '''Reports''' in the left menu.
# Select '''Custom Reports''' from the submenu.
# You will land on the Custom Reports page, which features an '''Explore panel'''.


Once you are on the Custom Reports page, familiarize yourself with the dashboard and terms used in it by referencing the Custom Reports Terminology.
=== Step 2: Accessing custom object data ===
1. Click on '''Settings''' in the main menu.
2. Navigate to '''Manage Data''' to view the custom objects you have created or connected to your account.


== Step-by-Step Instructions for Creating Custom Reports ==
=== Step 3: Viewing custom objects in Custom Reports ===
1. Click on '''Reports''' in the main menu.
2. Then select '''Custom Reports'''.
3. On the left side of the Custom Reports page, you will see a list of relevant custom objects associated with your data in the '''Settings > Manage Data''' section.


Creating a Custom Report involves several steps to ensure you capture the data you need effectively. Follow the instructions below:
=== Step 4: Exploring dimensions and measures ===
1. To see the available dimensions and measures for each custom object, click the arrow to the left of the custom object name.
2. Be mindful that the dimensions and measures available are dynamic and can change; any updates or changes need to be made under the '''Settings > Manage Data''' section.


1. **Select Tables**: On the left side of the '''Explore panel''', you will see various tables available to create your reports:
=== Step 5: Saving your report ===
  - '''Automation table'''
After accessing the required dimensions and measures and building your report:
  - '''Campaigns table'''
1. Save your work by selecting the option to save the report as a look or as part of a dashboard for quick access later.
  - '''Contacts table'''
  - '''Deals table'''
  - '''Ecommerce table'''


2. **Choose Dimensions and Measures**:
== Configuration options and settings ==
  - For each table, you can select '''Dimensions''', which define the static fields (headers) for your report.
The following key components and settings are important when working with Custom Reports:
  - Select '''Measures''', which are the fields that you want to calculate and align with specific dimensions.


3. **Hover for Help**: If you need clarification on specific measures, hover over the '''I''' icon next to each measure for more information.
* '''Custom Objects''': These must be created or connected to be used in reports.
* '''Dimensions and Measures''': The data points that represent the attributes and metrics of the custom objects, which are customizable and dynamic.
* '''Refresh Cycle''': Custom Report data updates once daily, around 5:30 AM CST.


4. **Generate and Save Reports**: After selecting your dimensions and measures, generate the report. You can save it to your account for future access or share it with other users.
Please note, if a custom object schema is deleted, it will no longer appear in Custom Reports following the next data refresh.


Remember, the data for your Custom Reports is updated once daily, providing you with a fresh view of your metrics.
== Best practices and tips ==
- Ensure your custom object data is well-defined and structured to facilitate effective reporting.
- Regularly check for updates or necessary changes to dimensions and measures in the '''Settings > Manage Data''' section.
- Take advantage of the ability to cross join dimensions and measures from the contact table, ensuring your contacts are associated with the relevant custom objects for comprehensive analytics.
- Explore the integration options available to enrich the reporting experience with external data sources.


== Configuration Options and Settings ==
== Common use cases with examples ==
 
- **Comparative Analysis**: Use custom objects to compare customer interaction history with sales data, identifying purchasing trends over time.
In Custom Reports, several key options are essential for configuring and optimizing your reporting process:
- **Performance Tracking**: Measure the effectiveness of marketing campaigns by linking campaign results with custom object metrics to get a complete picture of campaign impact.
 
- **Opportunity Identification**: By examining custom metrics alongside customer lifecycle stages, businesses can identify prospects that exhibit promising engagement.
- **Dimensions**: These are the static fields that define the content or categories of your report. For example, you may select dimensions related to contact engagement or campaign performance.
- **Measures**: These fields allow you to perform calculations on your data, such as counts or averages, aligned with your chosen dimensions.
- **Filter Options**: You can apply filters to isolate specific data points or metrics you're interested in, allowing for more granular insight into your reports.
 
When utilizing Custom Reports, ensure that you choose dimensions and measures that are relevant to the information you wish to analyze.
 
== Best Practices and Tips ==
 
To maximize the effectiveness of your Custom Reports, consider the following best practices:
 
- **Define clear objectives**: Before creating a report, clarify what you want to achieve, whether it's understanding customer engagement or analyzing campaign performance.
- **Leverage Templates**: Use report templates available in ActiveCampaign to guide your report-building process. Templates can provide a solid starting point for your analyses.
- **Share Insights with Your Team**: Share reports with team members when applicable to ensure everyone is on the same page and can contribute to data-driven decision-making.
- **Experiment with Filters**: Utilize various filter options to refine your data further and uncover deeper insights that may not be immediately apparent.
 
== Common Use Cases ==
 
Custom Reports can serve various purposes within marketing and sales analytics. Here are some common use cases:
 
- **Engagement Analysis**: View a list of a contact's engagements segmented by different campaign or automation attributes, such as campaign names.
- **Unsubscribe Trends**: Analyze the average commitment time of contacts who unsubscribed from a particular campaign or automation.
- **Email Activity Tracking**: Monitor the opens of an automation email filtered by specific contact field values within a certain date range.
- **Cross-Campaign Metrics**: Use new measures to assess metrics across campaigns, including total sends, engagement rates, completed automations, and more.


== Troubleshooting ==
== Troubleshooting ==
If you encounter issues with viewing custom objects in Custom Reports:
- Ensure that the custom object has been created and is available in the '''Manage Data''' settings.
- Check if there has been a data refresh; new custom objects will only appear after the next scheduled refresh cycle.
- Double-check the integration settings if working through an external integration.


If you encounter issues while using Custom Reports, consider the following troubleshooting tips:
== Related features ==
 
- For more details on creating and managing custom objects, visit the [[Manage Data]] documentation.
- **Data Refresh Timing**: Remember that data updates once daily around 5:30 am CST/11:30 UTC. If your report data seems outdated, ensure you are not attempting to analyze data before this update.
- To learn about more advanced reporting techniques, check out the [[Automation]] section for greater insights on utilizing automation features in conjunction with reporting.
- **Access Permissions**: To view or share reports, ensure that you have the necessary permissions in your ActiveCampaign account. Only users with access to Custom Reporting can see these reports.
- **Error Messages**: If you receive error messages during report generation, double-check your selected dimensions and measures as well as the filters you applied.


== FAQ ==
== FAQ ==
=== What are custom objects? ===
Custom objects are user-defined entities within ActiveCampaign that allow tracking of unique data pertinent to business needs.


=== What can I report on in Custom Reporting? ===
=== How often is the data in Custom Reports refreshed? ===
Custom Reporting allows you to report on various areas, including '''Contacts''', '''Deals''', '''Automations''', '''Campaigns''', and '''Ecommerce'''. You can perform cross joins to integrate data from these areas.
Data in Custom Reports is refreshed once daily at around 5:30 AM CST.
 
=== How do I create a report based on contact or deal custom fields? ===
To report on custom fields, select the desired dimensions and measures, then apply filters to isolate specific fields, such as Lead Source. This will enable you to generate a report based on the contacts associated with each value.


=== Can I apply filters to a Dashboard that I have created? ===
=== How can I create a custom object? ===
Yes, you can click '''Edit''' on your Dashboard, then choose '''Filters''' to apply various filters to the reports you've created.
You can create a custom object schema using the ActiveCampaign API or through the '''Manage Data''' page in your account.


=== What does using a Pivot on my report mean? ===
=== Can I use data from external integrations? ===
A Pivot allows you to report on multiple dimensions rather than just one. This can enable more complex analyses, such as breaking down counts by multiple characteristics like dates and owner names.
Yes, certain integrations like '''Zendesk Support''' and '''Calendly''' include a custom object that can be utilized in reports.


=== What are filter-only dimensions and what are they used for? ===
=== What happens if I delete a custom object schema? ===
Filter-only dimensions can only be added as filters for creating cross joins. They allow for detailed reports that pull data from multiple areas—such as combining contacts who opened a campaign email.
If a custom object schema is deleted, the custom object will not appear in Custom Reports after the next data refresh.


=== How do I share reports with my team? ===
=== Are there limitations on dimensions and measures? ===
Reports cannot be directly shared via links. However, you can set reports as '''Personal''', '''Group''', or '''Shared'''. Group reports can be viewed by anyone in Custom Reporting, ensuring accessibility among team members.
Yes, dimensions and measures are dynamic and vary with each custom object. Any necessary updates should be addressed in the '''Settings > Manage Data''' section.


By understanding and utilizing Custom Reports effectively, you can transform the way you analyze data and make strategic business decisions in ActiveCampaign.
=== Can I cross join custom object data with contact data? ===
Yes, cross joins are available for dimensions and measures that are associated with contacts and custom objects, enabling deeper analytical capabilities.
```
```

Latest revision as of 19:22, 3 November 2025

```mediawiki Navigation: Main_Page > Reports > Custom Reports > Custom Reports

How to view custom objects in Custom Reports[edit | edit source]

Custom Reports in ActiveCampaign allow users to analyze and visualize data by incorporating custom objects. This feature is crucial for businesses looking to extract actionable insights and foster growth through precise data comparison. By integrating custom object data with existing ActiveCampaign information, users can identify trends, areas of opportunity, and strategize effectively.

How to access this feature[edit | edit source]

To utilize Custom Reports effectively, users must have access to a suitable ActiveCampaign plan. The Custom Reports feature is included in the Enterprise plan, while the custom reports add-on is available for Plus and Professional plans. Users need to ensure they have created a custom object using the ActiveCampaign API or through the Manage Data page in their account before proceeding.

Step-by-step instructions[edit | edit source]

Step 1: Create or integrate custom objects[edit | edit source]

To begin using Custom Reports, you must first create a custom object template or schema. This can be done either through the ActiveCampaign API or by accessing the Manage Data page in your ActiveCampaign account. Additionally, connecting integrations like Zendesk Support or Calendly that come with a custom object will allow you to utilize their data as well.

  • Note:* Newly created custom objects will only show up in Custom Reports after the data refresh cycle, which occurs daily around 5:30 AM CST.

Step 2: Accessing custom object data[edit | edit source]

1. Click on Settings in the main menu. 2. Navigate to Manage Data to view the custom objects you have created or connected to your account.

Step 3: Viewing custom objects in Custom Reports[edit | edit source]

1. Click on Reports in the main menu. 2. Then select Custom Reports. 3. On the left side of the Custom Reports page, you will see a list of relevant custom objects associated with your data in the Settings > Manage Data section.

Step 4: Exploring dimensions and measures[edit | edit source]

1. To see the available dimensions and measures for each custom object, click the arrow to the left of the custom object name. 2. Be mindful that the dimensions and measures available are dynamic and can change; any updates or changes need to be made under the Settings > Manage Data section.

Step 5: Saving your report[edit | edit source]

After accessing the required dimensions and measures and building your report: 1. Save your work by selecting the option to save the report as a look or as part of a dashboard for quick access later.

Configuration options and settings[edit | edit source]

The following key components and settings are important when working with Custom Reports:

  • Custom Objects: These must be created or connected to be used in reports.
  • Dimensions and Measures: The data points that represent the attributes and metrics of the custom objects, which are customizable and dynamic.
  • Refresh Cycle: Custom Report data updates once daily, around 5:30 AM CST.

Please note, if a custom object schema is deleted, it will no longer appear in Custom Reports following the next data refresh.

Best practices and tips[edit | edit source]

- Ensure your custom object data is well-defined and structured to facilitate effective reporting. - Regularly check for updates or necessary changes to dimensions and measures in the Settings > Manage Data section. - Take advantage of the ability to cross join dimensions and measures from the contact table, ensuring your contacts are associated with the relevant custom objects for comprehensive analytics. - Explore the integration options available to enrich the reporting experience with external data sources.

Common use cases with examples[edit | edit source]

- **Comparative Analysis**: Use custom objects to compare customer interaction history with sales data, identifying purchasing trends over time. - **Performance Tracking**: Measure the effectiveness of marketing campaigns by linking campaign results with custom object metrics to get a complete picture of campaign impact. - **Opportunity Identification**: By examining custom metrics alongside customer lifecycle stages, businesses can identify prospects that exhibit promising engagement.

Troubleshooting[edit | edit source]

If you encounter issues with viewing custom objects in Custom Reports: - Ensure that the custom object has been created and is available in the Manage Data settings. - Check if there has been a data refresh; new custom objects will only appear after the next scheduled refresh cycle. - Double-check the integration settings if working through an external integration.

Related features[edit | edit source]

- For more details on creating and managing custom objects, visit the Manage Data documentation. - To learn about more advanced reporting techniques, check out the Automation section for greater insights on utilizing automation features in conjunction with reporting.

FAQ[edit | edit source]

What are custom objects?[edit | edit source]

Custom objects are user-defined entities within ActiveCampaign that allow tracking of unique data pertinent to business needs.

How often is the data in Custom Reports refreshed?[edit | edit source]

Data in Custom Reports is refreshed once daily at around 5:30 AM CST.

How can I create a custom object?[edit | edit source]

You can create a custom object schema using the ActiveCampaign API or through the Manage Data page in your account.

Can I use data from external integrations?[edit | edit source]

Yes, certain integrations like Zendesk Support and Calendly include a custom object that can be utilized in reports.

What happens if I delete a custom object schema?[edit | edit source]

If a custom object schema is deleted, the custom object will not appear in Custom Reports after the next data refresh.

Are there limitations on dimensions and measures?[edit | edit source]

Yes, dimensions and measures are dynamic and vary with each custom object. Any necessary updates should be addressed in the Settings > Manage Data section.

Can I cross join custom object data with contact data?[edit | edit source]

Yes, cross joins are available for dimensions and measures that are associated with contacts and custom objects, enabling deeper analytical capabilities. ```