config/annotations/reporting/Leads.yaml

name: "{{ project_id_tgt }}.{{ sfdc_datasets_reporting }}.Leads"
description: "Leads data."
catalog_tags:
  - display_name: "line_of_business"
    fields:
      - display_name: "group"
        value: "Customer Relationship Management"
      - display_name: "domain"
        value: "Leads and Opportunity Management"
fields:
  - name: "LeadId"
    description: "Lead ID"
  - name: "AnnualRevenue"
    description: "Annual Revenue"
  - name: "City"
    description: "City"
  - name: "Company"
    description: "Company"
  - name: "ConvertedAccountId"
    description: "Converted Account ID"
  - name: "ConvertedContactId"
    description: "Converted Contact ID"
  - name: "ConvertedDate"
    description: "Converted Date"
  - name: "ConvertedOpportunityId"
    description: "Converted Opportunity ID"
  - name: "Country"
    description: "Country"
  - name: "CreatedById"
    description: "ID of the User who created this Lead"
  - name: "CreatedDatestamp"
    description: "Created Date Timestamp"
  - name: "Description"
    description: "Description of Lead"
  - name: "Email"
    description: "Email"
  - name: "FirstName"
    description: "First Name"
  - name: "GeocodeAccuracy"
    description: "Geocode Accuracy"
  - name: "IndividualId"
    description: "Individual ID"
  - name: "Industry"
    description: "Industry"
  - name: "IsConverted"
    description: "Converted"
  - name: "IsUnreadByOwner"
    description: "Unread By Owner"
  - name: "LastActivityDate"
    description: "Last Activity"
  - name: "LastModifiedById"
    description: "ID of the last User who modified this Lead"
  - name: "LastModifiedDatestamp"
    description: "Last Modified Date"
  - name: "LastName"
    description: "Last Name"
  - name: "Latitude"
    description: "Latitude"
  - name: "LeadSource"
    description: "Lead Source"
  - name: "Longitude"
    description: "Longitude"
  - name: "MasterRecordId"
    description: "Master Record ID"
  - name: "Name"
    description: "Name of Lead"
  - name: "NumberOfEmployees"
    description: "Employees"
  - name: "OwnerID"
    description: "Owner ID"
  - name: "Phone"
    description: "Phone"
  - name: "PostalCode"
    description: "Zip/Postal Code"
  - name: "Rating"
    description: "Rating"
  - name: "RecordTypeID"
    description: "Record Type ID"
  - name: "Salutation"
    description: "Salutation"
  - name: "State"
    description: "State/Province"
  - name: "Status"
    description: "Status"
  - name: "Street"
    description: "Street"
  - name: "Title"
    description: "Title"
  - name: "Website"
    description: "Website"
  - name: "EmailBouncedDatestamp"
    description: "Email Bounced Date"
  - name: "EmailBouncedReason"
    description: "Email Bounced Reason"
  - name: "Jigsaw"
    description: "Data.com Key"
  - name: "JigsawContactId"
    description: "Jigsaw Contact ID"
  - name: "LastReferencedDatestamp"
    description: "Last Referenced Date"
  - name: "LastViewedDatestamp"
    description: "Last Viewed Date"
  - name: "PhotoUrl"
    description: "Photo URL"
  - name: "LeadCreatedDate"
    description: "Created date."
  - name: "LeadCreatedWeek"
    description: "Week in which this is created."
  - name: "LeadCreatedMonth"
    description: "Month in which this is created."
  - name: "LeadCreatedQuarter"
    description: "Quarter in which this is created."
  - name: "LeadCreatedYear"
    description: "Year in which this is created."