Please enable JavaScript.

Coggle requires JavaScript to display documents.

Attom Data Flow, RAW Attom Data - Coggle Diagram

- - - - Remove Key Words
        (Railroad, Government, City, Association, ect)
  - - - Filter Out Owner Duration
        
        Filter out CRM DNC
    - - Every property (Row) that has been brought into the Master List is visually checked via satellite imagery and given a qualification note for most appropriate form of marketing.
      - Generate Marketing List/Report
        
        Every qualified row is processed by a google apps script or macro to create an appropriate mailing list for the category of marketing:
        Neutral Letter
        Offer Letter
        Text Campaign
        This report is a selection of columns (not all) from the master list that are related to the form of marketing being processed.
        Note: At this step "Portfolio Owners" (property owners that own more then one qualified property in our Master List are merged into a single row, some information such as APN and AC is merged into a single cell comma separated while other data such as offer amount is summed into a total for the row (One Portfolio Offer)
        
        Generate Podio Report
        
        Similar to the Marketing Report, in this step another selection of columns (more columns are included for due diligence/property profile/owner profile reasons) is gathered from the Master List and then processed to merge Portfolio Owners into one row.
        This report is then uploaded into our CRM system as a reference to every marketing record we send out.
      - Supercharged Offers
        
        How will Portfolio Owners be processed?
        
        How will we mirror offers sent by supercharged in our CRM (Podio)?