**************************************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Oracle Account Engagement **************************************************************************************************** -------------------------------------------------- Datasource Oracle Eloqua -------------------------------------------------- -- Query(s) SELECT [Activities - All].[ActivityId], [Activities - All].[ActivityType], [Activities - All].[ActivityDate], [Activities - All].[EmailAddress], [Activities - All].[ContactId], [Activities - All].[EmailRecipientId], [Activities - All].[AssetType], [Activities - All].[AssetId], [Activities - All].[AssetName], [Activities - All].[SubjectLine], [Activities - All].[EmailWebLink], [Activities - All].[CampaignId], [Activities - All].[ExternalId], [Activities - All].[DeploymentId], [Activities - All].[EmailSendType], [Activities - All].[VisitorId], [Activities - All].[VisitorExternalId], [Activities - All].[ReferrerUrl], [Activities - All].[IpAddress], [Activities - All].[NumberOfPages], [Activities - All].[FirstPageViewUrl], [Activities - All].[Duration], [Activities - All].[WebVisitId], [Activities - All].[Url], [Activities - All].[IsWebTrackingOptedIn], [Activities - All].[RawData], [Activities - All].[EmailClickedThruLink] FROM [activitiesAll] AS [Activities - All] SELECT [Contacts].[ContactID], [Contacts].[Eloqua_Contact_ID], [Contacts].[Email_Address], [Contacts].[First_Name], [Contacts].[Last_Name], [Contacts].[Company], [Contacts].[Email_Display_Name], [Contacts].[Address_1], [Contacts].[Address_2], [Contacts].[Address_3], [Contacts].[City], [Contacts].[State_or_Province], [Contacts].[Zip_or_Postal_Code], [Contacts].[Country], [Contacts].[Business_Phone], [Contacts].[Mobile_Phone], [Contacts].[Fax], [Contacts].[Title], [Contacts].[Salutation], [Contacts].[Owner], [Contacts].[IDNumber], [Contacts].[Sensitivity], [Contacts].[Salesperson], [Contacts].[SFDCContactID], [Contacts].[SFDCLeadID], [Contacts].[Website], [Contacts].[Date_Created], [Contacts].[Date_Modified], [Contacts].[SalesnetContactID], [Contacts].[SalesnetAccountID], [Contacts].[Permission_Source], [Contacts].[Permission_Medium], [Contacts].[Permission_Date], [Contacts].[SFDCAccountID], [Contacts].[Salesnet_OwnerID], [Contacts].[Last_Modified_by_CRM_System], [Contacts].[Last_SFDC_Campaign_ID], [Contacts].[Last_SFDC_Campaign_Status], [Contacts].[Last_SFDC_Campaign_Name], [Contacts].[Lead_Rating__Last_SPOI], [Contacts].[Trial_Task_Exclusion], [Contacts].[Lead_Score__Historical_AllTime_HAT], [Contacts].[Lead_Rating__Historical_AllTime_HAT], [Contacts].[Company_Revenue], [Contacts].[Buying_Horizon], [Contacts].[SFDC_EmailOptOut], [Contacts].[MSCRM_Contact_ID], [Contacts].[MSCRM_Lead_ID], [Contacts].[Siebel_OnDemand_Contact_ID], [Contacts].[Siebel_OnDemand_Lead_ID], [Contacts].[SalesLogix_Contact_ID], [Contacts].[Lead_Source__Most_Recent], [Contacts].[Lead_Source__Original], [Contacts].[Industry], [Contacts].[Annual_Revenue], [Contacts].[Lead_Status], [Contacts].[SFDC_Lead_Rating], [Contacts].[Siebel_OnDemand_Account_ID], [Contacts].[SalesLogix_Account_ID], [Contacts].[MS_CRM_Account_ID], [Contacts].[Job_Role], [Contacts].[Last_Website_Visit_Date_and_Time], [Contacts].[LS__High_Value_Website_Content], [Contacts].[NetSuite_Contact_ID], [Contacts].[NetSuite_Lead_ID], [Contacts].[NetSuite_Company_ID], [Contacts].[Confidence_Level], [Contacts].[DB_DUNS_Number], [Contacts].[DB_Doing_Business_As], [Contacts].[DB_CEO_Name], [Contacts].[DB_Industry], [Contacts].[DB_SIC_Code], [Contacts].[DB_Established_In], [Contacts].[DB_Annual_Sales_Indicator], [Contacts].[DB_Annual_Sales], [Contacts].[DB_Total_Employees], [Contacts].[DB_Total_Employees_Indicator], [Contacts].[StrikeIron_Country], [Contacts].[DB_Business_Structure], [Contacts].[Lead_Score_Date__Most_Recent], [Contacts].[Dept], [Contacts].[HAT_Rating], [Contacts].[TShirt_Size], [Contacts].[NNC], [Contacts].[Keyword__Original], [Contacts].[Why_Remarket], [Contacts].[High_Touch], [Contacts].[First_Login], [Contacts].[Last_Login], [Contacts].[Trial_Request], [Contacts].[Trial_Start_Date], [Contacts].[Trial_Exp_Date__Most_Recent], [Contacts].[Server_Trial_Type], [Contacts].[Server_Trial_End_Date], [Contacts].[email_notification], [Contacts].[Last_Campaign], [Contacts].[Remarket_Date], [Contacts].[Account_Contact_Role], [Contacts].[Customer], [Contacts].[Authorized_User_Check_on_Contact], [Contacts].[ESD_Access_on_Contact], [Contacts].[No_Promo], [Contacts].[Lead_Source_Detail__Original], [Contacts].[Lead_Source_Detail__Most_Recent], [Contacts].[Department], [Contacts].[Parent_Account], [Contacts].[TAC], [Contacts].[TAE], [Contacts].[Lead_Type], [Contacts].[Company_Size], [Contacts].[SIC_Code], [Contacts].[Lead_Owner_ID], [Contacts].[Lead_ID], [Contacts].[Keyword__Most_Recent], [Contacts].[PURL_Name_Try], [Contacts].[Eloqua_Program], [Contacts].[Partner_Agreement_on_File], [Contacts].[MSLA_on_File], [Contacts].[Global_Parent], [Contacts].[Account_Owner], [Contacts].[Adused], [Contacts].[Campaign_ID__Most_Recent], [Contacts].[Campaign_ID__Original], [Contacts].[Trial_Product__Most_Recent], [Contacts].[Evaluation_Team_Size], [Contacts].[Analysis_Software_Used], [Contacts].[Analysis_Types], [Contacts].[Eloqua_GUID], [Contacts].[Standard_Form], [Contacts].[Account_User_Name], [Contacts].[Account_Password], [Contacts].[Total_Pages], [Contacts].[Total_Visits], [Contacts].[Last_Visit_Date_and_Time], [Contacts].[Buy_Registration_Date__Most_Recent], [Contacts].[Marketing_Opt_Out__For_Harvested_Names], [Contacts].[Comment__Most_Recent], [Contacts].[Referring_Website], [Contacts].[Viz_ID], [Contacts].[Email_Address_Domain], [Contacts].[First_and_Last_Name], [Contacts].[Microsoft_Custom_URL], [Contacts].[License_Key_Offline_Activation], [Contacts].[Lead_Score], [Contacts].[Primed_Date], [Contacts].[Contacting_Date], [Contacts].[Remarket_Details], [Contacts].[Lead_Stage], [Contacts].[adgroup], [Contacts].[distribution], [Contacts].[Qualifying_Date], [Contacts].[job_level], [Contacts].[referring_keyword], [Contacts].[referring_source], [Contacts].[db_industry], [Contacts].[db_sub_industry], [Contacts].[db_employee_count], [Contacts].[db_annual_sales], [Contacts].[db_sic], [Contacts].[db_web_site], [Contacts].[db_title], [Contacts].[db_state], [Contacts].[db_country], [Contacts].[Nurture_Track], [Contacts].[Account_Partner_Program_Type], [Contacts].[Account_Partner_Agreement_Status], [Contacts].[Appointment], [Contacts].[Data_Geek_Profile], [Contacts].[Salesperson_Email], [Contacts].[Language_Site__Most_Recent], [Contacts].[Deleted_Lead_Date], [Contacts].[Deleted_Contact_Date], [Contacts].[Contact_Us_Request_Type], [Contacts].[Comment_1], [Contacts].[Comment_2], [Contacts].[Comment_3], [Contacts].[Name_Analyzer__Validation_Results], [Contacts].[Name_Analyzer__Gender_Results], [Contacts].[db_zip], [Contacts].[Territory], [Contacts].[Last_Email_Received_Date], [Contacts].[Contact_Owner_ID], [Contacts].[Preferred_Language], [Contacts].[TFT_Course_Expiration], [Contacts].[Student_Verification], [Contacts].[Student_Verification_Status], [Contacts].[Student_Verification_ID], [Contacts].[Session], [Contacts].[SheerID_Manual_Verification], [Contacts].[Slice_Score], [Contacts].[Slice_Last_Modified_Date], [Contacts].[Do_Not_Process], [Contacts].[Asset], [Contacts].[Online_Trial_Start_Date], [Contacts].[Online_Trial_Exp_Date__Most_Recent], [Contacts].[Record_Type], [Contacts].[Webinar_ID], [Contacts].[Author_Profiles__URL], [Contacts].[Master_Asset__temp], [Contacts].[Referrs_Name], [Contacts].[Slice_Prime_Exclude], [Contacts].[Device], [Contacts].[ProServ_Opportunty_ID], [Contacts].[Account_Type], [Contacts].[SFDCTerritoryID], [Contacts].[Lead_Record_Type], [Contacts].[Channel_Manager], [Contacts].[Browser_Language__Most_Recent], [Contacts].[Area_Of_Interest], [Contacts].[Partner_Point_of_Contact], [Contacts].[Partner_TSI_Birthday], [Contacts].[Channel_Manager_Email], [Contacts].[Partner_Program_Type], [Contacts].[Platform], [Contacts].[OptIn], [Contacts].[Optin_Date], [Contacts].[Eloqua_Slice_Hash], [Contacts].[Eloqua_Slice_Modified_Date], [Contacts].[Eloqua_Slice_Score], [Contacts].[External_Notification_Email], [Contacts].[Processing_Control], [Contacts].[Highest_Stage], [Contacts].[Last_Form_Submission], [Contacts].[MD5_Hashed_Email_Address], [Contacts].[SHA256_Hashed_Email_Address], [Contacts].[MD5_Hashed_Business_Phone], [Contacts].[SHA256_Hashed_Business_Phone], [Contacts].[MD5_Hashed_Mobile_Phone], [Contacts].[SHA256_Hashed_Mobile_Phone], [Contacts].[TC14_Confirmation_Code__Attendees], [Contacts].[BrightTALK_User_ID], [Contacts].[zzLead_Score__TEST], [Contacts].[Slice_Score__Enterprise], [Contacts].[Lead_Score__TEST], [Contacts].[Eloqua_Slice_Score__Enterprise], [Contacts].[Known_User], [Contacts].[Reason_Primed__Most_Recent], [Contacts].[CIBC__Trial_Portal__TPEP__20150218], [Contacts].[RBC__Trial_Portal__TPEP__20150218], [Contacts].[Subscription_Page_Link], [Contacts].[SFDC_Date_Created], [Contacts].[Open_Grade], [Contacts].[Create_Lead_Hold], [Contacts].[Bizo_ID], [Contacts].[AWS_AccountID], [Contacts].[Customer_Date], [Contacts].[Teleteam_Date], [Contacts].[TQL_Date], [Contacts].[Lead_Score_247] FROM [contacts] AS [Contacts]