ActiveCampaign PBIX Instructions

If you purchased the subscription for the paid ActiveCampaign app (here), you are entitled to use the Power BI Report File (PBIX) source code and customize it as long as you are subscribed.

After you subscribe to the paid ActiveCampaign app, you will receive an email with the password to access the Power BI Template file that can be downloaded here.

Save the PBIT file and open it using the latest version of Power BI Desktop. In the ActiveCampaign dialog box, enter the paramaters, as you may already use in the ActiveCampaign Power BI app.

If this is your first time entering the parameters, follow these instructions to enter each parameter:

Account Name — This is your ActiveCampaign account name. You can find it by going to your ActiveCampaign login page here (https://www.activecampaign.com/login). You would need to use the same account name that you use on this login page. Don’t provide a full URL that starts with https://, we only need the single-word account name.

Api Token — The Api Token can be found in your ActiveCampaign portal. Login to your ActiveCampaign account. Select Settings, Developer, and copy the Key in the API Access section.

Subscription Email — The free version of the app has refresh limits. Enter none, if you wish to run on the free version. With the free version, you can only refresh up to 3 months of recently sent campaigns, and 1 month of recently active contacts. To lift the refresh limitations, you can subscribe to the Premium version here, and enter your email address that was used during the subscription in the Subscription Email parameter.

Campaign Sent Since — Enter a date in the format YYYY-MM-DD. This parameter will limit the refresh to include only data from recently sent campaigns. It is recommended to enter a later date if you have refresh timeouts, but you can first try only the Contact Modified Since parameter, which can limit the slowest tables in the dataset. If you enter a date that is too recent, the refresh may fail since you have no recent data.

Contact Modified Since — Enter a date in the format YYYY-MM-DD. This parameter will limit the refresh to include only data from recently active contacts. If you have a very large number of contacts and tags and get timeout errors when you refresh the dataset, it is recommended to enter a later date here and try again. If you enter a date that is too recent, the refresh may fail since you have no recent data.

Is Demo — Enter TRUE or FALSE. When TRUE, all personal data will be masked.

Include Deals — Enter TRUE or FALSE. When TRUE, Deals tables will be imported to the report. If you don’t use Deals in your account set this parameter to FALSE.

After you enter all parameters, click Load. The report will load. When it is done, make sure you save the Power BI report PBIX file.

Support & License Considerations

The Power BI report file includes an advanced implementation of the report. You should handle any changes with care. We assume you are an experienced Power BI developer — DataChant will not provide any support for the PBIX file if you make any modifications to the report itself.

What are the advantages of using the PBIX instead of the online app version? (The online version is explained here)

The $100/month paid subscription supports the following:

  1. If you work with a high number of contacts and campaigns, the web version of the app may time out during refresh. With the PBIX you can refresh more data using your Power BI Desktop, and not suffer from the refresh limits of the Power BI service.
  2. You get the PBIX file with access to review the source code that includes the Power Query queries that connect to ActiveCampaign. If you have strong Power BI developers on the team, you can customize everything to meet your needs and reuse the logic of the PBIX to build any missing functionality. Note: If you cancel the subscription, you will not have the license to use any derivative of this report and can only use it for one account. Do not transfer accounts when using the PBIX file. Each account would require a separate license.
  3. With the PBIX, and by having an advanced Power Query developer in your team, you can implement incremental refresh as well and be able to load more data into the report.

You can still use the app as-is, without making any changes using the web version of the app.

Note that we will support breaking changes and bugs of the out-of-box features in the PBIX.

For further questions, contact us here.