Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Activties&Campaigns
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 Rate
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"
Dashboards
Dashboard: Email Performance Overview
Worksheets
Worksheet: Sent Emails
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id]
[Name]
[Program Name]
[Sent Email]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Send Email].[Activity_Date]
[Activity - Send Email].[id]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Sent
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date]
[Id]
[Name]
[Program Name]
Used Remote Columns: [Activity - Send Email].[Activity_Date]
[Activity - Send Email].[id]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Sent DD
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Send Email].[Activity_Date]
[Activity - Send Email].[id]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Sent HH
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Send Email].[Activity_Date]
[Activity - Send Email].[id]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Delivery Rate
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Bounceback]
[Delivered Email]
[Delivery Rate]
[Id (Activity - Email Delivered)]
[Id]
[Name]
[Program Name]
[Sent Email]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Send Email].[Activity_Date]
[Activity - Send Email].[id]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Delivery
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id (Activity - Email Delivered)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Delivery DD
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id (Activity - Email Delivered)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Delivery HH
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id (Activity - Email Delivered)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Open Rate
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Delivered Email]
[Id (Activity - Email Delivered)]
[Id (Activity - Open Email)]
[Name]
[Non Opened Email]
[Open Rate]
[Opened Email]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Open Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Open
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Open Email)]
[Activity Date]
[Id (Activity - Open Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Open Email].[Activity_Date]
[Activity - Open Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Open DD
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date (Activity - Open Email)]
[Activity Date]
[Id (Activity - Open Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Open Email].[Activity_Date]
[Activity - Open Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Open HH
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date (Activity - Open Email)]
[Activity Date]
[Id (Activity - Open Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Email Delivered].[Activity_Date]
[Activity - Open Email].[Activity_Date]
[Activity - Open Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Click-to-Open
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Clickthrough Emails]
[Click-to-Open Rate]
[Delivered Email]
[Id (Activity - Click Email)]
[Id (Activity - Email Delivered)]
[Id (Activity - Open Email)]
[Name]
[Non Opened Email]
[Opened Email]
[Opened Non Clicked Emails]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Click Email].[id]
[Activity - Email Delivered].[Activity_Date]
[Activity - Email Delivered].[id]
[Activity - Open Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Click
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date]
[Id (Activity - Click Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Click Email].[id]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Click DD
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id (Activity - Click Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Click Email].[id]
[Activity - Email Delivered].[Activity_Date]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Worksheet: Timeline - Click HH
Datasources: Activties&Campaigns
Used Dimensions & Measures: [Active]
[Activity Date (Activity - Click Email)]
[Activity Date (Activity - Email Delivered)]
[Activity Date]
[Id (Activity - Click Email)]
[Name]
[Program Name]
Used Remote Columns: [Activity - Click Email].[Activity_Date]
[Activity - Click Email].[id]
[Activity - Email Delivered].[Activity_Date]
[Activity - Send Email].[Activity_Date]
[Campaigns].[active]
[Campaigns].[name]
[Campaigns].[programName]
Dashboard Objects:
Filter: [Activties&Campaigns].[DAY(Activity_Date)]
Filter: [Activties&Campaigns].[active]
Filter: [Activties&Campaigns].[programName]
Text: Email Performance Overview
Text: TOTALS
Text: DELIVERY
Text: OPEN
Text: CLICK-TO-OPEN
Worksheets
Worksheet: Click-to-Open
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
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: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Continous Measure: Delivered Email
Continous Measure: Opened Email
Continous Measure: Non Opened Email
Continous Measure: Clickthrough Emails
Continous Measure: Opened Non Clicked Emails
Continous Measure: Click-to-Open Rate
Marks
Mark: All
Type: Pie
Tooltip: Click-to-Open Rate
<[Activties&Campaigns].[Clickthrough Rate (copy)]> of total sent
Click-to-open-rate rate calculated by total emails clicked divided by total opened
View
Filters: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Manual Sorting: [Activties&Campaigns].[Measure Names()] ASC
Slices: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
Styles
Style: axis
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: legend
Other
color: #898989
Style: legend-title
Other
color: #898989
Worksheet: Delivery Rate
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[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: Bounceback
Continous Measure: Delivered Email
Continous Measure: Delivery Rate
Continous Measure: Sent Email
Marks
Mark: All
Type: Pie
Tooltip: Delivery Rate
<[Activties&Campaigns].[Delivery Rate]> of total sent
Delivery rate calculated by total emails delivered divided by total sent
View
Filters: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Manual Sorting: [Activties&Campaigns].[Measure Names()] ASC
Slices: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
Styles
Style: table
Other
background-color: #00000000
Style: title
Other
background-color: #00000000
Worksheet: Open Rate
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
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: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Continous Measure: Delivered Email
Continous Measure: Opened Email
Continous Measure: Open Rate
Continous Measure: Non Opened Email
Marks
Mark: All
Type: Pie
Tooltip: Open Rate
<[Activties&Campaigns].[Open Rate]> of total delivered
Open rate calculated by total emails opened divided by total delivered
View
Filters: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Manual Sorting: [Activties&Campaigns].[Measure Names()] ASC
Slices: [Activties&Campaigns].[Measure Names()]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
Styles
Style: table
Other
background-color: #00000000
Style: title
Other
background-color: #00000000
Worksheet: Sent Emails
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
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: Sent Email
Marks
Mark: All
Type: Text
Label: <[Activties&Campaigns].[Sent Email]>
sent emails
Tooltip: Sent Email: <[Activties&Campaigns].[Sent Email]>
View
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Action (HOUR(Activity Date)) 1]
Styles
Style: table
Other
background-color: #00000000
Style: title
Other
background-color: #00000000
Worksheet: Sheet 1
Visible: No
Marks
Mark: All
Type: Automatic
View
Worksheet: Timeline - Click
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
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: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Area
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]>:00 hours
<[Activties&Campaigns].[id (Activity - Click Email)]> clicked emails
<Sheet name="Tooltips - Click-to-Open by Campaign" maxwidth="350" maxheight="400" filter="<All Fields>">
View
Rows: [Activties&Campaigns].[id (Activity - Click Email)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
Filters: [Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
Styles
Style: axis
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
auto-subtitle: true
[Activties&Campaigns].[id (Activity - Click Email)]
auto-subtitle: true
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Click Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #ffbe7d
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Click DD
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
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: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Click Email))]>
<[Activties&Campaigns].[id (Activity - Click Email)]> clicked emails
View
Rows: [Activties&Campaigns].[id (Activity - Click Email)]
Columns: [Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Click Email))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Click Email))]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Click Email)]
auto-subtitle: true
width: 40
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Click Email))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Click Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Click Email))]
color: #898989
text-format: ieeeee
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #ffbe7d
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Click HH
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
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: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]>:00 hours
<[Activties&Campaigns].[id (Activity - Click Email)]> clicked emails
View
Rows: [Activties&Campaigns].[id (Activity - Click Email)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Click Email)]
auto-subtitle: true
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Click Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Click Email))]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #ffbe7d
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Delivery
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Area
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]>:00 hours
<[Activties&Campaigns].[id (Activity - Email Delivered)]> delivered emails
<Sheet name="Tooltips - Delivered by Campaign" maxwidth="350" maxheight="400" filter="<All Fields>">
View
Rows: [Activties&Campaigns].[id (Activity - Email Delivered)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
Filters: [Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
Styles
Style: axis
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
auto-subtitle: true
[Activties&Campaigns].[id (Activity - Email Delivered)]
auto-subtitle: true
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Email Delivered)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #a0cbe8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Delivery DD
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Email Delivered))]>
<[Activties&Campaigns].[id (Activity - Email Delivered)]> delivered emails
View
Rows: [Activties&Campaigns].[id (Activity - Email Delivered)]
Columns: [Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Email Delivered))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Email Delivered))]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Email Delivered)]
auto-subtitle: true
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Email Delivered))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
display: false
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Email Delivered))]
display: true
color: #898989
text-format: ieeeee
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[id (Activity - Email Delivered)]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #a0cbe8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Delivery HH
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]>:00 hours
<[Activties&Campaigns].[id (Activity - Email Delivered)]> delivered emails
View
Rows: [Activties&Campaigns].[id (Activity - Email Delivered)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Email Delivered)]
auto-subtitle: true
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Email Delivered))]
display: true
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[id (Activity - Email Delivered)]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #a0cbe8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Open
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Open Email)
Remote Column: [Activity - Open Email].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Open Email)
Remote Column: [Activity - Open Email].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Area
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]>:00 hours
<[Activties&Campaigns].[id (Activity - Open Email)]> opened emails
<Sheet name="Tooltips - Opened by Campaign" maxwidth="350" maxheight="400" filter="<All Fields>">
View
Rows: [Activties&Campaigns].[id (Activity - Open Email)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
Filters: [Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
Styles
Style: axis
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
auto-subtitle: true
[Activties&Campaigns].[id (Activity - Open Email)]
auto-subtitle: true
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Open Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #d4a6c8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Open DD
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Open Email)
Remote Column: [Activity - Open Email].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Open Email)
Remote Column: [Activity - Open Email].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]>
<[Activties&Campaigns].[id (Activity - Open Email)]> opened emails
View
Rows: [Activties&Campaigns].[id (Activity - Open Email)]
Columns: [Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]
Slices: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Open Email)]
auto-subtitle: true
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Open Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[WEEKDAY(Activity_Date (Activity - Open Email))]
color: #898989
text-format: ieeeee
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #d4a6c8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Open HH
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Open Email)
Remote Column: [Activity - Open Email].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
Discrete Dimension: Id (Activity - Open Email)
Remote Column: [Activity - Open Email].[id]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Dimension: Program Name
Remote Column: [Campaigns].[programName]
Marks
Mark: All
Type: Bar
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]>:00 hours
<[Activties&Campaigns].[id (Activity - Open Email)]> opened emails
View
Rows: [Activties&Campaigns].[id (Activity - Open Email)]
Columns: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id (Activity - Open Email)]
auto-subtitle: true
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[id (Activity - Open Email)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[HOUR(Activity_Date (Activity - Open Email))]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #d4a6c8
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Sent
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
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: <[Activties&Campaigns].[HOUR(Activity_Date)]>:00 hours
<[Activties&Campaigns].[id]> sent emails
<Sheet name="Tooltips - Sent by Campaign" maxwidth="500" maxheight="800" filter="<All Fields>">
View
Rows: [Activties&Campaigns].[id]
Columns: [Activties&Campaigns].[HOUR(Activity_Date)]
Filters: [Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Styles
Style: axis
[Activties&Campaigns].[HOUR(Activity_Date)]
auto-subtitle: true
[Activties&Campaigns].[id]
auto-subtitle: true
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: header
[Activties&Campaigns].[HOUR(Activity_Date)]
background-color: #ffffff
Style: label
[Activties&Campaigns].[HOUR(Activity_Date)]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[id]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-size: 2
stroke-color: #ff9d9a
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
[Activties&Campaigns].[DAY(Activity_Date)]
title: Day of Activity Date
[Activties&Campaigns].[programName]
title: Program Name
[Activties&Campaigns].[name]
title: Campaign
[Activties&Campaigns].[active]
title: Active
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
font-weight: normal
font-size: 9
color: #898989
font-family: Tableau Semibold
Worksheet: Timeline - Sent DD
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
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: Bar
Tooltip: <[Activties&Campaigns].[WEEKDAY(Activity_Date)]>
<[Activties&Campaigns].[id]> sent emails
View
Rows: [Activties&Campaigns].[id]
Columns: [Activties&Campaigns].[WEEKDAY(Activity_Date)]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[WEEKDAY(Activity_Date)]
Slices: [Activties&Campaigns].[WEEKDAY(Activity_Date)]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id]
auto-subtitle: true
[Activties&Campaigns].[WEEKDAY(Activity_Date)]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[HOUR(Activity_Date)]
display: false
[Activties&Campaigns].[DAY(Activity_Date)]
display: true
[Activties&Campaigns].[WEEKDAY(Activity_Date)]
display: true
color: #898989
text-format: ieeeee
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[id]
color: #898989
font-family: Tableau Book
font-size: 9
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #ff9d9a
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Timeline - Sent HH
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: Active
Remote Column: [Campaigns].[active]
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: Bar
Tooltip: <[Activties&Campaigns].[HOUR(Activity_Date)]>:00 hours
<[Activties&Campaigns].[id]> sent emails
View
Rows: [Activties&Campaigns].[id]
Columns: [Activties&Campaigns].[HOUR(Activity_Date)]
Filters: [Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[HOUR(Activity_Date)]
[Activties&Campaigns].[active]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[DAY(Activity_Date)]
Slices: [Activties&Campaigns].[HOUR(Activity_Date)]
[Activties&Campaigns].[active]
[Activties&Campaigns].[DAY(Activity_Date)]
[Activties&Campaigns].[name]
[Activties&Campaigns].[programName]
[Activties&Campaigns].[Action (HOUR(Activity Date))]
[Activties&Campaigns].[Action (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Action (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[id]
auto-subtitle: true
[Activties&Campaigns].[HOUR(Activity_Date)]
height: 30
Other
tick-color: #00000000
Style: cell
Other
cell-w: 80
cell-h: 20
cell: 20
cell-q: 100
Style: label
[Activties&Campaigns].[HOUR(Activity_Date)]
display: true
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[id]
color: #898989
font-family: Tableau Book
font-size: 9
[Activties&Campaigns].[WEEKDAY(Activity_Date)]
color: #b4b4b4
text-format: ieeeee
Style: table
Other
show-null-value-warning: false
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Other
color: #ffffff
font-size: 8
font-family: Tableau Light
font-weight: bold
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
stroke-size: 2
line-visibility: on
line-pattern-only: dashed
background-color: #ffffff00
font-size: 6
color: #898989
stroke-color: #ff9d9a
font-family: Tableau Book
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff81
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #e6e6e6
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #83a3ce
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
Other
color: #555555
font-weight: normal
Style: quick-filter-title
Other
color: #333333
font-weight: normal
Worksheet: Tooltips - Click-to-Open by Campaign
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Click Email)
Remote Column: [Activity - Click Email].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Open Email)
Remote Column: [Activity - Open Email].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: "Click-to-Open Rate"
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]
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 Rate
Marks
Mark: All
Type: Bar
View
Rows: [Activties&Campaigns].[id (Campaigns)]
([Activties&Campaigns].[name]
([Activties&Campaigns].[Sent Email]
([Activties&Campaigns].[Delivery Rate]
[Activties&Campaigns].[Open Rate]))))
Columns: [Activties&Campaigns].["Click-to-Open Rate"]
[Activties&Campaigns].[Clickthrough Rate (copy)]
Filters: [Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Click Email)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Open Email)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Delivery Rate]
Slices: [Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Delivery Rate]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Open Email)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Click Email)))]
Styles
Style: axis
[Activties&Campaigns].[Delivery Rate]
display: false
[Activties&Campaigns].[Clickthrough Rate (copy)]
display: false
Style: header
Other
height-header: 40
[Activties&Campaigns].[name]
width: 140
[Activties&Campaigns].[Delivery Rate]
width: 56
[Activties&Campaigns].[Open Rate]
width: 60
[Activties&Campaigns].[Sent Email]
width: 44
[Activties&Campaigns].["Click-to-Open Rate"]
height: 36
background-color: #f5f5f5
Style: field-labels
Other
font-family: Tableau Book
font-size: 8
background-color: #f5f5f5
Style: label
[Activties&Campaigns].[id (Campaigns)]
display: false
[Activties&Campaigns].[name]
font-size: 8
[Activties&Campaigns].[Delivery Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Open Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Sent Email]
text-align: center
font-size: 8
color: #555555
[Activties&Campaigns].["Click-to-Open Rate"]
font-size: 8
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: Tooltips - Delivered by Campaign
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: "Delivery Rate"
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]
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 Rate
Marks
Mark: All
Type: Automatic
View
Rows: [Activties&Campaigns].[id (Campaigns)]
([Activties&Campaigns].[name]
([Activties&Campaigns].[Sent Email]
([Activties&Campaigns].[Open Rate]
[Activties&Campaigns].[Clickthrough Rate (copy)]))))
Columns: [Activties&Campaigns].["Delivery Rate"]
[Activties&Campaigns].[Delivery Rate]
Filters: [Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Tooltip (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Delivery Rate]
Slices: [Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Delivery Rate]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (WEEKDAY(Activity Date (Activity - Email Delivered)),HOUR(Activity Date (Activity - Email Delivered)))]
Styles
Style: axis
[Activties&Campaigns].[Delivery Rate]
display: false
Style: cell
[Activties&Campaigns].[Clickthrough Rate (copy)]
height: 24
Style: header
Other
height-header: 40
[Activties&Campaigns].[name]
width: 124
[Activties&Campaigns].[Open Rate]
width: 48
[Activties&Campaigns].[Clickthrough Rate (copy)]
width: 56
[Activties&Campaigns].["Delivery Rate"]
height: 36
background-color: #f5f5f5
[Activties&Campaigns].[Sent Email]
width: 56
Style: field-labels
Other
font-family: Tableau Book
font-size: 8
background-color: #f5f5f5
Style: label
[Activties&Campaigns].[id (Campaigns)]
display: false
[Activties&Campaigns].[name]
font-size: 8
[Activties&Campaigns].[Open Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Clickthrough Rate (copy)]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].["Delivery Rate"]
font-size: 8
color: #555555
[Activties&Campaigns].[Sent Email]
text-align: center
font-size: 8
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: Tooltips - Opened by Campaign
Visible: No
Used Datasources
Datasource: Activties&Campaigns
Discrete Dimension: Activity Date (Activity - Email Delivered)
Remote Column: [Activity - Email Delivered].[Activity_Date]
Discrete Dimension: Activity Date (Activity - Open Email)
Remote Column: [Activity - Open Email].[Activity_Date]
Discrete Dimension: Activity Date
Remote Column: [Activity - Send Email].[Activity_Date]
Discrete Dimension: "Open Rate"
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]
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 Rate
Marks
Mark: All
Type: Bar
View
Rows: [Activties&Campaigns].[id (Campaigns)]
([Activties&Campaigns].[name]
([Activties&Campaigns].[Sent Email]
([Activties&Campaigns].[Delivery Rate]
[Activties&Campaigns].[Clickthrough Rate (copy)]))))
Columns: [Activties&Campaigns].["Open Rate"]
[Activties&Campaigns].[Open Rate]
Filters: [Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Open Email)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Delivery Rate]
Slices: [Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
[Activties&Campaigns].[Delivery Rate]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Email Delivered)))]
[Activties&Campaigns].[Tooltip (HOUR(Activity Date (Activity - Open Email)))]
Styles
Style: axis
[Activties&Campaigns].[Delivery Rate]
display: false
[Activties&Campaigns].[Open Rate]
display: false
Style: cell
[Activties&Campaigns].[Clickthrough Rate (copy)]
height: 24
Style: header
Other
height-header: 40
[Activties&Campaigns].[name]
width: 132
[Activties&Campaigns].[Delivery Rate]
width: 56
[Activties&Campaigns].[Clickthrough Rate (copy)]
width: 60
[Activties&Campaigns].[Sent Email]
width: 56
[Activties&Campaigns].["Open Rate"]
height: 36
background-color: #f5f5f5
Style: field-labels
Other
font-family: Tableau Book
font-size: 8
background-color: #f5f5f5
Style: label
[Activties&Campaigns].[id (Campaigns)]
display: false
[Activties&Campaigns].[name]
font-size: 8
[Activties&Campaigns].[Delivery Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Clickthrough Rate (copy)]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Sent Email]
text-align: center
font-size: 8
color: #555555
[Activties&Campaigns].["Open Rate"]
font-size: 8
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: Tooltips - Sent by Campaign
Visible: No
Used Datasources
Datasource: Activties&Campaigns
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: [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 Rate
Marks
Mark: All
Type: Automatic
View
Rows: [Activties&Campaigns].[programName]
([Activties&Campaigns].[name]
([Activties&Campaigns].[Delivery Rate]
([Activties&Campaigns].[Open Rate]
[Activties&Campaigns].[Clickthrough Rate (copy)]))))
Columns: [Activties&Campaigns].["Sent Emails"]
[Activties&Campaigns].[id]
Filters: [Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
Slices: [Activties&Campaigns].[Tooltip (HOUR(Activity Date))]
Styles
Style: axis
[Activties&Campaigns].[id]
display: false
Style: cell
[Activties&Campaigns].[Clickthrough Rate (copy)]
height: 24
Style: header
Other
height-header: 40
[Activties&Campaigns].["Sent Emails"]
height: 36
background-color: #f5f5f5
[Activties&Campaigns].[name]
width: 132
[Activties&Campaigns].[Delivery Rate]
width: 60
[Activties&Campaigns].[Open Rate]
width: 52
[Activties&Campaigns].[Clickthrough Rate (copy)]
width: 56
[Activties&Campaigns].[programName]
width: 120
Style: field-labels
Other
font-family: Tableau Book
font-size: 8
background-color: #f5f5f5
Style: label
[Activties&Campaigns].[name]
font-size: 8
color: #898989
[Activties&Campaigns].[Delivery Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Open Rate]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].[Clickthrough Rate (copy)]
font-size: 8
text-align: center
color: #555555
[Activties&Campaigns].["Sent Emails"]
font-size: 8
[Activties&Campaigns].[programName]
color: #898989
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