Connect ActiveCampaign to Google Data Studio with Windsor.ai
Directly connect ActiveCampaign to Google Data Studio, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.
Automate and save time.
No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Use all your data where and when you need it.
We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).
About ActiveCampaign
ActiveCampaign is a cloud-based customer experience automation (CXA) platform that provides businesses with tools for marketing automation, email marketing, sales automation, customer relationship management (CRM), and messaging. The platform enables businesses to segment customer data based on various factors, including customer behavior, interests, and demographics, and helps them create personalized customer experiences at scale. 180K+ businesses in 170 countries use ActiveCampaign to deepen relationships with customers at every touch point.
Learn more about ActiveCampaign
About Google Data Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Google Data Studio
Why integrate ActiveCampaign with Google Data Studio?
- Integrating ActiveCampaign with Google Data Studio makes it easier to track and analyze performance metrics across multiple channels and campaigns and identify areas for optimization.
- You can connect the data from ActiveCampaign with other sources using Google Data Studio to reveal the entire customer journey which helps you optimize the customer experience and drive growth.
- Google Data Studio provides a range of visualization options and customization features that allow you to monitor key metrics for email marketing performance, such as open rates, click-through rates, and conversion rates.
- By connecting ActiveCampaign with Google Data Studio, you can analyze how different segments are engaging with your email campaigns, and adjust your messaging accordingly.
- Google Data Studio enables you to automate your email marketing reporting processes and receive regular updates on your performance metrics without having to manually generate reports.
About ActiveCampaign Google Data Studio Connector
The ActiveCampaign Google Data Studio connector pulls metrics and dimensions from ActiveCampaign. The insights are retrieved at address, automation, campaign, contact, deal, and message level.
Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- An ActiveCampaign API URL and an ActiveCampaign API key
- A Google account for ActiveCampaign to Google Data Studio integration.
- A Windsor account. Start your free trial now.
How to connect ActiveCampaign to Google Data Studio?
You need to select ActiveCampaign as a Data Source and grant access to Windsor.ai. You should have an ActiveCampaign API URL and an ActiveCampaign API key in order to use this connector.
Select the fields on the right to later use in your data source. For example, you can include metrics such as Open Rate, Click-Through Rate, or Message text.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Google Data Studio Templates for ActiveCampaign
Do you plan to connect and visualize ActiveCampaign data in Google Data Studio?
These free and customizable Google Data Studio ActiveCampaign templates will assist you in visualizing your data for easy reporting and analysis.
Google Data Studio Tutorials for ActiveCampaign
Would you like to take your Google Data Studio ActiveCampaign dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available ActiveCampaign Metrics and Dimensions
| Name | Type | Description |
|---|---|---|
| Address address1 | TEXT | Address address1 |
| Address address2 | TEXT | Address address2 |
| Address allgroup | TEXT | Address allgroup |
| Address city | TEXT | Address city |
| Address company name | TEXT | Address company name |
| Address country | TEXT | Address country |
| Address district | TEXT | Address district |
| Address id | TEXT | Address id |
| Address is default flag | TEXT | Address is default flag |
| Address state | TEXT | Address state |
| Address zip | TEXT | Address zip |
| Automation cdate | DATE | Automation creation date |
| Automation default screenshot | TEXT | Automation default screenshot |
| Automation entered | TEXT | Automation entered |
| Automation exited | TEXT | Automation exited |
| TEXT | Automation hidden | |
| Automation id | TEXT | Automation id |
| Automation mdate | DATE | Automation modification date |
| Automation name | TEXT | Automation name |
| Automation screenshot | TEXT | Automation screenshot |
| Automation status | TEXT | Automation status |
| Automation user id | TEXT | Automation user id |
| Campaign name | TEXT | Campaign name |
| Campaign activerss interval | TEXT | Campaign activerss interval |
| Campaign activerss items | TEXT | Campaign activerss items |
| Campaign activerss url | TEXT | Campaign activerss url |
| Campaign address id | TEXT | Campaign address id |
| Campaign analytics_campaign_name | TEXT | Campaign analytics_campaign_name |
| Campaign automation | TEXT | Campaign automation |
| Campaign base message id | TEXT | Campaign base message id |
| Campaign basetemplate id | TEXT | Campaign basetemplate id |
| Campaign bounce id | TEXT | Campaign bounce id |
| Campaign cdate | DATE | Campaign creation date |
| Campaign deletestamp | TEXT | Campaign deletestamp |
| Campaign embed_images | TEXT | Campaign embed_images |
| Campaign facebook | TEXT | Campaign facebook |
| Campaign form id | TEXT | Campaign form id |
| Campaign forwards | NUMERIC | Campaign forwards |
| Campaign hard bounces | NUMERIC | Campaign hard bounces |
| Campaign html unsub | NUMERIC | Campaign html unsub |
| Campaign html unsub data | TEXT | Campaign html unsub data |
| Campaign id | TEXT | Campaign id |
| Campaign ip4 | TEXT | Campaign ip4 |
| Campaign last step | TEXT | Campaign last step |
| Campaign ldate | DATE | Campaign ldate |
| Campaign link clicks | NUMERIC | Campaign link clicks |
| Campaign mail_cleanup | TEXT | Campaign mail_cleanup |
| Campaign mail_send | TEXT | Campaign mail_send |
| Campaign mail transfer | TEXT | Campaign mail transfer |
| Campaign mailer_log_file | TEXT | Campaign mailer_log_file |
| Campaign manage text | TEXT | Campaign manage text |
| Campaign mdate | DATE | Campaign modification date |
| Campaign opens | NUMERIC | Campaign opens |
| Campaign public | TEXT | Campaign public |
| Campaign realcid | TEXT | Campaign realcid |
| Campaign recurring | TEXT | Campaign recurring |
| Campaign reminder field | TEXT | Campaign reminder field |
| Campaign reminder format | TEXT | Campaign reminder format |
| Campaign reminder last cron run | TEXT | Campaign reminder last cron run |
| Campaign reminder offset | TEXT | Campaign reminder offset |
| Campaign reminder offset sign | TEXT | Campaign reminder offset sign |
| Campaign reminder offset type | TEXT | Campaign reminder offset type |
| Campaign reminder type | TEXT | Campaign reminder type |
| Campaign replies | NUMERIC | Campaign replies |
| Campaign replysys | TEXT | Campaign replysys |
| Campaign responder existing | TEXT | Campaign responder existing |
| Campaign responder offset | TEXT | Campaign responder offset |
| Campaign responder type | TEXT | Campaign responder type |
| Campaign schedule | TEXT | Campaign schedule |
| Campaign scheduled date | DATE | Campaign scheduled date |
| Campaign sdate | DATE | Campaign sdate |
| Campaign segment id | TEXT | Campaign segment id |
| Campaign send_amt | NUMERIC | Campaign send_amt |
| Campaign send id | TEXT | Campaign send id |
| Campaign series id | TEXT | Campaign series id |
| Campaign social shares | NUMERIC | Campaign social shares |
| Campaign soft bounces | NUMERIC | Campaign soft bounces |
| Campaign source | TEXT | Campaign source |
| Campaign split content | TEXT | Campaign split content |
| Campaign split offset | TEXT | Campaign split offset |
| Campaign split offset type | TEXT | Campaign split offset type |
| Campaign split type | TEXT | Campaign split type |
| Campaign split winner awaiting | TEXT | Campaign split winner awaiting |
| Campaign split winner message id | TEXT | Campaign split winner message id |
| Campaign status | TEXT | Campaign status |
| Campaign subscriber clicks | NUMERIC | Campaign subscriber clicks |
| Campaign survey | TEXT | Campaign survey |
| Campaign text unsub | NUMERIC | Campaign text unsub |
| Campaign text unsub data | TEXT | Campaign text unsub data |
| Campaign thread id | TEXT | Campaign thread id |
| Campaign total_amt | NUMERIC | Campaign total_amt |
| Campaign track links | TEXT | Campaign track links |
| Campaign track links analytics | TEXT | Campaign track links analytics |
| Campaign track reads | TEXT | Campaign track reads |
| Campaign track reads analytics | TEXT | Campaign track reads analytics |
| Campaign tweet | TEXT | Campaign tweet |
| ActiveCampaign campaign type | TEXT | ActiveCampaign campaign type |
| Campaign unique forwards | NUMERIC | Campaign unique forwards |
| Campaign unique link clicks | NUMERIC | Campaign unique link clicks |
| Campaign unique opens | NUMERIC | Campaign unique opens |
| Campaign unique replies | NUMERIC | Campaign unique replies |
| Campaign unsub reasons | NUMERIC | Campaign unsub reasons |
| Campaign unsubscribes | NUMERIC | Campaign unsubscribes |
| Campaign updates | DATE | Campaign updates |
| Campaign user | TEXT | Campaign user |
| Campaign user id | TEXT | Campaign user id |
| Campaign waitpreview | TEXT | Campaign waitpreview |
| Campaign willrecur | TEXT | Campaign willrecur |
| Contact adate | DATE | Contact adate |
| Contact bounced date | DATE | Contact bounced date |
| Contact bounced hard | TEXT | Contact bounced hard |
| Contact bounced soft | TEXT | Contact bounced soft |
| Contact cdate | DATE | Contact creation date |
| Contact deleted | TEXT | Contact deleted |
| Contact edate | DATE | Contact edate |
| Contact email | TEXT | Contact email |
| Contact email domain | TEXT | Contact email domain |
| Contact email local | TEXT | Contact email local |
| Contact first name | TEXT | Contact first name |
| Contact gravatar | TEXT | Contact gravatar |
| Contact hash | TEXT | Contact hash |
| Contact id | TEXT | Contact id |
| Contact ip | TEXT | Contact ip |
| Contact last name | TEXT | Contact last name |
| Contact organization | TEXT | Contact organization |
| Contact orgid | TEXT | Contact orgid |
| Contact phone | TEXT | Contact phone |
| Contact rating_tstamp | TEXT | Contact rating_tstamp |
| Contact segmentio_id | TEXT | Contact segmentio_id |
| Contact sentcnt | NUMERIC | Contact sentcnt |
| Contact socialdata_lastcheck | TEXT | Contact socialdata_lastcheck |
| Contact ua | TEXT | Contact ua |
| Contact udate | DATE | Contact update date |
| Deal account | TEXT | Deal account |
| Deal activity count | NUMERIC | Deal activity count |
| Deal cdate | DATE | Deal creation date |
| Deal contact | TEXT | Deal contact |
| Deal currency | TEXT | Deal currency |
| Deal customer account | TEXT | Deal customer account |
| Deal description | TEXT | Deal description |
| Deal edate | DATE | Deal edate |
| Deal group | TEXT | Deal group |
| Deal id | TEXT | Deal id |
| Deal mdate | DATE | Deal modification date |
| Deal next date | DATE | Deal next date |
| Deal next deal id | TEXT | Deal next deal id |
| Deal next task id | TEXT | Deal next task id |
| Deal organization | TEXT | Deal organization |
| Deal owner | TEXT | Deal owner |
| Deal percent | PERCENT | Deal percent |
| Deal stage | TEXT | Deal stage |
| Deal status | TEXT | Deal status |
| Deal task assignee | TEXT | Deal task assignee |
| Deal task automation | TEXT | Deal task automation |
| Deal task cdate | DATE | Deal task creation date |
| Deal task type | TEXT | Deal task type |
| Deal task done automation | TEXT | Deal task done automation |
| Deal task due date | DATE | Deal task due date |
| Deal task edate | DATE | Deal task edate |
| Deal task id | TEXT | Deal task id |
| Deal task note | TEXT | Deal task note |
| Deal task outcome info | TEXT | Deal task outcome info |
| Deal task outcome id | TEXT | Deal task outcome id |
| Deal task relid | TEXT | Deal task relid |
| Deal task reltype | TEXT | Deal task reltype |
| Deal task status | TEXT | Deal task status |
| Deal task title | TEXT | Deal task title |
| Deal task udate | DATE | Deal task update date |
| Deal task user | TEXT | Deal task user |
| Deal title | TEXT | Deal title |
| Deal value | NUMERIC | Deal value |
| Deal win probability | NUMERIC | Deal win probability |
| Deal win probability mdate | DATE | Deal win probability mdate |
| List analytics_domains | TEXT | List analytics_domains |
| List analytics_source | TEXT | List analytics_source |
| List analytics_ua | TEXT | List analytics_ua |
| List carboncopy | TEXT | List carboncopy |
| List cdate | DATE | List creation date |
| List deletestamp | TEXT | List deletestamp |
| List facebook session | TEXT | List facebook session |
| List full address | TEXT | List full address |
| List get_unsubscribe_reason | TEXT | List get_unsubscribe_reason |
| List id | TEXT | List id |
| List name | TEXT | List name |
| List optinmessageid | TEXT | List optinmessageid |
| List optin optout | TEXT | List optin optout |
| List optout conf | TEXT | List optout conf |
| List p_embed_image | TEXT | List p_embed_image |
| List p_use_analytics_link | TEXT | List p_use_analytics_link |
| List p_use_analytics_read | TEXT | List p_use_analytics_read |
| List p_use_captcha | TEXT | List p_use_captcha |
| List p_use_facebook | TEXT | List p_use_facebook |
| List p_use_tracking | TEXT | List p_use_tracking |
| List p_use_twitter | TEXT | List p_use_twitter |
| List private | TEXT | List private |
| List require name | TEXT | List require name |
| List send_last_broadcast | TEXT | List send_last_broadcast |
| List sender addr1 | TEXT | List sender addr1 |
| List sender addr2 | TEXT | List sender addr2 |
| List sender city | TEXT | List sender city |
| List sender country | TEXT | List sender country |
| List sender name | TEXT | List sender name |
| List sender phone | TEXT | List sender phone |
| List sender reminder | TEXT | List sender reminder |
| List sender state | TEXT | List sender state |
| List sender url | TEXT | List sender url |
| List sender zip | TEXT | List sender zip |
| List string id | TEXT | List string id |
| List subscription_notify | TEXT | List subscription_notify |
| List to_name | TEXT | List to_name |
| List twitter_token | TEXT | List twitter_token |
| List twitter token secret | TEXT | List twitter token secret |
| List update date | DATE | List update date |
| List unsubscription notify | TEXT | List unsubscription notify |
| List user | TEXT | List user |
| List user id | TEXT | List user id |
| Message cdate | DATE | Message creation date |
| Message charset | TEXT | Message charset |
| Message ed_instanceid | TEXT | Message ed_instanceid |
| Message ed_version | TEXT | Message ed_version |
| Message encoding | TEXT | Message encoding |
| Message format | TEXT | Message format |
| Message from email | TEXT | Message from email |
| Message from name | TEXT | Message from name |
| TEXT | Message hidden | |
| Message html | TEXT | Message html |
| Message html fetch | TEXT | Message htmlfetch |
| Message id | TEXT | Message id |
| Message mdate | DATE | Message modification date |
| Message name | TEXT | Message name |
| Message preheader text | TEXT | Message preheader text |
| Message preview data | TEXT | Message preview data |
| Message preview mime | TEXT | Message preview mime |
| Message priority | TEXT | Message priority |
| Message reply2 | TEXT | Message reply2 |
| Message subject | TEXT | Message subject |
| Message text | TEXT | Message text |
| Message text fetch | TEXT | Message text fetch |
| Message user | TEXT | Message user |
| Message user id | TEXT | Message user id |