The Active Campaign connector allows us to pull tables for our email campaigns (campaign), email lists (list), and email contacts (contact). There are no connector tables that let us map which email lists a campaign is sent to or which contacts are subscribed to each list.

I propose two new tables: one that relates contacts to lists and one that relates lists to campaigns.

API endpoints:

• {account_info}/api/3/contacts/{contact_id}/contactLists
• {account_info}/api/3/campaigns/{campaign_id}/campaignLists

The table would be structured in the same way the contact_tag table is structured. There would be a row for each contact for each list they belong to.