Power My Analytics
Free Trial Log In

Constant Contact Metrics & Dimensions

LabelDescriptionNameTypeData TypeTables
Account IDThe unique identifier for an account.account_idDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
Account NameThe name of the account. Also called "user name."configNameDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
Bounce RateThe percentage of emails that didn’t make it to the subscriber.bounce_rateMETRICNUMBER
  • campaigns
BouncesThe number of emails that didn’t make it to the subscriber.bouncesMETRICNUMBER
  • campaigns
Campaign Created DateThe date a campaign was created.campaign_created_dateDIMENSIONSTRING
  • campaigns_dimensions
Campaign IDThe ID of the email campaign configured in Constant Contact.campaign_idDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
Campaign Modified DateThe date a campaign was modified.campaign_modified_dateDIMENSIONSTRING
  • campaigns_dimensions
Campaign NameThe name of a campaign.campaign_nameDIMENSIONSTRING
  • campaigns_dimensions
Campaign StatusThe status of a campaign.campaign_statusDIMENSIONSTRING
  • campaigns_dimensions
Campaign TypeIdentifies the email campaign type.campaign_typeDIMENSIONSTRING
  • campaigns_dimensions
Click RateThe click through rate, determined by email clicks divided by email opened.click_rateMETRICNUMBER
  • campaigns
ClicksThe number of clicks an email receives.clicksMETRICNUMBER
  • campaigns
Contacts CountTotal number of contacts.contacts_countMETRICNUMBER
  • contacts
Data FreshnessUsed by Power My Analytics to improve report quality.dataFreshnessDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
Data SourceData source titledataSourceDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
Data Source LogoData source logodataSourceLogoDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
DateThe date and time dimension.dateDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Day Of MonthThe dimension that determines how date-based data in a chart is handled.day_of_monthDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Day Of WeekThe dimension that determines how date-based data in a chart is handled.day_of_weekDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
ForwardsThe number of times an email was forwarded.forwardsMETRICNUMBER
  • campaigns
List Contact CountThe number of contacts in the list.list_contact_countMETRICNUMBER
  • lists
List Created DateTime stamp indicating when the contact list was created, in ISO-8601 format.list_created_dateDIMENSIONSTRING
  • lists
List FavoriteIdentifies whether or not the account has favorited the contact list.list_favoriteMETRICNUMBER
  • lists
List IDUnique ID for a contact list.list_idDIMENSIONSTRING
  • lists
List Modified DateTime stamp indicating when the contact list was last modified, in ISO-8601 format.list_modified_dateDIMENSIONSTRING
  • lists
List NameContact list name.list_nameDIMENSIONSTRING
  • lists
MonthThe dimension that determines how date-based data in a chart is handled.month_onlyDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Month DayThe dimension that determines how date-based data in a chart is handled.month_dayDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Open RateThe open rate, determined by email opens divided by email arrived.open_rateMETRICNUMBER
  • campaigns
OpensThe number of times an email is openedopensMETRICNUMBER
  • campaigns
PMA Is Interpolated?Used by Power My Analytics to indicate whether lifetime data might be interpolatedisInterpolatedBOOLEAN
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
PMA Maximum Cached Data DateUsed by Power My Analytics to indicate maximum cached data date.MaxDateDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
PMA Minimum Cached Data DateUsed by Power My Analytics to indicate minimum cached data date.MinDateDIMENSIONSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
PMA Payment URLUsed by Power My Analytics to provide URL to activate your account, or to see the billing information.PaymentSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
PMA Subscription IDUsed by Power My Analytics for billing and user-identification with our support staff.SubscriptionSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
PMA Trial StatusUsed by Power My Analytics to show trial as Active, Expired or number of days remaining.TrialSTRING
  • campaigns
  • campaigns_dimensions
  • contacts
  • lists
QuarterThe dimension that determines how date-based data in a chart is handled.quarterDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Send DateThe date a campaign email was sent to subscribers.campaign_last_run_dateDIMENSIONSTRING
  • campaigns
SendsThe number of contacts you sent your email to.sendsMETRICNUMBER
  • campaigns
Spam CountNumber of spam complaints received.spam_countMETRICNUMBER
  • campaigns
Spam RateThe spam rate, determined by email spam divided by email sent.spam_rateMETRICNUMBER
  • campaigns
Successful DeliveriesThe number of emails sent that were successfully delivered to your contacts’ inboxesarrivedMETRICNUMBER
  • campaigns
UnopenedThe number of sends that were not opened.unopenedMETRICNUMBER
  • campaigns
Unopened RateThe unopened rate, determined by email unopened divided by email arrived.unopened_rateMETRICNUMBER
  • campaigns
UnsubscribesThe total number of unique unsubscribes.unsubscribesMETRICNUMBER
  • campaigns
Unsubscribes RateThe unsubscribes rate, determined by email unsubscribes divided by email sent.unsubscribes_rateMETRICNUMBER
  • campaigns
WeekThe dimension that determines how date-based data in a chart is handled.weekDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
YearThe dimension that determines how date-based data in a chart is handled.yearDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Year MonthThe dimension that determines how date-based data in a chart is handled.monthDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Year QuarterThe dimension that determines how date-based data in a chart is handled.year_quarterDIMENSIONSTRING
  • campaigns
  • contacts
  • lists
Year WeekThe dimension that determines how date-based data in a chart is handled.year_weekDIMENSIONSTRING
  • campaigns
  • contacts
  • lists

← Back to Constant Contact Data Connector

Preferred by data-driven businesses

Humane Society
Wyndham
Bissell
Autonation
Oneill