**************************************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Sales Force Marketing Leads **************************************************************************************************** -------------------------------------------------- Datasource login.salesforce.com -------------------------------------------------- -- Query(s) SELECT [Leads].[Id] AS [Lead ID], [Leads].[IsDeleted] AS [Deleted], [Leads].[MasterRecordId] AS [Master Record ID], [Leads].[LastName] AS [Last Name], [Leads].[FirstName] AS [First Name], [Leads].[Salutation], [Leads].[Name] AS [Full Name], [Leads].[Title], [Leads].[Company], [Leads].[Street], [Leads].[City], [Leads].[State] AS [State/Province], [Leads].[PostalCode] AS [Zip/Postal Code], [Leads].[Country], [Leads].[Latitude], [Leads].[Longitude], [Leads].[Phone], [Leads].[MobilePhone] AS [Mobile Phone], [Leads].[Fax] AS [Fax (Leads)], [Leads].[Email], [Leads].[Website], [Leads].[PhotoUrl] AS [Photo URL], [Leads].[LeadSource] AS [Lead Source], [Leads].[Status], [Leads].[Industry], [Leads].[Rating], [Leads].[AnnualRevenue] AS [Annual Revenue], [Leads].[NumberOfEmployees] AS [Employees], [Leads].[OwnerId] AS [Owner ID], [Leads].[IsConverted] AS [Converted], [Leads].[ConvertedDate] AS [Converted Date], [Leads].[ConvertedAccountId] AS [Converted Account ID], [Leads].[ConvertedContactId] AS [Converted Contact ID], [Leads].[ConvertedOpportunityId] AS [Converted Opportunity ID], [Leads].[IsUnreadByOwner] AS [Unread By Owner], [Leads].[CreatedDate] AS [Created Date], [Leads].[CreatedById] AS [Created By ID], [Leads].[LastModifiedDate] AS [Last Modified Date], [Leads].[LastModifiedById] AS [Last Modified By ID], [Leads].[SystemModstamp] AS [System Modstamp], [Leads].[LastActivityDate] AS [Last Activity], [Leads].[LastViewedDate] AS [Last Viewed Date], [Leads].[LastReferencedDate] AS [Last Referenced Date], [Leads].[Jigsaw] AS [Data.com Key], [Leads].[JigsawContactId] AS [Jigsaw Contact ID], [Leads].[CleanStatus] AS [Clean Status], [Leads].[CompanyDunsNumber] AS [Company D-U-N-S Number], [Leads].[DandbCompanyId] AS [D&B Company ID], [Leads].[EmailBouncedReason] AS [Email Bounced Reason], [Leads].[EmailBouncedDate] AS [Email Bounced Date], [Leads].[SICCode__c] AS [SIC Code], [Leads].[ProductInterest__c] AS [Product Interest], [Leads].[Primary__c] AS [Primary], [Leads].[CurrentGenerators__c] AS [Current Generator(s)], [Leads].[NumberofLocations__c] AS [Number of Locations] FROM [Lead] AS [Leads] SELECT [Owned By].[Id] AS [User ID], [Owned By].[Username], [Owned By].[LastName] AS [LastName (Owned By)], [Owned By].[FirstName] AS [FirstName (Owned By)], [Owned By].[Name] AS [Name (Owned By)], [Owned By].[CompanyName] AS [Company Name], [Owned By].[Division], [Owned By].[Department], [Owned By].[Title] AS [Title (Owned By)], [Owned By].[Street] AS [Street (Owned By)], [Owned By].[City] AS [City (Owned By)], [Owned By].[State] AS [State (Owned By)], [Owned By].[PostalCode] AS [PostalCode (Owned By)], [Owned By].[Country] AS [Country (Owned By)], [Owned By].[Latitude] AS [Latitude (Owned By)], [Owned By].[Longitude] AS [Longitude (Owned By)], [Owned By].[Email] AS [Email (Owned By)], [Owned By].[EmailPreferencesAutoBcc] AS [AutoBcc], [Owned By].[EmailPreferencesAutoBccStayInTouch] AS [AutoBccStayInTouch], [Owned By].[EmailPreferencesStayInTouchReminder] AS [StayInTouchReminder], [Owned By].[SenderEmail] AS [Email Sender Address], [Owned By].[SenderName] AS [Email Sender Name], [Owned By].[Signature] AS [Email Signature], [Owned By].[StayInTouchSubject] AS [Stay-in-Touch Email Subject], [Owned By].[StayInTouchSignature] AS [Stay-in-Touch Email Signature], [Owned By].[StayInTouchNote] AS [Stay-in-Touch Email Note], [Owned By].[Phone] AS [Phone (Owned By)], [Owned By].[Fax], [Owned By].[MobilePhone] AS [Cell], [Owned By].[Alias], [Owned By].[CommunityNickname] AS [Nickname], [Owned By].[IsBadged] AS [User Photo has a badge overlay], [Owned By].[IsActive] AS [Active], [Owned By].[TimeZoneSidKey] AS [Time Zone], [Owned By].[UserRoleId] AS [Role ID], [Owned By].[LocaleSidKey] AS [Locale], [Owned By].[ReceivesInfoEmails] AS [Info Emails], [Owned By].[ReceivesAdminInfoEmails] AS [Admin Info Emails], [Owned By].[EmailEncodingKey] AS [Email Encoding], [Owned By].[ProfileId] AS [Profile ID], [Owned By].[UserType] AS [User Type], [Owned By].[LanguageLocaleKey] AS [Language], [Owned By].[EmployeeNumber] AS [Employee Number], [Owned By].[DelegatedApproverId] AS [Delegated Approver ID], [Owned By].[ManagerId] AS [Manager ID], [Owned By].[LastLoginDate] AS [Last Login], [Owned By].[LastPasswordChangeDate] AS [Last Password Change or Reset], [Owned By].[CreatedDate] AS [CreatedDate (Owned By)], [Owned By].[CreatedById] AS [CreatedById (Owned By)], [Owned By].[LastModifiedDate] AS [LastModifiedDate (Owned By)], [Owned By].[LastModifiedById] AS [LastModifiedById (Owned By)], [Owned By].[SystemModstamp] AS [SystemModstamp (Owned By)], [Owned By].[OfflineTrialExpirationDate] AS [Offline Edition Trial Expiration Date], [Owned By].[OfflinePdaTrialExpirationDate] AS [Sales Anywhere Trial Expiration Date], [Owned By].[UserPermissionsMarketingUser] AS [Marketing User], [Owned By].[UserPermissionsOfflineUser] AS [Offline User], [Owned By].[UserPermissionsCallCenterAutoLogin] AS [Auto-login To Call Center], [Owned By].[UserPermissionsMobileUser] AS [Apex Mobile User], [Owned By].[UserPermissionsSFContentUser] AS [Salesforce CRM Content User], [Owned By].[UserPermissionsKnowledgeUser] AS [Knowledge User], [Owned By].[UserPermissionsInteractionUser] AS [Force.com Flow User], [Owned By].[UserPermissionsSupportUser] AS [Service Cloud User], [Owned By].[UserPermissionsJigsawProspectingUser] AS [Data.com User], [Owned By].[UserPermissionsSiteforceContributorUser] AS [Site.com Contributor User], [Owned By].[UserPermissionsSiteforcePublisherUser] AS [Site.com Publisher User], [Owned By].[UserPermissionsWorkDotComUserFeature] AS [Work.com User], [Owned By].[ForecastEnabled] AS [Allow Forecasting], [Owned By].[UserPreferencesActivityRemindersPopup] AS [ActivityRemindersPopup], [Owned By].[UserPreferencesEventRemindersCheckboxDefault] AS [EventRemindersCheckboxDefault], [Owned By].[UserPreferencesTaskRemindersCheckboxDefault] AS [TaskRemindersCheckboxDefault], [Owned By].[UserPreferencesReminderSoundOff] AS [ReminderSoundOff], [Owned By].[UserPreferencesDisableAllFeedsEmail] AS [DisableAllFeedsEmail], [Owned By].[UserPreferencesDisableFollowersEmail] AS [DisableFollowersEmail], [Owned By].[UserPreferencesDisableProfilePostEmail] AS [DisableProfilePostEmail], [Owned By].[UserPreferencesDisableChangeCommentEmail] AS [DisableChangeCommentEmail], [Owned By].[UserPreferencesDisableLaterCommentEmail] AS [DisableLaterCommentEmail], [Owned By].[UserPreferencesDisProfPostCommentEmail] AS [DisProfPostCommentEmail], [Owned By].[UserPreferencesContentNoEmail] AS [ContentNoEmail], [Owned By].[UserPreferencesContentEmailAsAndWhen] AS [ContentEmailAsAndWhen], [Owned By].[UserPreferencesApexPagesDeveloperMode] AS [ApexPagesDeveloperMode], [Owned By].[UserPreferencesHideCSNGetChatterMobileTask] AS [HideCSNGetChatterMobileTask], [Owned By].[UserPreferencesDisableMentionsPostEmail] AS [DisableMentionsPostEmail], [Owned By].[UserPreferencesDisMentionsCommentEmail] AS [DisMentionsCommentEmail], [Owned By].[UserPreferencesHideCSNDesktopTask] AS [HideCSNDesktopTask], [Owned By].[UserPreferencesHideChatterOnboardingSplash] AS [HideChatterOnboardingSplash], [Owned By].[UserPreferencesHideSecondChatterOnboardingSplash] AS [HideSecondChatterOnboardingSplash], [Owned By].[UserPreferencesDisCommentAfterLikeEmail] AS [DisCommentAfterLikeEmail], [Owned By].[UserPreferencesDisableLikeEmail] AS [DisableLikeEmail], [Owned By].[UserPreferencesSortFeedByComment] AS [SortFeedByComment], [Owned By].[UserPreferencesDisableMessageEmail] AS [DisableMessageEmail], [Owned By].[UserPreferencesJigsawListUser] AS [JigsawListUser], [Owned By].[UserPreferencesDisableBookmarkEmail] AS [DisableBookmarkEmail], [Owned By].[UserPreferencesDisableSharePostEmail] AS [DisableSharePostEmail], [Owned By].[UserPreferencesEnableAutoSubForFeeds] AS [EnableAutoSubForFeeds], [Owned By].[UserPreferencesDisableFileShareNotificationsForApi] AS [DisableFileShareNotificationsForApi], [Owned By].[UserPreferencesShowTitleToExternalUsers] AS [ShowTitleToExternalUsers], [Owned By].[UserPreferencesShowManagerToExternalUsers] AS [ShowManagerToExternalUsers], [Owned By].[UserPreferencesShowEmailToExternalUsers] AS [ShowEmailToExternalUsers], [Owned By].[UserPreferencesShowWorkPhoneToExternalUsers] AS [ShowWorkPhoneToExternalUsers], [Owned By].[UserPreferencesShowMobilePhoneToExternalUsers] AS [ShowMobilePhoneToExternalUsers], [Owned By].[UserPreferencesShowFaxToExternalUsers] AS [ShowFaxToExternalUsers], [Owned By].[UserPreferencesShowStreetAddressToExternalUsers] AS [ShowStreetAddressToExternalUsers], [Owned By].[UserPreferencesShowCityToExternalUsers] AS [ShowCityToExternalUsers], [Owned By].[UserPreferencesShowStateToExternalUsers] AS [ShowStateToExternalUsers], [Owned By].[UserPreferencesShowPostalCodeToExternalUsers] AS [ShowPostalCodeToExternalUsers], [Owned By].[UserPreferencesShowCountryToExternalUsers] AS [ShowCountryToExternalUsers], [Owned By].[UserPreferencesShowProfilePicToGuestUsers] AS [ShowProfilePicToGuestUsers], [Owned By].[UserPreferencesShowTitleToGuestUsers] AS [ShowTitleToGuestUsers], [Owned By].[UserPreferencesShowCityToGuestUsers] AS [ShowCityToGuestUsers], [Owned By].[UserPreferencesShowStateToGuestUsers] AS [ShowStateToGuestUsers], [Owned By].[UserPreferencesShowPostalCodeToGuestUsers] AS [ShowPostalCodeToGuestUsers], [Owned By].[UserPreferencesShowCountryToGuestUsers] AS [ShowCountryToGuestUsers], [Owned By].[UserPreferencesDisableFeedbackEmail] AS [DisableFeedbackEmail], [Owned By].[UserPreferencesDisableWorkEmail] AS [DisableWorkEmail], [Owned By].[UserPreferencesHideS1BrowserUI] AS [HideS1BrowserUI], [Owned By].[UserPreferencesDisableEndorsementEmail] AS [DisableEndorsementEmail], [Owned By].[UserPreferencesLightningExperiencePreferred] AS [LightningExperiencePreferred], [Owned By].[ContactId] AS [Contact ID], [Owned By].[AccountId] AS [Account ID], [Owned By].[CallCenterId] AS [Call Center ID], [Owned By].[Extension], [Owned By].[FederationIdentifier] AS [SAML Federation ID], [Owned By].[AboutMe] AS [About Me], [Owned By].[FullPhotoUrl] AS [Url for full-sized Photo], [Owned By].[SmallPhotoUrl] AS [Photo], [Owned By].[DigestFrequency] AS [Chatter Email Highlights Frequency], [Owned By].[DefaultGroupNotificationFrequency] AS [Default Notification Frequency when Joining Groups], [Owned By].[JigsawImportLimitOverride] AS [Data.com Monthly Addition Limit], [Owned By].[LastViewedDate] AS [LastViewedDate (Owned By)], [Owned By].[LastReferencedDate] AS [LastReferencedDate (Owned By)] FROM [User] AS [Owned By] SELECT [Created By].[Id] AS [Id (Created By)], [Created By].[Username] AS [Username (Created By)], [Created By].[LastName] AS [LastName (Created By)], [Created By].[FirstName] AS [FirstName (Created By)], [Created By].[Name] AS [Name (Created By)], [Created By].[CompanyName] AS [CompanyName (Created By)], [Created By].[Division] AS [Division (Created By)], [Created By].[Department] AS [Department (Created By)], [Created By].[Title] AS [Title (Created By)], [Created By].[Street] AS [Street (Created By)], [Created By].[City] AS [City (Created By)], [Created By].[State] AS [State (Created By)], [Created By].[PostalCode] AS [PostalCode (Created By)], [Created By].[Country] AS [Country (Created By)], [Created By].[Latitude] AS [Latitude (Created By)], [Created By].[Longitude] AS [Longitude (Created By)], [Created By].[Email] AS [Email (Created By)], [Created By].[EmailPreferencesAutoBcc] AS [EmailPreferencesAutoBcc (Created By)], [Created By].[EmailPreferencesAutoBccStayInTouch] AS [EmailPreferencesAutoBccStayInTouch (Created By)], [Created By].[EmailPreferencesStayInTouchReminder] AS [EmailPreferencesStayInTouchReminder (Created By)], [Created By].[SenderEmail] AS [SenderEmail (Created By)], [Created By].[SenderName] AS [SenderName (Created By)], [Created By].[Signature] AS [Signature (Created By)], [Created By].[StayInTouchSubject] AS [StayInTouchSubject (Created By)], [Created By].[StayInTouchSignature] AS [StayInTouchSignature (Created By)], [Created By].[StayInTouchNote] AS [StayInTouchNote (Created By)], [Created By].[Phone] AS [Phone (Created By)], [Created By].[Fax] AS [Fax (Created By)], [Created By].[MobilePhone] AS [MobilePhone (Created By)], [Created By].[Alias] AS [Alias (Created By)], [Created By].[CommunityNickname] AS [CommunityNickname (Created By)], [Created By].[IsBadged] AS [IsBadged (Created By)], [Created By].[IsActive] AS [IsActive (Created By)], [Created By].[TimeZoneSidKey] AS [TimeZoneSidKey (Created By)], [Created By].[UserRoleId] AS [UserRoleId (Created By)], [Created By].[LocaleSidKey] AS [LocaleSidKey (Created By)], [Created By].[ReceivesInfoEmails] AS [ReceivesInfoEmails (Created By)], [Created By].[ReceivesAdminInfoEmails] AS [ReceivesAdminInfoEmails (Created By)], [Created By].[EmailEncodingKey] AS [EmailEncodingKey (Created By)], [Created By].[ProfileId] AS [ProfileId (Created By)], [Created By].[UserType] AS [UserType (Created By)], [Created By].[LanguageLocaleKey] AS [LanguageLocaleKey (Created By)], [Created By].[EmployeeNumber] AS [EmployeeNumber (Created By)], [Created By].[DelegatedApproverId] AS [DelegatedApproverId (Created By)], [Created By].[ManagerId] AS [ManagerId (Created By)], [Created By].[LastLoginDate] AS [LastLoginDate (Created By)], [Created By].[LastPasswordChangeDate] AS [LastPasswordChangeDate (Created By)], [Created By].[CreatedDate] AS [CreatedDate (Created By)], [Created By].[CreatedById] AS [CreatedById (Created By)], [Created By].[LastModifiedDate] AS [LastModifiedDate (Created By)], [Created By].[LastModifiedById] AS [LastModifiedById (Created By)], [Created By].[SystemModstamp] AS [SystemModstamp (Created By)], [Created By].[OfflineTrialExpirationDate] AS [OfflineTrialExpirationDate (Created By)], [Created By].[OfflinePdaTrialExpirationDate] AS [OfflinePdaTrialExpirationDate (Created By)], [Created By].[UserPermissionsMarketingUser] AS [UserPermissionsMarketingUser (Created By)], [Created By].[UserPermissionsOfflineUser] AS [UserPermissionsOfflineUser (Created By)], [Created By].[UserPermissionsCallCenterAutoLogin] AS [UserPermissionsCallCenterAutoLogin (Created By)], [Created By].[UserPermissionsMobileUser] AS [UserPermissionsMobileUser (Created By)], [Created By].[UserPermissionsSFContentUser] AS [UserPermissionsSFContentUser (Created By)], [Created By].[UserPermissionsKnowledgeUser] AS [UserPermissionsKnowledgeUser (Created By)], [Created By].[UserPermissionsInteractionUser] AS [UserPermissionsInteractionUser (Created By)], [Created By].[UserPermissionsSupportUser] AS [UserPermissionsSupportUser (Created By)], [Created By].[UserPermissionsJigsawProspectingUser] AS [UserPermissionsJigsawProspectingUser (Created By)], [Created By].[UserPermissionsSiteforceContributorUser] AS [UserPermissionsSiteforceContributorUser (Created By)], [Created By].[UserPermissionsSiteforcePublisherUser] AS [UserPermissionsSiteforcePublisherUser (Created By)], [Created By].[UserPermissionsWorkDotComUserFeature] AS [UserPermissionsWorkDotComUserFeature (Created By)], [Created By].[ForecastEnabled] AS [ForecastEnabled (Created By)], [Created By].[UserPreferencesActivityRemindersPopup] AS [UserPreferencesActivityRemindersPopup (Created By)], [Created By].[UserPreferencesEventRemindersCheckboxDefault] AS [UserPreferencesEventRemindersCheckboxDefault (Created By)], [Created By].[UserPreferencesTaskRemindersCheckboxDefault] AS [UserPreferencesTaskRemindersCheckboxDefault (Created By)], [Created By].[UserPreferencesReminderSoundOff] AS [UserPreferencesReminderSoundOff (Created By)], [Created By].[UserPreferencesDisableAllFeedsEmail] AS [UserPreferencesDisableAllFeedsEmail (Created By)], [Created By].[UserPreferencesDisableFollowersEmail] AS [UserPreferencesDisableFollowersEmail (Created By)], [Created By].[UserPreferencesDisableProfilePostEmail] AS [UserPreferencesDisableProfilePostEmail (Created By)], [Created By].[UserPreferencesDisableChangeCommentEmail] AS [UserPreferencesDisableChangeCommentEmail (Created By)], [Created By].[UserPreferencesDisableLaterCommentEmail] AS [UserPreferencesDisableLaterCommentEmail (Created By)], [Created By].[UserPreferencesDisProfPostCommentEmail] AS [UserPreferencesDisProfPostCommentEmail (Created By)], [Created By].[UserPreferencesContentNoEmail] AS [UserPreferencesContentNoEmail (Created By)], [Created By].[UserPreferencesContentEmailAsAndWhen] AS [UserPreferencesContentEmailAsAndWhen (Created By)], [Created By].[UserPreferencesApexPagesDeveloperMode] AS [UserPreferencesApexPagesDeveloperMode (Created By)], [Created By].[UserPreferencesHideCSNGetChatterMobileTask] AS [UserPreferencesHideCSNGetChatterMobileTask (Created By)], [Created By].[UserPreferencesDisableMentionsPostEmail] AS [UserPreferencesDisableMentionsPostEmail (Created By)], [Created By].[UserPreferencesDisMentionsCommentEmail] AS [UserPreferencesDisMentionsCommentEmail (Created By)], [Created By].[UserPreferencesHideCSNDesktopTask] AS [UserPreferencesHideCSNDesktopTask (Created By)], [Created By].[UserPreferencesHideChatterOnboardingSplash] AS [UserPreferencesHideChatterOnboardingSplash (Created By)], [Created By].[UserPreferencesHideSecondChatterOnboardingSplash] AS [UserPreferencesHideSecondChatterOnboardingSplash (Created By)], [Created By].[UserPreferencesDisCommentAfterLikeEmail] AS [UserPreferencesDisCommentAfterLikeEmail (Created By)], [Created By].[UserPreferencesDisableLikeEmail] AS [UserPreferencesDisableLikeEmail (Created By)], [Created By].[UserPreferencesSortFeedByComment] AS [UserPreferencesSortFeedByComment (Created By)], [Created By].[UserPreferencesDisableMessageEmail] AS [UserPreferencesDisableMessageEmail (Created By)], [Created By].[UserPreferencesJigsawListUser] AS [UserPreferencesJigsawListUser (Created By)], [Created By].[UserPreferencesDisableBookmarkEmail] AS [UserPreferencesDisableBookmarkEmail (Created By)], [Created By].[UserPreferencesDisableSharePostEmail] AS [UserPreferencesDisableSharePostEmail (Created By)], [Created By].[UserPreferencesEnableAutoSubForFeeds] AS [UserPreferencesEnableAutoSubForFeeds (Created By)], [Created By].[UserPreferencesDisableFileShareNotificationsForApi] AS [UserPreferencesDisableFileShareNotificationsForApi (Created By)], [Created By].[UserPreferencesShowTitleToExternalUsers] AS [UserPreferencesShowTitleToExternalUsers (Created By)], [Created By].[UserPreferencesShowManagerToExternalUsers] AS [UserPreferencesShowManagerToExternalUsers (Created By)], [Created By].[UserPreferencesShowEmailToExternalUsers] AS [UserPreferencesShowEmailToExternalUsers (Created By)], [Created By].[UserPreferencesShowWorkPhoneToExternalUsers] AS [UserPreferencesShowWorkPhoneToExternalUsers (Created By)], [Created By].[UserPreferencesShowMobilePhoneToExternalUsers] AS [UserPreferencesShowMobilePhoneToExternalUsers (Created By)], [Created By].[UserPreferencesShowFaxToExternalUsers] AS [UserPreferencesShowFaxToExternalUsers (Created By)], [Created By].[UserPreferencesShowStreetAddressToExternalUsers] AS [UserPreferencesShowStreetAddressToExternalUsers (Created By)], [Created By].[UserPreferencesShowCityToExternalUsers] AS [UserPreferencesShowCityToExternalUsers (Created By)], [Created By].[UserPreferencesShowStateToExternalUsers] AS [UserPreferencesShowStateToExternalUsers (Created By)], [Created By].[UserPreferencesShowPostalCodeToExternalUsers] AS [UserPreferencesShowPostalCodeToExternalUsers (Created By)], [Created By].[UserPreferencesShowCountryToExternalUsers] AS [UserPreferencesShowCountryToExternalUsers (Created By)], [Created By].[UserPreferencesShowProfilePicToGuestUsers] AS [UserPreferencesShowProfilePicToGuestUsers (Created By)], [Created By].[UserPreferencesShowTitleToGuestUsers] AS [UserPreferencesShowTitleToGuestUsers (Created By)], [Created By].[UserPreferencesShowCityToGuestUsers] AS [UserPreferencesShowCityToGuestUsers (Created By)], [Created By].[UserPreferencesShowStateToGuestUsers] AS [UserPreferencesShowStateToGuestUsers (Created By)], [Created By].[UserPreferencesShowPostalCodeToGuestUsers] AS [UserPreferencesShowPostalCodeToGuestUsers (Created By)], [Created By].[UserPreferencesShowCountryToGuestUsers] AS [UserPreferencesShowCountryToGuestUsers (Created By)], [Created By].[UserPreferencesDisableFeedbackEmail] AS [UserPreferencesDisableFeedbackEmail (Created By)], [Created By].[UserPreferencesDisableWorkEmail] AS [UserPreferencesDisableWorkEmail (Created By)], [Created By].[UserPreferencesHideS1BrowserUI] AS [UserPreferencesHideS1BrowserUI (Created By)], [Created By].[UserPreferencesDisableEndorsementEmail] AS [UserPreferencesDisableEndorsementEmail (Created By)], [Created By].[UserPreferencesLightningExperiencePreferred] AS [UserPreferencesLightningExperiencePreferred (Created By)], [Created By].[ContactId] AS [ContactId (Created By)], [Created By].[AccountId] AS [AccountId (Created By)], [Created By].[CallCenterId] AS [CallCenterId (Created By)], [Created By].[Extension] AS [Extension (Created By)], [Created By].[FederationIdentifier] AS [FederationIdentifier (Created By)], [Created By].[AboutMe] AS [AboutMe (Created By)], [Created By].[FullPhotoUrl] AS [FullPhotoUrl (Created By)], [Created By].[SmallPhotoUrl] AS [SmallPhotoUrl (Created By)], [Created By].[DigestFrequency] AS [DigestFrequency (Created By)], [Created By].[DefaultGroupNotificationFrequency] AS [DefaultGroupNotificationFrequency (Created By)], [Created By].[JigsawImportLimitOverride] AS [JigsawImportLimitOverride (Created By)], [Created By].[LastViewedDate] AS [LastViewedDate (Created By)], [Created By].[LastReferencedDate] AS [LastReferencedDate (Created By)] FROM [User] AS [Created By] SELECT [Opportunity].[Id] AS [Opportunity ID], [Opportunity].[IsDeleted] AS [IsDeleted (Opportunity)], [Opportunity].[AccountId] AS [AccountId (Opportunity)], [Opportunity].[IsPrivate] AS [Private], [Opportunity].[Name], [Opportunity].[StageName] AS [Stage], [Opportunity].[Amount], [Opportunity].[Probability] AS [Probability (%)], [Opportunity].[ExpectedRevenue] AS [Expected Amount], [Opportunity].[TotalOpportunityQuantity] AS [Quantity], [Opportunity].[CloseDate] AS [Close Date], [Opportunity].[Type] AS [Opportunity Type], [Opportunity].[NextStep] AS [Next Step], [Opportunity].[LeadSource] AS [LeadSource (Opportunity)], [Opportunity].[IsClosed] AS [Closed], [Opportunity].[IsWon] AS [Won], [Opportunity].[ForecastCategory] AS [Forecast Category], [Opportunity].[ForecastCategoryName] AS [Forecast Category1], [Opportunity].[CampaignId] AS [Campaign ID], [Opportunity].[HasOpportunityLineItem] AS [Has Line Item], [Opportunity].[Pricebook2Id] AS [Price Book ID], [Opportunity].[OwnerId] AS [OwnerId (Opportunity)], [Opportunity].[CreatedDate] AS [CreatedDate (Opportunity)], [Opportunity].[CreatedById] AS [CreatedById (Opportunity)], [Opportunity].[LastModifiedDate] AS [LastModifiedDate (Opportunity)], [Opportunity].[LastModifiedById] AS [LastModifiedById (Opportunity)], [Opportunity].[SystemModstamp] AS [SystemModstamp (Opportunity)], [Opportunity].[LastActivityDate] AS [LastActivityDate (Opportunity)], [Opportunity].[FiscalQuarter] AS [Fiscal Quarter], [Opportunity].[FiscalYear] AS [Fiscal Year], [Opportunity].[Fiscal] AS [Fiscal Period], [Opportunity].[LastViewedDate] AS [LastViewedDate (Opportunity)], [Opportunity].[LastReferencedDate] AS [LastReferencedDate (Opportunity)], [Opportunity].[DeliveryInstallationStatus__c] AS [Delivery/Installation Status], [Opportunity].[TrackingNumber__c] AS [Tracking Number], [Opportunity].[OrderNumber__c] AS [Order Number], [Opportunity].[CurrentGenerators__c] AS [CurrentGenerators__c (Opportunity)], [Opportunity].[MainCompetitors__c] AS [Main Competitor(s)] FROM [Opportunity]