Dimensions in your custom reports are aggregate numbers. This includes total campaign sends, campaign engagement metrics, total automation completes, and more.
In this article, you'll learn which dimensions you can use to build custom reports in your ActiveCampaign account.
Take note
All email opens from Apple Mail clients will be reflected in these metrics. This includes contacts who use the Apple Mail app with iOS 15 with Mail Privacy Protection (MPP) enabled on their device. To learn more, visit ActiveCampaign and Apple iOS 15 Mail Privacy Protection.
Build reports with Accounts dimensions
You can build custom reports using any Account dimension below.
| Dimension name | Dimension description |
| Account Custom Field Name | The name of the custom account field. |
| Account Custom Field Value | The value of the account custom field. |
| Account Name | The name of the account. |
| Account Created Date | The date the account was created in the ActiveCampaign platform. |
| Account Website | The website of the account. |
| Account Address 1 | The address the account has listed. |
| Account Address 2 | The address the account has listed. |
| Account City | The city location associated with the account. |
| Account State/Province | The state or province associated with the account. |
| Account Country | The country associated with the account. |
| Account Phone Number | The phone number associated with the account. |
| Number of Employees | The reported employee count for the account. |
| Industry/Vertical | The industry or vertical the account is listed under. |
| Annual Revenue | The reported annual revenue listed for this account. |
| Account Owner | The current owner assigned to a given account. |
|
Account Name |
The account name for the account related to a relevant deal. |
Build reports with Automation dimensions
You can build custom reports using any Automation dimension below.
| Dimension name | Dimension description |
| Automation ID | The unique identifier for the automation. |
| Automation Name | The name of the automation. |
| Currency | The currency of orders associated to the automation. (Ecommerce Deep Data integrations) |
| Event Date | The date for which a specific event occurred. (Entry, Goal Completion, etc). |
Build reports with Campaign dimensions
You can build custom reports using any Campaign dimension below.
The dimensions below apply to:
- Campaigns created in the Campaigns section of your ActiveCampaign account that you sent to a list(s)
- Automation emails created within automations that were sent to at least one contact
| Dimension name | Dimension description |
| Automation Campaign Identifier | The identifier for whether a Campaign is related to an Automation. |
| Automation Name | The Automation name for which a Campaign is related. |
| Campaign ID | The unique identifier for a Campaign. |
| Campaign Name | The name of a Campaign. |
| Currency | The currency of the eCommerce Orders purchases related to a Campaign. |
| Event Date | The date for which a specific event occurred (Send, Open, Click, etc). |
| Last Send Date | The most recent send date for a Campaign. |
Build reports with Contact dimensions
You can build custom reports using any Contact dimension below.
| Dimension name | Dimension description |
| Account Name | The name of the account related to the contact. |
| City | The city value for a contact. |
| Contact Custom Field Name | The name of the custom field that is being referenced. |
| Contact Custom Field Value | The value of the custom field name that is being referenced. |
| Contact ID | Unique identifier for the contact. |
| Country | The country value for a contact. |
| Custom Field Value Change Flag (Yes / No | Indicates whether the custom field value was updated after the value was initially created for a contact. |
| Custom Field Value Updated Date | The most recent date that a custom field value was changed for a contact. |
| Date Created | The date the contact was created. |
| The email value for a contact. | |
| Name | The name value for a contact. |
| State | The state value for a contact |
| Tag | The tag name related to a contact. |
| Tag Application Date | The date a tag was applied to a contact. |
| Timezone | The timezone value for a contact. |
| Last Campaign Sent Date | The UTC date of the last Campaign sent to the Contact |
| Last Campaign Sent | The Name of the last Campaign sent to the Contact |
| Last Campaign Open Date | The UTC date of the last Campaign opened by the Contact |
| Last Campaign Open | The Name of the last Campaign opened by the Contact |
| Last Campaign Verified Open Date | The UTC date of the last Campaign Verified Open by the contact |
| Last Campaign Verified Open | The Name of the last Campaign Verified Open by the Contact |
| Last Campaign Unverified Open Date | The UTC date of the last Campaign Unverified Open by the Contact |
| Last Campaign Unverified Open | The Name of the last Campaign Unverified Open by the Contact |
| Last Campaign Click Date | The UTC date of the last Campaign clicked by the Contact |
| Last Campaign Click | The Name of the last Campaign clicked by the Contact |
| Last Automation Entry Date | The UTC date of the last Automation entered by the Contact |
| Last Automation Entry | The Name of the last Automation entered by the Contact |
| Last Automation Completion Date | The UTC date of the last Automation completed by the contact |
| Last Automation Completion | The Name of the last Automation completed by the contact |
Build reports with Custom Object dimensions
You can build custom reports using any Custom Object dimension below.
Take note:
-
Custom Objects from supported third-party applications and integrations are available on:
- Marketing Lite, Plus, Professional, and Enterprise
- Sales Plus, Professional, and Enterprise
-
Custom objects from supported third-party integrations on Deal Standard Objects are available on:
- Sales Plus, Professional, and Enterprise plans
-
Custom objects from supported third-party integrations on Account Standard Objects are available on:
- Marketing Professional and Enterprise
- Sales Plus, Professional, and Enterprise
-
Custom objects created through the API or “Manage Data” page in ActiveCampaign accounts are available on:
- Marketing Enterprise
- Sales Enterprise
| Dimension name | Dimension description |
| *currency | A unique dimension for each currency field associated with a custom object schema. |
| *date | A unique dimension for each date field associated with a custom object schema. |
| *datetime | A unique dimension for each datetime field associated with a custom object schema. |
| *dropdown | A unique dimension for each dropdown field associated with a custom object schema. |
| *multiselect | A unique dimension for each multiselect field associated with a custom object schema. |
| *number | A unique dimension for each number field associated with a custom object schema. |
| *text | A unique dimension for each text field associated with a custom object schema. |
| *text area | A unique dimension for each text area field associated with a custom object schema. |
| *text required | A unique dimension for each text required field associated with a custom object schema. |
| Related Contact ID | The contact Id of the contact that is related to a given custom object record. |
Build reports with Deals dimensions
You can build custom reports using any Deals dimension below.
| Dimension name | Dimension description |
| Deal Custom Field Name | The name of the custom field related to a deal. |
| Deal Custom Field Value | The value of a selected custom field related to a deal. |
| Deal ID | The unique identifier for a deal. |
| Forecasted Close Date | The forecasted close date value for a date. |
| Owner Name | The owner value for a deal. |
| Pipeline | The pipeline value for a deal. |
| Stage | The stage value for a deal. |
| Status | The status value for a deal. |
| Status Change Date | The most recent status change date for a deal. |
| Title | The title value for a deal. |
| Total value | The total deal value for all given deals. |
| Value | The value for a given deal. |
Build reports with Ecommerce dimensions
You can build custom reports using any Ecommerce dimension below.
| Dimension name | Dimension description |
| Abandoned Cart Date | The date an order was abandoned. |
| Automation Name | The name of the automation related to an order. |
| Campaign Name | The name of a campaign related to an order. |
| Contact Email | The email address of the contact related to an order. |
| Contact Order Number | The sequential completed order associated to a contact. |
| Currency | The currency value assigned to an order. |
| Integration | The integration/store that the order is assigned to. |
| Order Created Date | The date the order was created. |
| Order ID | The unique identifier assigned to an order. |
| Order State | The current state value for an order. |
| Product Category | The category for a unit item in an order. |
| Product ID | The unique identifier for a unit item in an order. |
| Product Name | The name for a unite item in an order. |
| Store Name | The name of the store assigned to an order. |
Cross-join attributes
You can cross-join between Automation, Campaign, Contact, and Deal attributes. Cross-joining lets you answer deeper-level questions based on the parameters you set.
For example, you may want to create a report that shows you:
- How many contacts with a specific tag were sent or opened an email
- How many contacts from a geographic area entered an automation
- A list of email addresses of contacts who completed an automation and clicked a link in a campaign
To cross-join between automation, campaign, and contact attributes, the "Relationship type" filter must be selected and defined.