**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Nested Project/Book-Sample2 **************************************************************************** Workbook Information Author: Unknown Embedded Datasources Datasource: Parameters Connection Measure Calculated/Other Measure: Cust_Prompt Role: Continous Measure Data Type: integer Formula: 1 Default Value: 1 Parameter Type: list Datasource: Email Notices Activity+ (SAP App Center leads) Connection Data Sources Data Source: EmailNoticesActivitySAPAppCenterleads Attributes channel: http class: sqlproxy dbname: EmailNoticesActivitySAPAppCenterleads directory: /dataserver port: 80 server: bnbrepository9 workgroup-auth-mode: prompt Tables Table: sqlproxy Database Object: [sqlproxy] Connection: EmailNoticesActivitySAPAppCenterleads Dimension sqlproxy Dimension: Action_Date Role: Discrete Dimension Remote Column: [sqlproxy].[Action_Date] Data Type: datetime Aggregation: Year Dimension: Customer Role: Discrete Dimension Remote Column: [sqlproxy].[Customer] Data Type: string Aggregation: Count Dimension: Email_Subject Role: Discrete Dimension Remote Column: [sqlproxy].[Email_Subject] Data Type: string Aggregation: Count Dimension: Sheet Role: Discrete Dimension Remote Column: [sqlproxy].[Sheet] Data Type: string Aggregation: Count Dimension: Table Name Role: Discrete Dimension Remote Column: [sqlproxy].[Table Name] Data Type: string Aggregation: Count Dimension: User_name Role: Discrete Dimension Remote Column: [sqlproxy].[User_name] Data Type: string Aggregation: Count Dimension: emailtrack_action Role: Discrete Dimension Remote Column: [sqlproxy].[emailtrack_action] Data Type: string Aggregation: Count Dimension: emailtrack_address Role: Discrete Dimension Remote Column: [sqlproxy].[emailtrack_address] Data Type: string Aggregation: Count Dimension: licensetype_desc Role: Discrete Dimension Remote Column: [sqlproxy].[licensetype_desc] Data Type: string Aggregation: Count Dimension: product_desc Role: Discrete Dimension Remote Column: [sqlproxy].[product_desc] Data Type: string Aggregation: Count Dimension: user_loginid Role: Discrete Dimension Remote Column: [sqlproxy].[user_loginid] Data Type: string Aggregation: Count Dimension: user_registrationdate Role: Discrete Dimension Remote Column: [sqlproxy].[user_registrationdate] Data Type: datetime Aggregation: Year Dimension: userlicense_issuedate Role: Discrete Dimension Remote Column: [sqlproxy].[userlicense_issuedate] Data Type: datetime Aggregation: Year Measure sqlproxy Measure: Number of Records Role: Continous Measure Remote Column: [sqlproxy].[Number of Records] Data Type: integer Formula: 1 Aggregation: Sum Measure: userlicense_activationlimit Role: Continous Measure Remote Column: [sqlproxy].[userlicense_activationlimit] Data Type: integer Aggregation: Sum Semantic Values [Country].[Name]: "Canada" Datasource: Marketo Connection Data Sources Data Source: Marketo Attributes authType: custom authentication: yes channel: https class: webdata-direct:marketo-marketo connectionData: {"connectorName":"Marketo","apiScheme":"https","apiDomain":"mktorest.com","pagination":{"batchSize":300},"userFilters":{"dateRange":30},"selectedFilter":"dateRange","apiSubdomain":"","apiUrl":""} connectionName: Marketo filename: marketo.html path: /marketo/marketo/1/ port: 443 server: connectors.tableau.com workgroup-auth-mode: prompt Tables Table: Activity - Send Email Database Object: [activity6] Connection: Marketo Table: Campaigns Database Object: [campaignsTable] Connection: Marketo Table: Activity - Email Delivered Database Object: [activity7] Connection: Marketo Table: Activity - Open Email Database Object: [activity10] Connection: Marketo Table: Activity - Click Email Database Object: [activity11] Connection: Marketo Dimension Activity - Click Email Dimension: Activity Date (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Activity_Date] Data Type: datetime Dimension: Campaign ID (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Campaign_ID] Data Type: integer Dimension: Campaign Run ID (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Campaign_Run_ID] Data Type: integer Dimension: Choice Number (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Choice_Number] Data Type: string Dimension: Is Mobile Device (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Is_Mobile_Device] Data Type: string Dimension: Is Predictive Role: Discrete Dimension Remote Column: [Activity - Click Email].[Is_Predictive] Data Type: string Dimension: Lead ID (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Lead_ID] Data Type: integer Dimension: Link ID Role: Discrete Dimension Remote Column: [Activity - Click Email].[Link_ID] Data Type: string Dimension: Mailing ID (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Mailing_ID] Data Type: integer Dimension: Step ID (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Step_ID] Data Type: integer Dimension: Test Variant (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[Test_Variant] Data Type: string Dimension: User Agent (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[User_Agent] Data Type: string Dimension: Id (Activity - Click Email) Role: Discrete Dimension Remote Column: [Activity - Click Email].[id] Data Type: integer Activity - Email Delivered Dimension: Activity Date (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Activity_Date] Data Type: datetime Dimension: Campaign ID (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Campaign_ID] Data Type: integer Dimension: Campaign Run ID (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Campaign_Run_ID] Data Type: integer Dimension: Choice Number (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Choice_Number] Data Type: string Dimension: Has Predictive (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Has_Predictive] Data Type: string Dimension: Lead ID (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Lead_ID] Data Type: integer Dimension: Mailing ID (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Mailing_ID] Data Type: integer Dimension: Step ID (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Step_ID] Data Type: integer Dimension: Test Variant (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[Test_Variant] Data Type: string Dimension: Id (Activity - Email Delivered) Role: Discrete Dimension Remote Column: [Activity - Email Delivered].[id] Data Type: integer Activity - Open Email Dimension: Activity Date (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Activity_Date] Data Type: datetime Dimension: Campaign ID (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Campaign_ID] Data Type: integer Dimension: Campaign Run ID (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Campaign_Run_ID] Data Type: integer Dimension: Choice Number (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Choice_Number] Data Type: string Dimension: Has Predictive (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Has_Predictive] Data Type: string Dimension: Is Mobile Device Role: Discrete Dimension Remote Column: [Activity - Open Email].[Is_Mobile_Device] Data Type: string Dimension: Lead ID (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Lead_ID] Data Type: integer Dimension: Mailing ID (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Mailing_ID] Data Type: integer Dimension: Step ID (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Step_ID] Data Type: integer Dimension: Test Variant (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[Test_Variant] Data Type: string Dimension: User Agent Role: Discrete Dimension Remote Column: [Activity - Open Email].[User_Agent] Data Type: string Dimension: Id (Activity - Open Email) Role: Discrete Dimension Remote Column: [Activity - Open Email].[id] Data Type: integer Activity - Send Email Dimension: Activity Date Role: Discrete Dimension Remote Column: [Activity - Send Email].[Activity_Date] Data Type: datetime Dimension: Campaign ID Role: Discrete Dimension Remote Column: [Activity - Send Email].[Campaign_ID] Data Type: integer Dimension: Campaign Run ID Role: Discrete Dimension Remote Column: [Activity - Send Email].[Campaign_Run_ID] Data Type: integer Dimension: Choice Number Role: Discrete Dimension Remote Column: [Activity - Send Email].[Choice_Number] Data Type: string Dimension: Has Predictive Role: Discrete Dimension Remote Column: [Activity - Send Email].[Has_Predictive] Data Type: string Dimension: Lead ID Role: Discrete Dimension Remote Column: [Activity - Send Email].[Lead_ID] Data Type: integer Dimension: Mailing ID Role: Discrete Dimension Remote Column: [Activity - Send Email].[Mailing_ID] Data Type: integer Dimension: Step ID Role: Discrete Dimension Remote Column: [Activity - Send Email].[Step_ID] Data Type: integer Dimension: Test Variant Role: Discrete Dimension Remote Column: [Activity - Send Email].[Test_Variant] Data Type: string Dimension: Id Role: Discrete Dimension Remote Column: [Activity - Send Email].[id] Data Type: integer Campaigns Dimension: Active Role: Discrete Dimension Remote Column: [Campaigns].[active] Data Type: string Dimension: Created At Role: Discrete Dimension Remote Column: [Campaigns].[createdAt] Data Type: datetime Dimension: Description Role: Discrete Dimension Remote Column: [Campaigns].[description] Data Type: string Dimension: ID Role: Discrete Dimension Remote Column: [Campaigns].[id] Data Type: integer Dimension: Name Role: Discrete Dimension Remote Column: [Campaigns].[name] Data Type: string Dimension: Program ID Role: Discrete Dimension Remote Column: [Campaigns].[programId] Data Type: string Dimension: Program Name Role: Discrete Dimension Remote Column: [Campaigns].[programName] Data Type: string Dimension: Updated At Role: Discrete Dimension Remote Column: [Campaigns].[updatedAt] Data Type: datetime Dimension: Workspace Name Role: Discrete Dimension Remote Column: [Campaigns].[workspaceName] Data Type: string Calculated/Other Dimension: Measure Names Role: Discrete Dimension Data Type: string Measure Activity - Click Email Measure: Device (Activity - Click Email) Role: Continous Measure Remote Column: [Activity - Click Email].[Device] Data Type: string Aggregation: Count Measure: Link Role: Continous Measure Remote Column: [Activity - Click Email].[Link] Data Type: string Aggregation: Count Measure: Platform (Activity - Click Email) Role: Continous Measure Remote Column: [Activity - Click Email].[Platform] Data Type: string Aggregation: Count Activity - Open Email Measure: Device Role: Continous Measure Remote Column: [Activity - Open Email].[Device] Data Type: string Aggregation: Count Measure: Platform Role: Continous Measure Remote Column: [Activity - Open Email].[Platform] Data Type: string Aggregation: Count Calculated/Other Measure: Bounceback Role: Continous Measure Data Type: integer Formula: [Sent Email] - [Delivered Email] Measure: Delivered Email Role: Continous Measure Data Type: integer Formula: COUNTD([id (Activity - Email Delivered)]) Measure: Opened Email Role: Continous Measure Data Type: integer Formula: COUNTD([id (Activity - Open Email)]) Measure: Delivery Rate Role: Continous Measure Data Type: real Formula: ZN([Delivered Email]/[Sent Email]) Measure: Open Rate Role: Continous Measure Data Type: real Formula: ZN([Opened Email]/[Delivered Email]) Measure: Non Opened Email Role: Continous Measure Data Type: integer Formula: [Delivered Email]-[Opened Email] Measure: Clickthrough Emails Role: Continous Measure Data Type: integer Formula: COUNTD([id (Activity - Click Email)]) Measure: Clickthrough Rate Role: Continous Measure Data Type: real Formula: [Clickthrough Emails]/[Delivered Email] Measure: Non Clickthrough Email Role: Continous Measure Data Type: integer Formula: [Delivered Email]-[Clickthrough Emails] Measure: Opened Non Clicked Emails Role: Continous Measure Data Type: integer Formula: [Opened Email]-[Clickthrough Emails] Measure: Sent Email Role: Continous Measure Data Type: integer Formula: COUNTD([id]) Measure: Click-to-Open Role: Continous Measure Data Type: real Formula: ZN([Clickthrough Emails] / [Opened Email]) Measure: Measure Values Role: Continous Measure Data Type: real Measure: Number of Records Role: Continous Measure Data Type: integer Formula: 1 Semantic Values [Country].[Name]: "United States" Datasource: bnbdatabase1 Connection Data Sources Data Source: bnbdatabase1 Attributes channel: http class: sqlproxy dbname: bnbdatabase1 directory: /dataserver port: 80 server: bnbrepository9 server-ds-friendly-name: bnbdatabase1 username: root workgroup-auth-mode: prompt Tables Table: sqlproxy Database Object: [sqlproxy] Connection: bnbdatabase1 Dimension sqlproxy Dimension: ID Role: Discrete Dimension Remote Column: [sqlproxy].[ID] Data Type: integer Aggregation: Count Dimension: Address Role: Discrete Dimension Remote Column: [sqlproxy].[address] Data Type: string Aggregation: Count Dimension: Address Id (Store) Role: Discrete Dimension Remote Column: [sqlproxy].[address_id (store)] Data Type: integer Aggregation: Sum Dimension: Address Id Role: Discrete Dimension Remote Column: [sqlproxy].[address_id] Data Type: integer Aggregation: Sum Dimension: City Role: Discrete Dimension Remote Column: [sqlproxy].[city] Data Type: string Aggregation: Count Dimension: Country (Customer List) Role: Discrete Dimension Remote Column: [sqlproxy].[country (customer_list)] Data Type: string Aggregation: Count Dimension: Country Role: Discrete Dimension Remote Column: [sqlproxy].[country] Data Type: string Aggregation: Count Dimension: Country Id Role: Discrete Dimension Remote Column: [sqlproxy].[country_id] Data Type: integer Aggregation: Count Dimension: create_date (Custom SQL Query1) Role: Discrete Dimension Remote Column: [sqlproxy].[create_date (Custom SQL Query1)] Data Type: datetime Aggregation: Year Dimension: Create Date Role: Discrete Dimension Remote Column: [sqlproxy].[create_date] Data Type: datetime Aggregation: Year Dimension: Customer Id Role: Discrete Dimension Remote Column: [sqlproxy].[customer_id] Data Type: integer Aggregation: Count Dimension: email (Custom SQL Query1) Role: Discrete Dimension Remote Column: [sqlproxy].[email (Custom SQL Query1)] Data Type: string Aggregation: Count Dimension: Email Role: Discrete Dimension Remote Column: [sqlproxy].[email] Data Type: string Aggregation: Count Dimension: first_name (Custom SQL Query1) Role: Discrete Dimension Remote Column: [sqlproxy].[first_name (Custom SQL Query1)] Data Type: string Aggregation: Count Dimension: First Name Role: Discrete Dimension Remote Column: [sqlproxy].[first_name] Data Type: string Aggregation: Count Dimension: last_name (Custom SQL Query1) Role: Discrete Dimension Remote Column: [sqlproxy].[last_name (Custom SQL Query1)] Data Type: string Aggregation: Count Dimension: Last Name Role: Discrete Dimension Remote Column: [sqlproxy].[last_name] Data Type: string Aggregation: Count Dimension: last_update (Custom SQL Query) Role: Discrete Dimension Remote Column: [sqlproxy].[last_update (Custom SQL Query)] Data Type: datetime Aggregation: Year Dimension: last_update (Custom SQL Query1) Role: Discrete Dimension Remote Column: [sqlproxy].[last_update (Custom SQL Query1)] Data Type: datetime Aggregation: Year Dimension: Last Update (Country) Role: Discrete Dimension Remote Column: [sqlproxy].[last_update (country)] Data Type: datetime Aggregation: Year Dimension: Last Update (Store) Role: Discrete Dimension Remote Column: [sqlproxy].[last_update (store)] Data Type: datetime Aggregation: Year Dimension: Last Update Role: Discrete Dimension Remote Column: [sqlproxy].[last_update] Data Type: datetime Aggregation: Year Dimension: Manager Role: Discrete Dimension Remote Column: [sqlproxy].[manager] Data Type: string Aggregation: Count Dimension: Manager Staff Id Role: Discrete Dimension Remote Column: [sqlproxy].[manager_staff_id] Data Type: integer Aggregation: Sum Dimension: Name Role: Discrete Dimension Remote Column: [sqlproxy].[name] Data Type: string Aggregation: Count Dimension: Notes Role: Discrete Dimension Remote Column: [sqlproxy].[notes] Data Type: string Aggregation: Count Dimension: Phone Role: Discrete Dimension Remote Column: [sqlproxy].[phone] Data Type: string Aggregation: Count Dimension: rental_date Role: Discrete Dimension Remote Column: [sqlproxy].[rental_date] Data Type: datetime Aggregation: Year Dimension: return_date Role: Discrete Dimension Remote Column: [sqlproxy].[return_date] Data Type: datetime Aggregation: Year Dimension: Store Role: Discrete Dimension Remote Column: [sqlproxy].[store] Data Type: string Aggregation: Count Dimension: Store Id (Store) Role: Discrete Dimension Remote Column: [sqlproxy].[store_id (store)] Data Type: integer Aggregation: Sum Dimension: Store Id Role: Discrete Dimension Remote Column: [sqlproxy].[store_id] Data Type: integer Aggregation: Sum Dimension: Zip Code Role: Discrete Dimension Remote Column: [sqlproxy].[zip code] Data Type: string Aggregation: Count Measure sqlproxy Measure: Number of Records Role: Continous Measure Remote Column: [sqlproxy].[Number of Records] Data Type: integer Formula: 1 Aggregation: Sum Measure: SID Role: Continous Measure Remote Column: [sqlproxy].[SID] Data Type: integer Aggregation: Sum Measure: active (Custom SQL Query1) Role: Continous Measure Remote Column: [sqlproxy].[active (Custom SQL Query1)] Data Type: integer Aggregation: Sum Measure: Active Role: Continous Measure Remote Column: [sqlproxy].[active] Data Type: integer Aggregation: Sum Measure: address_id (Custom SQL Query1) Role: Continous Measure Remote Column: [sqlproxy].[address_id (Custom SQL Query1)] Data Type: integer Aggregation: Sum Measure: customer_id (Custom SQL Query) Role: Continous Measure Remote Column: [sqlproxy].[customer_id (Custom SQL Query)] Data Type: integer Aggregation: Sum Measure: customer_id (Custom SQL Query1) Role: Continous Measure Remote Column: [sqlproxy].[customer_id (Custom SQL Query1)] Data Type: integer Aggregation: Sum Measure: inventory_id Role: Continous Measure Remote Column: [sqlproxy].[inventory_id] Data Type: integer Aggregation: Sum Measure: rental_id Role: Continous Measure Remote Column: [sqlproxy].[rental_id] Data Type: integer Aggregation: Sum Measure: staff_id Role: Continous Measure Remote Column: [sqlproxy].[staff_id] Data Type: integer Aggregation: Sum Measure: store_id (Custom SQL Query1) Role: Continous Measure Remote Column: [sqlproxy].[store_id (Custom SQL Query1)] Data Type: integer Aggregation: Sum Measure: Total Sales Role: Continous Measure Remote Column: [sqlproxy].[total_sales] Data Type: real Aggregation: Sum Semantic Values [Country].[Name]: "Canada" Dashboards Dashboard: Email Performance by Campaign Worksheets Worksheet: Summary Datasources: Marketo Used Dimensions & Measures: [Active] [Activity Date] [Clickthrough Emails] [Clickthrough Rate] [Click-to-Open] [Delivered Email] [Delivery Rate] [Id (Activity - Click Email)] [Id (Activity - Email Delivered)] [Id (Activity - Open Email)] [Id] [ID] [Name] [Open Rate] [Opened Email] [Program Name] [Sent Email] Used Remote Columns: [Activity - Click Email].[id] [Activity - Email Delivered].[id] [Activity - Open Email].[id] [Activity - Send Email].[Activity_Date] [Activity - Send Email].[id] [Campaigns].[active] [Campaigns].[id] [Campaigns].[name] [Campaigns].[programName] Worksheet: Timeline - Sent Datasources: Marketo Used Dimensions & Measures: [Active] [Activity Date] [Id] [ID] [Name] [Program Name] Used Remote Columns: [Activity - Send Email].[Activity_Date] [Activity - Send Email].[id] [Campaigns].[active] [Campaigns].[id] [Campaigns].[name] [Campaigns].[programName] Worksheet: Campaign List Datasources: Marketo Used Dimensions & Measures: [Active] [Activity Date] [Clickthrough Emails] [Clickthrough Rate] [Click-to-Open] [Delivered Email] [Delivery Rate] [Id (Activity - Click Email)] [Id (Activity - Email Delivered)] [Id (Activity - Open Email)] [Id] [ID] [Name] [Open Rate] [Opened Email] [Program Name] [Sent Email] Used Remote Columns: [Activity - Click Email].[id] [Activity - Email Delivered].[id] [Activity - Open Email].[id] [Activity - Send Email].[Activity_Date] [Activity - Send Email].[id] [Campaigns].[active] [Campaigns].[id] [Campaigns].[name] [Campaigns].[programName] Worksheet: Mobile - Sent by Campaign Datasources: Marketo Used Dimensions & Measures: ["Sent Emails"] [Activity Date] [Clickthrough Emails] [Click-to-Open] [Delivered Email] [Delivery Rate] [Id (Activity - Click Email)] [Id (Activity - Email Delivered)] [Id (Activity - Open Email)] [Id] [ID] [Name] [Open Rate] [Opened Email] [Program Name] [Sent Email] Used Remote Columns: [Activity - Click Email].[id] [Activity - Email Delivered].[id] [Activity - Open Email].[id] [Activity - Send Email].[Activity_Date] [Activity - Send Email].[id] [Campaigns].[id] [Campaigns].[name] [Campaigns].[programName] Dashboard Objects: Filter: [Marketo].[DAY(Activity_Date)] Filter: [Marketo].[active] Filter: [Marketo].[programName] Filter: [Marketo].[name] Text: Text: Campaign List Worksheets Worksheet: Campaign List Visible: No Used Datasources Datasource: Marketo Discrete Dimension: Activity Date Remote Column: [Activity - Send Email].[Activity_Date] Discrete Dimension: Active Remote Column: [Campaigns].[active] Discrete Dimension: Id (Activity - Click Email) Remote Column: [Activity - Click Email].[id] Discrete Dimension: Id (Activity - Email Delivered) Remote Column: [Activity - Email Delivered].[id] Discrete Dimension: Id (Activity - Open Email) Remote Column: [Activity - Open Email].[id] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Id Remote Column: [Activity - Send Email].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Dimension: Program Name Remote Column: [Campaigns].[programName] Continous Measure: Delivered Email Continous Measure: Opened Email Continous Measure: Delivery Rate Continous Measure: Open Rate Continous Measure: Clickthrough Emails Continous Measure: Clickthrough Rate Continous Measure: Sent Email Continous Measure: Click-to-Open Marks Mark: All Type: Automatic Tooltip: Campaign <[Marketo].[name]> Part of <[Marketo].[programName]> (Program) Sent: <[Marketo].[Sent Email]> email(s) Delivered: <[Marketo].[Delivered Email]> email(s) (<[Marketo].[Delivery Rate]> of all sent) Opened: <[Marketo].[Opened Email]> email(s) (<[Marketo].[Open Rate]> of all delivered) Clicked: <[Marketo].[Clickthrough Emails]> email(s) (<[Marketo].[Clickthrough Rate (copy)]> of all opened and <[Marketo].[Clickthrough Rate]> of all delivered) Mark: [Marketo].[Delivery Rate] Type: Automatic Tooltip: Campaign <[Marketo].[name]> Part of <[Marketo].[programName]> (Program) Sent: <[Marketo].[Sent Email]> email(s) Delivered: <[Marketo].[Delivered Email]> email(s) (<[Marketo].[Delivery Rate]> of all sent) Opened: <[Marketo].[Opened Email]> email(s) (<[Marketo].[Open Rate]> of all delivered) Clicked: <[Marketo].[Clickthrough Emails]> email(s) (<[Marketo].[Clickthrough Rate (copy)]> of all opened and <[Marketo].[Clickthrough Rate]> of all delivered) Mark: [Marketo].[Open Rate] Type: Automatic Tooltip: Campaign <[Marketo].[name]> Part of <[Marketo].[programName]> (Program) Sent: <[Marketo].[Sent Email]> email(s) Delivered: <[Marketo].[Delivered Email]> email(s) (<[Marketo].[Delivery Rate]> of all sent) Opened: <[Marketo].[Opened Email]> email(s) (<[Marketo].[Open Rate]> of all delivered) Clicked: <[Marketo].[Clickthrough Emails]> email(s) (<[Marketo].[Clickthrough Rate (copy)]> of all opened and <[Marketo].[Clickthrough Rate]> of all delivered) Mark: [Marketo].[Clickthrough Rate (copy)] Type: Automatic Tooltip: Campaign <[Marketo].[name]> Part of <[Marketo].[programName]> (Program) Sent: <[Marketo].[Sent Email]> email(s) Delivered: <[Marketo].[Delivered Email]> email(s) (<[Marketo].[Delivery Rate]> of all sent) Opened: <[Marketo].[Opened Email]> email(s) (<[Marketo].[Open Rate]> of all delivered) Clicked: <[Marketo].[Clickthrough Emails]> email(s) (<[Marketo].[Clickthrough Rate (copy)]> of all opened and <[Marketo].[Clickthrough Rate]> of all delivered) Mark: [Marketo].[Sent Email] Type: Automatic Tooltip: Campaign <[Marketo].[name]> Part of <[Marketo].[programName]> (Program) Sent: <[Marketo].[Sent Email]> email(s) Delivered: <[Marketo].[Delivered Email]> email(s) (<[Marketo].[Delivery Rate]> of all sent) Opened: <[Marketo].[Opened Email]> email(s) (<[Marketo].[Open Rate]> of all delivered) Clicked: <[Marketo].[Clickthrough Emails]> email(s) (<[Marketo].[Clickthrough Rate (copy)]> of all opened and <[Marketo].[Clickthrough Rate]> of all delivered) View Rows: [Marketo].[id (Campaigns)] [Marketo].[name] Columns: [Marketo].[Sent Email] ([Marketo].[Delivery Rate] ([Marketo].[Open Rate] [Marketo].[Clickthrough Rate (copy)]))) Filters: [Marketo].[active] [Marketo].[name] [Marketo].[name] [Marketo].[programName] [Marketo].[DAY(Activity_Date)] [Marketo].[Sent Email] Slices: [Marketo].[programName] [Marketo].[DAY(Activity_Date)] [Marketo].[active] [Marketo].[name] [Marketo].[Sent Email] Styles Style: axis [Marketo].[Delivery Rate] auto-subtitle: true height: 37 [Marketo].[id] height: 37 [Marketo].[Open Rate] height: 37 auto-subtitle: true [Marketo].[Clickthrough Rate (copy)] height: 37 auto-subtitle: true Other border-color: #b0b0b0 border-width: 1 hnlabel: horizontal Style: cell [Marketo].[name] height: 29 Style: header [Marketo].[id (Campaigns)] width: 56 [Marketo].[name] width: 230 rows band-color: #00000000 cols band-color: #00000000 Style: field-labels Other font-family: Tableau Bold font-size: 8 Style: label [Marketo].[name] font-size: 8 font-family: Tableau Light [Marketo].[id (Campaigns)] font-size: 8 font-family: Tableau Light [Marketo].[Delivery Rate] text-format: p0% color: #4f7cba [Marketo].[Open Rate] text-format: p0% color: #7873c0 [Marketo].[Clickthrough Rate (copy)] text-format: p0% color: #c564b6 [Marketo].[Sent Email] font-family: Tableau Book Style: pane cols band-color: #00000000 rows band-color: #00000000 Style: table Other show-null-value-warning: false rows band-size: 1 cols band-size: 1 Style: worksheet Other font-size: 8 Style: refline refline0 line-visibility: on line-pattern-only: dashed stroke-size: 2 fill-above: #00000000 fill-below: #00000000 font-size: 6 color: #c564b6 background-color: #ffffff00 stroke-color: #4f7cba refline1 line-visibility: on line-pattern-only: dashed stroke-color: #c564b6 font-size: 6 color: #c564b6 fill-above: #00000000 fill-below: #00000000 text-format: p0.0% background-color: #ffffff81 font-family: Tableau Bold refline2 line-visibility: on line-pattern-only: dashed font-size: 6 fill-above: #00000000 fill-below: #00000000 stroke-color: #c564b6 color: #c564b6 font-family: Tableau Bold background-color: #ffffff81 text-format: p0.00% refline3 line-visibility: on line-pattern-only: dashed stroke-color: #c564b6 color: #c564b6 fill-above: #00000000 fill-below: #00000000 font-family: Tableau Bold background-color: #ffffff81 font-size: 6 refline4 stroke-color: #c564b6 line-visibility: on line-pattern-only: dashed stroke-size: 2 color: #c564b6 fill-above: #00000000 fill-below: #00000000 font-size: 6 font-family: Tableau Bold text-align: right vertical-align: bottom background-color: #ffffff81 text-format: n#,##0;-#,##0 Style: gridline Other line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 stroke-size: 3 Style: table-div rows stroke-color: #f5f5f5 stroke-size: 3 cols stroke-size: 5 line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 Style: legend-title Other font-size: 8 font-family: Tableau Book font-weight: bold text-align: right Style: axis-title [Marketo].[id] font-family: Tableau Bold font-size: 8 [Marketo].[Delivery Rate] font-family: Tableau Bold font-size: 8 [Marketo].[Open Rate] font-family: Tableau Bold font-size: 8 [Marketo].[Clickthrough Rate (copy)] font-family: Tableau Bold font-size: 8 [Marketo].[Sent Email] font-family: Tableau Bold Style: quick-filter [Marketo].[name] title: Campaign [Marketo].[programName] title: Program Style: quick-filter-title Other font-family: Tableau Regular Style: data-highlighter-title [Marketo].[name] title: Campaign Other font-family: Tableau Regular Worksheet: Mobile - Sent by Campaign Visible: No Used Datasources Datasource: Marketo Discrete Dimension: Activity Date Remote Column: [Activity - Send Email].[Activity_Date] Discrete Dimension: "Sent Emails" Discrete Dimension: Id (Activity - Click Email) Remote Column: [Activity - Click Email].[id] Discrete Dimension: Id (Activity - Email Delivered) Remote Column: [Activity - Email Delivered].[id] Discrete Dimension: Id (Activity - Open Email) Remote Column: [Activity - Open Email].[id] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Id Remote Column: [Activity - Send Email].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Dimension: Program Name Remote Column: [Campaigns].[programName] Continous Measure: Delivered Email Continous Measure: Opened Email Continous Measure: Delivery Rate Continous Measure: Open Rate Continous Measure: Clickthrough Emails Continous Measure: Sent Email Continous Measure: Click-to-Open Marks Mark: All Type: Automatic View Rows: [Marketo].[id (Campaigns)] ([Marketo].[name] ([Marketo].[Delivery Rate] ([Marketo].[Open Rate] [Marketo].[Clickthrough Rate (copy)])))) Columns: [Marketo].["Sent Emails"] [Marketo].[id] Filters: [Marketo].[Action (ID,Name,Program Name)] [Marketo].[Tooltip (HOUR(Activity Date))] [Marketo].[id] [Marketo].[name] Slices: [Marketo].[Tooltip (HOUR(Activity Date))] [Marketo].[id] [Marketo].[name] [Marketo].[Action (ID,Name,Program Name)] Styles Style: axis [Marketo].[id] display: false Style: cell [Marketo].[Clickthrough Rate (copy)] height: 26 Style: header Other height-header: 40 [Marketo].["Sent Emails"] height: 40 background-color: #f5f5f5 [Marketo].[name] width: 92 [Marketo].[Delivery Rate] width: 54 [Marketo].[Open Rate] width: 40 [Marketo].[Clickthrough Rate (copy)] width: 40 Style: field-labels Other font-family: Tableau Bold font-size: 6 background-color: #f2f2f3 Style: label [Marketo].[id (Campaigns)] display: false [Marketo].[Delivery Rate] color: #4f7cba font-size: 8 text-align: center text-format: p0% [Marketo].[Open Rate] color: #7873c0 font-size: 8 text-align: center text-format: p0% [Marketo].[Clickthrough Rate (copy)] color: #c564b6 font-size: 8 text-align: center text-format: p0% [Marketo].[name] font-size: 8 [Marketo].["Sent Emails"] font-family: Tableau Bold font-size: 6 color: #555555 Style: worksheet cols display-field-labels: false Style: gridline Other stroke-size: 5 line-pattern-only: solid line-visibility: off Style: zeroline Other line-visibility: off Style: table-div cols div-level: 1 stroke-size: 5 line-visibility: on line-pattern-only: solid stroke-color: #ffffff rows stroke-size: 1 stroke-color: #e6e6e6 Style: header-div cols stroke-color: #ffffff stroke-size: 4 line-visibility: on line-pattern-only: solid Worksheet: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Summary Visible: No Used Datasources Datasource: Marketo Discrete Dimension: Activity Date Remote Column: [Activity - Send Email].[Activity_Date] Discrete Dimension: Active Remote Column: [Campaigns].[active] Discrete Dimension: Id (Activity - Click Email) Remote Column: [Activity - Click Email].[id] Discrete Dimension: Id (Activity - Email Delivered) Remote Column: [Activity - Email Delivered].[id] Discrete Dimension: Id (Activity - Open Email) Remote Column: [Activity - Open Email].[id] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Id Remote Column: [Activity - Send Email].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Dimension: Program Name Remote Column: [Campaigns].[programName] Continous Measure: Delivered Email Continous Measure: Opened Email Continous Measure: Delivery Rate Continous Measure: Open Rate Continous Measure: Clickthrough Emails Continous Measure: Clickthrough Rate Continous Measure: Sent Email Continous Measure: Click-to-Open Marks Mark: All Type: Automatic Label: <[Marketo].[Multiple Values]> Tooltip: <[Marketo].[Measure Names()]>: <[Marketo].[Multiple Values]> View Columns: [Marketo].[Measure Names()] Filters: [Marketo].[Measure Names()] [Marketo].[Action (ID,Name,Program Name)] [Marketo].[active] [Marketo].[name] [Marketo].[programName] [Marketo].[DAY(Activity_Date)] Manual Sorting: [Marketo].[Measure Names()] ASC Slices: [Marketo].[Measure Names()] [Marketo].[DAY(Activity_Date)] [Marketo].[active] [Marketo].[programName] [Marketo].[name] [Marketo].[Action (ID,Name,Program Name)] Styles Style: header [Marketo].[Measure Names()] height: 31 background-color: #f2f2f3 Style: label [Marketo].[Measure Names()] font-weight: normal text-align: center vertical-align: center font-family: Tableau Regular Style: table-div rows stroke-size: 4 line-visibility: off cols stroke-size: 3 line-visibility: on line-pattern-only: solid stroke-color: #ffffff div-level: 1 Worksheet: Timeline - Sent Visible: No Used Datasources Datasource: Marketo Discrete Dimension: Activity Date Remote Column: [Activity - Send Email].[Activity_Date] Discrete Dimension: Active Remote Column: [Campaigns].[active] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Id Remote Column: [Activity - Send Email].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Dimension: Program Name Remote Column: [Campaigns].[programName] Marks Mark: All Type: Area Tooltip: <[Marketo].[HOUR(Activity_Date)]> <[Marketo].[id]> sent emails View Rows: [Marketo].[id] Columns: [Marketo].[HOUR(Activity_Date)] Filters: [Marketo].[Action (ID,Name,Program Name)] [Marketo].[active] [Marketo].[name] [Marketo].[programName] [Marketo].[DAY(Activity_Date)] Slices: [Marketo].[active] [Marketo].[name] [Marketo].[programName] [Marketo].[DAY(Activity_Date)] [Marketo].[Action (ID,Name,Program Name)] Styles Style: axis [Marketo].[HOUR(Activity_Date)] auto-subtitle: true height: 23 [Marketo].[id] auto-subtitle: true Other border-color: #b0b0b0 border-width: 1 hnlabel: horizontal Style: header rows band-color: #00000000 cols band-color: #00000000 Style: field-labels Other font-family: Tableau Bold font-size: 8 Style: label [Marketo].[name] font-size: 8 font-family: Tableau Light [Marketo].[HOUR(Activity_Date)] font-size: 8 Style: pane cols band-color: #00000000 rows band-color: #00000000 Style: table Other show-null-value-warning: false rows band-size: 1 cols band-size: 1 Style: worksheet Other font-size: 8 Style: refline refline0 line-visibility: on line-pattern-only: dashed stroke-size: 2 fill-above: #00000000 fill-below: #00000000 font-size: 6 color: #c564b6 background-color: #ffffff00 stroke-color: #c564b6 refline1 line-visibility: on line-pattern-only: dashed stroke-color: #c564b6 background-color: #ffffff00 font-size: 6 color: #c564b6 fill-above: #00000000 fill-below: #00000000 refline2 line-visibility: on line-pattern-only: dashed font-size: 6 fill-above: #00000000 fill-below: #00000000 stroke-color: #c564b6 background-color: #ffffff00 color: #c564b6 refline3 line-visibility: on line-pattern-only: dashed stroke-color: #c564b6 color: #c564b6 background-color: #ffffff00 fill-above: #00000000 fill-below: #00000000 Style: gridline Other line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 stroke-size: 3 Style: table-div rows stroke-color: #f5f5f5 stroke-size: 3 cols stroke-size: 5 line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 Style: title Other background-color: #f2f2f3 Style: legend-title Other font-size: 8 font-family: Tableau Book font-weight: bold text-align: right Style: axis-title [Marketo].[id] font-family: Tableau Bold font-size: 8 Style: quick-filter [Marketo].[DAY(Activity_Date)] title: Date of Sent Email: [Marketo].[programName] title: Program [Marketo].[name] title: Campaign