# Marketo: Email Templates

## Description

* Each record is the most recent version of an email template.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/marketo/resources/marketo.svg" alt="" data-size="line"> Marketo

## Columns

| Type     | Name                         | Description                                                                                        |
| -------- | ---------------------------- | -------------------------------------------------------------------------------------------------- |
| DATETIME | created\_timestamp           | Timestamp the email template was created.                                                          |
| STRING   | description                  | Description of the email template.                                                                 |
| STRING   | folder\_name                 | The name of the email template's folder.                                                           |
| INTEGER  | folder\_id                   | The ID of the email template's folder.                                                             |
| STRING   | folder\_type                 | The type of the email template's folder.                                                           |
| INTEGER  | folder\_value                | The value of the email template's folder.                                                          |
| STRING   | from\_email                  | The 'From' address of the email.                                                                   |
| STRING   | from\_name                   | The 'From' name of the email.                                                                      |
| INTEGER  | email\_template\_id          | ID of the email template                                                                           |
| STRING   | email\_template\_name        | Name of the email template.                                                                        |
| BOOLEAN  | is\_operational              | Whether the email is operational. Operational emails bypass unsubscribe status. Defaults to false. |
| INTEGER  | program\_id                  | The ID of the email template's program.                                                            |
| BOOLEAN  | publish\_to\_msi             | Whether the email is published to Marketo Sales Insight.                                           |
| STRING   | reply\_email                 | Reply-To address of the Email.                                                                     |
| STRING   | email\_template\_status      | Status filter for draft or approved versions.                                                      |
| STRING   | email\_subject               | Subject line of the email.                                                                         |
| INTEGER  | parent\_template\_id         | ID of the parent template.                                                                         |
| BOOLEAN  | is\_text\_only               | Setting to include text-only version of email when sent.                                           |
| DATETIME | updated\_timestamp           | Timestamp the email template was last updated.                                                     |
| STRING   | email\_template\_url         | URL of the email template in the Marketo UI.                                                       |
| INTEGER  | version\_type                | The type version of the email, either '1' or '2'.                                                  |
| BOOLEAN  | has\_web\_view\_enabled      | Whether 'View as Webpage' function is enabled for the email.                                       |
| STRING   | workspace\_name              | Name of the workspace.                                                                             |
| INTEGER  | inferred\_version            | Incrementing integer version of the email template.                                                |
| INTEGER  | total\_count\_of\_versions   | Count of records for a given email\_template\_id.                                                  |
| DATETIME | valid\_from                  | When the version of the email template was is valid from.                                          |
| DATETIME | valid\_to                    | When the version of the email template was is valid to.                                            |
| BOOLEAN  | is\_most\_recent\_version    | Whether it is the most recent version of the email template.                                       |
| STRING   | email\_template\_history\_id | ID of the version of the email template.                                                           |
| INTEGER  | count\_sends                 | Count of total sends from related email sends.                                                     |
| INTEGER  | count\_opens                 | Count of total opens from related email sends.                                                     |
| INTEGER  | count\_bounces               | Count of total bounces from related email sends.                                                   |
| INTEGER  | count\_clicks                | Count of total clicks from related email sends.                                                    |
| INTEGER  | count\_deliveries            | Count of total deliveries from related email sends.                                                |
| INTEGER  | count\_unsubscribes          | Count of total unsubscribes from related email sends.                                              |
| INTEGER  | count\_unique\_opens         | Count of unique opens from related email sends.                                                    |
| INTEGER  | count\_unique\_clicks        | Count of unique clicks from related email sends.                                                   |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/marketo-email-templates.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.