I can connect active campaign to Quicksight. How can I do it?
Hi @edwardrollout welcome to the QuickSight community! Thanks for your query.
If I understand your question properly, you want to pull data from ActiveCampaign and create reports in QuickSight. If yes, one of the approaches that you can take is as follows:
- Pull the data from ActiveCampaign into AWS. I see a link on S3 integration. You may use APIs provided by ActiveCampaign or leverage partners
- You crawl and catalog the data stored in S3 using Glue crawler. The catalog can be queried using Athena.
- Use Glue catalog as your data source for QuickSight and create analysis/ dashboard. Please refer to the following link.
If my understanding is incorrect, I’ll request you to clarify your ask. Thanks!
Hi @edwardrollout - We hope this solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking this answer as a “Solution.”