Skip to main content

How do I create ActiveCampaign metrics?

Updated

Visualize, discover, and act on your email marketing data by creating ActiveCampaign data feed metrics.

Connecting PowerMetrics to your ActiveCampaign data

When writing queries in PowerMetrics, you'll enter your ActiveCampaign user URL and API Key. Depending on the query, you may also need to enter your ActiveCampaign campaign id.

Finding your user URL and API Key

  1. Log in to your ActiveCampaign account using your account name.
    Note: ActiveCampaign uses the company name you provided when you created your account as your account name. For example, if the company name you supplied when creating an account is “mynewcompany,” then your login URL is “mynewcompany.activehosted.com.”
  2. Click Settings on the bottom left side of the screen and select Developer from the side menu.
  3. Copy the text under the URL and Key headings for your user URL and API Key respectively.

Finding your campaign id

  1. In the left navigation sidebar click the + button beside Metrics and select See all services.
  2. On the Where is your data? page, under Data Feed Services, select ActiveCampaign.
  3. Click +New data feed > Select ActiveCampaign data.
  4. On the Choose a pre-built or custom connection page, select the Campaigns (This Month) pre-built data source.
  5. Adjust the Query URL information, as noted on the Configure data service page, to replace <userURL> and <apiKey> with your user URL and API Key from the procedure above.
  6. Click Get data.
  7. Locate the name of your chosen campaign and the accompanying ID. Use this campaign ID number in queries where appropriate.

Creating ActiveCampaign data feed metrics

When you create ActiveCampaign data feed metrics, you:

Connecting to your ActiveCampaign account and adding a data feed

Every metric needs a data feed. As you create metrics, you’ll either create a new data feed or select one from your list of existing data feeds. Learn more about data feeds.

To create a new data feed for your metric:

  1. In the left navigation sidebar click the + button beside Metrics and select See all services.
  2. On the Where is your data? page, under Data Feed Services, select ActiveCampaign.
  3. Click +New data feed > Select ActiveCampaign data.
  4. Select a pre-built data source from the left section of the Choose a pre-built or custom connection page or click +Create a custom ActiveCampaign data source.
  5. Edit the Query URL to return the data you're looking for. Depending on the query, replace <userURL>, <apiKey>, and <campaignID> with your own data.  If you need help writing your query, refer to the ActiveCampaign API documentation.
  6. Click Get data.
  7. Ensure this is the data you’re looking for. Then, click Continue. Next step - refine the data in the data feed editor.

To use an existing data feed for your metric:

  1. In the left navigation sidebar, click Data Feeds.
  2. In your list of Data Feeds, select the one you want to use for your metric.
  3. Click the Metrics tab in the right-side pane.
  4. Click +Add metric and proceed to Configuring your metric.

Refining data in the data feed editor

You’ve arrived in the data feed editor where you can choose to either accept the automatic settings or make changes.

If you’re happy with the automatic settings:

If you want to make changes:

  • ActiveCampaign returns data in a JSON format. The method for refining and editing JSON source data is slightly different than when dealing with source data that’s already in a tabular format. Learn how to refine and edit JSON source data feeds.
  • Some common adjustments include changing the data format or names for columns, updating the data feed name, and combining columns using formulas - there are many customization options available.
  • If you want to adjust the original query, click the tile under Data service.
  • When you’re finished editing the data feed, click Save data feed and proceed to Configuring your metric.

Note: After you’re finished creating a metric with this data feed, you can return to it and use it to make more data feed metrics. In the left navigation sidebar, click Data Feeds. Select the desired data feed from the list and click +Add metric.

Configuring your metric

When you configure a data feed metric, you select the measure and dimensions from the data feed to include in the metric and choose settings that determine how the data will be visualized. Go here for detailed instructions on configuring your metric.

Next steps – Interacting with your data

Now that you're connected and have some metrics, it's time to start learning from your data and tracking your progress.

Here are a few suggestions for interacting with your data:

Related articles