Label | Description | Name | Type | Data Type | Tables |
---|---|---|---|---|---|
Account ID | The unique identifier for an account. | account_id | DIMENSION | STRING |
|
Account Name | The name of the account. Also called "user name." | configName | DIMENSION | STRING |
|
Bounce Rate | The percentage of emails that didn’t make it to the subscriber. | bounce_rate | METRIC | NUMBER |
|
Bounces | The number of emails that didn’t make it to the subscriber. | bounces | METRIC | NUMBER |
|
Campaign Created Date | The date a campaign was created. | campaign_created_date | DIMENSION | STRING |
|
Campaign ID | The ID of the email campaign configured in Constant Contact. | campaign_id | DIMENSION | STRING |
|
Campaign Modified Date | The date a campaign was modified. | campaign_modified_date | DIMENSION | STRING |
|
Campaign Name | The name of a campaign. | campaign_name | DIMENSION | STRING |
|
Campaign Status | The status of a campaign. | campaign_status | DIMENSION | STRING |
|
Campaign Type | Identifies the email campaign type. | campaign_type | DIMENSION | STRING |
|
Click Rate | The click through rate, determined by email clicks divided by email opened. | click_rate | METRIC | NUMBER |
|
Clicks | The number of clicks an email receives. | clicks | METRIC | NUMBER |
|
Contacts Count | Total number of contacts. | contacts_count | METRIC | NUMBER |
|
Data Freshness | Used by Power My Analytics to improve report quality. | dataFreshness | DIMENSION | STRING |
|
Data Source | Data source title | dataSource | DIMENSION | STRING |
|
Data Source Logo | Data source logo | dataSourceLogo | DIMENSION | STRING |
|
Date | The date and time dimension. | date | DIMENSION | STRING |
|
Day Of Month | The dimension that determines how date-based data in a chart is handled. | day_of_month | DIMENSION | STRING |
|
Day Of Week | The dimension that determines how date-based data in a chart is handled. | day_of_week | DIMENSION | STRING |
|
Forwards | The number of times an email was forwarded. | forwards | METRIC | NUMBER |
|
List Contact Count | The number of contacts in the list. | list_contact_count | METRIC | NUMBER |
|
List Created Date | Time stamp indicating when the contact list was created, in ISO-8601 format. | list_created_date | DIMENSION | STRING |
|
List Favorite | Identifies whether or not the account has favorited the contact list. | list_favorite | METRIC | NUMBER |
|
List ID | Unique ID for a contact list. | list_id | DIMENSION | STRING |
|
List Modified Date | Time stamp indicating when the contact list was last modified, in ISO-8601 format. | list_modified_date | DIMENSION | STRING |
|
List Name | Contact list name. | list_name | DIMENSION | STRING |
|
Month | The dimension that determines how date-based data in a chart is handled. | month_only | DIMENSION | STRING |
|
Month Day | The dimension that determines how date-based data in a chart is handled. | month_day | DIMENSION | STRING |
|
Open Rate | The open rate, determined by email opens divided by email arrived. | open_rate | METRIC | NUMBER |
|
Opens | The number of times an email is opened | opens | METRIC | NUMBER |
|
PMA Is Interpolated? | Used by Power My Analytics to indicate whether lifetime data might be interpolated | isInterpolated | BOOLEAN |
| |
PMA Maximum Cached Data Date | Used by Power My Analytics to indicate maximum cached data date. | MaxDate | DIMENSION | STRING |
|
PMA Minimum Cached Data Date | Used by Power My Analytics to indicate minimum cached data date. | MinDate | DIMENSION | STRING |
|
PMA Payment URL | Used by Power My Analytics to provide URL to activate your account, or to see the billing information. | Payment | STRING |
| |
PMA Subscription ID | Used by Power My Analytics for billing and user-identification with our support staff. | Subscription | STRING |
| |
PMA Trial Status | Used by Power My Analytics to show trial as Active, Expired or number of days remaining. | Trial | STRING |
| |
Quarter | The dimension that determines how date-based data in a chart is handled. | quarter | DIMENSION | STRING |
|
Send Date | The date a campaign email was sent to subscribers. | campaign_last_run_date | DIMENSION | STRING |
|
Sends | The number of contacts you sent your email to. | sends | METRIC | NUMBER |
|
Spam Count | Number of spam complaints received. | spam_count | METRIC | NUMBER |
|
Spam Rate | The spam rate, determined by email spam divided by email sent. | spam_rate | METRIC | NUMBER |
|
Successful Deliveries | The number of emails sent that were successfully delivered to your contacts’ inboxes | arrived | METRIC | NUMBER |
|
Unopened | The number of sends that were not opened. | unopened | METRIC | NUMBER |
|
Unopened Rate | The unopened rate, determined by email unopened divided by email arrived. | unopened_rate | METRIC | NUMBER |
|
Unsubscribes | The total number of unique unsubscribes. | unsubscribes | METRIC | NUMBER |
|
Unsubscribes Rate | The unsubscribes rate, determined by email unsubscribes divided by email sent. | unsubscribes_rate | METRIC | NUMBER |
|
Week | The dimension that determines how date-based data in a chart is handled. | week | DIMENSION | STRING |
|
Year | The dimension that determines how date-based data in a chart is handled. | year | DIMENSION | STRING |
|
Year Month | The dimension that determines how date-based data in a chart is handled. | month | DIMENSION | STRING |
|
Year Quarter | The dimension that determines how date-based data in a chart is handled. | year_quarter | DIMENSION | STRING |
|
Year Week | The dimension that determines how date-based data in a chart is handled. | year_week | DIMENSION | STRING |
|
Preferred by data-driven businesses