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