How do I connect ActiveCampaign to Redash using Kondado?

Start by adding ActiveCampaign as a new data source in your Kondado account using your API credentials. Then select Redash as your destination and choose which pipelines you want to replicate, such as Contacts, Campaigns, or Deals. Your data will begin flowing immediately, allowing you to query and visualize it in Redash within minutes.

What marketing KPIs can I track with ActiveCampaign data in Redash?

You can monitor email open rates, click-through rates, and campaign engagement using the Campaigns and Contacts pipelines. Track deal progression and sales velocity through the Deals pipeline, or analyze list growth and segmentation performance. These metrics help you optimize your marketing automation and improve customer retention strategies.

How often does my ActiveCampaign data update in Redash?

Kondado lets you configure update frequencies based on your business needs, ranging from every 5 minutes to daily schedules. This ensures your Redash dashboards reflect recent marketing activities and contact interactions without manual refreshes. You can adjust the frequency anytime as your reporting requirements evolve.

Can I share ActiveCampaign dashboards with my team in Redash?

Once you build your dashboards in Redash, you can share them with team members through Redash's native sharing features. Since Kondado keeps your data updated automatically on your chosen schedule, your colleagues always see current information when they access the shared reports. This keeps marketing and sales teams aligned on the latest performance metrics.

Do I need technical skills to build ActiveCampaign reports in Redash?

No coding is required to set up the connection through Kondado, as the platform handles the data replication automatically. Building visualizations in Redash uses SQL queries, but once your data is available, business users can create charts and graphs using Redash's visual query builder. This makes marketing analytics accessible to teams without database expertise.

Can I send ActiveCampaign data to other tools besides Redash?

Yes, Kondado allows you to replicate your ActiveCampaign data to multiple destinations simultaneously. You can send information to Power BI , Looker Studio , Google Sheets , or BigQuery in addition to Redash, ensuring your marketing data is available wherever your team prefers to work.

What types of contacts data can I visualize in Redash?

Through the Contacts pipeline and its related endpoints, you can analyze custom field values, tag assignments, list activities, and task completions. This enables you to segment your audience by engagement level, track lead scoring changes over time, and identify which contact attributes correlate with higher conversion rates in your marketing campaigns.

Kondado: Connect ActiveCampaign to Redash: Dashboards in Minutes

How to Visualize ActiveCampaign Data in Redash

Connecting your marketing automation data to visualization tools should be straightforward for business users and marketing teams. With Kondado, you can replicate your ActiveCampaign information directly into Redash without complex configurations, intermediate databases, or coding requirements. Simply select ActiveCampaign as your data source, choose Redash as your destination, and define which pipelines you want to visualize for your reports. Your marketing metrics, contact activities, and campaign performances become accessible charts and graphs within minutes, enabling your team to track KPIs and make data-driven decisions without waiting for technical support.

Kondado connects ActiveCampaign to Redash directly, offering 29 available pipelines with 644 fields that update on a configurable schedule ranging from 5 minutes to daily, enabling marketing teams to monitor email performance and customer journeys without technical expertise.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

ActiveCampaign data available in Redash

available pipelines

644

extractable fields

Available integrations

Integration	Description
Accounts	Contains information about accounts, including ID, registered URL, contact count, and account name.
Accounts: Contacts	Presents relationships between accounts and contacts, including account and contact IDs, as well as the creation timestamp of the link.
Accounts: Custom Fields (Data)	Includes values of custom fields for accounts, such as value ID, account ID, and creation timestamp.
Accounts: Custom Fields (Meta)	Provides metadata for custom fields, including field ID, field type, and available options.
Accounts: Notes	Records notes associated with accounts, featuring fields like note ID, note text, and creation date.
Campaigns	Contains data about campaigns, including ID, campaign name, and current status.
Campaigns: Messages	Presents messages sent in campaigns, with fields such as message ID and message content.
Campaigns: Messages: Content	Includes the content of campaign messages, detailing the text and visual elements used.
Contacts	Stores information about contacts, including ID, name, and contact details.
Contacts: Custom Fields (Data)	Contains values of custom fields for contacts, such as value ID and associated contact ID.
Contacts: custom fields (meta)	Includes metadata such as field ID, type, available options, and whether the field is required or visible in forms.
Contacts: list activity	Records contact activity in lists, including contact ID, list ID, and date/time of the activity.
Contacts: notes	Contains notes associated with contacts, featuring fields like note ID, note text, and creation date.
Contacts: tags	List of tags assigned to contacts, including tag ID, contact ID, and tag creation date.
Contacts: tasks	Includes tasks related to contacts, featuring fields like task ID, status, and due date.
Deals	Represents deals with fields like deal ID, value, status, and creation date.
Deals: activities	Records activities associated with deals, including activity ID, type, and activity date.
Deals: custom fields (data)	Contains values of custom fields for deals, including field ID and field value.
Deals: custom fields (meta)	Includes metadata for custom fields of deals, such as field ID, type, and whether it is required.
Deals: secondary contacts	List of secondary contacts associated with deals, including contact IDs and deal IDs.
Deals Tasks	View tasks associated with deals, including fields such as ID, status, and created timestamp.
Lists	Manage contact lists, with information on ID, name, and contact count.
List Contacts	Examine the relationship between lists and contacts, including list ID, contact ID, and created timestamp.
Pipelines	Visualize sales pipelines, with details on ID, name, and stages of deals.
Scores	Track scores assigned to contacts or deals, including ID and score value.
Tasks Outcomes	Analyze task outcomes, with fields such as ID, status, and completion date.
Tasks Types	Explore different types of tasks, including ID, name, and description.
User Groups	Manage user groups, with information on ID, name, and assigned permissions.
Users	View information about users, including ID, name, and created timestamp.

Accounts

Contains information about accounts, including ID, registered URL, contact count, and account name.

Accounts: Contacts

Presents relationships between accounts and contacts, including account and contact IDs, as well as the creation timestamp of the link.

Accounts: Custom Fields (Data)

Includes values of custom fields for accounts, such as value ID, account ID, and creation timestamp.

Accounts: Custom Fields (Meta)

Provides metadata for custom fields, including field ID, field type, and available options.

Accounts: Notes

Records notes associated with accounts, featuring fields like note ID, note text, and creation date.

Campaigns

Contains data about campaigns, including ID, campaign name, and current status.

Campaigns: Messages

Presents messages sent in campaigns, with fields such as message ID and message content.

Campaigns: Messages: Content

Includes the content of campaign messages, detailing the text and visual elements used.

Contacts

Stores information about contacts, including ID, name, and contact details.

Contacts: Custom Fields (Data)

Contains values of custom fields for contacts, such as value ID and associated contact ID.

Contacts: custom fields (meta)

Includes metadata such as field ID, type, available options, and whether the field is required or visible in forms.

Contacts: list activity

Records contact activity in lists, including contact ID, list ID, and date/time of the activity.

Contacts: notes

Contains notes associated with contacts, featuring fields like note ID, note text, and creation date.

Contacts: tags

List of tags assigned to contacts, including tag ID, contact ID, and tag creation date.

Contacts: tasks

Includes tasks related to contacts, featuring fields like task ID, status, and due date.

Deals

Represents deals with fields like deal ID, value, status, and creation date.

Deals: activities

Records activities associated with deals, including activity ID, type, and activity date.

Deals: custom fields (data)

Contains values of custom fields for deals, including field ID and field value.

Deals: custom fields (meta)

Includes metadata for custom fields of deals, such as field ID, type, and whether it is required.

Deals: secondary contacts

List of secondary contacts associated with deals, including contact IDs and deal IDs.

Deals Tasks

View tasks associated with deals, including fields such as ID, status, and created timestamp.

Lists

Manage contact lists, with information on ID, name, and contact count.

List Contacts

Examine the relationship between lists and contacts, including list ID, contact ID, and created timestamp.

Pipelines

Visualize sales pipelines, with details on ID, name, and stages of deals.

Scores

Track scores assigned to contacts or deals, including ID and score value.

Tasks Outcomes

Analyze task outcomes, with fields such as ID, status, and completion date.

Tasks Types

Explore different types of tasks, including ID, name, and description.

User Groups

Manage user groups, with information on ID, name, and assigned permissions.

Users

View information about users, including ID, name, and created timestamp.

See all available data →

Try out all the features for free for 14 days

Get started for free

Get started for free

Get started for free

Connect ActiveCampaign to Redash: Dashboards in Minutes

Get started for free

How to Visualize ActiveCampaign Data in Redash

ActiveCampaign data available in Redash

Available integrations

How to create ActiveCampaign dashboards in Redash

Add ActiveCampaign to Kondado

Choose Redash as your destination

Configure refresh and create visualizations

Access ActiveCampaign data in Redash and combine it with dozens of other data sources

55pbx

ActiveCampaign

Google Ads

Amazon S3

api4com

Apple App Store

ASAAS

AWS CloudWatch Metrics

Azure Table Storage

BigQuery

Bing

Bitrix24 CRM

Bling!

Blip (take)

ClickUp

Clockify

ContaAzul

Criteo

E-goi

EADBOX

Exact Sales

Facebook Ads

Facebook

Fatura Simples

Freshdesk

FTP

Google Analytics GA4

Google Cloud Storage

Google Play Store

Google Search Console

Google Sheets

Granatum

Hi Platform

Hotmart

Hubspot

Huggy

InfluxDB v1

Infusionsoft (Keap)

Instagram Ads

Instagram

Jira

Linkedin

Loja Integrada

MailChimp

Mandrill

Mautic

Meetime

Mercado Libre

Meta Ads

Microsoft Ads

Microsoft Advertising

Mixpanel

monday.com

MongoDB

Movidesk

MySQL (& MariaDB)

NectarCRM

Notion

Nuvemshop (Tiendanube)

Olist Tiny

Omie

Oracle

Pagar.me

Pinterest Ads

Pipedrive

Pipefy

PipeRun