Field Requirements for Email Channel Performance Reporting

In order to generate performance metrics in reports we need to import marketing activity and campaign data from your marketing automation system.

Today we only support performance reporting if you are using Marketo, Eloqua or Pardot.

Performance Reporting for Email Campaigns in Eloqua

We require that the following objects and fields be brought in from Eloqua to support performance reporting.

Objects:

We require the following fields from each object.

Activity Email Clickthrough	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId EmailClickedThruLink VisitorExternalId
Activity Email Open	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId VisitorExternalId
Activity Email Send	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId VisitorExternalId
Activity Form Submit	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId VisitorExternalId
Activity Page View	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId Url VisitorExternalId
Activity Web Visit	ActivityDate ActivityType AssetId AssetName AssetType CampaignId ContactId VisitorExternalId
Campaign	Id name

We require that the following objects and fields be brought in from Marketo to support performance reporting.

Objects:

We require the following fields from each object.

Activities Click Link	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId
Activities Click Email	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId Link
Activities Send Email	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId
Activities Open Email	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId
Activities Visit Webpage	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId webpage_url
Activities Fill Out Form	ActivityDate campaign_run_id marketoGUID ActivityType primary_attribute_value_id primary_attribute_value primary_attribute_name leadId
Campaign	Id name programId programName

We require that the following objects and fields be brought in from Pardot to support performance reporting.

Objects:

We require the following fields from each object.

Visitor Activities

created_at

type_name

prospect_id

campaign_id

visitor_id

details

name

email_id

file_id

form_handler_id

form_id

landing_page_id

paid_search_id_

visitor_page_view_id

Campaign

name