Explore the Constant Contact API data model

See how the various Constant Contact endpoints relate to each other, using our handy Entity Relationship Diagram

Free trial Book a demo

Pulling data from the Constant Contact API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SYNCHUB, we not only sync your Constant Contact API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

What can you do with your Constant Contact data?

Connect your AI chatbots & agentic workflows

Our Universal MCP Server lets you query your Constant Contact data using Claude, ChatGPT or your favourite AI tool.

Empower your BI dashboards

Our Constant Contact Connector connects your Constant Contact data to favourite reporting tools.

Your business runs on more than just Constant Contact

We connect to over over 70+ cloud services, letting you manage the data needs of your entire business in a single location.

Endpoints

Browse the data model below, or if you'd prefer, we also have an interactive ERD over here.

OpenEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DeviceType string - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

DidNotOpenEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

ForwardEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

SendEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

OptOutEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
OptOutReason string - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

BounceEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BounceCode string - -
CurrentEmailAddress string - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

ClickEvent

Column Type Relates to Notes
RemoteID string - -
CampaignActivityRemoteID string CampaignActivity → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DeviceType string - -
UrlID string - -
LinkUrl string - -
CampaignActivityID guid CampaignActivity → CampaignActivityID -
TrackingActivityType string - -
ContactID guid Contact → ContactID -
EmailAddress string - -
FirstName string - -
LastName string - -
CreatedTime datetime - -

Contact

Documentation: https://developer.constantcontact.com/api_reference/index.html#!/Contacts/getContacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID guid - -
FirstName string - -
LastName string - -
JobTitle string - -
CompanyName string - -
BirthdayMonth int - -
BirthdayDay int - -
Anniversary datetime - -
UpdateSource string - -
CreateSource string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DeletedAt datetime - -
Email string - -
EmailPermissionToSend string - -
EmailOptInSource string - -
EmailOptInDate datetime - -
EmailOptOutSource string - -
EmailOptOutDate datetime - -
EmailOptOutReason string - -
EmailConfirmStatus string - -

ContactList

Documentation: https://developer.constantcontact.com/api_reference/index.html#!/Contact_Lists/getLists

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
ListID guid - -
Favorite boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
MembershipCount int - -

CustomField

Documentation: https://developer.constantcontact.com/api_reference/index.html#!/Contacts_Custom_Fields/getCustomFields

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CustomFieldID guid - -
Label string - -
Type string - -
UpdatedAt datetime - -
CreatedAt datetime - -

EmailCampaign

Documentation: https://developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCampaignsUsingGET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
CampaignID guid - -
CreatedAt datetime - -
CurrentStatus string - -
Type string - -
UpdatedAt datetime - -

ContactCustomField

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID guid Contact → ContactID -
CustomFieldID guid - -
Value string - -

ContactPhoneNumber

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID guid Contact → ContactID -
PhoneNumberID guid - -
PhoneNumber string - -
Kind string - -
CreatedAt datetime - -
UpdatedAt datetime - -
UpdateSource string - -
CreateSource string - -

ContactStreetAddress

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID guid Contact → ContactID -
StreetAddressID guid - -
Kind string - -
Street string - -
City string - -
State string - -
PostalCode string - -
Country string - -
CreatedAt datetime - -
UpdatedAt datetime - -

ContactListMembership

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ContactID guid Contact → ContactID -
ContactListID guid ContactList → ListID -

CampaignActivity

Documentation: https://developer.constantcontact.com/api_reference/index.html#!/Email_Campaigns/retrieveEmailCampaignActivityUsingGET

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
CampaignActivityID guid - -
CampaignID guid EmailCampaign → CampaignID -
Role string - -

Need more?

SYNCHUB lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Constant Contact data Querying Constant Contact using regular SQL