Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Oracle Eloqua
Connection
Data Sources
Data Source: Oracle Eloqua
Attributes
authType: custom
authentication: yes
channel: https
class: webdata-direct:oracle-eloqua
connectionData: {"connectorName":"Oracle Eloqua","location":{"protocol":"https:","hostname":"connectors.tableau.com","port":"443","host":"https://connectors.tableau.com:443"},"apiUrl":"https://secure.eloqua.com/API/REST","apiScheme":"https","apiDomain":"eloqua.com","oAuth":{"requestTokenUrl":"--","callbackUrl":"https://connectors.tableau.com:443/oracle/eloqua/1/eloqua.html","authorizationFlowUrl":"https://login.eloqua.com/auth/oauth2/authorize","getAccessTokenUrl":"https://login.eloqua.com/auth/oauth2/token"},"userFilters":{"dateRange":30},"pagination":{"invoicePageSize":10},"selectedCompanyName":"","selectedEntity":"","selectedFilter":"dateRange","baseUrl":"https://secure.p01.eloqua.com","authMode":"Basic","basicAuthUsername":"","basicAuthCompany":""}
connectionName: Eloqua
filename: eloqua.html
path: /oracle/eloqua/1/
port: 443
server: connectors.tableau.com
username: {"user":"","technologyPartner":""}
workgroup-auth-mode: prompt
Tables
Table: Activities - All
Database Object: [activitiesAll]
Connection: Oracle Eloqua
Table: Campaigns
Database Object: [campaigns]
Connection: Oracle Eloqua
Dimension
Activities - All
Dimension: Activity Date
Role: Discrete Dimension
Remote Column: [Activities - All].[ActivityDate]
Data Type: datetime
Dimension: Activity Id
Role: Discrete Dimension
Remote Column: [Activities - All].[ActivityId]
Data Type: integer
Dimension: Activity Type
Role: Discrete Dimension
Remote Column: [Activities - All].[ActivityType]
Data Type: string
Dimension: Asset Id
Role: Discrete Dimension
Remote Column: [Activities - All].[AssetId]
Data Type: integer
Dimension: Asset Name
Role: Discrete Dimension
Remote Column: [Activities - All].[AssetName]
Data Type: string
Dimension: Asset Type
Role: Discrete Dimension
Remote Column: [Activities - All].[AssetType]
Data Type: string
Dimension: Campaign Id
Role: Discrete Dimension
Remote Column: [Activities - All].[CampaignId]
Data Type: integer
Dimension: Contact Id
Role: Discrete Dimension
Remote Column: [Activities - All].[ContactId]
Data Type: integer
Dimension: Deployment Id
Role: Discrete Dimension
Remote Column: [Activities - All].[DeploymentId]
Data Type: integer
Dimension: Email Address
Role: Discrete Dimension
Remote Column: [Activities - All].[EmailAddress]
Data Type: string
Dimension: Email Clicked Thru Link
Role: Discrete Dimension
Remote Column: [Activities - All].[EmailClickedThruLink]
Data Type: string
Dimension: Email Recipient Id
Role: Discrete Dimension
Remote Column: [Activities - All].[EmailRecipientId]
Data Type: string
Dimension: Email Send Type
Role: Discrete Dimension
Remote Column: [Activities - All].[EmailSendType]
Data Type: string
Dimension: Email Web Link
Role: Discrete Dimension
Remote Column: [Activities - All].[EmailWebLink]
Data Type: string
Dimension: External Id
Role: Discrete Dimension
Remote Column: [Activities - All].[ExternalId]
Data Type: string
Dimension: First Page View Url
Role: Discrete Dimension
Remote Column: [Activities - All].[FirstPageViewUrl]
Data Type: string
Dimension: Ip Address
Role: Discrete Dimension
Remote Column: [Activities - All].[IpAddress]
Data Type: string
Dimension: Is Web Tracking Opted In
Role: Discrete Dimension
Remote Column: [Activities - All].[IsWebTrackingOptedIn]
Data Type: string
Dimension: Raw Data
Role: Discrete Dimension
Remote Column: [Activities - All].[RawData]
Data Type: string
Dimension: Referrer Url
Role: Discrete Dimension
Remote Column: [Activities - All].[ReferrerUrl]
Data Type: string
Dimension: Subject Line
Role: Discrete Dimension
Remote Column: [Activities - All].[SubjectLine]
Data Type: string
Dimension: Visitor External Id
Role: Discrete Dimension
Remote Column: [Activities - All].[VisitorExternalId]
Data Type: string
Dimension: Visitor Id
Role: Discrete Dimension
Remote Column: [Activities - All].[VisitorId]
Data Type: integer
Dimension: Web Visit Id
Role: Discrete Dimension
Remote Column: [Activities - All].[WebVisitId]
Data Type: integer
Campaigns
Dimension: Campaign Category
Role: Discrete Dimension
Remote Column: [Campaigns].[campaignCategory]
Data Type: string
Dimension: Campaign Type
Role: Discrete Dimension
Remote Column: [Campaigns].[campaignType]
Data Type: string
Dimension: Created At
Role: Discrete Dimension
Remote Column: [Campaigns].[createdAt]
Data Type: datetime
Dimension: CRM Id
Role: Discrete Dimension
Remote Column: [Campaigns].[crmId]
Data Type: string
Dimension: Current Status
Role: Discrete Dimension
Remote Column: [Campaigns].[currentStatus]
Data Type: string
Dimension: Description
Role: Discrete Dimension
Remote Column: [Campaigns].[description]
Data Type: string
Dimension: End At
Role: Discrete Dimension
Remote Column: [Campaigns].[endAt]
Data Type: datetime
Dimension: First Activation
Role: Discrete Dimension
Remote Column: [Campaigns].[firstActivation]
Data Type: datetime
Dimension: ID
Role: Discrete Dimension
Remote Column: [Campaigns].[id]
Data Type: integer
Dimension: Is Email Marketing Campaign
Role: Discrete Dimension
Remote Column: [Campaigns].[isEmailMarketingCampaign]
Data Type: string
Dimension: Is Included In ROI
Role: Discrete Dimension
Remote Column: [Campaigns].[isIncludedInROI]
Data Type: string
Dimension: Is Read Only
Role: Discrete Dimension
Remote Column: [Campaigns].[isReadOnly]
Data Type: boolean
Dimension: Is Synced With CRM
Role: Discrete Dimension
Remote Column: [Campaigns].[isSyncedWithCRM]
Data Type: string
Dimension: Member Count
Role: Discrete Dimension
Remote Column: [Campaigns].[memberCount]
Data Type: string
Dimension: Name
Role: Discrete Dimension
Remote Column: [Campaigns].[name]
Data Type: string
Dimension: Product
Role: Discrete Dimension
Remote Column: [Campaigns].[product]
Data Type: string
Dimension: Region
Role: Discrete Dimension
Remote Column: [Campaigns].[region]
Data Type: string
Dimension: Start At
Role: Discrete Dimension
Remote Column: [Campaigns].[startAt]
Data Type: datetime
Dimension: Updated At
Role: Discrete Dimension
Remote Column: [Campaigns].[updatedAt]
Data Type: datetime
Calculated/Other
Dimension: Measure Names
Role: Discrete Dimension
Data Type: string
Dimension: Step 1
Role: Discrete Dimension
Data Type: string
Formula: // This is a calculation used to create the instructions button
"?"
Dimension: Step 2
Role: Discrete Dimension
Data Type: string
Formula: // This is a calculation used to create the instructions button
"Step 1"
Measure
Activities - All
Measure: Number Of Pages
Role: Continous Measure
Remote Column: [Activities - All].[NumberOfPages]
Data Type: integer
Measure: Duration
Role: Continous Measure
Remote Column: [Activities - All].[Duration]
Data Type: string
Aggregation: Count
Measure: Url
Role: Continous Measure
Remote Column: [Activities - All].[Url]
Data Type: string
Aggregation: Count
Campaigns
Measure: Actual Cost
Role: Continous Measure
Remote Column: [Campaigns].[actualCost]
Data Type: integer
Measure: Budgeted Cost
Role: Continous Measure
Remote Column: [Campaigns].[budgetedCost]
Data Type: integer
Measure: isMemberAllowedReEntry
Role: Continous Measure
Remote Column: [Campaigns].[isMemberAllowedReEntry]
Data Type: boolean
Aggregation: Count
Measure: eloquacustomfield_3
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_3]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_4
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_4]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_5
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_5]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_6
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_6]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_7
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_7]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_8
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_8]
Data Type: real
Aggregation: Sum
Measure: eloquacustomfield_9
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_9]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_10
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_10]
Data Type: datetime
Aggregation: Year
Measure: eloquacustomfield_12
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_12]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_13
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_13]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_16
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_16]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_17
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_17]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_18
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_18]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_19
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_19]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_20
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_20]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_28
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_28]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_29
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_29]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_30
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_30]
Data Type: string
Aggregation: Count
Measure: eloquacustomfield_31
Role: Continous Measure
Remote Column: [Campaigns].[eloquacustomfield_31]
Data Type: string
Aggregation: Count
Calculated/Other
Measure: Open Rate
Role: Discrete Measure
Data Type: real
Formula: // It is a calculation
// It shows the proportion of open emails compared to the total of sent emails
[Total Open ]
/
[Total Sent]
Measure: Delivery Rate
Role: Discrete Measure
Data Type: real
Formula: // It is a calculation
// It shows the proportion of delivered emails compared to the total of sent emails
ZN([Total Delivery])
/
ZN([Total Sent])
Measure: Total Sent
Role: Continous Measure
Data Type: integer
Formula: // It is a calculation containing an If Statement
// It shows the tota numbelr of sent emails
ZN(COUNTD(IF [ActivityType]="EmailSend"
THEN [ActivityId]
END))
Measure: Total for Open rate
Role: Continous Measure
Data Type: real
Formula: // It is a calculation to be used to generate the pie chart
// It shows the percentage missing to 1 (full circle)
1-[Bounce Rate (copy)]
Measure: Click Rate
Role: Discrete Measure
Data Type: real
Formula: // It is a calculation containing a ZN expression
// It shows the porportion of clickthrough emails compared to total of sent emails
ZN([Total Clickthrough])
/
ZN([Total Sent])
Measure: Click-to-Open Rate (CTOR)
Role: Discrete Measure
Data Type: real
Formula: // It is a calculation containing a ZN expression
// It shows the porportion of clickthrough emails compared to total open emails
ZN([Clickthrough Rate (Unique Clicks) (copy)]
/
[Open Rate (copy)])
Measure: Total Clickthrough
Role: Discrete Measure
Data Type: integer
Formula: // It is a calculation containing an If Statement
// It shows the total of emails clicked
ZN(COUNTD(IF [ActivityType]="EmailClickthrough"
THEN [ActivityId]
END))
Measure: Total Delivery
Role: Discrete Measure
Data Type: integer
Formula: // It is a calculation containing an If Statement
// It shows the total email sent minus the bounceback emails
([Total Sent] - ZN(COUNTD(IF [ActivityType]="Bounceback"
THEN [ActivityId]
END)))
Measure: Measure Values
Role: Continous Measure
Data Type: real
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Measure: Total Open
Role: Discrete Measure
Data Type: integer
Formula: // Show total number of open emails
ZN(COUNTD(IF [ActivityType]="EmailOpen"
THEN [ActivityId]
END))
Measure: Total for Delivery
Role: Continous Measure
Data Type: real
Formula: // It is a calculation to be used to generate the pie chart
// It shows the percentage missing to 1 (full circle)
1-[Delivery Rate]
Measure: Total for Clickthrough
Role: Continous Measure
Data Type: real
Formula: //It is a calculation to be used to generate the pie chart
// It shows the percentage missing to 1 (full circle)
1 - [Clickthrough (copy)]
Semantic Values
[Country].[Name]: "United States"
Dashboards
Dashboard: Campaign Overview
Worksheets
Worksheet: Icon
Datasources: Oracle Eloqua
Used Dimensions & Measures: ["Click to learn how to edit the date filter"]
[Step 1]
Worksheet: Big Numbers
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Click-to-Open Rate (CTOR)]
[Current Status]
[Delivery Rate]
[Name]
[Subject Line]
[Total Clickthrough]
[Total Delivery]
[Total Open ]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: Top 5 Campaigns
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Current Status]
[Name]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: Bounceback Rate
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Current Status]
[Delivery Rate]
[Name]
[Number of Records]
[Subject Line]
[Total Delivery]
[Total for Delivery]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: Open Rate
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Current Status]
[Name]
[Number of Records]
[Open Rate]
[Subject Line]
[Total for Open rate]
[Total Open ]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: Clickthrough Rate
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Click Rate]
[Name]
[Number of Records]
[Subject Line]
[Total Clickthrough]
[Total for Clickthrough]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[name]
Worksheet: Timeline
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Asset Name]
[Current Status]
[Name]
[Subject Line]
[Total Clickthrough]
[Total Delivery]
[Total Open ]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[AssetName]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: By Weekday
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Current Status]
[Name]
[Subject Line]
[Total Clickthrough]
[Total Delivery]
[Total Open ]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Worksheet: By Hour
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Current Status]
[Name]
[Subject Line]
[Total Clickthrough]
[Total Delivery]
[Total Open ]
[Total Sent]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[SubjectLine]
[Campaigns].[currentStatus]
[Campaigns].[name]
Dashboard Objects:
Filter: [Oracle Eloqua].[DAY(ActivityDate)]
Filter: [Oracle Eloqua].[currentStatus]
Filter: [Oracle Eloqua].[name]
Filter: [Oracle Eloqua].[AssetName]
Filter: [Oracle Eloqua].[SubjectLine]
Text: <Sheet Name>
Worksheets
Worksheet: Big Numbers
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Measure: Delivery Rate
Continous Measure: Total Sent
Discrete Measure: Click-to-Open Rate (CTOR)
Discrete Measure: Total Clickthrough
Discrete Measure: Total Delivery
Discrete Measure: Total Open
Marks
Mark: All
Type: Automatic
Label: <[Oracle Eloqua].[Multiple Values]>
View
Columns: [Oracle Eloqua].[Measure Names()]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
Styles
Style: cell
[Oracle Eloqua].[Calculation_998391747871600647]
text-format: N
Style: header
[Oracle Eloqua].[name]
width: 240
[Oracle Eloqua].[Measure Names()]
height: 34
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[Measure Names()]
display: true
color: #333333
font-family: Tableau Regular
font-size: 10
Style: table-div
rows
line-visibility: off
cols
stroke-size: 4
line-pattern-only: solid
div-level: 1
stroke-color: #f5f5f5
line-visibility: off
Style: header-div
cols
stroke-color: #ffffff
line-visibility: on
line-pattern-only: solid
Style: title
Other
background-color: #f2f2f3
Worksheet: Bounceback Rate
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Measure: Delivery Rate
Continous Measure: Total Sent
Discrete Measure: Total Delivery
Continous Measure: Number of Records
Continous Measure: Total for Delivery
Marks
Mark: All
Type: Pie
Tooltip: Delivery Report
Delivered emails: <[Oracle Eloqua].[Delivery Rate (copy)]>
Delivery Rate: <[Oracle Eloqua].[Delivery Rate]>
* Delivery rate calculated as (total sent e-mails - total bounceback) /total sent e-mails
View
Rows: [Oracle Eloqua].[MIN(Number of Records)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
Styles
Style: axis
[Oracle Eloqua].[MIN(Number of Records)]
display: false
Style: cell
[Oracle Eloqua].[Delivery Rate]
text-format: p0.00%
Style: label
[Oracle Eloqua].[Delivery Rate]
text-format: p0.0%
Style: pane
Other
border-style: none
Style: caption
Other
background-color: #00000000
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: zeroline
Other
stroke-size: 4
line-pattern-only: solid
stroke-color: #e15759
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
border-color: #e6e6e6
border-style: none
background-color: #f2f2f3
Worksheet: By Hour
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Continous Measure: Total Sent
Discrete Measure: Total Clickthrough
Discrete Measure: Total Delivery
Discrete Measure: Total Open
Marks
Mark: All
Type: Bar
Tooltip: Hour <[Oracle Eloqua].[HOUR(ActivityDate)]>:00
<[Oracle Eloqua].[Measure Names()]>
<[Oracle Eloqua].[Multiple Values]>
View
Rows: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Multiple Values]
Columns: [Oracle Eloqua].[HOUR(ActivityDate)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
Styles
Style: axis
[Oracle Eloqua].[Multiple Values]
auto-subtitle: true
[Oracle Eloqua].[HOUR(ActivityDate)]
height: 29
cols
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: header
[Oracle Eloqua].[Measure Names()]
width: 96
[Oracle Eloqua].[Multiple Values]
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[Measure Names()]
display: false
[Oracle Eloqua].[HOUR(ActivityDate)]
text-orientation: 0
font-size: 8
color: #555555
[Oracle Eloqua].[Multiple Values]
font-size: 8
font-family: Tableau Book
color: #555555
Style: worksheet
cols
display-field-labels: false
Style: refline
refline0
line-visibility: on
line-pattern-only: dashed
fill-above: #00000000
fill-below: #00000000
stroke-color: #fb1b3cb4
Style: gridline
Other
stroke-color: #f5f5f5
stroke-size: 2
line-visibility: on
line-pattern-only: dotted
cols
line-visibility: off
Style: zeroline
Other
line-pattern-only: solid
stroke-color: #898989
stroke-size: 2
line-visibility: off
Style: table-div
cols
line-visibility: off
rows
stroke-size: 3
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
Style: header-div
rows
stroke-color: #ffffff
Style: title
Other
background-color: #f2f2f3
Worksheet: By Weekday
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Continous Measure: Total Sent
Discrete Measure: Total Clickthrough
Discrete Measure: Total Delivery
Discrete Measure: Total Open
Marks
Mark: All
Type: Bar
Tooltip: Day: <[Oracle Eloqua].[WEEKDAY(ActivityDate)]>
<[Oracle Eloqua].[Measure Names()]>
<[Oracle Eloqua].[Multiple Values]>
View
Rows: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Multiple Values]
Columns: [Oracle Eloqua].[WEEKDAY(ActivityDate)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
Styles
Style: axis
[Oracle Eloqua].[Multiple Values]
auto-subtitle: true
[Oracle Eloqua].[WEEKDAY(ActivityDate)]
height: 30
cols
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: header
[Oracle Eloqua].[Measure Names()]
width: 96
[Oracle Eloqua].[Multiple Values]
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[Measure Names()]
display: false
[Oracle Eloqua].[WEEKDAY(ActivityDate)]
text-format: ieeeee
text-orientation: 0
font-size: 8
color: #555555
[Oracle Eloqua].[Multiple Values]
font-size: 8
font-family: Tableau Book
color: #555555
Style: worksheet
cols
display-field-labels: false
Other
color: #555555
Style: refline
refline0
line-visibility: on
line-pattern-only: dashed
fill-above: #00000000
fill-below: #00000000
background-color: #ffffffce
stroke-color: #fb1b3cb4
Style: gridline
Other
stroke-color: #f5f5f5
stroke-size: 2
line-visibility: on
line-pattern-only: dotted
cols
line-visibility: off
Style: zeroline
Other
line-pattern-only: solid
stroke-color: #898989
stroke-size: 2
line-visibility: off
Style: table-div
cols
line-visibility: off
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
stroke-size: 3
Style: header-div
rows
stroke-color: #ffffff
Style: title
Other
background-color: #f2f2f3
Worksheet: Clickthrough Rate
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Continous Measure: Total Sent
Discrete Measure: Click Rate
Discrete Measure: Total Clickthrough
Continous Measure: Number of Records
Continous Measure: Total for Clickthrough
Marks
Mark: All
Type: Pie
Tooltip: Clickthrough Report
Clickthrough emails: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]>
Clickthrough Rate: <[Oracle Eloqua].[Clickthrough (copy)]>
* Clickthrough rate calculated as total clickthtough e-mails /total sent e-mails
View
Rows: [Oracle Eloqua].[MIN(Number of Records)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[name]
Slices: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
Styles
Style: axis
[Oracle Eloqua].[MIN(Number of Records)]
display: false
Style: pane
Other
border-style: none
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: zeroline
Other
stroke-size: 4
line-pattern-only: solid
stroke-color: #e15759
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Icon
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: "Click to learn how to edit the date filter"
Discrete Dimension: Step 1
Marks
Mark: All
Type: Text
Label: How to edit the date filter
Tooltip: How to edit the date filter
1. Click "Edit" in the top right of your dashboard to enable web edit
2. In web edit mode, click on the desired filter
3. In the box around the filter, click the tab showing "More Options"
3. Pick "Relative Date" as below
<Sheet name="Tooltip: Instructions" maxwidth="350" maxheight="300" filter="<All Fields>">
4. To change the date range, click on "Today"
<Sheet name="Tooltip: Instructions 2" maxwidth="350" maxheight="250" filter="<All Fields>">
View
Styles
Style: cell
Other
width: 304
color: #f71b3b
Style: table
Other
background-color: #00000000
Worksheet: Open Rate
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Measure: Open Rate
Continous Measure: Total Sent
Continous Measure: Total for Open rate
Continous Measure: Number of Records
Discrete Measure: Total Open
Marks
Mark: All
Type: Pie
Tooltip: Open Emails Report
Open Emails: <[Oracle Eloqua].[Open Rate (copy)]>
Open Rate: <[Oracle Eloqua].[Bounce Rate (copy)]>
* Open rate calculated as total open e-mails /total sent e-mails
View
Rows: [Oracle Eloqua].[MIN(Number of Records)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[Action (HOUR(Activity Date))]
Styles
Style: axis
[Oracle Eloqua].[MIN(Number of Records)]
display: false
Style: pane
Other
border-style: none
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: zeroline
Other
stroke-size: 4
line-pattern-only: solid
stroke-color: #e15759
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Sheet 1
Visible: No
Marks
Mark: All
Type: Automatic
View
Worksheet: Timeline
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Asset Name
Remote Column: [Activities - All].[AssetName]
Discrete Dimension: Subject Line
Remote Column: [Activities - All].[SubjectLine]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Continous Measure: Total Sent
Discrete Measure: Total Clickthrough
Discrete Measure: Total Delivery
Discrete Measure: Total Open
Marks
Mark: All
Type: Area
Tooltip: <[Oracle Eloqua].[HOUR(ActivityDate)]>:00 hours
<[Oracle Eloqua].[Measure Names()]>: <[Oracle Eloqua].[Multiple Values]>
Active Campaigns:<[Oracle Eloqua].[name]>
<Sheet name="Tooltip: Active Campaigns" maxwidth="350" maxheight="900" filter="<All Fields>">
View
Rows: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Multiple Values]
Columns: [Oracle Eloqua].[HOUR(ActivityDate)]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[AssetName]
[Oracle Eloqua].[SubjectLine]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[AssetName]
[Oracle Eloqua].[name]
[Oracle Eloqua].[SubjectLine]
Styles
Style: axis
[Oracle Eloqua].[HOUR(ActivityDate)]
auto-subtitle: true
height: 28
[Oracle Eloqua].[Multiple Values]
auto-subtitle: true
cols
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: header
[Oracle Eloqua].[Multiple Values]
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[Measure Names()]
display: false
[Oracle Eloqua].[Multiple Values]
font-size: 8
font-weight: normal
font-family: Tableau Book
color: #555555
[Oracle Eloqua].[HOUR(ActivityDate)]
color: #555555
font-size: 8
Style: worksheet
Other
color: #555555
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
line-visibility: on
line-pattern-only: dashed
stroke-size: 2
stroke-color: #fb1b3cb4
Style: gridline
Other
stroke-color: #f5f5f5
stroke-size: 2
line-visibility: on
line-pattern-only: dotted
cols
line-visibility: off
Style: zeroline
Other
stroke-color: #898989
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: table-div
cols
line-visibility: off
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
stroke-size: 3
Style: header-div
rows
stroke-color: #ffffff
Style: title
Other
background-color: #f2f2f3
Style: quick-filter
[Oracle Eloqua].[name]
title: Campaign
[Oracle Eloqua].[DAY(ActivityDate)]
title: Period:
[Oracle Eloqua].[SubjectLine]
title: Email Subject
Other
font-size: 8
background-color: #ffffff
color: #898989
border-color: #f71b3b
border-style: none
Style: quick-filter-title
Other
font-family: Tableau Regular
font-size: 8
font-weight: normal
color: #555555
Worksheet: Tooltip: Active Campaigns
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Discrete Measure: Open Rate
Continous Measure: Total Sent
Discrete Measure: Click Rate
Discrete Measure: Total Clickthrough
Discrete Measure: Total Delivery
Discrete Measure: Total Open
Marks
Mark: All
Type: Text
View
Rows: [Oracle Eloqua].[name]
Columns: [Oracle Eloqua].[Measure Names()]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Tooltip (HOUR(Activity Date))]
[Oracle Eloqua].[Delivery Rate (copy)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[Tooltip (HOUR(Activity Date))]
[Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Delivery Rate (copy)]
Styles
Style: cell
[Oracle Eloqua].[name]
height: 24
Other
width: 256
[Oracle Eloqua].[Measure Names()]
width: 58
Style: header
[Oracle Eloqua].[name]
width: 144
[Oracle Eloqua].[Measure Names()]
height: 44
background-color: #f2f2f3
rows
band-color: #00000000
Style: field-labels
Other
font-size: 9
font-family: Tableau Regular
color: #333333
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[name]
display: true
font-size: 8
[Oracle Eloqua].[Measure Names()]
font-weight: normal
text-align: center
font-family: Tableau Regular
color: #333333
Style: pane
rows
band-color: #00000000
Style: table
Other
background-color: #00000000
rows
band-size: 1
Style: worksheet
cols
display-field-labels: false
Other
font-family: Tableau Regular
font-weight: normal
font-size: 8
Style: table-div
rows
line-visibility: on
line-pattern-only: solid
stroke-size: 3
stroke-color: #f5f5f5
div-level: 1
cols
div-level: 1
Style: header-div
cols
stroke-size: 2
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff
Worksheet: Tooltip: Instructions
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Step 1
Marks
Mark: All
Type: Shape
View
Filters: [Oracle Eloqua].[Tooltip ("Instructions")]
[Oracle Eloqua].[Tooltip (Step 1)]
Slices: [Oracle Eloqua].[Tooltip ("Instructions")]
[Oracle Eloqua].[Tooltip (Step 1)]
Worksheet: Tooltip: Instructions 2
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Step 1
Discrete Dimension: Step 2
Marks
Mark: All
Type: Shape
View
Filters: [Oracle Eloqua].[Tooltip ("Instructions")]
[Oracle Eloqua].[Tooltip (Step 1)]
Slices: [Oracle Eloqua].[Tooltip ("Instructions")]
[Oracle Eloqua].[Tooltip (Step 1)]
Worksheet: Top 5 Campaigns
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Id
Remote Column: [Activities - All].[ActivityId]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Discrete Dimension: Current Status
Remote Column: [Campaigns].[currentStatus]
Discrete Dimension: Name
Remote Column: [Campaigns].[name]
Continous Measure: Total Sent
Marks
Mark: All
Type: Bar
Label: <[Oracle Eloqua].[Total Sent]>
View
Rows: [Oracle Eloqua].[name]
Columns: [Oracle Eloqua].[Total Sent]
Filters: [Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[name]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[Action (HOUR(Activity Date))]
[Oracle Eloqua].[currentStatus]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[name]
Styles
Style: axis
[Oracle Eloqua].[Total Sent]
display: false
Style: header
[Oracle Eloqua].[name]
width: 251
Other
height-header: 10
Style: label
[Oracle Eloqua].[name]
text-align: left
font-weight: normal
font-family: Tableau Book
font-size: 9
Style: table
Other
background-color: #00000000
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
line-pattern-only: solid
stroke-size: 5
line-visibility: off
Style: table-div
rows
div-level: 1
line-visibility: on
line-pattern-only: solid
stroke-size: 2
stroke-color: #f5f5f5
Style: title
Other
background-color: #f2f2f3