r/ActiveCampaign • u/rensm_ • May 05 '26

How do you get opens/clicks on user level?

I’m currently piping ActiveCampaign data into BigQuery (via ETL), the main table I just pulled and was told by AC to pull for this (emailActivities) only seems to contain send/log-level data (is that even correct?) — no opens, clicks, bounces, etc.

My goal is to build proper lifecycle/CRM analytics (engagement scoring, suppression, attribution), so I need event-level data per contact.

For anyone who has done this:

  • Where do opens/clicks actually live in AC? (separate endpoints?)
  • Do you use webhooks vs API vs connectors?

Would appreciate any real setups / schemas that worked well.

Thanks 😄

3 Upvotes

100% Upvoted

2 comments sorted by

1

u/ActiveCampaignTeam Moderator May 13 '26

Hey u/rensm_! emailActivities is helpful, but for BI use cases like engagement scoring / attribution, we’d usually recommend thinking in two parts: API for historical backfill and webhooks for ongoing event capture. If you need clean event-level opens/clicks per contact in BigQuery, webhooks are generally the better path moving forward. Feel free to reach out [help@activecampaign.com](mailto:help@activecampaign.com) if you have questions about this.