# Marketo: Programs

## Description

* Each record is a Marketo program.

## Supported Data Sources

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

## Columns

| Type    | Name                  | Description                                                                                                        |
| ------- | --------------------- | ------------------------------------------------------------------------------------------------------------------ |
| INTEGER | program\_id           | ID of the program.                                                                                                 |
| STRING  | channel               | Channel of the program.                                                                                            |
| STRING  | created\_timestamp    | Timestamp the program was created at                                                                               |
| INTEGER | description           | Description of the program.                                                                                        |
| INTEGER | end\_timestamp        | End date of the program. Applicable to event, email, and webinar type programs.                                    |
| STRING  | program\_name         | Name of the program.                                                                                               |
| STRING  | sfdc\_id              | SFDC id of the program if linked to an SFDC campaign.                                                              |
| STRING  | sfdc\_name            | Name of the linked SFDC campaign if applicable.                                                                    |
| INTEGER | start\_timestamp      | Start date of program. Applicable to event, email and webinar type programs.                                       |
| STRING  | program\_status       | Status of the program. Only valid for Email and engagement program types.Allowed values: locked, unlocked, on, off |
| STRING  | program\_type         | Type of the program. Allowed values: program, event, webinar, nurture                                              |
| STRING  | updated\_timestamp    | Timestamp the program was most recently updated.                                                                   |
| STRING  | url                   | URL of the program in the Marketo UI.                                                                              |
| STRING  | workspace             | Name of the workspace.                                                                                             |
| 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-programs.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.
