Marketo email templates
Email templates with detailed delivery statistics
Use case
Marketing
Apps
Marketo
Created by
Canvas
Each record is the most recent version of an email template.
Model columns
| Column | Description |
|---|---|
| email_template_id | ID of the email template |
| created_timestamp | Timestamp the email template was created. |
| description | Description of the email template. |
| email_subject | Subject line of the email. |
| email_template_history_id | ID of the version of the email template. |
| email_template_name | Name of the email template. |
| email_template_status | Status filter for draft or approved versions. |
| email_template_url | URL of the email template in the Marketo UI. |
| folder_name | The name of the email template's folder. |
| folder_id | The ID of the email template's folder. |
| folder_type | The type of the email template's folder. |
| folder_value | The value of the email template's folder. |
| from_email | The 'From' address of the email. |
| from_name | The 'From' name of the email. |
| has_web_view_enabled | Whether 'View as Webpage' function is enabled for the email. |
| inferred_version | Incrementing integer version of the email template. |
| is_most_recent_version | Whether it is the most recent version of the email template. |
| is_operational | Whether the email is operational. Operational emails bypass unsubscribe status. Defaults to false. |
| is_text_only | Setting to include text-only version of email when sent. |
| parent_template_id | ID of the parent template. |
| program_id | The ID of the email template's program. |
| publish_to_msi | Whether the email is published to Marketo Sales Insight. |
| reply_email | Reply-To address of the Email. |
| total_count_of_versions | Count of records for a given email_template_id. |
| updated_timestamp | Timestamp the email template was last updated. |
| valid_from | When the version of the email template was is valid from. |
| valid_to | When the version of the email template was is valid to. |
| version_type | The type version of the email, either '1' or '2'. |
| workspace_name | Name of the workspace. |
| count_sends | Count of total sends from related email sends. |
| count_opens | Count of total opens from related email sends. |
| count_bounces | Count of total bounces from related email sends. |
| count_clicks | Count of total clicks from related email sends. |
| count_deliveries | Count of total deliveries from related email sends. |
| count_unsubscribes | Count of total unsubscribes from related email sends. |
| count_unique_opens | Count of unique opens from related email sends. |
| count_unique_clicks | Count of unique clicks from related email sends. |
| open_rates_by_sends | Unique email opened divided by total email sent. |
| click_rates_by_sends | Unique email clicked divided by total email sent. |
| open_rates_by_deliveries | Unique email opened divided by total email deliveries. |
| click_rates_by_deliveries | Unique email clicked divided by total email deliveries. |
