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: Contacts
Database Object: [contacts]
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: string
Dimension: Duration
Role: Discrete Dimension
Remote Column: [Activities - All].[Duration]
Data Type: string
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: Url
Role: Discrete Dimension
Remote Column: [Activities - All].[Url]
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
Contacts
Dimension: AWS AccountID
Role: Discrete Dimension
Remote Column: [Contacts].[AWS_AccountID]
Data Type: string
Dimension: Account Contact Role
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Contact_Role]
Data Type: string
Dimension: Account Owner
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Owner]
Data Type: string
Dimension: Account Partner Agreement Status
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Partner_Agreement_Status]
Data Type: string
Dimension: Account Partner Program Type
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Partner_Program_Type]
Data Type: string
Dimension: Account Password
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Password]
Data Type: string
Dimension: Account Type
Role: Discrete Dimension
Remote Column: [Contacts].[Account_Type]
Data Type: string
Dimension: Account User Name
Role: Discrete Dimension
Remote Column: [Contacts].[Account_User_Name]
Data Type: string
Dimension: Address 1
Role: Discrete Dimension
Remote Column: [Contacts].[Address_1]
Data Type: string
Dimension: Address 2
Role: Discrete Dimension
Remote Column: [Contacts].[Address_2]
Data Type: string
Dimension: Address 3
Role: Discrete Dimension
Remote Column: [Contacts].[Address_3]
Data Type: string
Dimension: Adused
Role: Discrete Dimension
Remote Column: [Contacts].[Adused]
Data Type: string
Dimension: Analysis Software Used
Role: Discrete Dimension
Remote Column: [Contacts].[Analysis_Software_Used]
Data Type: string
Dimension: Analysis Types
Role: Discrete Dimension
Remote Column: [Contacts].[Analysis_Types]
Data Type: string
Dimension: Annual Revenue
Role: Discrete Dimension
Remote Column: [Contacts].[Annual_Revenue]
Data Type: string
Dimension: Appointment
Role: Discrete Dimension
Remote Column: [Contacts].[Appointment]
Data Type: string
Dimension: Area Of Interest
Role: Discrete Dimension
Remote Column: [Contacts].[Area_Of_Interest]
Data Type: string
Dimension: Asset
Role: Discrete Dimension
Remote Column: [Contacts].[Asset]
Data Type: string
Dimension: Author Profiles - URL
Role: Discrete Dimension
Remote Column: [Contacts].[Author_Profiles__URL]
Data Type: string
Dimension: Authorized User Check on Contact
Role: Discrete Dimension
Remote Column: [Contacts].[Authorized_User_Check_on_Contact]
Data Type: string
Dimension: Bizo ID
Role: Discrete Dimension
Remote Column: [Contacts].[Bizo_ID]
Data Type: string
Dimension: BrightTALK User ID
Role: Discrete Dimension
Remote Column: [Contacts].[BrightTALK_User_ID]
Data Type: string
Dimension: Browser Language - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Browser_Language__Most_Recent]
Data Type: string
Dimension: Business Phone
Role: Discrete Dimension
Remote Column: [Contacts].[Business_Phone]
Data Type: string
Dimension: Buy Registration Date - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Buy_Registration_Date__Most_Recent]
Data Type: string
Dimension: Buying Horizon
Role: Discrete Dimension
Remote Column: [Contacts].[Buying_Horizon]
Data Type: string
Dimension: CIBC - Trial Portal - TPEP - 2015-02-18
Role: Discrete Dimension
Remote Column: [Contacts].[CIBC__Trial_Portal__TPEP__20150218]
Data Type: string
Dimension: Campaign ID - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Campaign_ID__Most_Recent]
Data Type: string
Dimension: Campaign ID - Original
Role: Discrete Dimension
Remote Column: [Contacts].[Campaign_ID__Original]
Data Type: string
Dimension: Channel Manager
Role: Discrete Dimension
Remote Column: [Contacts].[Channel_Manager]
Data Type: string
Dimension: Channel Manager Email
Role: Discrete Dimension
Remote Column: [Contacts].[Channel_Manager_Email]
Data Type: string
Dimension: City
Role: Discrete Dimension
Remote Column: [Contacts].[City]
Data Type: string
Dimension: Comment 1
Role: Discrete Dimension
Remote Column: [Contacts].[Comment_1]
Data Type: string
Dimension: Comment 2
Role: Discrete Dimension
Remote Column: [Contacts].[Comment_2]
Data Type: string
Dimension: Comment 3
Role: Discrete Dimension
Remote Column: [Contacts].[Comment_3]
Data Type: string
Dimension: Comment - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Comment__Most_Recent]
Data Type: string
Dimension: Company
Role: Discrete Dimension
Remote Column: [Contacts].[Company]
Data Type: string
Dimension: Company Revenue
Role: Discrete Dimension
Remote Column: [Contacts].[Company_Revenue]
Data Type: string
Dimension: Company Size
Role: Discrete Dimension
Remote Column: [Contacts].[Company_Size]
Data Type: string
Dimension: Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[ContactID]
Data Type: integer
Dimension: Contact Owner ID
Role: Discrete Dimension
Remote Column: [Contacts].[Contact_Owner_ID]
Data Type: string
Dimension: Contact Us Request Type
Role: Discrete Dimension
Remote Column: [Contacts].[Contact_Us_Request_Type]
Data Type: string
Dimension: Contacting Date
Role: Discrete Dimension
Remote Column: [Contacts].[Contacting_Date]
Data Type: datetime
Dimension: Country
Role: Discrete Dimension
Remote Column: [Contacts].[Country]
Data Type: string
Dimension: Create Lead Hold
Role: Discrete Dimension
Remote Column: [Contacts].[Create_Lead_Hold]
Data Type: string
Dimension: Customer
Role: Discrete Dimension
Remote Column: [Contacts].[Customer]
Data Type: string
Dimension: Customer Date
Role: Discrete Dimension
Remote Column: [Contacts].[Customer_Date]
Data Type: datetime
Dimension: D&B Annual Sales Indicator
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Annual_Sales_Indicator]
Data Type: string
Dimension: D&B Business Structure
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Business_Structure]
Data Type: string
Dimension: D&B CEO Name
Role: Discrete Dimension
Remote Column: [Contacts].[DB_CEO_Name]
Data Type: string
Dimension: D&B DUNS Number
Role: Discrete Dimension
Remote Column: [Contacts].[DB_DUNS_Number]
Data Type: string
Dimension: D&B Doing Business As
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Doing_Business_As]
Data Type: string
Dimension: D&B Established In
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Established_In]
Data Type: string
Dimension: D&B Industry
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Industry]
Data Type: string
Dimension: D&B SIC Code
Role: Discrete Dimension
Remote Column: [Contacts].[DB_SIC_Code]
Data Type: string
Dimension: D&B Total Employees Indicator
Role: Discrete Dimension
Remote Column: [Contacts].[DB_Total_Employees_Indicator]
Data Type: string
Dimension: Data Geek Profile
Role: Discrete Dimension
Remote Column: [Contacts].[Data_Geek_Profile]
Data Type: string
Dimension: Date Created
Role: Discrete Dimension
Remote Column: [Contacts].[Date_Created]
Data Type: datetime
Dimension: Date Modified
Role: Discrete Dimension
Remote Column: [Contacts].[Date_Modified]
Data Type: datetime
Dimension: Deleted Contact Date
Role: Discrete Dimension
Remote Column: [Contacts].[Deleted_Contact_Date]
Data Type: datetime
Dimension: Deleted Lead Date
Role: Discrete Dimension
Remote Column: [Contacts].[Deleted_Lead_Date]
Data Type: datetime
Dimension: Department
Role: Discrete Dimension
Remote Column: [Contacts].[Department]
Data Type: string
Dimension: Dept
Role: Discrete Dimension
Remote Column: [Contacts].[Dept]
Data Type: string
Dimension: Device
Role: Discrete Dimension
Remote Column: [Contacts].[Device]
Data Type: string
Dimension: ESD Access on Contact
Role: Discrete Dimension
Remote Column: [Contacts].[ESD_Access_on_Contact]
Data Type: string
Dimension: Contact ID EXT
Role: Discrete Dimension
Remote Column: [Contacts].[Eloqua_Contact_ID]
Data Type: string
Dimension: Eloqua GUID
Role: Discrete Dimension
Remote Column: [Contacts].[Eloqua_GUID]
Data Type: string
Dimension: Eloqua Program
Role: Discrete Dimension
Remote Column: [Contacts].[Eloqua_Program]
Data Type: string
Dimension: Eloqua Slice Hash
Role: Discrete Dimension
Remote Column: [Contacts].[Eloqua_Slice_Hash]
Data Type: string
Dimension: Eloqua Slice Modified Date
Role: Discrete Dimension
Remote Column: [Contacts].[Eloqua_Slice_Modified_Date]
Data Type: datetime
Dimension: Email Address
Role: Discrete Dimension
Remote Column: [Contacts].[Email_Address]
Data Type: string
Dimension: Email Address Domain
Role: Discrete Dimension
Remote Column: [Contacts].[Email_Address_Domain]
Data Type: string
Dimension: Email Display Name
Role: Discrete Dimension
Remote Column: [Contacts].[Email_Display_Name]
Data Type: string
Dimension: Evaluation Team Size
Role: Discrete Dimension
Remote Column: [Contacts].[Evaluation_Team_Size]
Data Type: string
Dimension: External Notification Email
Role: Discrete Dimension
Remote Column: [Contacts].[External_Notification_Email]
Data Type: string
Dimension: Fax
Role: Discrete Dimension
Remote Column: [Contacts].[Fax]
Data Type: string
Dimension: First Login
Role: Discrete Dimension
Remote Column: [Contacts].[First_Login]
Data Type: datetime
Dimension: First Name
Role: Discrete Dimension
Remote Column: [Contacts].[First_Name]
Data Type: string
Dimension: First and Last Name
Role: Discrete Dimension
Remote Column: [Contacts].[First_and_Last_Name]
Data Type: string
Dimension: Global Parent
Role: Discrete Dimension
Remote Column: [Contacts].[Global_Parent]
Data Type: string
Dimension: HAT Rating
Role: Discrete Dimension
Remote Column: [Contacts].[HAT_Rating]
Data Type: string
Dimension: High Touch?
Role: Discrete Dimension
Remote Column: [Contacts].[High_Touch]
Data Type: string
Dimension: Highest Stage
Role: Discrete Dimension
Remote Column: [Contacts].[Highest_Stage]
Data Type: string
Dimension: ID Number
Role: Discrete Dimension
Remote Column: [Contacts].[IDNumber]
Data Type: string
Dimension: Job Role
Role: Discrete Dimension
Remote Column: [Contacts].[Job_Role]
Data Type: string
Dimension: Keyword - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Keyword__Most_Recent]
Data Type: string
Dimension: Keyword - Original
Role: Discrete Dimension
Remote Column: [Contacts].[Keyword__Original]
Data Type: string
Dimension: Known User
Role: Discrete Dimension
Remote Column: [Contacts].[Known_User]
Data Type: string
Dimension: Language Site - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Language_Site__Most_Recent]
Data Type: string
Dimension: Last Campaign
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Campaign]
Data Type: string
Dimension: Last Email Received Date
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Email_Received_Date]
Data Type: datetime
Dimension: Last Form Submission
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Form_Submission]
Data Type: datetime
Dimension: Last Login
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Login]
Data Type: datetime
Dimension: Last Modified by CRM System
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Modified_by_CRM_System]
Data Type: datetime
Dimension: Last Name
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Name]
Data Type: string
Dimension: Last SFDC Campaign ID
Role: Discrete Dimension
Remote Column: [Contacts].[Last_SFDC_Campaign_ID]
Data Type: string
Dimension: Last SFDC Campaign Name
Role: Discrete Dimension
Remote Column: [Contacts].[Last_SFDC_Campaign_Name]
Data Type: string
Dimension: Last SFDC Campaign Status
Role: Discrete Dimension
Remote Column: [Contacts].[Last_SFDC_Campaign_Status]
Data Type: string
Dimension: Last Visit Date and Time
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Visit_Date_and_Time]
Data Type: string
Dimension: Last Website Visit Date and Time
Role: Discrete Dimension
Remote Column: [Contacts].[Last_Website_Visit_Date_and_Time]
Data Type: datetime
Dimension: Lead ID
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_ID]
Data Type: string
Dimension: Lead Owner ID
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Owner_ID]
Data Type: string
Dimension: Lead Rating - Historical All-Time (HAT)
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Rating__Historical_AllTime_HAT]
Data Type: string
Dimension: Lead Rating - Last (SPOI)
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Rating__Last_SPOI]
Data Type: string
Dimension: Lead Record Type
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Record_Type]
Data Type: string
Dimension: Lead Score (Contacts)
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Score_247]
Data Type: string
Dimension: Lead Score Date - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Score_Date__Most_Recent]
Data Type: datetime
Dimension: Lead Source Detail - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Source_Detail__Most_Recent]
Data Type: string
Dimension: Lead Source Detail - Original
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Source_Detail__Original]
Data Type: string
Dimension: Lead Source - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Source__Most_Recent]
Data Type: string
Dimension: Lead Source - Original
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Source__Original]
Data Type: string
Dimension: Lead Stage
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Stage]
Data Type: string
Dimension: Lead Status
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Status]
Data Type: string
Dimension: Lead Type
Role: Discrete Dimension
Remote Column: [Contacts].[Lead_Type]
Data Type: string
Dimension: License Key Offline Activation
Role: Discrete Dimension
Remote Column: [Contacts].[License_Key_Offline_Activation]
Data Type: string
Dimension: MD5 Hashed Business Phone
Role: Discrete Dimension
Remote Column: [Contacts].[MD5_Hashed_Business_Phone]
Data Type: string
Dimension: MD5 Hashed Email Address
Role: Discrete Dimension
Remote Column: [Contacts].[MD5_Hashed_Email_Address]
Data Type: string
Dimension: MD5 Hashed Mobile Phone
Role: Discrete Dimension
Remote Column: [Contacts].[MD5_Hashed_Mobile_Phone]
Data Type: string
Dimension: MSCRM Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[MSCRM_Contact_ID]
Data Type: string
Dimension: MSCRM Lead ID
Role: Discrete Dimension
Remote Column: [Contacts].[MSCRM_Lead_ID]
Data Type: string
Dimension: MSLA on File
Role: Discrete Dimension
Remote Column: [Contacts].[MSLA_on_File]
Data Type: string
Dimension: MS CRM Account ID
Role: Discrete Dimension
Remote Column: [Contacts].[MS_CRM_Account_ID]
Data Type: string
Dimension: Marketing Opt Out - For Harvested Names
Role: Discrete Dimension
Remote Column: [Contacts].[Marketing_Opt_Out__For_Harvested_Names]
Data Type: string
Dimension: Master Asset - temp
Role: Discrete Dimension
Remote Column: [Contacts].[Master_Asset__temp]
Data Type: string
Dimension: Microsoft Custom URL
Role: Discrete Dimension
Remote Column: [Contacts].[Microsoft_Custom_URL]
Data Type: string
Dimension: Mobile Phone
Role: Discrete Dimension
Remote Column: [Contacts].[Mobile_Phone]
Data Type: string
Dimension: NNC
Role: Discrete Dimension
Remote Column: [Contacts].[NNC]
Data Type: string
Dimension: Name Analyzer - Gender Results
Role: Discrete Dimension
Remote Column: [Contacts].[Name_Analyzer__Gender_Results]
Data Type: string
Dimension: Name Analyzer - Validation Results
Role: Discrete Dimension
Remote Column: [Contacts].[Name_Analyzer__Validation_Results]
Data Type: string
Dimension: NetSuite Company ID
Role: Discrete Dimension
Remote Column: [Contacts].[NetSuite_Company_ID]
Data Type: string
Dimension: NetSuite Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[NetSuite_Contact_ID]
Data Type: string
Dimension: NetSuite Lead ID
Role: Discrete Dimension
Remote Column: [Contacts].[NetSuite_Lead_ID]
Data Type: string
Dimension: No Promo
Role: Discrete Dimension
Remote Column: [Contacts].[No_Promo]
Data Type: string
Dimension: Nurture Track
Role: Discrete Dimension
Remote Column: [Contacts].[Nurture_Track]
Data Type: string
Dimension: Online Trial Exp Date - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Online_Trial_Exp_Date__Most_Recent]
Data Type: datetime
Dimension: Online Trial Start Date
Role: Discrete Dimension
Remote Column: [Contacts].[Online_Trial_Start_Date]
Data Type: datetime
Dimension: Opt-In
Role: Discrete Dimension
Remote Column: [Contacts].[OptIn]
Data Type: string
Dimension: Opt-in Date
Role: Discrete Dimension
Remote Column: [Contacts].[Optin_Date]
Data Type: datetime
Dimension: Owner
Role: Discrete Dimension
Remote Column: [Contacts].[Owner]
Data Type: string
Dimension: PURL Name (Try)
Role: Discrete Dimension
Remote Column: [Contacts].[PURL_Name_Try]
Data Type: string
Dimension: Parent Account
Role: Discrete Dimension
Remote Column: [Contacts].[Parent_Account]
Data Type: string
Dimension: Partner Agreement on File
Role: Discrete Dimension
Remote Column: [Contacts].[Partner_Agreement_on_File]
Data Type: string
Dimension: Partner Point of Contact
Role: Discrete Dimension
Remote Column: [Contacts].[Partner_Point_of_Contact]
Data Type: string
Dimension: Partner Program Type
Role: Discrete Dimension
Remote Column: [Contacts].[Partner_Program_Type]
Data Type: string
Dimension: Partner TSI Birthday
Role: Discrete Dimension
Remote Column: [Contacts].[Partner_TSI_Birthday]
Data Type: datetime
Dimension: Permission Date
Role: Discrete Dimension
Remote Column: [Contacts].[Permission_Date]
Data Type: datetime
Dimension: Permission Medium
Role: Discrete Dimension
Remote Column: [Contacts].[Permission_Medium]
Data Type: string
Dimension: Permission Source
Role: Discrete Dimension
Remote Column: [Contacts].[Permission_Source]
Data Type: string
Dimension: Platform
Role: Discrete Dimension
Remote Column: [Contacts].[Platform]
Data Type: string
Dimension: Preferred Language
Role: Discrete Dimension
Remote Column: [Contacts].[Preferred_Language]
Data Type: string
Dimension: Primed Date
Role: Discrete Dimension
Remote Column: [Contacts].[Primed_Date]
Data Type: datetime
Dimension: ProServ Opportunty ID
Role: Discrete Dimension
Remote Column: [Contacts].[ProServ_Opportunty_ID]
Data Type: string
Dimension: Processing Control
Role: Discrete Dimension
Remote Column: [Contacts].[Processing_Control]
Data Type: string
Dimension: Qualifying Date
Role: Discrete Dimension
Remote Column: [Contacts].[Qualifying_Date]
Data Type: datetime
Dimension: RBC - Trial Portal - TPEP - 2015-02-18
Role: Discrete Dimension
Remote Column: [Contacts].[RBC__Trial_Portal__TPEP__20150218]
Data Type: string
Dimension: Reason Primed - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Reason_Primed__Most_Recent]
Data Type: string
Dimension: Record Type
Role: Discrete Dimension
Remote Column: [Contacts].[Record_Type]
Data Type: string
Dimension: Referring Website
Role: Discrete Dimension
Remote Column: [Contacts].[Referring_Website]
Data Type: string
Dimension: Referr's Name
Role: Discrete Dimension
Remote Column: [Contacts].[Referrs_Name]
Data Type: string
Dimension: Remarket Date
Role: Discrete Dimension
Remote Column: [Contacts].[Remarket_Date]
Data Type: datetime
Dimension: Remarket Details
Role: Discrete Dimension
Remote Column: [Contacts].[Remarket_Details]
Data Type: string
Dimension: SFDC Account ID
Role: Discrete Dimension
Remote Column: [Contacts].[SFDCAccountID]
Data Type: string
Dimension: SFDC Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[SFDCContactID]
Data Type: string
Dimension: SFDC Lead ID
Role: Discrete Dimension
Remote Column: [Contacts].[SFDCLeadID]
Data Type: string
Dimension: SFDC Territory ID
Role: Discrete Dimension
Remote Column: [Contacts].[SFDCTerritoryID]
Data Type: string
Dimension: SFDC Date Created
Role: Discrete Dimension
Remote Column: [Contacts].[SFDC_Date_Created]
Data Type: datetime
Dimension: SFDC EmailOptOut
Role: Discrete Dimension
Remote Column: [Contacts].[SFDC_EmailOptOut]
Data Type: string
Dimension: SFDC Lead Rating
Role: Discrete Dimension
Remote Column: [Contacts].[SFDC_Lead_Rating]
Data Type: string
Dimension: SHA256 Hashed Business Phone
Role: Discrete Dimension
Remote Column: [Contacts].[SHA256_Hashed_Business_Phone]
Data Type: string
Dimension: SHA256 Hashed Email Address
Role: Discrete Dimension
Remote Column: [Contacts].[SHA256_Hashed_Email_Address]
Data Type: string
Dimension: SHA256 Hashed Mobile Phone
Role: Discrete Dimension
Remote Column: [Contacts].[SHA256_Hashed_Mobile_Phone]
Data Type: string
Dimension: SIC Code
Role: Discrete Dimension
Remote Column: [Contacts].[SIC_Code]
Data Type: string
Dimension: SalesLogix Account ID
Role: Discrete Dimension
Remote Column: [Contacts].[SalesLogix_Account_ID]
Data Type: string
Dimension: SalesLogix Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[SalesLogix_Contact_ID]
Data Type: string
Dimension: Salesnet Account ID
Role: Discrete Dimension
Remote Column: [Contacts].[SalesnetAccountID]
Data Type: string
Dimension: Salesnet Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[SalesnetContactID]
Data Type: string
Dimension: Salesnet OwnerID
Role: Discrete Dimension
Remote Column: [Contacts].[Salesnet_OwnerID]
Data Type: string
Dimension: Salesperson
Role: Discrete Dimension
Remote Column: [Contacts].[Salesperson]
Data Type: string
Dimension: Salesperson Email
Role: Discrete Dimension
Remote Column: [Contacts].[Salesperson_Email]
Data Type: string
Dimension: Salutation
Role: Discrete Dimension
Remote Column: [Contacts].[Salutation]
Data Type: string
Dimension: Sensitivity
Role: Discrete Dimension
Remote Column: [Contacts].[Sensitivity]
Data Type: string
Dimension: Server Trial End Date
Role: Discrete Dimension
Remote Column: [Contacts].[Server_Trial_End_Date]
Data Type: datetime
Dimension: Server Trial Type
Role: Discrete Dimension
Remote Column: [Contacts].[Server_Trial_Type]
Data Type: string
Dimension: Session
Role: Discrete Dimension
Remote Column: [Contacts].[Session]
Data Type: string
Dimension: SheerID Manual Verification
Role: Discrete Dimension
Remote Column: [Contacts].[SheerID_Manual_Verification]
Data Type: string
Dimension: Siebel OnDemand Account ID
Role: Discrete Dimension
Remote Column: [Contacts].[Siebel_OnDemand_Account_ID]
Data Type: string
Dimension: Siebel OnDemand Contact ID
Role: Discrete Dimension
Remote Column: [Contacts].[Siebel_OnDemand_Contact_ID]
Data Type: string
Dimension: Siebel OnDemand Lead ID
Role: Discrete Dimension
Remote Column: [Contacts].[Siebel_OnDemand_Lead_ID]
Data Type: string
Dimension: Slice Last Modified Date
Role: Discrete Dimension
Remote Column: [Contacts].[Slice_Last_Modified_Date]
Data Type: datetime
Dimension: Slice Prime Exclude
Role: Discrete Dimension
Remote Column: [Contacts].[Slice_Prime_Exclude]
Data Type: string
Dimension: Standard Form
Role: Discrete Dimension
Remote Column: [Contacts].[Standard_Form]
Data Type: string
Dimension: State or Province
Role: Discrete Dimension
Remote Column: [Contacts].[State_or_Province]
Data Type: string
Dimension: StrikeIron Country
Role: Discrete Dimension
Remote Column: [Contacts].[StrikeIron_Country]
Data Type: string
Dimension: Student Verification
Role: Discrete Dimension
Remote Column: [Contacts].[Student_Verification]
Data Type: string
Dimension: Student Verification ID
Role: Discrete Dimension
Remote Column: [Contacts].[Student_Verification_ID]
Data Type: string
Dimension: Student Verification Status
Role: Discrete Dimension
Remote Column: [Contacts].[Student_Verification_Status]
Data Type: string
Dimension: Subscription Page Link
Role: Discrete Dimension
Remote Column: [Contacts].[Subscription_Page_Link]
Data Type: string
Dimension: TAC
Role: Discrete Dimension
Remote Column: [Contacts].[TAC]
Data Type: string
Dimension: TAE
Role: Discrete Dimension
Remote Column: [Contacts].[TAE]
Data Type: string
Dimension: TC14 Confirmation Code - Attendees
Role: Discrete Dimension
Remote Column: [Contacts].[TC14_Confirmation_Code__Attendees]
Data Type: string
Dimension: TFT Course Expiration
Role: Discrete Dimension
Remote Column: [Contacts].[TFT_Course_Expiration]
Data Type: datetime
Dimension: TQL Date
Role: Discrete Dimension
Remote Column: [Contacts].[TQL_Date]
Data Type: datetime
Dimension: T-Shirt Size
Role: Discrete Dimension
Remote Column: [Contacts].[TShirt_Size]
Data Type: string
Dimension: Teleteam Date
Role: Discrete Dimension
Remote Column: [Contacts].[Teleteam_Date]
Data Type: datetime
Dimension: Territory
Role: Discrete Dimension
Remote Column: [Contacts].[Territory]
Data Type: string
Dimension: Title
Role: Discrete Dimension
Remote Column: [Contacts].[Title]
Data Type: string
Dimension: Total Pages
Role: Discrete Dimension
Remote Column: [Contacts].[Total_Pages]
Data Type: string
Dimension: Total Visits
Role: Discrete Dimension
Remote Column: [Contacts].[Total_Visits]
Data Type: string
Dimension: Trial Exp Date - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Trial_Exp_Date__Most_Recent]
Data Type: datetime
Dimension: Trial Product - Most Recent
Role: Discrete Dimension
Remote Column: [Contacts].[Trial_Product__Most_Recent]
Data Type: string
Dimension: Trial Request
Role: Discrete Dimension
Remote Column: [Contacts].[Trial_Request]
Data Type: string
Dimension: Trial Start Date
Role: Discrete Dimension
Remote Column: [Contacts].[Trial_Start_Date]
Data Type: datetime
Dimension: Viz ID
Role: Discrete Dimension
Remote Column: [Contacts].[Viz_ID]
Data Type: string
Dimension: Webinar ID
Role: Discrete Dimension
Remote Column: [Contacts].[Webinar_ID]
Data Type: string
Dimension: Website
Role: Discrete Dimension
Remote Column: [Contacts].[Website]
Data Type: string
Dimension: Why Remarket?
Role: Discrete Dimension
Remote Column: [Contacts].[Why_Remarket]
Data Type: string
Dimension: Zip or Postal Code
Role: Discrete Dimension
Remote Column: [Contacts].[Zip_or_Postal_Code]
Data Type: string
Dimension: Adgroup
Role: Discrete Dimension
Remote Column: [Contacts].[adgroup]
Data Type: string
Dimension: Db Country
Role: Discrete Dimension
Remote Column: [Contacts].[db_country]
Data Type: string
Dimension: Db Industry
Role: Discrete Dimension
Remote Column: [Contacts].[db_industry]
Data Type: string
Dimension: Db Sic
Role: Discrete Dimension
Remote Column: [Contacts].[db_sic]
Data Type: string
Dimension: Db State
Role: Discrete Dimension
Remote Column: [Contacts].[db_state]
Data Type: string
Dimension: Db Sub Industry
Role: Discrete Dimension
Remote Column: [Contacts].[db_sub_industry]
Data Type: string
Dimension: Db Title
Role: Discrete Dimension
Remote Column: [Contacts].[db_title]
Data Type: string
Dimension: Db Web Site
Role: Discrete Dimension
Remote Column: [Contacts].[db_web_site]
Data Type: string
Dimension: Db Zip
Role: Discrete Dimension
Remote Column: [Contacts].[db_zip]
Data Type: string
Dimension: Distribution
Role: Discrete Dimension
Remote Column: [Contacts].[distribution]
Data Type: string
Dimension: Email Notification
Role: Discrete Dimension
Remote Column: [Contacts].[email_notification]
Data Type: string
Dimension: Job Level
Role: Discrete Dimension
Remote Column: [Contacts].[job_level]
Data Type: string
Dimension: Referring Keyword
Role: Discrete Dimension
Remote Column: [Contacts].[referring_keyword]
Data Type: string
Dimension: Referring Source
Role: Discrete Dimension
Remote Column: [Contacts].[referring_source]
Data Type: string
Dimension: zzLead Score - TEST
Role: Discrete Dimension
Remote Column: [Contacts].[zzLead_Score__TEST]
Data Type: string
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
Contacts
Measure: Confidence Level
Role: Continous Measure
Remote Column: [Contacts].[Confidence_Level]
Data Type: real
Measure: D&B Annual Sales
Role: Continous Measure
Remote Column: [Contacts].[DB_Annual_Sales]
Data Type: real
Measure: D&B Total Employees
Role: Continous Measure
Remote Column: [Contacts].[DB_Total_Employees]
Data Type: real
Measure: Do Not Process
Role: Continous Measure
Remote Column: [Contacts].[Do_Not_Process]
Data Type: real
Measure: Eloqua Slice Score
Role: Continous Measure
Remote Column: [Contacts].[Eloqua_Slice_Score]
Data Type: real
Measure: Eloqua Slice Score - Enterprise
Role: Continous Measure
Remote Column: [Contacts].[Eloqua_Slice_Score__Enterprise]
Data Type: real
Measure: LS - High Value Website Content
Role: Continous Measure
Remote Column: [Contacts].[LS__High_Value_Website_Content]
Data Type: real
Measure: Lead Score
Role: Continous Measure
Remote Column: [Contacts].[Lead_Score]
Data Type: real
Measure: Lead Score - Historical All-Time (HAT)
Role: Continous Measure
Remote Column: [Contacts].[Lead_Score__Historical_AllTime_HAT]
Data Type: real
Measure: Lead Score - TEST
Role: Continous Measure
Remote Column: [Contacts].[Lead_Score__TEST]
Data Type: real
Measure: Open Grade
Role: Continous Measure
Remote Column: [Contacts].[Open_Grade]
Data Type: real
Measure: Slice Score
Role: Continous Measure
Remote Column: [Contacts].[Slice_Score]
Data Type: real
Measure: Slice Score - Enterprise
Role: Continous Measure
Remote Column: [Contacts].[Slice_Score__Enterprise]
Data Type: real
Measure: Trial Task Exclusion
Role: Continous Measure
Remote Column: [Contacts].[Trial_Task_Exclusion]
Data Type: real
Measure: Db Annual Sales
Role: Continous Measure
Remote Column: [Contacts].[db_annual_sales]
Data Type: real
Measure: Db Employee Count
Role: Continous Measure
Remote Column: [Contacts].[db_employee_count]
Data Type: real
Measure: Industry
Role: Continous Measure
Remote Column: [Contacts].[Industry]
Data Type: string
Aggregation: Count
Calculated/Other
Measure: Activies Total
Role: Continous Measure
Data Type: integer
Formula: // It is a COUNTD expression
// It returns the number of distinc activity IDs
COUNTD([ActivityId])
Measure: Contacts Total
Role: Continous Measure
Data Type: integer
Formula: // It is a COUNTD expression
// It returns the number of distinc contact IDs
COUNTD([ContactID])
Measure: Activities per Contact
Role: Continous Measure
Data Type: real
Formula: // It is an expression
// It calculates the number of activities per contact
COUNTD([ActivityId])/COUNTD([ContactId])
Measure: Total Web Visits
Role: Continous Measure
Data Type: integer
Formula: // It is a calculation combining a COUNTD expression and an IF statement
// It counts the IDs of all distinct activties marked as "webvisit"
COUNTD(IF [ActivityType]= "WebVisit"
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 Forms Submitted
Role: Continous Measure
Data Type: integer
Formula: // It is a calculation combining a COUNTD expression and an IF statement
// It counts the IDs of all distinct activties marked as "formsubmit"
COUNTD(IF [ActivityType]= "FormSubmit"
THEN [ActivityId]
END)
Measure: Total Page Views
Role: Continous Measure
Data Type: integer
Formula: // It is a calculation combining a COUNTD expression and an IF statement
// It counts the IDs of all distinct activties marked as "pageview"
COUNTD(IF [ActivityType]= "PageView"
THEN [ActivityId]
END)
Semantic Values
[Country].[Name]: "United States"
Dashboards
Dashboard: Account Engagement
Worksheets
Worksheet: Title
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Type]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityType]
Worksheet: Control Activity Type
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Type]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityType]
Worksheet: Summary
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activies Total]
[Activities per Contact]
[Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Contact Id]
[Contact ID]
[Contacts Total]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Activities - All].[ContactId]
[Contacts].[Company]
[Contacts].[ContactID]
[Contacts].[Industry]
Worksheet: Summary (2)
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Industry]
[Total Forms Submitted]
[Total Page Views]
[Total Web Visits]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[Industry]
Worksheet: Activities
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[Industry]
Worksheet: Contacts
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[First and Last Name]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[First_and_Last_Name]
[Contacts].[Industry]
Worksheet: Timeline of Activity
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[Industry]
Worksheet: Weekday
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[Industry]
Worksheet: Hour
Datasources: Oracle Eloqua
Used Dimensions & Measures: [Activity Date]
[Activity Id]
[Activity Type]
[Company]
[Industry]
Used Remote Columns: [Activities - All].[ActivityDate]
[Activities - All].[ActivityId]
[Activities - All].[ActivityType]
[Contacts].[Company]
[Contacts].[Industry]
Dashboard Objects:
Filter: [Oracle Eloqua].[Company]
Filter: [Oracle Eloqua].[Industry]
Filter: [Oracle Eloqua].[DAY(ActivityDate)]
Text: <Sheet Name>
Text: Accounts
Text: Contacts
Text: Company
Text: Total Activity
Text: % of Activity by Type
Text: Name
Text: Company
Text: Total Activity
Text: % Activity by Type
Worksheets
Worksheet: Activities
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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Marks
Mark: All
Type: Automatic
Tooltip: <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a company to filter dashboard and show related contacts
Mark: [Oracle Eloqua].[ActivityId]
Type: Automatic
Tooltip: <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a company to filter dashboard and show related contacts
Mark: [Oracle Eloqua].[ActivityId]
Type: Automatic
Tooltip: <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a company to filter dashboard and show related contacts
View
Rows: [Oracle Eloqua].[Company]
Columns: [Oracle Eloqua].[ActivityId]
[Oracle Eloqua].[ActivityId]
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
Styles
Style: axis
[Oracle Eloqua].[ActivityId]
auto-subtitle: true
auto-subtitle: true
Other
stroke-size: 4
line-pattern-only: solid
line-visibility: off
Style: cell
[Oracle Eloqua].[Company]
height: 26
Style: header
[Oracle Eloqua].[Company]
width: 222
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
stroke-size: 5
line-visibility: on
line-pattern-only: solid
cols
line-visibility: on
line-pattern-only: solid
stroke-size: 2
Style: zeroline
Other
stroke-color: #1b1b1b
stroke-size: 3
line-visibility: off
Style: table-div
cols
line-visibility: on
line-pattern-only: solid
stroke-size: 5
stroke-color: #f5f5f5
rows
stroke-size: 5
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
div-level: 1
Style: header-div
rows
stroke-size: 4
stroke-color: #f5f5f5
line-visibility: on
line-pattern-only: solid
cols
stroke-color: #f28e2b
line-pattern-only: solid
line-visibility: off
Style: quick-filter
Other
font-family: Tableau Regular
font-weight: normal
font-size: 8
Style: quick-filter-title
Other
font-family: Tableau Regular
font-weight: normal
font-size: 8
color: #555555
Worksheet: Contacts
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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: First and Last Name
Remote Column: [Contacts].[First_and_Last_Name]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Marks
Mark: All
Type: Automatic
Tooltip: <[Oracle Eloqua].[First_and_Last_Name]> | <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a campaign to show related contacts
Mark: [Oracle Eloqua].[ActivityId]
Type: Automatic
Tooltip: <[Oracle Eloqua].[First_and_Last_Name]> | <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a campaign to show related contacts
Mark: [Oracle Eloqua].[ActivityId]
Type: Automatic
Tooltip: <[Oracle Eloqua].[First_and_Last_Name]> | <[Oracle Eloqua].[Company]>
<[Oracle Eloqua].[ActivityType]>: <[Oracle Eloqua].[ActivityId]>
Activities: <[Oracle Eloqua].[ActivityId]>
Click a campaign to show related contacts
View
Rows: [Oracle Eloqua].[First_and_Last_Name]
[Oracle Eloqua].[Company]
Columns: [Oracle Eloqua].[ActivityId]
[Oracle Eloqua].[ActivityId]
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: axis
[Oracle Eloqua].[ActivityId]
auto-subtitle: true
auto-subtitle: true
Other
stroke-size: 4
line-pattern-only: solid
line-visibility: off
Style: cell
[Oracle Eloqua].[Company]
height: 26
height: 26
Style: header
[Oracle Eloqua].[Company]
width: 224
width: 176
[Oracle Eloqua].[First_and_Last_Name]
width: 152
Style: label
[Oracle Eloqua].[ActivityId]
text-format: p0%
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
stroke-size: 5
line-visibility: on
line-pattern-only: solid
cols
stroke-size: 2
line-visibility: on
line-pattern-only: solid
Style: zeroline
Other
stroke-color: #1b1b1b
stroke-size: 3
line-visibility: off
Style: table-div
cols
line-visibility: on
line-pattern-only: solid
stroke-size: 5
stroke-color: #f5f5f5
rows
stroke-size: 5
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
Style: header-div
cols
line-visibility: off
rows
stroke-color: #f5f5f5
line-visibility: on
line-pattern-only: solid
Worksheet: Control Activity Type
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Marks
Mark: All
Type: Shape
Label: <[Oracle Eloqua].[ActivityType]>
Tooltip: Click to filter dashboard | Show only <[Oracle Eloqua].[ActivityType]> activity
View
Columns: [Oracle Eloqua].[ActivityType]
Filters: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[ActivityType] ASC
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: label
[Oracle Eloqua].[ActivityType]
display: false
Style: table
Other
background-color: #00000000
Style: worksheet
cols
display-field-labels: false
Style: table-div
rows
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Style: quick-filter
[Oracle Eloqua].[DAY(ActivityDate)]
title: Day of Activity Date
Style: quick-filter-title
Other
font-family: Tableau Regular
font-size: 8
Worksheet: 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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Marks
Mark: All
Type: Bar
Tooltip: <[Oracle Eloqua].[HOUR(ActivityDate)]>h
Activity Type: <[Oracle Eloqua].[ActivityType]>
Number of Activities: <[Oracle Eloqua].[ActivityId]>
View
Rows: [Oracle Eloqua].[ActivityId]
Columns: [Oracle Eloqua].[HOUR(ActivityDate)]
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: axis
[Oracle Eloqua].[ActivityId]
auto-subtitle: true
[Oracle Eloqua].[HOUR(ActivityDate)]
height: 22
cols
stroke-size: 4
rows
line-visibility: off
Style: label
[Oracle Eloqua].[HOUR(ActivityDate)]
text-orientation: 0
font-weight: normal
font-size: 9
Style: worksheet
cols
display-field-labels: false
Style: gridline
Other
stroke-size: 3
line-visibility: on
line-pattern-only: solid
cols
line-visibility: off
Style: table-div
rows
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Sheet 1
Visible: No
Marks
Mark: All
Type: Automatic
View
Worksheet: Summary
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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Contact ID
Remote Column: [Contacts].[ContactID]
Discrete Dimension: Contact Id
Remote Column: [Activities - All].[ContactId]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Continous Measure: Activies Total
Continous Measure: Contacts Total
Continous Measure: Activities per Contact
Marks
Mark: All
Type: Automatic
Label: <[Oracle Eloqua].[Multiple Values]>
View
Columns: [Oracle Eloqua].[Measure Names()]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: cell
[Oracle Eloqua].[Multiple Values]
text-format: *#,##0.00;-#,##0.00
Style: header
[Oracle Eloqua].[Measure Names()]
height: 46
background-color: #f2f2f3
Style: label
[Oracle Eloqua].[Measure Names()]
font-family: Tableau Regular
color: #333333
font-size: 9
Style: pane
Other
border-style: none
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
stroke-color: #fb1b3c
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
div-level: 1
Style: header-div
cols
stroke-size: 5
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff
Style: title
Other
background-color: #eef1f3
Worksheet: Summary (2)
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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Continous Measure: Total Web Visits
Continous Measure: Total Forms Submitted
Continous Measure: Total Page Views
Marks
Mark: All
Type: Automatic
Label: <[Oracle Eloqua].[Multiple Values]>
View
Columns: [Oracle Eloqua].[Measure Names()]
Filters: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Manual Sorting: [Oracle Eloqua].[Measure Names()] ASC
Slices: [Oracle Eloqua].[Measure Names()]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: header
[Oracle Eloqua].[Measure Names()]
height: 46
background-color: #f2f2f3
Other
width-header: 10
Style: label
[Oracle Eloqua].[Measure Names()]
font-family: Tableau Regular
color: #333333
font-size: 9
Style: pane
Other
border-style: none
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
stroke-color: #fb1b3c
line-visibility: off
Style: table-div
rows
line-visibility: off
cols
div-level: 1
Style: header-div
cols
stroke-size: 5
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff
Style: title
Other
background-color: #eef1f3
Worksheet: Timeline of Activity
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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Marks
Mark: All
Type: Bar
Tooltip: <[Oracle Eloqua].[HOUR(ActivityDate)]>h
Activity Type: <[Oracle Eloqua].[ActivityType]>
Number of Activities: <[Oracle Eloqua].[ActivityId]>
View
Rows: [Oracle Eloqua].[ActivityId]
Columns: [Oracle Eloqua].[HOUR(ActivityDate)]
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: axis
[Oracle Eloqua].[HOUR(ActivityDate)]
auto-subtitle: true
height: 25
[Oracle Eloqua].[ActivityId]
auto-subtitle: true
cols
stroke-size: 4
rows
line-visibility: off
Style: label
[Oracle Eloqua].[HOUR(ActivityDate)]
font-size: 9
Style: gridline
Other
stroke-size: 3
line-visibility: on
line-pattern-only: solid
cols
line-visibility: off
Style: table-div
rows
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Title
Visible: No
Used Datasources
Datasource: Oracle Eloqua
Discrete Dimension: Activity Date
Remote Column: [Activities - All].[ActivityDate]
Discrete Dimension: Activity Type
Remote Column: [Activities - All].[ActivityType]
Marks
Mark: All
Type: Automatic
Label: <[Oracle Eloqua].[ActivityType]>
View
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: table
Other
background-color: #f2f2f3
Worksheet: 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: Company
Remote Column: [Contacts].[Company]
Discrete Dimension: Industry
Remote Column: [Contacts].[Industry]
Marks
Mark: All
Type: Bar
Tooltip: Day: <[Oracle Eloqua].[WEEKDAY(ActivityDate)]>
Activity Type: <[Oracle Eloqua].[ActivityType]>
Number of Activities: <[Oracle Eloqua].[ActivityId]>
View
Rows: [Oracle Eloqua].[ActivityId]
Columns: [Oracle Eloqua].[WEEKDAY(ActivityDate)]
Filters: [Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[DAY(ActivityDate)]
Slices: [Oracle Eloqua].[ActivityType]
[Oracle Eloqua].[ActivityDate]
[Oracle Eloqua].[Company]
[Oracle Eloqua].[Industry]
[Oracle Eloqua].[Action (Activity Type)]
[Oracle Eloqua].[Action (Company Name)]
[Oracle Eloqua].[Action (Company)]
[Oracle Eloqua].[DAY(ActivityDate)]
Styles
Style: axis
[Oracle Eloqua].[ActivityId]
auto-subtitle: true
[Oracle Eloqua].[WEEKDAY(ActivityDate)]
height: 22
cols
stroke-size: 4
rows
line-visibility: off
Style: label
[Oracle Eloqua].[WEEKDAY(ActivityDate)]
text-format: ieeeee
text-orientation: 0
font-size: 9
Style: worksheet
cols
display-field-labels: false
Style: gridline
Other
stroke-size: 3
line-visibility: on
line-pattern-only: solid
cols
line-visibility: off
Style: table-div
rows
stroke-size: 3
line-pattern-only: solid
line-visibility: off
Style: title
Other
background-color: #f2f2f3