Exclusive: all our customers get a free six-month subscription to EDNA, a next-gen data and AI learning platform

Knowledge base

Data Model Explorer

Our Data Model Explorer provides an Entity Relationship Diagram (ERD) of your Constant Contact data, allowing you to see the relationships between your different tables.

  1. Drag tables around the workspace, by clicking and dragging anywhere on a table
  2. Drag the entire workspace around by clicking and dragging the background
  3. Minimize/maximize your workspace to take up your entire browser screen

Relationships

Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the Relationships Only checkbox, which will hide all the other columns which are not part of a relationship

Endpoints

  • Open event
  • Did not open event
  • Forward event
  • Send event
  • Opt out event
  • Bounce event
  • Click event
  • Contact
  • Contact list
  • Custom field
  • Email campaign
  • Contact custom field
  • Contact phone number
  • Contact street address
  • Contact list membership
  • Campaign activity