****************************************************************************************************
Location : Tableau Server
Host     : http://bnbrepository9/#/
Path     : Tableau Samples/Web Engagement Samples
****************************************************************************************************

-------------------------------------------------- Datasource Engagement --------------------------------------------------

-- Query(s)

SELECT 
	[Leads].[Company_Name],
	[Leads].[Site],
	[Leads].[Billing_Address],
	[Leads].[Billing_City],
	[Leads].[Billing_State],
	[Leads].[Billing_Country],
	[Leads].[Billing_Postal_Code],
	[Leads].[Website],
	[Leads].[Main_Phone],
	[Leads].[Annual_Revenue],
	[Leads].[Num_Employees],
	[Leads].[Industry],
	[Leads].[SIC_Code],
	[Leads].[Company_Notes],
	[Leads].[SFDC_Account_Id],
	[Leads].[External_Company_Id],
	[Leads].[Id],
	[Leads].[Full_Name],
	[Leads].[Person_Type],
	[Leads].[Is_Partner],
	[Leads].[Is_Lead],
	[Leads].[Is_Customer],
	[Leads].[Is_Anonymous],
	[Leads].[Salutation],
	[Leads].[First_Name],
	[Leads].[Middle_Name],
	[Leads].[Last_Name],
	[Leads].[Email_Address],
	[Leads].[Phone_Number],
	[Leads].[Mobile_Phone_Number],
	[Leads].[Fax_Number],
	[Leads].[Job_Title],
	[Leads].[Contact_Company],
	[Leads].[Date_of_Birth],
	[Leads].[Address],
	[Leads].[City],
	[Leads].[State],
	[Leads].[Country],
	[Leads].[Postal_Code],
	[Leads].[Original_Source_Type],
	[Leads].[Original_Source_Info],
	[Leads].[Registration_Source_Type],
	[Leads].[Registration_Source_Info],
	[Leads].[Original_Search_Engine],
	[Leads].[Original_Search_Phrase],
	[Leads].[Original_Referrer],
	[Leads].[Email_Invalid],
	[Leads].[Email_Invalid_Cause],
	[Leads].[Unsubscribed],
	[Leads].[Unsubscribed_Reason],
	[Leads].[Do_Not_Call],
	[Leads].[Do_Not_Call_Cause],
	[Leads].[Do_Not_Call_Reason],
	[Leads].[Person_Notes],
	[Leads].[SFDC_Type],
	[Leads].[SFDC_Contact_Id],
	[Leads].[Anonymous_IP],
	[Leads].[Inferred_Company],
	[Leads].[Inferred_Country],
	[Leads].[Inferred_City],
	[Leads].[Inferred_State_Region],
	[Leads].[Inferred_Postal_Code],
	[Leads].[Inferred_Metropolitan_Area],
	[Leads].[Inferred_Phone_Area_Code],
	[Leads].[Department],
	[Leads].[SFDC_Id],
	[Leads].[Created_At],
	[Leads].[Updated_At],
	[Leads].[Cookies],
	[Leads].[External_Sales_Person_Id],
	[Leads].[Lead_Person],
	[Leads].[Role],
	[Leads].[Lead_Source],
	[Leads].[Lead_Status],
	[Leads].[Lead_Score],
	[Leads].[Urgency],
	[Leads].[Priority],
	[Leads].[Relative_Score],
	[Leads].[Relative_Urgency],
	[Leads].[Lead_Rating],
	[Leads].[SFDC_Lead_Id],
	[Leads].[SFDC_Lead_Owner_Id],
	[Leads].[Primary_Lead_Interest],
	[Leads].[Lead_Partition],
	[Leads].[Lead_Revenue_Cycle_Model_ID],
	[Leads].[Lead_Revenue_Stage_ID],
	[Leads].[Marketo_Social_Gender],
	[Leads].[Marketo_Social_Facebook_Display_Name],
	[Leads].[Marketo_Social_Twitter_Display_Name],
	[Leads].[Marketo_Social_LinkedIn_Display_Name],
	[Leads].[Marketo_Social_Facebook_Profile_URL],
	[Leads].[Marketo_Social_Twitter_Profile_URL],
	[Leads].[Marketo_Social_LinkedIn_Profile_URL],
	[Leads].[Marketo_Social_Facebook_Photo_URL],
	[Leads].[Marketo_Social_Twitter_Photo_URL],
	[Leads].[Marketo_Social_LinkedIn_Photo_URL],
	[Leads].[Marketo_Social_Facebook_Reach],
	[Leads].[Marketo_Social_Twitter_Reach],
	[Leads].[Marketo_Social_LinkedIn_Reach],
	[Leads].[Marketo_Social_Facebook_Referred_Visits],
	[Leads].[Marketo_Social_Twitter_Referred_Visits],
	[Leads].[Marketo_Social_LinkedIn_Referred_Visits],
	[Leads].[Marketo_Social_Total_Referred_Visits],
	[Leads].[Marketo_Social_Facebook_Referred_Enrollments],
	[Leads].[Marketo_Social_Twitter_Referred_Enrollments],
	[Leads].[Marketo_Social_LinkedIn_Referred_Enrollments],
	[Leads].[Marketo_Social_Total_Referred_Enrollments],
	[Leads].[Marketo_Social_Last_Referred_Visit],
	[Leads].[Marketo_Social_Last_Referred_Enrollment],
	[Leads].[Marketo_Social_Syndication_Id],
	[Leads].[Marketo_Social_Facebook_Id],
	[Leads].[Marketo_Social_Twitter_Id],
	[Leads].[Marketo_Social_LinkedIn_Id],
	[Leads].[Acquisition_Program],
	[Leads].[Acquisition_Date],
	[Leads].[Email_Bounced_Reason],
	[Leads].[Email_Bounced_Date],
	[Leads].[SIC_Code_L],
	[Leads].[Product_Interest],
	[Leads].[Primary],
	[Leads].[Current_Generators],
	[Leads].[Number_of_Locations],
	[Leads].[Customer_Priority],
	[Leads].[SLA],
	[Leads].[Active],
	[Leads].[Number_of_Locations_A],
	[Leads].[Upsell_Opportunity],
	[Leads].[SLA_Serial_Number],
	[Leads].[SLA_Expiration_Date],
	[Leads].[Level],
	[Leads].[Languages],
	[Leads].[column_131],
	[Leads].[lucha_boolean_field],
	[Leads].[Person_Time_Zone],
	[Leads].[Latitude],
	[Leads].[Longitude],
	[Leads].[Geocode_Accuracy],
	[Leads].[Address_L],
	[Leads].[Photo_URL],
	[Leads].[Last_Viewed_Date],
	[Leads].[Last_Referenced_Date],
	[Leads].[Datacom_Key],
	[Leads].[Jigsaw_Contact_ID],
	[Leads].[Clean_Status],
	[Leads].[Company_DUNS_Number],
	[Leads].[DB_Company_ID],
	[Leads].[Billing_Latitude],
	[Leads].[Billing_Longitude],
	[Leads].[Billing_Geocode_Accuracy],
	[Leads].[Billing_Address_A],
	[Leads].[Shipping_Latitude],
	[Leads].[Shipping_Longitude],
	[Leads].[Shipping_Geocode_Accuracy],
	[Leads].[Shipping_Address],
	[Leads].[Photo_URL_A],
	[Leads].[Last_Viewed_Date_A],
	[Leads].[Last_Referenced_Date_A],
	[Leads].[Datacom_Key_A],
	[Leads].[Jigsaw_Company_ID],
	[Leads].[Clean_Status_A],
	[Leads].[Account_Source],
	[Leads].[DUNS_Number],
	[Leads].[Tradestyle],
	[Leads].[NAICS_Code],
	[Leads].[NAICS_Description],
	[Leads].[Year_Started],
	[Leads].[SIC_Description],
	[Leads].[DB_Company_ID_A],
	[Leads].[Other_Latitude],
	[Leads].[Other_Longitude],
	[Leads].[Other_Geocode_Accuracy],
	[Leads].[Other_Address],
	[Leads].[Mailing_Latitude],
	[Leads].[Mailing_Longitude],
	[Leads].[Mailing_Geocode_Accuracy],
	[Leads].[Mailing_Address],
	[Leads].[Is_Email_Bounced]
FROM
	[leadsTable] AS [Leads]

SELECT 
	[Activity - Fill Out Form].[id],
	[Activity - Fill Out Form].[Webform_ID],
	[Activity - Fill Out Form].[Client_IP_Address],
	[Activity - Fill Out Form].[Form_Fields],
	[Activity - Fill Out Form].[Query_Parameters],
	[Activity - Fill Out Form].[Referrer_URL],
	[Activity - Fill Out Form].[User_Agent],
	[Activity - Fill Out Form].[Webpage_ID],
	[Activity - Fill Out Form].[Lead_ID],
	[Activity - Fill Out Form].[Campaign_ID],
	[Activity - Fill Out Form].[Activity_Date]
FROM
	[activity2] AS [Activity - Fill Out Form]

SELECT 
	[Activity - Visit Webpage].[id] AS [id (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Webpage_ID] AS [Webpage_ID (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Client_IP_Address] AS [Client_IP_Address (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Query_Parameters] AS [Query_Parameters (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Referrer_URL] AS [Referrer_URL (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Search_Engine],
	[Activity - Visit Webpage].[Search_Query],
	[Activity - Visit Webpage].[User_Agent] AS [User_Agent (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Webpage_URL],
	[Activity - Visit Webpage].[Lead_ID] AS [Lead_ID (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Campaign_ID] AS [Campaign_ID (Activity - Visit Webpage)],
	[Activity - Visit Webpage].[Activity_Date] AS [Activity_Date (Activity - Visit Webpage)]
FROM
	[activity1] AS [Activity - Visit Webpage]

SELECT 
	[Activity - Click Link].[id] AS [id (Activity - Click Link)],
	[Activity - Click Link].[Link_ID],
	[Activity - Click Link].[Client_IP_Address] AS [Client_IP_Address (Activity - Click Link)],
	[Activity - Click Link].[Query_Parameters] AS [Query_Parameters (Activity - Click Link)],
	[Activity - Click Link].[Referrer_URL] AS [Referrer_URL (Activity - Click Link)],
	[Activity - Click Link].[User_Agent] AS [User_Agent (Activity - Click Link)],
	[Activity - Click Link].[Webpage_ID] AS [Webpage_ID (Activity - Click Link)],
	[Activity - Click Link].[Lead_ID] AS [Lead_ID (Activity - Click Link)],
	[Activity - Click Link].[Campaign_ID] AS [Campaign_ID (Activity - Click Link)],
	[Activity - Click Link].[Activity_Date] AS [Activity_Date (Activity - Click Link)]
FROM
	[activity3] AS [Activity - Click Link]