Eloqua fields

  • Updated on Sep 30, 2025
  • Published on Sep 30, 2025
Prev Next

Supermetrics brings all your Eloqua data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access28 metrics76 dimensions

CAMPAIGN

campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_description
Field label Campaign description
Description Description of the campaign
Field type dimension
Data type string.text.value
campaign_type
Field label Campaign type
Description Type of campaign
Field type dimension
Data type string.text.value
campaign_status
Field label Campaign status
Description Current status of the campaign
Field type dimension
Data type string.text.value
crm_campaign_id
Field label CRM campaign ID
Description Unique identifier for the campaign in CRM
Field type dimension
Data type string.text.value
ad_campaign_id
Field label Ad campaign ID
Description Unique identifier for the ad campaign
Field type dimension
Data type string.text.value
campaign_region
Field label Campaign region
Description Geographic region for the campaign
Field type dimension
Data type string.geo.region
campaign_product
Field label Campaign product
Description Product associated with the campaign
Field type dimension
Data type string.text.value
reference_product
Field label Reference product
Description Reference product linked to the campaign
Field type dimension
Data type string.text.value
is_deleted_campaign
Field label Is deleted
Description Indicates if the campaign is deleted
Field type dimension
Data type bool
campaign_created_by_user_id
Field label Campaign created by user ID
Description User ID of the campaign creator
Field type dimension
Data type string.text.value
last_activated_by_user_id
Field label Last activated by user ID
Description User ID who last activated the campaign
Field type dimension
Data type string.text.value
segment_id
Field label Segment ID
Description Identifier for the campaign segment
Field type dimension
Data type string.text.value
campaign_start_date
Field label Campaign start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
campaign_end_date
Field label Campaign end date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaign_created_datetime
Field label Campaign created datetime
Description Creation timestamp of the campaign
Field type dimension
Data type string.time.datetime
campaign_created_date
Field label Campaign created date
Description Creation date of the campaign
Field type dimension
Data type string.time.date
campaign_modified_datetime
Field label Campaign modified datetime
Description Last modification timestamp of the campaign
Field type dimension
Data type string.time.datetime
campaign_modified_date
Field label Campaign modified date
Description Last modification date of the campaign
Field type dimension
Data type string.time.date
actual_cost
Field label Actual cost
Description Actual cost incurred for the campaign
Field type dimension
Data type string.text.value
budget_cost
Field label Budget cost
Description Budgeted cost for the campaign
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

EMAIL

email_name
Field label Email name
Description The name of the email campaign
Field type dimension
Data type string.text.value
email_id
Field label Email ID
Description Identifier for the associated email
Field type dimension
Data type string.text.value
subject_line
Field label Subject line
Description The subject line of the email
Field type dimension
Data type string.text.value
email_created_by_user_id
Field label Email created by user ID
Description The user ID of the creator of the email
Field type dimension
Data type string.text.value
is_deleted_email
Field label Is deleted
Description Whether the email has been deleted
Field type dimension
Data type bool
is_archived
Field label Is archived
Description Whether the email has been archived
Field type dimension
Data type bool
email_sent_datetime
Field label Email sent datetime
Description The timestamp of when the email was sent
Field type dimension
Data type string.time.datetime
email_sent_date
Field label Email sent date
Description The date of when the email was sent
Field type dimension
Data type string.time.date
last_modified_datetime
Field label Last modified datetime
Description The timestamp of the last modification to the email
Field type dimension
Data type string.time.datetime
last_modified_date
Field label Last modified date
Description The date of the last modification to the email
Field type dimension
Data type string.time.date

EMAIL GROUP

email_group_name
Field label Email group name
Description The name of the email group
Field type dimension
Data type string.text.value
email_group_id
Field label Email group ID
Description Unique identifier for the email group
Field type dimension
Data type string.text.value
email_group_description
Field label Email group description
Description The description of the email group
Field type dimension
Data type string.text.value
email_group_is_deleted
Field label Email group is deleted
Description Whether the email group has been deleted
Field type dimension
Data type bool

FORM

form_name
Field label Form name
Description Name of the form
Field type dimension
Data type string.text.value
form_id
Field label Form ID
Description Unique identifier for the form
Field type dimension
Data type string.text.value
landing_page_id
Field label Landing page ID
Description Unique identifier for the landing page
Field type dimension
Data type string.text.value
web_page_id
Field label Web page ID
Description Unique identifier for the web page
Field type dimension
Data type string.text.value
form_current_status
Field label Form current status
Description Current status of the form
Field type dimension
Data type string.text.value
is_archived_form
Field label Is archived
Description Whether the form is archived
Field type dimension
Data type bool
folder_id
Field label Folder ID
Description Unique identifier for the folder
Field type dimension
Data type string.text.value
form_created_datetime
Field label Form created datetime
Description Date and time when the form was created
Field type dimension
Data type string.time.datetime
form_created_date
Field label Form created date
Description Date when the form was created
Field type dimension
Data type string.time.date
form_modified_datetime
Field label Form modified datetime
Description Date and time when the form was last modified
Field type dimension
Data type string.time.datetime
form_modified_date
Field label Form modified date
Description Date when the form was last modified
Field type dimension
Data type string.time.date
form_submission_datetime
Field label Form submission datetime
Description The hour when the form was submitted
Field type dimension
Data type string.time.datetime
form_submission_date
Field label Form submission date
Description The date when the form was submitted
Field type dimension
Data type string.time.date

PERFORMANCE

total_sends
Field label Total sends
Description Total number of emails sent
Field type metric
Data type int.number.value
total_delivered
Field label Total delivered
Description Total number of emails successfully delivered
Field type metric
Data type int.number.value
total_hard_bouncebacks
Field label Total hard bouncebacks
Description Total number of permanent delivery failures
Field type metric
Data type int.number.value
hard_bounceback_rate
Field label Hard bounceback rate
Description Percentage of emails that resulted in hard bounces. (Total hard bouncebacks / Total sends)
Field type metric
Data type float.number.ratio
total_soft_bouncebacks
Field label Total soft bouncebacks
Description Total number of temporary delivery failures
Field type metric
Data type int.number.value
soft_bounceback_rate
Field label Soft bounceback rate
Description Percentage of emails that resulted in soft bounces. (Total soft bouncebacks / Total sends)
Field type metric
Data type float.number.ratio
total_bouncebacks
Field label Total bouncebacks
Description Total number of both hard and soft bouncebacks
Field type metric
Data type int.number.value
bounceback_rate
Field label Bounceback rate
Description Percentage of emails that bounced. (Total bouncebacks / Total sends)
Field type metric
Data type float.number.ratio
total_opens
Field label Total opens
Description Total number of times emails were opened
Field type metric
Data type int.number.value
open_rate
Field label Open rate
Description Percentage of delivered emails that were opened. (Total opens / Total delivered)
Field type metric
Data type float.number.ratio
unique_opens
Field label Unique opens
Description Number of unique recipients who opened the email
Field type metric
Data type int.number.value
unique_open_rate
Field label Unique open rate
Description Percentage of unique opens per delivered. (Unique opens / Total delivered)
Field type metric
Data type float.number.ratio
total_clickthroughs
Field label Total clickthroughs
Description Total number of clicks received
Field type metric
Data type int.number.value
clickthrough_rate
Field label Clickthrough rate
Description Percentage of delivered emails that resulted in clicks. (Total clickthroughs / Total delivered)
Field type metric
Data type float.number.ratio
unique_clickthroughs
Field label Unique clickthroughs
Description Number of unique recipients who clicked
Field type metric
Data type int.number.value
unique_clickthrough_rate
Field label Unique clickthrough rate
Description Percentage of unique clicks per delivered. (Unique clickthroughs / Total delivered)
Field type metric
Data type float.number.ratio
existing_visitor_clickthroughs
Field label Existing visitor clickthroughs
Description Number of clicks from returning visitors
Field type metric
Data type int.number.value
new_visitor_clickthroughs
Field label New visitor clickthroughs
Description Number of clicks from new visitors
Field type metric
Data type int.number.value
click_to_open_rate
Field label Click-to-open rate
Description Percentage of opens that resulted in clicks. (Total clickthroughs / Total opens)
Field type metric
Data type float.number.ratio
possible_forward_rate
Field label Possible forward rate
Description Percentage of possible forwards per delivered. (Total possible forwarders / Total delivered)
Field type metric
Data type float.number.ratio
total_possible_forwarders
Field label Total possible forwarders
Description Number of recipients who may have forwarded the email
Field type metric
Data type int.number.value
total_unsubscribes_by_email
Field label Total unsubscribes by email
Description Number of recipients who unsubscribed via email
Field type metric
Data type int.number.value
unsubscribe_rate
Field label Unsubscribe rate
Description Percentage of delivered emails that resulted in unsubscribes. (Total unsubscribes by email / Total delivered)
Field type metric
Data type float.number.ratio
total_spam_unsubscribes_by_email
Field label Total spam unsubscribes by email
Description Number of recipients who marked the email as spam
Field type metric
Data type int.number.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SITE NAME

site_name
Field label Site name
Description Name of the site
Field type dimension
Data type string.text.value

SUBMISSION METRICS

form_fields
Field label Form fields
Description Count of fields in the form
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
form_completed_fields
Field label Form completed fields
Description Number of fields that were filled and submitted
Field type metric
Data type int.number.value
Aggregation Non-aggregatable metric
field_completion_rate
Field label Field completion rate
Description Rate of the completed fields
Field type metric
Data type float.number.ratio
Aggregation Non-aggregatable metric
total_form_submissions
Field label Total form submissions
Description Total number of form submissions received
Field type metric
Data type int.number.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime