**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Sales Force Marketing Leads **************************************************************************** Workbook Information Author: Unknown Embedded Datasources Datasource: Parameters Connection Measure Calculated/Other Measure: Define Monthly Goal (# New Leads) Role: Continous Measure Data Type: integer Formula: 270 Default Value: 270 Parameter Type: any Datasource: login.salesforce.com Connection Data Sources Data Source: login.salesforce.com Attributes REDIRECT_URI: https://login.salesforce.com/services/oauth2/success SCOPE: api id refresh_token authentication: auth-oauth class: salesforce compressed-responses: yes compressed-responses-bulk: yes compressed-responses-rest: yes compressed-responses-soap: yes maxfieldlength: 4096 pagesize: 200 salesforce-api-version: 30.0 server: login.salesforce.com sf-total-requestor-buffer-size-in-mb: 32 userLanguage: en_US workgroup-auth-mode: as-is Tables Table: Leads Database Object: [Lead] Connection: login.salesforce.com Table: Owned By Database Object: [User] Connection: login.salesforce.com Table: Created By Database Object: [User] Connection: login.salesforce.com Table: Opportunity Database Object: [Opportunity] Connection: login.salesforce.com Dimension Created By Dimension: AboutMe (Created By) Role: Discrete Dimension Remote Column: [Created By].[AboutMe] Data Type: string Dimension: AccountId (Created By) Role: Discrete Dimension Remote Column: [Created By].[AccountId] Data Type: string Dimension: Alias (Created By) Role: Discrete Dimension Remote Column: [Created By].[Alias] Data Type: string Dimension: CallCenterId (Created By) Role: Discrete Dimension Remote Column: [Created By].[CallCenterId] Data Type: string Dimension: City (Created By) Role: Discrete Dimension Remote Column: [Created By].[City] Data Type: string Dimension: CommunityNickname (Created By) Role: Discrete Dimension Remote Column: [Created By].[CommunityNickname] Data Type: string Dimension: CompanyName (Created By) Role: Discrete Dimension Remote Column: [Created By].[CompanyName] Data Type: string Dimension: ContactId (Created By) Role: Discrete Dimension Remote Column: [Created By].[ContactId] Data Type: string Dimension: Country (Created By) Role: Discrete Dimension Remote Column: [Created By].[Country] Data Type: string Dimension: CreatedById (Created By) Role: Discrete Dimension Remote Column: [Created By].[CreatedById] Data Type: string Dimension: CreatedDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[CreatedDate] Data Type: datetime Dimension: DefaultGroupNotificationFrequency (Created By) Role: Discrete Dimension Remote Column: [Created By].[DefaultGroupNotificationFrequency] Data Type: string Dimension: DelegatedApproverId (Created By) Role: Discrete Dimension Remote Column: [Created By].[DelegatedApproverId] Data Type: string Dimension: Department (Created By) Role: Discrete Dimension Remote Column: [Created By].[Department] Data Type: string Dimension: DigestFrequency (Created By) Role: Discrete Dimension Remote Column: [Created By].[DigestFrequency] Data Type: string Dimension: Division (Created By) Role: Discrete Dimension Remote Column: [Created By].[Division] Data Type: string Dimension: Email (Created By) Role: Discrete Dimension Remote Column: [Created By].[Email] Data Type: string Dimension: EmailEncodingKey (Created By) Role: Discrete Dimension Remote Column: [Created By].[EmailEncodingKey] Data Type: string Dimension: EmailPreferencesAutoBcc (Created By) Role: Discrete Dimension Remote Column: [Created By].[EmailPreferencesAutoBcc] Data Type: boolean Dimension: EmailPreferencesAutoBccStayInTouch (Created By) Role: Discrete Dimension Remote Column: [Created By].[EmailPreferencesAutoBccStayInTouch] Data Type: boolean Dimension: EmailPreferencesStayInTouchReminder (Created By) Role: Discrete Dimension Remote Column: [Created By].[EmailPreferencesStayInTouchReminder] Data Type: boolean Dimension: EmployeeNumber (Created By) Role: Discrete Dimension Remote Column: [Created By].[EmployeeNumber] Data Type: string Dimension: Extension (Created By) Role: Discrete Dimension Remote Column: [Created By].[Extension] Data Type: string Dimension: Fax (Created By) Role: Discrete Dimension Remote Column: [Created By].[Fax] Data Type: string Dimension: FederationIdentifier (Created By) Role: Discrete Dimension Remote Column: [Created By].[FederationIdentifier] Data Type: string Dimension: FirstName (Created By) Role: Discrete Dimension Remote Column: [Created By].[FirstName] Data Type: string Dimension: ForecastEnabled (Created By) Role: Discrete Dimension Remote Column: [Created By].[ForecastEnabled] Data Type: boolean Dimension: FullPhotoUrl (Created By) Role: Discrete Dimension Remote Column: [Created By].[FullPhotoUrl] Data Type: string Dimension: IsActive (Created By) Role: Discrete Dimension Remote Column: [Created By].[IsActive] Data Type: boolean Dimension: IsBadged (Created By) Role: Discrete Dimension Remote Column: [Created By].[IsBadged] Data Type: boolean Dimension: LanguageLocaleKey (Created By) Role: Discrete Dimension Remote Column: [Created By].[LanguageLocaleKey] Data Type: string Dimension: LastLoginDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastLoginDate] Data Type: datetime Dimension: LastModifiedById (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastModifiedDate] Data Type: datetime Dimension: LastName (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastName] Data Type: string Dimension: LastPasswordChangeDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastPasswordChangeDate] Data Type: datetime Dimension: LastReferencedDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[LastViewedDate] Data Type: datetime Dimension: LocaleSidKey (Created By) Role: Discrete Dimension Remote Column: [Created By].[LocaleSidKey] Data Type: string Dimension: ManagerId (Created By) Role: Discrete Dimension Remote Column: [Created By].[ManagerId] Data Type: string Dimension: MobilePhone (Created By) Role: Discrete Dimension Remote Column: [Created By].[MobilePhone] Data Type: string Dimension: Name (Created By) Role: Discrete Dimension Remote Column: [Created By].[Name] Data Type: string Dimension: OfflinePdaTrialExpirationDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[OfflinePdaTrialExpirationDate] Data Type: datetime Dimension: OfflineTrialExpirationDate (Created By) Role: Discrete Dimension Remote Column: [Created By].[OfflineTrialExpirationDate] Data Type: datetime Dimension: Phone (Created By) Role: Discrete Dimension Remote Column: [Created By].[Phone] Data Type: string Dimension: PostalCode (Created By) Role: Discrete Dimension Remote Column: [Created By].[PostalCode] Data Type: string Dimension: ProfileId (Created By) Role: Discrete Dimension Remote Column: [Created By].[ProfileId] Data Type: string Dimension: ReceivesAdminInfoEmails (Created By) Role: Discrete Dimension Remote Column: [Created By].[ReceivesAdminInfoEmails] Data Type: boolean Dimension: ReceivesInfoEmails (Created By) Role: Discrete Dimension Remote Column: [Created By].[ReceivesInfoEmails] Data Type: boolean Dimension: SenderEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[SenderEmail] Data Type: string Dimension: SenderName (Created By) Role: Discrete Dimension Remote Column: [Created By].[SenderName] Data Type: string Dimension: Signature (Created By) Role: Discrete Dimension Remote Column: [Created By].[Signature] Data Type: string Dimension: SmallPhotoUrl (Created By) Role: Discrete Dimension Remote Column: [Created By].[SmallPhotoUrl] Data Type: string Dimension: State (Created By) Role: Discrete Dimension Remote Column: [Created By].[State] Data Type: string Dimension: StayInTouchNote (Created By) Role: Discrete Dimension Remote Column: [Created By].[StayInTouchNote] Data Type: string Dimension: StayInTouchSignature (Created By) Role: Discrete Dimension Remote Column: [Created By].[StayInTouchSignature] Data Type: string Dimension: StayInTouchSubject (Created By) Role: Discrete Dimension Remote Column: [Created By].[StayInTouchSubject] Data Type: string Dimension: Street (Created By) Role: Discrete Dimension Remote Column: [Created By].[Street] Data Type: string Dimension: SystemModstamp (Created By) Role: Discrete Dimension Remote Column: [Created By].[SystemModstamp] Data Type: datetime Dimension: TimeZoneSidKey (Created By) Role: Discrete Dimension Remote Column: [Created By].[TimeZoneSidKey] Data Type: string Dimension: Title (Created By) Role: Discrete Dimension Remote Column: [Created By].[Title] Data Type: string Dimension: UserPermissionsCallCenterAutoLogin (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsCallCenterAutoLogin] Data Type: boolean Dimension: UserPermissionsInteractionUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsInteractionUser] Data Type: boolean Dimension: UserPermissionsJigsawProspectingUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsJigsawProspectingUser] Data Type: boolean Dimension: UserPermissionsKnowledgeUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsKnowledgeUser] Data Type: boolean Dimension: UserPermissionsMarketingUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsMarketingUser] Data Type: boolean Dimension: UserPermissionsMobileUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsMobileUser] Data Type: boolean Dimension: UserPermissionsOfflineUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsOfflineUser] Data Type: boolean Dimension: UserPermissionsSFContentUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsSFContentUser] Data Type: boolean Dimension: UserPermissionsSiteforceContributorUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsSiteforceContributorUser] Data Type: boolean Dimension: UserPermissionsSiteforcePublisherUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsSiteforcePublisherUser] Data Type: boolean Dimension: UserPermissionsSupportUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsSupportUser] Data Type: boolean Dimension: UserPermissionsWorkDotComUserFeature (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPermissionsWorkDotComUserFeature] Data Type: boolean Dimension: UserPreferencesActivityRemindersPopup (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesActivityRemindersPopup] Data Type: boolean Dimension: UserPreferencesApexPagesDeveloperMode (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesApexPagesDeveloperMode] Data Type: boolean Dimension: UserPreferencesContentEmailAsAndWhen (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesContentEmailAsAndWhen] Data Type: boolean Dimension: UserPreferencesContentNoEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesContentNoEmail] Data Type: boolean Dimension: UserPreferencesDisCommentAfterLikeEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisCommentAfterLikeEmail] Data Type: boolean Dimension: UserPreferencesDisMentionsCommentEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisMentionsCommentEmail] Data Type: boolean Dimension: UserPreferencesDisProfPostCommentEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisProfPostCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableAllFeedsEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableAllFeedsEmail] Data Type: boolean Dimension: UserPreferencesDisableBookmarkEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableBookmarkEmail] Data Type: boolean Dimension: UserPreferencesDisableChangeCommentEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableChangeCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableEndorsementEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableEndorsementEmail] Data Type: boolean Dimension: UserPreferencesDisableFeedbackEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableFeedbackEmail] Data Type: boolean Dimension: UserPreferencesDisableFileShareNotificationsForApi (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableFileShareNotificationsForApi] Data Type: boolean Dimension: UserPreferencesDisableFollowersEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableFollowersEmail] Data Type: boolean Dimension: UserPreferencesDisableLaterCommentEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableLaterCommentEmail] Data Type: boolean Dimension: UserPreferencesDisableLikeEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableLikeEmail] Data Type: boolean Dimension: UserPreferencesDisableMentionsPostEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableMentionsPostEmail] Data Type: boolean Dimension: UserPreferencesDisableMessageEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableMessageEmail] Data Type: boolean Dimension: UserPreferencesDisableProfilePostEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableProfilePostEmail] Data Type: boolean Dimension: UserPreferencesDisableSharePostEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableSharePostEmail] Data Type: boolean Dimension: UserPreferencesDisableWorkEmail (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesDisableWorkEmail] Data Type: boolean Dimension: UserPreferencesEnableAutoSubForFeeds (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesEnableAutoSubForFeeds] Data Type: boolean Dimension: UserPreferencesEventRemindersCheckboxDefault (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesEventRemindersCheckboxDefault] Data Type: boolean Dimension: UserPreferencesHideCSNDesktopTask (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesHideCSNDesktopTask] Data Type: boolean Dimension: UserPreferencesHideCSNGetChatterMobileTask (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesHideCSNGetChatterMobileTask] Data Type: boolean Dimension: UserPreferencesHideChatterOnboardingSplash (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesHideChatterOnboardingSplash] Data Type: boolean Dimension: UserPreferencesHideS1BrowserUI (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesHideS1BrowserUI] Data Type: boolean Dimension: UserPreferencesHideSecondChatterOnboardingSplash (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesHideSecondChatterOnboardingSplash] Data Type: boolean Dimension: UserPreferencesJigsawListUser (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesJigsawListUser] Data Type: boolean Dimension: UserPreferencesLightningExperiencePreferred (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesLightningExperiencePreferred] Data Type: boolean Dimension: UserPreferencesReminderSoundOff (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesReminderSoundOff] Data Type: boolean Dimension: UserPreferencesShowCityToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowCityToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowCityToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowCityToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowCountryToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowCountryToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowCountryToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowCountryToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowEmailToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowEmailToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowFaxToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowFaxToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowManagerToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowManagerToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowMobilePhoneToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowMobilePhoneToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowPostalCodeToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowPostalCodeToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowPostalCodeToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowPostalCodeToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowProfilePicToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowProfilePicToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowStateToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowStateToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowStateToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowStateToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowStreetAddressToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowStreetAddressToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowTitleToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowTitleToExternalUsers] Data Type: boolean Dimension: UserPreferencesShowTitleToGuestUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowTitleToGuestUsers] Data Type: boolean Dimension: UserPreferencesShowWorkPhoneToExternalUsers (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesShowWorkPhoneToExternalUsers] Data Type: boolean Dimension: UserPreferencesSortFeedByComment (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesSortFeedByComment] Data Type: boolean Dimension: UserPreferencesTaskRemindersCheckboxDefault (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserPreferencesTaskRemindersCheckboxDefault] Data Type: boolean Dimension: UserRoleId (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserRoleId] Data Type: string Dimension: UserType (Created By) Role: Discrete Dimension Remote Column: [Created By].[UserType] Data Type: string Dimension: Username (Created By) Role: Discrete Dimension Remote Column: [Created By].[Username] Data Type: string Leads Dimension: City Role: Discrete Dimension Remote Column: [Leads].[City] Data Type: string Dimension: Clean Status Role: Discrete Dimension Remote Column: [Leads].[CleanStatus] Data Type: string Dimension: Company D-U-N-S Number Role: Discrete Dimension Remote Column: [Leads].[CompanyDunsNumber] Data Type: string Dimension: Company Role: Discrete Dimension Remote Column: [Leads].[Company] Data Type: string Dimension: Converted Contact ID Role: Discrete Dimension Remote Column: [Leads].[ConvertedContactId] Data Type: string Dimension: Converted Date Role: Discrete Dimension Remote Column: [Leads].[ConvertedDate] Data Type: date Dimension: Converted Role: Discrete Dimension Remote Column: [Leads].[IsConverted] Data Type: boolean Dimension: Country Role: Discrete Dimension Remote Column: [Leads].[Country] Data Type: string Dimension: Created By ID Role: Discrete Dimension Remote Column: [Leads].[CreatedById] Data Type: string Dimension: Created Date Role: Discrete Dimension Remote Column: [Leads].[CreatedDate] Data Type: datetime Dimension: Current Generator(s) Role: Discrete Dimension Remote Column: [Leads].[CurrentGenerators__c] Data Type: string Dimension: D&B Company ID Role: Discrete Dimension Remote Column: [Leads].[DandbCompanyId] Data Type: string Dimension: Data.com Key Role: Discrete Dimension Remote Column: [Leads].[Jigsaw] Data Type: string Dimension: Deleted Role: Discrete Dimension Remote Column: [Leads].[IsDeleted] Data Type: boolean Dimension: Email Bounced Date Role: Discrete Dimension Remote Column: [Leads].[EmailBouncedDate] Data Type: datetime Dimension: Email Bounced Reason Role: Discrete Dimension Remote Column: [Leads].[EmailBouncedReason] Data Type: string Dimension: Email Role: Discrete Dimension Remote Column: [Leads].[Email] Data Type: string Dimension: Fax (Leads) Role: Discrete Dimension Remote Column: [Leads].[Fax] Data Type: string Dimension: First Name Role: Discrete Dimension Remote Column: [Leads].[FirstName] Data Type: string Dimension: Full Name Role: Discrete Dimension Remote Column: [Leads].[Name] Data Type: string Dimension: Industry Role: Discrete Dimension Remote Column: [Leads].[Industry] Data Type: string Dimension: Jigsaw Contact ID Role: Discrete Dimension Remote Column: [Leads].[JigsawContactId] Data Type: string Dimension: Last Activity Role: Discrete Dimension Remote Column: [Leads].[LastActivityDate] Data Type: date Dimension: Last Modified By ID Role: Discrete Dimension Remote Column: [Leads].[LastModifiedById] Data Type: string Dimension: Last Modified Date Role: Discrete Dimension Remote Column: [Leads].[LastModifiedDate] Data Type: datetime Dimension: Last Name Role: Discrete Dimension Remote Column: [Leads].[LastName] Data Type: string Dimension: Last Referenced Date Role: Discrete Dimension Remote Column: [Leads].[LastReferencedDate] Data Type: datetime Dimension: Last Viewed Date Role: Discrete Dimension Remote Column: [Leads].[LastViewedDate] Data Type: datetime Dimension: Lead Source Role: Discrete Dimension Remote Column: [Leads].[LeadSource] Data Type: string Dimension: Master Record ID Role: Discrete Dimension Remote Column: [Leads].[MasterRecordId] Data Type: string Dimension: Mobile Phone Role: Discrete Dimension Remote Column: [Leads].[MobilePhone] Data Type: string Dimension: Owner ID Role: Discrete Dimension Remote Column: [Leads].[OwnerId] Data Type: string Dimension: Phone Role: Discrete Dimension Remote Column: [Leads].[Phone] Data Type: string Dimension: Photo URL Role: Discrete Dimension Remote Column: [Leads].[PhotoUrl] Data Type: string Dimension: Primary Role: Discrete Dimension Remote Column: [Leads].[Primary__c] Data Type: string Dimension: Product Interest Role: Discrete Dimension Remote Column: [Leads].[ProductInterest__c] Data Type: string Dimension: Rating Role: Discrete Dimension Remote Column: [Leads].[Rating] Data Type: string Dimension: SIC Code Role: Discrete Dimension Remote Column: [Leads].[SICCode__c] Data Type: string Dimension: Salutation Role: Discrete Dimension Remote Column: [Leads].[Salutation] Data Type: string Dimension: State/Province Role: Discrete Dimension Remote Column: [Leads].[State] Data Type: string Dimension: Status Role: Discrete Dimension Remote Column: [Leads].[Status] Data Type: string Dimension: Street Role: Discrete Dimension Remote Column: [Leads].[Street] Data Type: string Dimension: System Modstamp Role: Discrete Dimension Remote Column: [Leads].[SystemModstamp] Data Type: datetime Dimension: Title Role: Discrete Dimension Remote Column: [Leads].[Title] Data Type: string Dimension: Unread By Owner Role: Discrete Dimension Remote Column: [Leads].[IsUnreadByOwner] Data Type: boolean Dimension: Website Role: Discrete Dimension Remote Column: [Leads].[Website] Data Type: string Dimension: Zip/Postal Code Role: Discrete Dimension Remote Column: [Leads].[PostalCode] Data Type: string Opportunity Dimension: AccountId (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[AccountId] Data Type: string Dimension: Campaign ID Role: Discrete Dimension Remote Column: [Opportunity].[CampaignId] Data Type: string Dimension: Close Date Role: Discrete Dimension Remote Column: [Opportunity].[CloseDate] Data Type: date Dimension: Closed Role: Discrete Dimension Remote Column: [Opportunity].[IsClosed] Data Type: boolean Dimension: CreatedById (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[CreatedById] Data Type: string Dimension: CreatedDate (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[CreatedDate] Data Type: datetime Dimension: CurrentGenerators__c (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[CurrentGenerators__c] Data Type: string Dimension: Delivery/Installation Status Role: Discrete Dimension Remote Column: [Opportunity].[DeliveryInstallationStatus__c] Data Type: string Dimension: Fiscal Period Role: Discrete Dimension Remote Column: [Opportunity].[Fiscal] Data Type: string Dimension: Fiscal Quarter Role: Continous Dimension Remote Column: [Opportunity].[FiscalQuarter] Data Type: integer Dimension: Fiscal Year Role: Continous Dimension Remote Column: [Opportunity].[FiscalYear] Data Type: integer Dimension: Forecast Category1 Role: Discrete Dimension Remote Column: [Opportunity].[ForecastCategoryName] Data Type: string Dimension: Forecast Category Role: Discrete Dimension Remote Column: [Opportunity].[ForecastCategory] Data Type: string Dimension: Has Line Item Role: Discrete Dimension Remote Column: [Opportunity].[HasOpportunityLineItem] Data Type: boolean Dimension: IsDeleted (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[IsDeleted] Data Type: boolean Dimension: LastActivityDate (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LastActivityDate] Data Type: date Dimension: LastModifiedById (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LastModifiedDate] Data Type: datetime Dimension: LastReferencedDate (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LastViewedDate] Data Type: datetime Dimension: LeadSource (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[LeadSource] Data Type: string Dimension: Main Competitor(s) Role: Discrete Dimension Remote Column: [Opportunity].[MainCompetitors__c] Data Type: string Dimension: Name Role: Discrete Dimension Remote Column: [Opportunity].[Name] Data Type: string Dimension: Next Step Role: Discrete Dimension Remote Column: [Opportunity].[NextStep] Data Type: string Dimension: Opportunity Type Role: Discrete Dimension Remote Column: [Opportunity].[Type] Data Type: string Dimension: Order Number Role: Discrete Dimension Remote Column: [Opportunity].[OrderNumber__c] Data Type: string Dimension: OwnerId (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[OwnerId] Data Type: string Dimension: Price Book ID Role: Discrete Dimension Remote Column: [Opportunity].[Pricebook2Id] Data Type: string Dimension: Private Role: Discrete Dimension Remote Column: [Opportunity].[IsPrivate] Data Type: boolean Dimension: Stage Role: Discrete Dimension Remote Column: [Opportunity].[StageName] Data Type: string Dimension: SystemModstamp (Opportunity) Role: Discrete Dimension Remote Column: [Opportunity].[SystemModstamp] Data Type: datetime Dimension: Tracking Number Role: Discrete Dimension Remote Column: [Opportunity].[TrackingNumber__c] Data Type: string Dimension: Won Role: Discrete Dimension Remote Column: [Opportunity].[IsWon] Data Type: boolean Owned By Dimension: About Me Role: Discrete Dimension Remote Column: [Owned By].[AboutMe] Data Type: string Dimension: Account ID Role: Discrete Dimension Remote Column: [Owned By].[AccountId] Data Type: string Dimension: Active Role: Discrete Dimension Remote Column: [Owned By].[IsActive] Data Type: boolean Dimension: ActivityRemindersPopup Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesActivityRemindersPopup] Data Type: boolean Dimension: Admin Info Emails Role: Discrete Dimension Remote Column: [Owned By].[ReceivesAdminInfoEmails] Data Type: boolean Dimension: Alias Role: Discrete Dimension Remote Column: [Owned By].[Alias] Data Type: string Dimension: Allow Forecasting Role: Discrete Dimension Remote Column: [Owned By].[ForecastEnabled] Data Type: boolean Dimension: Apex Mobile User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsMobileUser] Data Type: boolean Dimension: ApexPagesDeveloperMode Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesApexPagesDeveloperMode] Data Type: boolean Dimension: Auto-login To Call Center Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsCallCenterAutoLogin] Data Type: boolean Dimension: AutoBccStayInTouch Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesAutoBccStayInTouch] Data Type: boolean Dimension: AutoBcc Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesAutoBcc] Data Type: boolean Dimension: Call Center ID Role: Discrete Dimension Remote Column: [Owned By].[CallCenterId] Data Type: string Dimension: Cell Role: Discrete Dimension Remote Column: [Owned By].[MobilePhone] Data Type: string Dimension: Chatter Email Highlights Frequency Role: Discrete Dimension Remote Column: [Owned By].[DigestFrequency] Data Type: string Dimension: City (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[City] Data Type: string Dimension: Company Name Role: Discrete Dimension Remote Column: [Owned By].[CompanyName] Data Type: string Dimension: Contact ID Role: Discrete Dimension Remote Column: [Owned By].[ContactId] Data Type: string Dimension: ContentEmailAsAndWhen Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesContentEmailAsAndWhen] Data Type: boolean Dimension: ContentNoEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesContentNoEmail] Data Type: boolean Dimension: Country (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[Country] Data Type: string Dimension: CreatedById (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[CreatedById] Data Type: string Dimension: CreatedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[CreatedDate] Data Type: datetime Dimension: Data.com User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsJigsawProspectingUser] Data Type: boolean Dimension: Default Notification Frequency when Joining Groups Role: Discrete Dimension Remote Column: [Owned By].[DefaultGroupNotificationFrequency] Data Type: string Dimension: Delegated Approver ID Role: Discrete Dimension Remote Column: [Owned By].[DelegatedApproverId] Data Type: string Dimension: Department Role: Discrete Dimension Remote Column: [Owned By].[Department] Data Type: string Dimension: DisCommentAfterLikeEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisCommentAfterLikeEmail] Data Type: boolean Dimension: DisMentionsCommentEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisMentionsCommentEmail] Data Type: boolean Dimension: DisProfPostCommentEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisProfPostCommentEmail] Data Type: boolean Dimension: DisableAllFeedsEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableAllFeedsEmail] Data Type: boolean Dimension: DisableBookmarkEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableBookmarkEmail] Data Type: boolean Dimension: DisableChangeCommentEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableChangeCommentEmail] Data Type: boolean Dimension: DisableEndorsementEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableEndorsementEmail] Data Type: boolean Dimension: DisableFeedbackEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFeedbackEmail] Data Type: boolean Dimension: DisableFileShareNotificationsForApi Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFileShareNotificationsForApi] Data Type: boolean Dimension: DisableFollowersEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableFollowersEmail] Data Type: boolean Dimension: DisableLaterCommentEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableLaterCommentEmail] Data Type: boolean Dimension: DisableLikeEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableLikeEmail] Data Type: boolean Dimension: DisableMentionsPostEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableMentionsPostEmail] Data Type: boolean Dimension: DisableMessageEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableMessageEmail] Data Type: boolean Dimension: DisableProfilePostEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableProfilePostEmail] Data Type: boolean Dimension: DisableSharePostEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableSharePostEmail] Data Type: boolean Dimension: DisableWorkEmail Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesDisableWorkEmail] Data Type: boolean Dimension: Division Role: Discrete Dimension Remote Column: [Owned By].[Division] Data Type: string Dimension: Email (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[Email] Data Type: string Dimension: Email Encoding Role: Discrete Dimension Remote Column: [Owned By].[EmailEncodingKey] Data Type: string Dimension: Email Sender Address Role: Discrete Dimension Remote Column: [Owned By].[SenderEmail] Data Type: string Dimension: Email Sender Name Role: Discrete Dimension Remote Column: [Owned By].[SenderName] Data Type: string Dimension: Email Signature Role: Discrete Dimension Remote Column: [Owned By].[Signature] Data Type: string Dimension: Employee Number Role: Discrete Dimension Remote Column: [Owned By].[EmployeeNumber] Data Type: string Dimension: EnableAutoSubForFeeds Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesEnableAutoSubForFeeds] Data Type: boolean Dimension: EventRemindersCheckboxDefault Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesEventRemindersCheckboxDefault] Data Type: boolean Dimension: Extension Role: Discrete Dimension Remote Column: [Owned By].[Extension] Data Type: string Dimension: Fax Role: Discrete Dimension Remote Column: [Owned By].[Fax] Data Type: string Dimension: FirstName (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[FirstName] Data Type: string Dimension: Force.com Flow User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsInteractionUser] Data Type: boolean Dimension: HideCSNDesktopTask Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideCSNDesktopTask] Data Type: boolean Dimension: HideCSNGetChatterMobileTask Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideCSNGetChatterMobileTask] Data Type: boolean Dimension: HideChatterOnboardingSplash Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideChatterOnboardingSplash] Data Type: boolean Dimension: HideS1BrowserUI Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideS1BrowserUI] Data Type: boolean Dimension: HideSecondChatterOnboardingSplash Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesHideSecondChatterOnboardingSplash] Data Type: boolean Dimension: Info Emails Role: Discrete Dimension Remote Column: [Owned By].[ReceivesInfoEmails] Data Type: boolean Dimension: JigsawListUser Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesJigsawListUser] Data Type: boolean Dimension: Knowledge User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsKnowledgeUser] Data Type: boolean Dimension: Language Role: Discrete Dimension Remote Column: [Owned By].[LanguageLocaleKey] Data Type: string Dimension: Last Login Role: Discrete Dimension Remote Column: [Owned By].[LastLoginDate] Data Type: datetime Dimension: Last Password Change or Reset Role: Discrete Dimension Remote Column: [Owned By].[LastPasswordChangeDate] Data Type: datetime Dimension: LastModifiedById (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastModifiedById] Data Type: string Dimension: LastModifiedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastModifiedDate] Data Type: datetime Dimension: LastName (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastName] Data Type: string Dimension: LastReferencedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastReferencedDate] Data Type: datetime Dimension: LastViewedDate (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[LastViewedDate] Data Type: datetime Dimension: LightningExperiencePreferred Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesLightningExperiencePreferred] Data Type: boolean Dimension: Locale Role: Discrete Dimension Remote Column: [Owned By].[LocaleSidKey] Data Type: string Dimension: Manager ID Role: Discrete Dimension Remote Column: [Owned By].[ManagerId] Data Type: string Dimension: Marketing User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsMarketingUser] Data Type: boolean Dimension: Nickname Role: Discrete Dimension Remote Column: [Owned By].[CommunityNickname] Data Type: string Dimension: Offline Edition Trial Expiration Date Role: Discrete Dimension Remote Column: [Owned By].[OfflineTrialExpirationDate] Data Type: datetime Dimension: Offline User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsOfflineUser] Data Type: boolean Dimension: Phone (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[Phone] Data Type: string Dimension: Photo Role: Discrete Dimension Remote Column: [Owned By].[SmallPhotoUrl] Data Type: string Dimension: PostalCode (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[PostalCode] Data Type: string Dimension: Profile ID Role: Discrete Dimension Remote Column: [Owned By].[ProfileId] Data Type: string Dimension: ReminderSoundOff Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesReminderSoundOff] Data Type: boolean Dimension: Role ID Role: Discrete Dimension Remote Column: [Owned By].[UserRoleId] Data Type: string Dimension: SAML Federation ID Role: Discrete Dimension Remote Column: [Owned By].[FederationIdentifier] Data Type: string Dimension: Sales Anywhere Trial Expiration Date Role: Discrete Dimension Remote Column: [Owned By].[OfflinePdaTrialExpirationDate] Data Type: datetime Dimension: Salesforce CRM Content User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSFContentUser] Data Type: boolean Dimension: Service Cloud User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSupportUser] Data Type: boolean Dimension: ShowCityToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCityToExternalUsers] Data Type: boolean Dimension: ShowCityToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCityToGuestUsers] Data Type: boolean Dimension: ShowCountryToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCountryToExternalUsers] Data Type: boolean Dimension: ShowCountryToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowCountryToGuestUsers] Data Type: boolean Dimension: ShowEmailToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowEmailToExternalUsers] Data Type: boolean Dimension: ShowFaxToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowFaxToExternalUsers] Data Type: boolean Dimension: ShowManagerToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowManagerToExternalUsers] Data Type: boolean Dimension: ShowMobilePhoneToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowMobilePhoneToExternalUsers] Data Type: boolean Dimension: ShowPostalCodeToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowPostalCodeToExternalUsers] Data Type: boolean Dimension: ShowPostalCodeToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowPostalCodeToGuestUsers] Data Type: boolean Dimension: ShowProfilePicToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowProfilePicToGuestUsers] Data Type: boolean Dimension: ShowStateToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStateToExternalUsers] Data Type: boolean Dimension: ShowStateToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStateToGuestUsers] Data Type: boolean Dimension: ShowStreetAddressToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowStreetAddressToExternalUsers] Data Type: boolean Dimension: ShowTitleToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowTitleToExternalUsers] Data Type: boolean Dimension: ShowTitleToGuestUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowTitleToGuestUsers] Data Type: boolean Dimension: ShowWorkPhoneToExternalUsers Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesShowWorkPhoneToExternalUsers] Data Type: boolean Dimension: Site.com Contributor User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSiteforceContributorUser] Data Type: boolean Dimension: Site.com Publisher User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsSiteforcePublisherUser] Data Type: boolean Dimension: SortFeedByComment Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesSortFeedByComment] Data Type: boolean Dimension: State (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[State] Data Type: string Dimension: Stay-in-Touch Email Note Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchNote] Data Type: string Dimension: Stay-in-Touch Email Signature Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchSignature] Data Type: string Dimension: Stay-in-Touch Email Subject Role: Discrete Dimension Remote Column: [Owned By].[StayInTouchSubject] Data Type: string Dimension: StayInTouchReminder Role: Discrete Dimension Remote Column: [Owned By].[EmailPreferencesStayInTouchReminder] Data Type: boolean Dimension: Street (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[Street] Data Type: string Dimension: SystemModstamp (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[SystemModstamp] Data Type: datetime Dimension: TaskRemindersCheckboxDefault Role: Discrete Dimension Remote Column: [Owned By].[UserPreferencesTaskRemindersCheckboxDefault] Data Type: boolean Dimension: Time Zone Role: Discrete Dimension Remote Column: [Owned By].[TimeZoneSidKey] Data Type: string Dimension: Title (Owned By) Role: Discrete Dimension Remote Column: [Owned By].[Title] Data Type: string Dimension: Url for full-sized Photo Role: Discrete Dimension Remote Column: [Owned By].[FullPhotoUrl] Data Type: string Dimension: User Photo has a badge overlay Role: Discrete Dimension Remote Column: [Owned By].[IsBadged] Data Type: boolean Dimension: User Type Role: Discrete Dimension Remote Column: [Owned By].[UserType] Data Type: string Dimension: Username Role: Discrete Dimension Remote Column: [Owned By].[Username] Data Type: string Dimension: Work.com User Role: Discrete Dimension Remote Column: [Owned By].[UserPermissionsWorkDotComUserFeature] Data Type: boolean Calculated/Other Dimension: Measure Names Role: Discrete Dimension Data Type: string Dimension: Status (Simplified) Role: Discrete Dimension Data Type: string Formula: // This is an If Statement // It shows the opportunities status IF [Status]= "Closed - Converted" OR [Status]= "Closed - Not Converted" THEN [Status] ELSE "Open" END Dimension: NCS_TestData__Populated__c (Opportunity) Role: Discrete Dimension Data Type: boolean Dimension: Populate Account Role: Discrete Dimension Data Type: string Dimension: Populated Role: Discrete Dimension Data Type: boolean Measure Created By Measure: JigsawImportLimitOverride (Created By) Role: Continous Measure Remote Column: [Created By].[JigsawImportLimitOverride] Data Type: integer Measure: Latitude (Created By) Role: Continous Measure Remote Column: [Created By].[Latitude] Data Type: real Measure: Longitude (Created By) Role: Continous Measure Remote Column: [Created By].[Longitude] Data Type: real Measure: Id (Created By) Role: Continous Measure Remote Column: [Created By].[Id] Data Type: string Aggregation: Count Leads Measure: Annual Revenue Role: Continous Measure Remote Column: [Leads].[AnnualRevenue] Data Type: real Measure: Employees Role: Continous Measure Remote Column: [Leads].[NumberOfEmployees] Data Type: integer Measure: Latitude Role: Continous Measure Remote Column: [Leads].[Latitude] Data Type: real Measure: Longitude Role: Continous Measure Remote Column: [Leads].[Longitude] Data Type: real Measure: Number of Locations Role: Continous Measure Remote Column: [Leads].[NumberofLocations__c] Data Type: real Measure: Lead ID Role: Continous Measure Remote Column: [Leads].[Id] Data Type: string Aggregation: Count Measure: Converted Account ID Role: Continous Measure Remote Column: [Leads].[ConvertedAccountId] Data Type: string Aggregation: Count Measure: Converted Opportunity ID Role: Continous Measure Remote Column: [Leads].[ConvertedOpportunityId] Data Type: string Aggregation: Count Opportunity Measure: Amount Role: Continous Measure Remote Column: [Opportunity].[Amount] Data Type: real Measure: Expected Amount Role: Continous Measure Remote Column: [Opportunity].[ExpectedRevenue] Data Type: real Measure: Probability (%) Role: Continous Measure Remote Column: [Opportunity].[Probability] Data Type: real Measure: Quantity Role: Continous Measure Remote Column: [Opportunity].[TotalOpportunityQuantity] Data Type: real Measure: Opportunity ID Role: Continous Measure Remote Column: [Opportunity].[Id] Data Type: string Aggregation: Count Owned By Measure: Data.com Monthly Addition Limit Role: Continous Measure Remote Column: [Owned By].[JigsawImportLimitOverride] Data Type: integer Measure: Latitude (Owned By) Role: Continous Measure Remote Column: [Owned By].[Latitude] Data Type: real Measure: Longitude (Owned By) Role: Continous Measure Remote Column: [Owned By].[Longitude] Data Type: real Measure: User ID Role: Continous Measure Remote Column: [Owned By].[Id] Data Type: string Aggregation: Count Measure: Name (Owned By) Role: Continous Measure Remote Column: [Owned By].[Name] Data Type: string Aggregation: Count Calculated/Other Measure: Total Leads Role: Continous Measure Data Type: integer Formula: //This is a calculation //It counts the number of distinct leads COUNTD([Lead ID]) Measure: # Converted Opportunities Role: Continous Measure Data Type: integer Formula: //This is a calculation //It counts the number of distinct converted opportunities COUNTD([Converted Opportunity ID]) Measure: Expected Amount from Converted Leads Role: Continous Measure Data Type: real Formula: [Expected Amount] Measure: # Converted Accounts Role: Continous Measure Data Type: integer Formula: // This is a calculation //It counts the number of distinct converted accounts COUNTD([Converted Account ID]) Measure: Conversion Rate Role: Continous Measure Data Type: real Formula: // This is an If Statement // It shows true and counts if a lead is converted ZN(COUNTD(IF [Converted]=TRUE THEN [Lead ID] END)) / COUNTD([Lead ID]) Measure: Measure Values Role: Continous Measure Data Type: real Measure: Number of Records Role: Continous Measure Data Type: integer Formula: 1 Semantic Values [Country].[Name]: "United States" Dashboards Dashboard: Marketing Leads Worksheets Worksheet: Total Leads 2 Datasources: login.salesforce.com Used Dimensions & Measures: [# Converted Accounts] [# Converted Opportunities] [City] [Conversion Rate] [Converted Account ID] [Converted Opportunity ID] [Converted] [Country] [Created Date] [Expected Amount from Converted Leads] [Expected Amount] [Industry] [Lead ID] [Lead Source] [Name (Owned By)] [State/Province] [Status] [Total Leads] Used Remote Columns: [Leads].[City] [Leads].[ConvertedAccountId] [Leads].[ConvertedOpportunityId] [Leads].[Country] [Leads].[CreatedDate] [Leads].[Id] [Leads].[Industry] [Leads].[IsConverted] [Leads].[LeadSource] [Leads].[State] [Leads].[Status] [Opportunity].[ExpectedRevenue] [Owned By].[Name] Worksheet: Monthly Goal Datasources: login.salesforce.com Parameters Used Dimensions & Measures: [City] [Country] [Created Date] [Define Monthly Goal (# New Leads)] [Industry] [Lead ID] [Lead Source] [Name (Owned By)] [State/Province] [Status] Used Remote Columns: [Leads].[City] [Leads].[Country] [Leads].[CreatedDate] [Leads].[Id] [Leads].[Industry] [Leads].[LeadSource] [Leads].[State] [Leads].[Status] [Owned By].[Name] Worksheet: Leads by Source Datasources: login.salesforce.com Used Dimensions & Measures: [City] [Country] [Created Date] [Expected Amount] [Industry] [Lead ID] [Lead Source] [Name (Owned By)] [Number of Records] [State/Province] [Status (Simplified)] [Status] [Total Leads] Used Remote Columns: [Leads].[City] [Leads].[Country] [Leads].[CreatedDate] [Leads].[Id] [Leads].[Industry] [Leads].[LeadSource] [Leads].[State] [Leads].[Status] [Opportunity].[ExpectedRevenue] [Owned By].[Name] Worksheet: Leads By Geography Datasources: login.salesforce.com Used Dimensions & Measures: [# Converted Opportunities] [City] [Conversion Rate] [Converted Opportunity ID] [Converted] [Country] [Created Date] [Industry] [Lead ID] [Lead Source] [Name (Owned By)] [State/Province] [Status] Used Remote Columns: [Leads].[City] [Leads].[ConvertedOpportunityId] [Leads].[Country] [Leads].[CreatedDate] [Leads].[Id] [Leads].[Industry] [Leads].[IsConverted] [Leads].[LeadSource] [Leads].[State] [Leads].[Status] [Owned By].[Name] Worksheet: Leads by Industry Datasources: login.salesforce.com Used Dimensions & Measures: [# Converted Opportunities] [City] [Conversion Rate] [Converted Opportunity ID] [Converted] [Country] [Created Date] [Industry] [Lead ID] [Lead Source] [Name (Owned By)] [Number of Records] [State/Province] [Status] Used Remote Columns: [Leads].[City] [Leads].[ConvertedOpportunityId] [Leads].[Country] [Leads].[CreatedDate] [Leads].[Id] [Leads].[Industry] [Leads].[IsConverted] [Leads].[LeadSource] [Leads].[State] [Leads].[Status] [Owned By].[Name] Dashboard Objects: Filter: [login.salesforce.com].[Country] Filter: [login.salesforce.com].[State/Province] Filter: [login.salesforce.com].[Status] Filter: [login.salesforce.com].[Lead Source] Filter: [login.salesforce.com].[DAY(Created Date)] Text: Use Options Below to Filter Text: Æ Text: Æ Worksheets Worksheet: Leads By Geography Visible: No Used Datasources Datasource: login.salesforce.com Discrete Dimension: City Remote Column: [Leads].[City] Discrete Dimension: Converted Opportunity ID Remote Column: [Leads].[ConvertedOpportunityId] Discrete Dimension: Converted Remote Column: [Leads].[IsConverted] Discrete Dimension: Country Remote Column: [Leads].[Country] Discrete Dimension: Created Date Remote Column: [Leads].[CreatedDate] Discrete Dimension: Industry Remote Column: [Leads].[Industry] Discrete Dimension: Lead ID Remote Column: [Leads].[Id] Discrete Dimension: Lead Source Remote Column: [Leads].[LeadSource] Discrete Dimension: Name (Owned By) Remote Column: [Owned By].[Name] Discrete Dimension: State/Province Remote Column: [Leads].[State] Discrete Dimension: Status Remote Column: [Leads].[Status] Continous Measure: # Converted Opportunities Continous Measure: Conversion Rate Marks Mark: All Type: Circle Tooltip: <[login.salesforce.com].[City]> <[login.salesforce.com].[Lead ID]> leads <[login.salesforce.com].[Conversion Rate]> converted View Rows: [login.salesforce.com].[Latitude (generated)] Columns: [login.salesforce.com].[Longitude (generated)] Filters: [login.salesforce.com].[Action (DAY(Created Date))] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Country] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] Slices: [login.salesforce.com].[Status] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[Country] [login.salesforce.com].[State/Province] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Action (DAY(Created Date))] Styles Style: table Other show-null-value-warning: false Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #f2f2f3 Style: map-layer tab_base enabled: true um_lcover enabled: true tab_coastline enabled: true pp2_line enabled: false light_adm0_bnd enabled: false light_adm0_lbl enabled: false um_adm0_bnd enabled: true um_adm0_lbl enabled: false light_pp2_statebounds enabled: false light_pp2_statelabels enabled: false pp2_adminlabels enabled: false pp2_statebounds enabled: false pp2_statelabels enabled: true countybounds enabled: false countylabels enabled: false zipbounds enabled: false ziplabels enabled: false tab_areabounds enabled: false tab_arealabels enabled: false tab_msabounds enabled: false tab_msalabels enabled: false Style: map Other washout: 0.5 Style: quick-filter [login.salesforce.com].[Name (Owned By)] title: Salesperson Other font-family: Tableau Book Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal Worksheet: Leads by Industry Visible: No Used Datasources Datasource: login.salesforce.com Discrete Dimension: City Remote Column: [Leads].[City] Discrete Dimension: Converted Opportunity ID Remote Column: [Leads].[ConvertedOpportunityId] Discrete Dimension: Converted Remote Column: [Leads].[IsConverted] Discrete Dimension: Country Remote Column: [Leads].[Country] Discrete Dimension: Created Date Remote Column: [Leads].[CreatedDate] Discrete Dimension: Industry Remote Column: [Leads].[Industry] Discrete Dimension: Lead ID Remote Column: [Leads].[Id] Discrete Dimension: Lead Source Remote Column: [Leads].[LeadSource] Discrete Dimension: Name (Owned By) Remote Column: [Owned By].[Name] Discrete Dimension: State/Province Remote Column: [Leads].[State] Discrete Dimension: Status Remote Column: [Leads].[Status] Continous Measure: # Converted Opportunities Continous Measure: Conversion Rate Continous Measure: Number of Records Marks Mark: All Type: Automatic Label: <[login.salesforce.com].[Industry]> <[login.salesforce.com].[SUM(Number of Records)]> Tooltip: <[login.salesforce.com].[Industry]> <[login.salesforce.com].[SUM(Number of Records)]> leads <[login.salesforce.com].[Conversion Rate]> converted View Filters: [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (DAY(Created Date))] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Action (Lead Source)] [login.salesforce.com].[Action (LeadSource)] [login.salesforce.com].[Country] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] Slices: [login.salesforce.com].[Action (Lead Source)] [login.salesforce.com].[Action (LeadSource)] [login.salesforce.com].[Status] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[Country] [login.salesforce.com].[State/Province] [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Action (DAY(Created Date))] Styles Style: cell [login.salesforce.com].[SUM(Number of Records)] Style: label [login.salesforce.com].[SUM(Number of Records)] [login.salesforce.com].[Industry] font-family: Tableau Book font-size: 9 font-weight: normal Style: pane rows border-style: none cols border-style: none Style: worksheet rows display-field-labels: false Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #f2f2f3 Style: legend Other background-color: #ffffff Worksheet: Leads by Source Visible: No Used Datasources Datasource: login.salesforce.com Discrete Dimension: Status (Simplified) Discrete Dimension: City Remote Column: [Leads].[City] Discrete Dimension: Country Remote Column: [Leads].[Country] Discrete Dimension: Created Date Remote Column: [Leads].[CreatedDate] Discrete Dimension: Industry Remote Column: [Leads].[Industry] Discrete Dimension: Lead ID Remote Column: [Leads].[Id] Discrete Dimension: Lead Source Remote Column: [Leads].[LeadSource] Discrete Dimension: Name (Owned By) Remote Column: [Owned By].[Name] Discrete Dimension: State/Province Remote Column: [Leads].[State] Discrete Dimension: Status Remote Column: [Leads].[Status] Continous Measure: Total Leads Continous Measure: Expected Amount Remote Column: [Opportunity].[ExpectedRevenue] Continous Measure: Number of Records Marks Mark: All Type: Automatic Label: <[login.salesforce.com].[SUM(Number of Records)]> Tooltip: <[login.salesforce.com].[Lead Source]> <[login.salesforce.com].[Status (Simplified)]>: <[login.salesforce.com].[SUM(Number of Records)]> leads <[login.salesforce.com].[SUM(Expected Amount)]> Mark: [login.salesforce.com].[Total Leads] Type: Automatic Tooltip: <[login.salesforce.com].[Lead Source]> <[login.salesforce.com].[Status (Simplified)]>: <[login.salesforce.com].[SUM(Number of Records)]> leads <[login.salesforce.com].[SUM(Expected Amount)]> Mark: [login.salesforce.com].[SUM(Expected Amount)] Type: Automatic Tooltip: <[login.salesforce.com].[Lead Source]> <[login.salesforce.com].[Status (Simplified)]>: <[login.salesforce.com].[SUM(Number of Records)]> leads <[login.salesforce.com].[SUM(Expected Amount)]> View Rows: [login.salesforce.com].[Lead Source] Columns: [login.salesforce.com].[Total Leads] [login.salesforce.com].[SUM(Expected Amount)] Filters: [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (DAY(Created Date))] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Country] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] Manual Sorting: [login.salesforce.com].[Status (Simplified)] ASC Slices: [login.salesforce.com].[Status] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Created Date] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[Country] [login.salesforce.com].[State/Province] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (DAY(Created Date))] Styles Style: axis [login.salesforce.com].[SUM(Expected Amount)] auto-subtitle: true height: 28 [login.salesforce.com].[SUM(Number of Records)] height: 28 [login.salesforce.com].[Total Leads] auto-subtitle: true height: 28 Other line-pattern-only: solid stroke-color: #c2d0ca line-visibility: off Style: cell [login.salesforce.com].[Lead Source] height: 28 Other font-family: Tableau Bold [login.salesforce.com].[SUM(Expected Amount)] Style: header [login.salesforce.com].[Lead Source] width: 128 Other border-style: none Style: label [login.salesforce.com].[Lead Source] font-family: Tableau Book font-weight: normal font-size: 8 [login.salesforce.com].[SUM(Number of Records)] font-family: Tableau Book [login.salesforce.com].[SUM(Expected Amount)] font-family: Tableau Book [login.salesforce.com].[Total Leads] font-family: Tableau Book Style: pane Other border-style: none Style: table Other show-null-value-warning: false Style: worksheet rows display-field-labels: false Style: zeroline Other line-visibility: off Style: table-div rows line-visibility: off cols div-level: 2 line-pattern-only: solid stroke-size: 3 stroke-color: #f5f5f5 line-visibility: off Style: title Other background-color: #f2f2f3 Style: legend Other background-color: #ffffff Style: quick-filter Other background-color: #ffffff font-family: Tableau Book font-size: 8 color: #555555 Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal Worksheet: Monthly Goal Visible: No Used Datasources Datasource: Parameters Continous Measure: Define Monthly Goal (# New Leads) Datasource: login.salesforce.com Discrete Dimension: City Remote Column: [Leads].[City] Discrete Dimension: Country Remote Column: [Leads].[Country] Discrete Dimension: Created Date Remote Column: [Leads].[CreatedDate] Discrete Dimension: Industry Remote Column: [Leads].[Industry] Discrete Dimension: Lead ID Remote Column: [Leads].[Id] Discrete Dimension: Lead Source Remote Column: [Leads].[LeadSource] Discrete Dimension: Name (Owned By) Remote Column: [Owned By].[Name] Discrete Dimension: State/Province Remote Column: [Leads].[State] Discrete Dimension: Status Remote Column: [Leads].[Status] Marks Mark: All Type: Automatic Tooltip: <[login.salesforce.com].[DAY(Created Date)]> Running Total of Leads: <[login.salesforce.com].[Lead ID]> View Rows: [login.salesforce.com].[Lead ID] Columns: [login.salesforce.com].[DAY(Created Date)] Filters: [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Country] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] [login.salesforce.com].[DAY(Created Date)] Slices: [login.salesforce.com].[DAY(Created Date)] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[Country] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (Lead Source) 1] Styles Style: axis [login.salesforce.com].[DAY(Created Date)] auto-subtitle: true height: 29 [login.salesforce.com].[Lead ID] width: 60 auto-subtitle: true Other tick-color: #00000000 line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: label [login.salesforce.com].[Lead ID] font-family: Tableau Book font-weight: normal [login.salesforce.com].[DAY(Created Date)] Style: worksheet Other font-family: Tableau Book Style: refline refline0 fill-above: #00000000 font-family: Tableau Book font-size: 6 fill-below: #00000000 stroke-size: 1 stroke-color: #f28e2b Style: gridline Other line-visibility: off Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #eef1f3 Style: quick-filter [login.salesforce.com].[DAY(Created Date)] title: Created Date Style: quick-filter-title Other font-family: Tableau Regular font-size: 8 font-weight: normal color: #333333 Worksheet: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Total Leads 2 Visible: No Used Datasources Datasource: login.salesforce.com Discrete Dimension: City Remote Column: [Leads].[City] Discrete Dimension: Converted Account ID Remote Column: [Leads].[ConvertedAccountId] Discrete Dimension: Converted Opportunity ID Remote Column: [Leads].[ConvertedOpportunityId] Discrete Dimension: Converted Remote Column: [Leads].[IsConverted] Discrete Dimension: Country Remote Column: [Leads].[Country] Discrete Dimension: Created Date Remote Column: [Leads].[CreatedDate] Discrete Dimension: Industry Remote Column: [Leads].[Industry] Discrete Dimension: Lead ID Remote Column: [Leads].[Id] Discrete Dimension: Lead Source Remote Column: [Leads].[LeadSource] Discrete Dimension: Name (Owned By) Remote Column: [Owned By].[Name] Discrete Dimension: State/Province Remote Column: [Leads].[State] Discrete Dimension: Status Remote Column: [Leads].[Status] Continous Measure: Total Leads Continous Measure: # Converted Opportunities Continous Measure: Expected Amount from Converted Leads Continous Measure: # Converted Accounts Continous Measure: Conversion Rate Continous Measure: Expected Amount Remote Column: [Opportunity].[ExpectedRevenue] Marks Mark: All Type: Automatic Label: <[login.salesforce.com].[Multiple Values]> Tooltip: Leads View Columns: [login.salesforce.com].[Measure Names()] Filters: [login.salesforce.com].[Measure Names()] [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (DAY(Created Date))] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Country] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[State/Province] [login.salesforce.com].[Status] Manual Sorting: [login.salesforce.com].[Measure Names()] ASC Slices: [login.salesforce.com].[Measure Names()] [login.salesforce.com].[Status] [login.salesforce.com].[Created Date] [login.salesforce.com].[Lead Source] [login.salesforce.com].[Name (Owned By)] [login.salesforce.com].[Country] [login.salesforce.com].[State/Province] [login.salesforce.com].[Action (Industry)] [login.salesforce.com].[Action (City,Country)] [login.salesforce.com].[Action (Lead Source) 1] [login.salesforce.com].[Action (DAY(Created Date))] Styles Style: axis Other stroke-size: 4 line-pattern-only: solid line-visibility: off Style: cell [login.salesforce.com].[SUM(Expected Amount from Converted Leads)] text-format: c"$"#,##0,.0K;("$"#,##0,.0K) Style: header [login.salesforce.com].[Measure Names()] height: 40 background-color: #f2f2f3 Other border-style: none Style: label [login.salesforce.com].[Measure Names()] vertical-align: center text-align: center color: #333333 font-family: Tableau Regular font-size: 9 font-weight: normal Style: pane Other border-style: none Style: table Other background-color: #00000000 Style: worksheet Other color: #333333 Style: gridline Other stroke-size: 4 line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: table-div rows line-visibility: off cols div-level: 1 stroke-size: 4 line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 Style: header-div cols line-visibility: on line-pattern-only: solid Style: title Other background-color: #f2f2f3