We’re trying to do some deeper analysis on open/click rates in automated campaigns, but we’re running into some apparent limitations of the ActiveCampaign API. Specifically, it doesn’t seem possible to track opens and clicks back to an individual e-mail that was sent, only to the governing campaign.
For example, consider a campaign that periodically sends an e-mail, with 1 subscriber. If this contact has received 3 e-mails within that campaign, the /api/3/logs API endpoint will show 3 entries, one for each e-mail sent to this contact. However, the /api/3/linkData endpoint aggregates open/click events over the entire campaign. Therefore, we currently can’t calculate the exact open rate for each specific e-mail separately.
Is it possible to get this data on a more granular level through the API, e.g. by getting access to the raw open / click events?
This may be possible using the v1 API. The calls for campaign_report_link_list and campaign_report_open_list both take an optional messageid parameter in addition to the required campaignid . If you know the messageid for each specific email, you may be able to find it that way, although I have not personally tested/confirmed this.
Thanks for the suggestion! I looked into this, but it seems messageid is not unique per sent, rather it’s unique per message. In many cases, the same message is sent multiple times over longer periods of time within a campaign to the same subscriber, e.g. a follow-up e-mail after an order in a e-commerce setting for recurring customers.
I did notice the field sendid in the response of the logs endpoint, which seems to be unique per send. However, this field currently isn’t available in the open/link data. Would it be possible (and make sense) to add it there?