**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Campain Details **************************************************************************** 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 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_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: string Aggregation: Count Measure: eloquacustomfield_9 Role: Continous Measure Remote Column: [Campaigns].[eloquacustomfield_9] Data Type: string Aggregation: Count Measure: eloquacustomfield_12 Role: Continous Measure Remote Column: [Campaigns].[eloquacustomfield_12] Data Type: datetime Aggregation: Year Measure: eloquacustomfield_13 Role: Continous Measure Remote Column: [Campaigns].[eloquacustomfield_13] Data Type: real Aggregation: Sum Measure: eloquacustomfield_14 Role: Continous Measure Remote Column: [Campaigns].[eloquacustomfield_14] Data Type: string Aggregation: Count Measure: eloquacustomfield_15 Role: Continous Measure Remote Column: [Campaigns].[eloquacustomfield_15] Data Type: string Aggregation: Count Calculated/Other Measure: Average Delivery Role: Continous Measure Data Type: real Formula: // It is an average expression // It return the average value of delivery rate AVG({[Delivery Rate]}) Measure: AVG Click to Open Role: Continous Measure Data Type: real Formula: AVG({[Clickthrough Rate (Unique Clicks) (copy 2)]}) 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 ZN([Total Open ] / [Total Email Send]) Measure: AVG Open Rate Role: Continous Measure Data Type: real Formula: AVG({[Bounce Rate (copy)]}) Measure: Compare to AVG Open Rate Role: Discrete Measure Data Type: string Formula: IF [Open Rate]> [AVG Open Rate] THEN "Bigger" ELSEIF [Open Rate]< [AVG Open Rate] THEN "Smaller" ELSE "Equal" END Measure: AVG Clickthrough Role: Continous Measure Data Type: real Formula: AVG({[Clickthrough (copy)]}) Measure: Diff to AVG Open rate Role: Continous Measure Data Type: real Formula: [Bounce Rate (copy)]-AVG({[Bounce Rate (copy)]}) 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 [Total Delivery] / [Total Email Send] Measure: Total Email Send 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: 1-[Bounce Rate (copy)] Measure: Clickthrough 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] / [Total Email Send]) Measure: Click to Open 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 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: Compare to Average Delivery Role: Discrete Measure Data Type: string Formula: // It is an If Statement // It is used to compare the delivery rate of a campaign to the average delivery rate IF [Delivery Rate]> [Average Delivery] THEN "Bigger" ELSEIF [Delivery Rate]< [Average Delivery] THEN "Smaller" ELSE "Equal" END Measure: Compare to Average Click to Open Role: Discrete Measure Data Type: string Formula: // It is an If Statement // It is used to compare the open rate of a campaign to the average open rate IF [Clickthrough Rate (Unique Clicks) (copy 2)]>[AVG Clickthrough (copy)] THEN "Bigger" ELSEIF [Clickthrough Rate (Unique Clicks) (copy 2)]<[AVG Clickthrough (copy)] THEN "Smaller" ELSE "Equal" END Measure: Compare to AVG Clickthrough Role: Discrete Measure Data Type: string Formula: IF [Clickthrough Rate]> [AVG Clickthrough] THEN "Bigger" ELSEIF [Clickthrough Rate]< [AVG Clickthrough] THEN "Smaller" ELSE "Equal" 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 Email Send] - 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: // It is a calculation containing an If Statement // It shows the total of emails opened ZN(COUNTD(IF [ActivityType]="EmailOpen" THEN [ActivityId] END)) Measure: Total for Click to Open Role: Continous Measure Data Type: real Formula: 1 - [Clickthrough Rate (Unique Clicks) (copy 2)] Measure: Total for Delivery Role: Continous Measure Data Type: real Formula: 1-[Delivery Rate] Measure: Total for Clickthrough Role: Continous Measure Data Type: real Formula: 1 - [Clickthrough (copy)] Semantic Values [Country].[Name]: "United States" Dashboards Dashboard: Campaign Details Worksheets Worksheet: Show Campaign Name (2) Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Current Status] [ID] [Name] Used Remote Columns: [Activities - All].[ActivityDate] [Campaigns].[currentStatus] [Campaigns].[id] [Campaigns].[name] Worksheet: Big Numbers Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Activity Id] [Activity Type] [Click to Open Rate] [Clickthrough Rate] [Current Status] [Delivery Rate] [ID] [Name] [Open Rate] [Total Clickthrough] [Total Delivery] [Total Email Send] [Total Open ] Used Remote Columns: [Activities - All].[ActivityDate] [Activities - All].[ActivityId] [Activities - All].[ActivityType] [Campaigns].[currentStatus] [Campaigns].[id] [Campaigns].[name] Worksheet: Timeline Campaign Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Activity Id] [Activity Type] [Current Status] [Name] Used Remote Columns: [Activities - All].[ActivityDate] [Activities - All].[ActivityId] [Activities - All].[ActivityType] [Campaigns].[currentStatus] [Campaigns].[name] Worksheet: Campaign List Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Activity Id] [Activity Type] [Click to Open Rate] [Clickthrough Rate] [Current Status] [Delivery Rate] [ID] [Name] [Open Rate] [Subject Line] [Total Clickthrough] [Total Delivery] [Total Email Send] [Total Open ] Used Remote Columns: [Activities - All].[ActivityDate] [Activities - All].[ActivityId] [Activities - All].[ActivityType] [Activities - All].[SubjectLine] [Campaigns].[currentStatus] [Campaigns].[id] [Campaigns].[name] Worksheet: Email List Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Activity Id] [Activity Type] [Asset Id] [Asset Name] [Click to Open Rate] [Clickthrough Rate] [Current Status] [Delivery Rate] [ID] [Name] [Open Rate] [Subject Line] [Total Clickthrough] [Total Delivery] [Total Email Send] [Total Open ] Used Remote Columns: [Activities - All].[ActivityDate] [Activities - All].[ActivityId] [Activities - All].[ActivityType] [Activities - All].[AssetId] [Activities - All].[AssetName] [Activities - All].[SubjectLine] [Campaigns].[currentStatus] [Campaigns].[id] [Campaigns].[name] Worksheet: Campaigns Datasources: Oracle Eloqua Used Dimensions & Measures: [Activity Date] [Activity Id] [Activity Type] [Click to Open Rate] [Clickthrough Rate] [Current Status] [Delivery Rate] [ID] [Name] [Open Rate] [Subject Line] [Total Clickthrough] [Total Delivery] [Total Email Send] [Total Open ] Used Remote Columns: [Activities - All].[ActivityDate] [Activities - All].[ActivityId] [Activities - All].[ActivityType] [Activities - All].[SubjectLine] [Campaigns].[currentStatus] [Campaigns].[id] [Campaigns].[name] Dashboard Objects: Filter: [Oracle Eloqua].[DAY(ActivityDate)] Filter: [Oracle Eloqua].[currentStatus] Filter: [Oracle Eloqua].[name] Text: Text: Campaign List 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: Current Status Remote Column: [Campaigns].[currentStatus] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Measure: Open Rate Discrete Measure: Delivery Rate Continous Measure: Total Email Send Discrete Measure: Clickthrough Rate Discrete Measure: Click to Open Rate Discrete Measure: Total Clickthrough Discrete Measure: Total Delivery Discrete Measure: Total Open Marks Mark: All Type: Text Label: <[Oracle Eloqua].[Multiple Values]> Tooltip: How are the rates calculated? Delivery rate: (total sent e-mails - total bounceback) /total sent e-mails Clickt to open rate: total clickthtough emails /total open emails View Columns: [Oracle Eloqua].[Measure Names()] Filters: [Oracle Eloqua].[Measure Names()] [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC Slices: [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[Measure Names()] [Oracle Eloqua].[name] [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[currentStatus] Styles Style: header [Oracle Eloqua].[Measure Names()] height: 42 background-color: #f2f2f3 Style: label [Oracle Eloqua].[Measure Names()] text-align: center vertical-align: center font-size: 9 font-family: Tableau Medium 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 div-level: 1 Style: header-div rows stroke-size: 5 line-pattern-only: solid stroke-color: #ffffff line-visibility: off cols stroke-size: 4 line-visibility: on line-pattern-only: solid stroke-color: #ffffff Style: title Other background-color: #f2f2f3 Worksheet: Campaign List 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: ID Remote Column: [Campaigns].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Measure: Open Rate Discrete Measure: Delivery Rate Continous Measure: Total Email Send Discrete Measure: Clickthrough Rate Discrete Measure: Click to Open Rate Discrete Measure: Total Clickthrough Discrete Measure: Total Delivery Discrete Measure: Total Open Marks Mark: All Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign references <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Total Email Send] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign references <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Open Rate (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign references <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign references <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails View Rows: [Oracle Eloqua].[id] [Oracle Eloqua].[name] Columns: [Oracle Eloqua].[Total Email Send] ([Oracle Eloqua].[Open Rate (copy)] [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)])) Filters: [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[Total Email Send] Slices: [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[Total Email Send] [Oracle Eloqua].[name] [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[currentStatus] Styles Style: axis [Oracle Eloqua].[Total Email Send] height: 52 title: Total Email Send and % Delivery auto-subtitle: true [Oracle Eloqua].[Open Rate (copy)] height: 52 title: Total Open and % Open auto-subtitle: true [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] height: 52 title: Total Clickthrough and % Clickthrough auto-subtitle: true Style: cell [Oracle Eloqua].[name] height: 32 [Oracle Eloqua].[SubjectLine] height: 29 Style: header [Oracle Eloqua].[name] width: 566 [Oracle Eloqua].[id] width: 68 Style: field-labels-decoration Other font-family: Tableau Bold font-size: 9 Style: label [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] font-size: 8 color: #555555 [Oracle Eloqua].[Total Email Send] font-size: 8 color: #555555 [Oracle Eloqua].[Open Rate (copy)] font-size: 8 color: #555555 Style: table-div rows stroke-size: 5 stroke-color: #f5f5f5 cols stroke-size: 5 stroke-color: #f5f5f5 Style: header-div cols line-visibility: off Style: title Other background-color: #eef1f3 Style: legend-title-text [Oracle Eloqua].[Delivery Rate] color: Rates: Style: axis-title [Oracle Eloqua].[Total Email Send] font-size: 9 font-family: Tableau Bold [Oracle Eloqua].[Open Rate (copy)] font-size: 9 font-family: Tableau Bold [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] font-size: 9 font-family: Tableau Bold Style: quick-filter [Oracle Eloqua].[DAY(ActivityDate)] title: Activity [Oracle Eloqua].[currentStatus] title: Status Other background-color: #ffffff Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal color: #555555 Style: data-highlighter Other font-weight: normal background-color: #f5f5f5 Style: data-highlighter-title [Oracle Eloqua].[name] Other font-family: Tableau Regular font-size: 8 font-weight: bold Worksheet: 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: Subject Line Remote Column: [Activities - All].[SubjectLine] Discrete Dimension: Current Status Remote Column: [Campaigns].[currentStatus] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Measure: Open Rate Discrete Measure: Delivery Rate Continous Measure: Total Email Send Discrete Measure: Clickthrough Rate Discrete Measure: Click to Open Rate Discrete Measure: Total Clickthrough Discrete Measure: Total Delivery Discrete Measure: Total Open Marks Mark: All Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign is composed by <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Total Email Send] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign is composed by <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Bounce Rate (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign is composed by <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of and a click to open rate of : Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Bounce Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails Mark: [Oracle Eloqua].[Clickthrough (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[name]> ID: <[Oracle Eloqua].[id]> This campaign is composed by <[Oracle Eloqua].[SubjectLine]> emails. <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough (copy)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough (copy)]> Total Delivery: <[Oracle Eloqua].[Delivery Rate (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Click a campaign to Filter Dashboard and Show Related E-mails View Rows: [Oracle Eloqua].[name] Columns: [Oracle Eloqua].[Total Email Send] ([Oracle Eloqua].[Bounce Rate (copy)] [Oracle Eloqua].[Clickthrough (copy)])) Filters: [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[Total Email Send] Slices: [Oracle Eloqua].[Total Email Send] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[Action (ID,Name)] Styles Style: axis [Oracle Eloqua].[Total Email Send] title: Sent auto-subtitle: true height: 35 [Oracle Eloqua].[Clickthrough (copy)] auto-subtitle: true height: 35 title: % Clickthrough [Oracle Eloqua].[Bounce Rate (copy)] auto-subtitle: true height: 35 title: % Open Style: cell [Oracle Eloqua].[name] height: 39 [Oracle Eloqua].[Clickthrough (copy)] font-family: Tableau Bold Style: header [Oracle Eloqua].[name] width: 90 Style: field-labels-decoration Other font-family: Tableau Bold font-size: 8 Style: label [Oracle Eloqua].[name] display: true font-size: 8 [Oracle Eloqua].[Total Email Send] font-size: 8 [Oracle Eloqua].[Bounce Rate (copy)] font-size: 8 Style: worksheet rows display-field-labels: false Style: gridline cols stroke-size: 2 line-pattern-only: solid line-visibility: off rows line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 stroke-size: 2 Style: zeroline Other line-visibility: off Style: table-div rows stroke-size: 5 stroke-color: #f5f5f5 cols stroke-size: 5 stroke-color: #f5f5f5 Style: header-div cols line-visibility: off Style: title Other background-color: #f2f2f3 Style: axis-title [Oracle Eloqua].[Total Email Send] font-family: Tableau Bold [Oracle Eloqua].[Bounce Rate (copy)] font-family: Tableau Bold font-size: 8 [Oracle Eloqua].[Clickthrough (copy)] font-family: Tableau Bold font-size: 8 Style: quick-filter [Oracle Eloqua].[DAY(ActivityDate)] title: Activity [Oracle Eloqua].[currentStatus] title: Status Other background-color: #ffffff Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: bold color: #333333 Style: data-highlighter Other font-weight: normal background-color: #f5f5f5 Style: data-highlighter-title [Oracle Eloqua].[name] Other font-family: Tableau Regular font-size: 8 font-weight: bold Worksheet: Email List 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 Id Remote Column: [Activities - All].[AssetId] 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: ID Remote Column: [Campaigns].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Discrete Measure: Open Rate Discrete Measure: Delivery Rate Continous Measure: Total Email Send Discrete Measure: Clickthrough Rate Discrete Measure: Click to Open Rate Discrete Measure: Total Clickthrough Discrete Measure: Total Delivery Discrete Measure: Total Open Marks Mark: All Type: Bar Tooltip: <[Oracle Eloqua].[SubjectLine]> Part of campaign <[Oracle Eloqua].[name]> . <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Mark: [Oracle Eloqua].[Open Rate (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[SubjectLine]> Part of campaign <[Oracle Eloqua].[name]> . <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> Mark: [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] Type: Bar Tooltip: <[Oracle Eloqua].[SubjectLine]> Part of campaign <[Oracle Eloqua].[name]> . <[Oracle Eloqua].[Total Email Send]> emails were sent, with a delivery rate of <[Oracle Eloqua].[Delivery Rate]> , an open rate of <[Oracle Eloqua].[Bounce Rate (copy)]> and a click to open rate of <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy 2)]>: Summary Report: Total Clickthrough: <[Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)]> Total Open : <[Oracle Eloqua].[Open Rate (copy)]> View Rows: [Oracle Eloqua].[AssetId] ([Oracle Eloqua].[SubjectLine] ([Oracle Eloqua].[AssetName] [Oracle Eloqua].[Total Email Send]))) Columns: [Oracle Eloqua].[Open Rate (copy)] [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] Filters: [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[SubjectLine] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[Total Email Send] Slices: [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[SubjectLine] [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[Total Email Send] [Oracle Eloqua].[name] [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[currentStatus] Styles Style: axis [Oracle Eloqua].[Total Email Send] height: 52 [Oracle Eloqua].[Delivery Rate (copy)] height: 52 [Oracle Eloqua].[Open Rate (copy)] height: 52 [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] height: 52 Style: cell [Oracle Eloqua].[SubjectLine] height: 30 [Oracle Eloqua].[Total Email Send] height: 27 Style: header [Oracle Eloqua].[SubjectLine] width: 374 Other height-header: 18 [Oracle Eloqua].[Total Email Send] width: 292 [Oracle Eloqua].[AssetName] width: 256 Style: field-labels-decoration Other color: #555555 font-family: Tableau Bold font-size: 9 Style: field-labels-spanner rows color: #555555 Style: label [Oracle Eloqua].[Total Email Send] display: true text-align: center vertical-align: center [Oracle Eloqua].[AssetId] display: false [Oracle Eloqua].[SubjectLine] text-align: left vertical-align: center [Oracle Eloqua].[Delivery Rate (copy)] font-size: 8 font-family: Tableau Book [Oracle Eloqua].[Open Rate (copy)] font-size: 8 [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] font-size: 8 Style: table-div rows stroke-size: 5 stroke-color: #f5f5f5 div-level: 1 cols stroke-size: 5 stroke-color: #f5f5f5 Style: header-div cols line-visibility: off Style: title Other background-color: #eef1f3 Style: axis-title [Oracle Eloqua].[Delivery Rate (copy)] font-family: Tableau Bold [Oracle Eloqua].[Total Email Send] font-family: Tableau Bold font-size: 8 [Oracle Eloqua].[Open Rate (copy)] font-size: 9 font-family: Tableau Bold [Oracle Eloqua].[Clickthrough Rate (Unique Clicks) (copy)] font-size: 9 font-family: Tableau Bold Worksheet: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Show Campaign Name (2) Visible: No Used Datasources Datasource: Oracle Eloqua Discrete Dimension: Activity Date Remote Column: [Activities - All].[ActivityDate] Discrete Dimension: Current Status Remote Column: [Campaigns].[currentStatus] Discrete Dimension: ID Remote Column: [Campaigns].[id] Discrete Dimension: Name Remote Column: [Campaigns].[name] Marks Mark: All Type: Automatic Label: <[Oracle Eloqua].[name]> View Filters: [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[currentStatus] Slices: [Oracle Eloqua].[Action (ID,Name)] [Oracle Eloqua].[Action (HOUR(Activity Date))] [Oracle Eloqua].[currentStatus] Styles Style: table Other background-color: #f2f2f3 Worksheet: Timeline Campaign 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] Marks Mark: All Type: Area Tooltip: <[Oracle Eloqua].[HOUR(ActivityDate)]> Number of Activities: <[Oracle Eloqua].[ActivityId]> View Rows: [Oracle Eloqua].[ActivityId] Columns: [Oracle Eloqua].[HOUR(ActivityDate)] Filters: [Oracle Eloqua].[ActivityType] [Oracle Eloqua].[currentStatus] [Oracle Eloqua].[name] [Oracle Eloqua].[DAY(ActivityDate)] Slices: [Oracle Eloqua].[DAY(ActivityDate)] [Oracle Eloqua].[ActivityType] [Oracle Eloqua].[name] [Oracle Eloqua].[currentStatus] Styles Style: axis [Oracle Eloqua].[HOUR(ActivityDate)] auto-subtitle: true height: 25 [Oracle Eloqua].[ActivityId] title: auto-subtitle: true width: 40 Other stroke-size: 3 Style: label [Oracle Eloqua].[HOUR(ActivityDate)] font-size: 8 Style: pane Other border-style: none Style: gridline Other line-visibility: on line-pattern-only: solid stroke-size: 2 cols line-pattern-only: solid line-visibility: off Style: zeroline Other line-visibility: off Style: title Other background-color: #f2f2f3 Style: quick-filter [Oracle Eloqua].[name] title: Campaign Other background-color: #ffffff Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal color: #555555