Guides
Shape Help Center

Constant Contact Fields

Suggest Edits

Dimensions (42)

Account

NinjaCat System ID: constant_contact:DIM_ACCOUNT
Data Type: text
Aggregates To: DIM_ACCOUNT

Activity Contact Id

API Name: contact_id
NinjaCat System ID: constant_contact:DIM_activityContactId
Data Type: text

Activity Email Address

API Name: email_address
NinjaCat System ID: constant_contact:DIM_activityEmail
Data Type: text

Bounce Date

API Name: bounce_date
NinjaCat System ID: constant_contact:DIM_bounceDate
Data Type: date

Bounce Description

API Name: bounce_description
NinjaCat System ID: constant_contact:DIM_bounceDescription
Data Type: text

Campaign Group

NinjaCat System ID: constant_contact:DIM_CampaignGroup
Data Type: text
Aggregates To: DIM_CAMPAIGN_GROUPS

Campaign Id

API Name: id
NinjaCat System ID: constant_contact:DIM_campaignId
Data Type: text
Aggregates To: DIM_CAMPAIGN_ID

Campaign Name

API Name: name
NinjaCat System ID: constant_contact:DIM_campaign
Data Type: text
Aggregates To: DIM_CAMPAIGN_NAME

Campaign Status

API Name: status
NinjaCat System ID: constant_contact:DIM_campaignStatus
Data Type: text
Aggregates To: DIM_CAMPAIGN_STATUS

Campaign Subject

API Name: subject
NinjaCat System ID: constant_contact:DIM_subject
Data Type: text

Click Date

API Name: click_date
NinjaCat System ID: constant_contact:DIM_clickDate
Data Type: date

Click Link Id

API Name: link_id
NinjaCat System ID: constant_contact:DIM_clickLinkId
Data Type: text

Click Url

API Name: link_url
NinjaCat System ID: constant_contact:DIM_clickLinkUrl
Data Type: text

Created Date

API Name: created_date
NinjaCat System ID: constant_contact:DIM_createdDate
Data Type: date

Currency

NinjaCat System ID: constant_contact:DIM_CURRENCY
Data Type: text
Aggregates To: DIM_CURRENCY

Data Source

NinjaCat System ID: constant_contact:DIM_DATA_SOURCE
Data Type: text
Aggregates To: DIM_DATA_SOURCE

date

API Name: last_run_date
NinjaCat System ID: constant_contact:DIM_date
Data Type: date
Aggregates To: DIM_DATE

Day Of Month

NinjaCat System ID: constant_contact:DIM_DAY_OF_MONTH
Data Type: integer
Aggregates To: DIM_DAY_OF_MONTH

Day Of Week

NinjaCat System ID: constant_contact:DIM_DAY_OF_WEEK
Data Type: text
Display As: day_of_week
Aggregates To: DIM_DAY_OF_WEEK

Email Content Format

API Name: email_content_format
NinjaCat System ID: constant_contact:DIM_emailContentFormat
Data Type: text

External Id

NinjaCat System ID: constant_contact:DIM_EXTERNAL_ID
Data Type: text
Aggregates To: DIM_EXTERNAL_ID

Forward Date

API Name: forward_date
NinjaCat System ID: constant_contact:DIM_forwardDate
Data Type: date

From Email

API Name: from_email
NinjaCat System ID: constant_contact:DIM_fromEmail
Data Type: text

From Name

API Name: from_name
NinjaCat System ID: constant_contact:DIM_fromName
Data Type: text

Last Run Date

API Name: last_run_date
NinjaCat System ID: constant_contact:DIM_lastRunDate
Data Type: date

Month Of Year

NinjaCat System ID: constant_contact:DIM_MONTH_OF_YEAR
Data Type: text
Display As: date_month_of_year
Aggregates To: DIM_MONTH_OF_YEAR

Network

NinjaCat System ID: constant_contact:DIM_NETWORK
Data Type: text
Display As: title_case
Aggregates To: DIM_NETWORK

Next Run Date

API Name: next_run_date
NinjaCat System ID: constant_contact:DIM_nextRunDate
Data Type: date

Open Date

API Name: open_date
NinjaCat System ID: constant_contact:DIM_openDate
Data Type: date

Permalink Url

API Name: permalink_url
NinjaCat System ID: constant_contact:DIM_permalinkUrl
Data Type: text
Display As: url

Quarter

NinjaCat System ID: constant_contact:DIM_QUARTER
Data Type: text
Display As: quarter
Aggregates To: DIM_QUARTER

Reply-To Email

API Name: reply_to_email
NinjaCat System ID: constant_contact:DIM_replyToEmail
Data Type: text

Row

NinjaCat System ID: constant_contact:DIM_ROW
Data Type: text
Aggregates To: DIM_ROW

Send Date

API Name: send_date
NinjaCat System ID: constant_contact:DIM_sendDate
Data Type: date

System Account ID

NinjaCat System ID: constant_contact:DIM_ACCOUNT_ID
Data Type: text
Aggregates To: DIM_ACCOUNT_ID

Template Type

API Name: template_type
NinjaCat System ID: constant_contact:DIM_templateType
Data Type: text

Unsubscribed Date

API Name: unsubscribe_date
NinjaCat System ID: constant_contact:DIM_unsubscribeDate
Data Type: date

Unsubscribe Reason

API Name: unsubscribe_reason
NinjaCat System ID: constant_contact:DIM_unsubscribeReason
Data Type: text

Unsubscribe Source

API Name: unsubscribe_source
NinjaCat System ID: constant_contact:DIM_unsubscribeSource
Data Type: text

Viewable as Webpage

API Name: is_view_as_webpage_enabled
NinjaCat System ID: constant_contact:DIM_viewableAsWebpage
Data Type: text

Week Of Year

NinjaCat System ID: constant_contact:DIM_WEEK_OF_YEAR
Data Type: text
Aggregates To: DIM_WEEK_OF_YEAR_SUNDAY

Year

NinjaCat System ID: constant_contact:DIM_Year
Data Type: text
Aggregates To: DIM_YEAR

Metrics (9)

Bounces

API Name: email_bounce
NinjaCat System ID: constant_contact:MET_bounces
Data Type: integer
Aggregates To: MET_BOUNCES

Clicks

API Name: email_click
NinjaCat System ID: constant_contact:MET_clicks
Data Type: integer
Aggregates To: MET_CLICKS

Count (Unique Dimensions)

NinjaCat System ID: constant_contact:MET_COUNT_NC
Data Type: integer
Aggregates To: MET_COUNT_NC

Forwards

API Name: email_forward
NinjaCat System ID: constant_contact:MET_forwards
Data Type: integer

Lists Used

API Name: sent_to_contact_lists
NinjaCat System ID: constant_contact:MET_sentToContactLists
Data Type: integer

Opens

API Name: email_open
NinjaCat System ID: constant_contact:MET_opens
Data Type: integer
Aggregates To: MET_OPENS

Sends

API Name: email_send
NinjaCat System ID: constant_contact:MET_sends
Data Type: integer
Aggregates To: MET_SENT

Spam Count

API Name: spam_count
NinjaCat System ID: constant_contact:MET_spamCount
Data Type: integer

Unsubscribes

API Name: email_unsubscribe
NinjaCat System ID: constant_contact:MET_unsubscribes
Data Type: integer
Aggregates To: MET_UNSUBSCRIBED

Updated 6 months ago