Marketo programs
Programs with delivery statistics
Use case
Marketing
Apps
Marketo
Created by
Canvas
Each record is a Marketo program.
Model columns
| Column | Description |
|---|---|
| program_id | ID of the program. |
| channel | Channel of the program. |
| created_timestamp | Timestamp the program was created at |
| description | Description of the program. |
| end_timestamp | End date of the program. Applicable to event, email, and webinar type programs. |
| program_name | Name of the program. |
| program_status | Status of the program. Only valid for Email and engagement program types. Allowed values: locked, unlocked, on, off |
| program_type | Type of the program. Allowed values: program, event, webinar, nurture |
| sfdc_id | SFDC id of the program if linked to an SFDC campaign. |
| sfdc_name | Name of the linked SFDC campaign if applicable. |
| start_timestamp | Start date of program. Applicable to event, email and webinar type programs. |
| updated_timestamp | Timestamp the program was most recently updated. |
| url | URL of the program in the Marketo UI. |
| workspace | 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. |
