{"id":2913,"date":"2015-12-07T14:57:02","date_gmt":"2015-12-07T14:57:02","guid":{"rendered":"http:\/\/myhomekeeper.org\/?p=2913"},"modified":"2015-12-07T14:57:02","modified_gmt":"2015-12-07T14:57:02","slug":"homekeeperreporttypes","status":"publish","type":"post","link":"https:\/\/myhomekeeper.org\/homekeeperreporttypes\/","title":{"rendered":"Make Reporting A Breeze with these 5 HomeKeeper Report Types"},"content":{"rendered":"

Learn the trick to understanding Salesforce’s report types, plus the our 5 favorite Report Types (Skip to the bottom to see our favorites).<\/p>\n

When you decide you want to start customizing your own reports in Salesforce, things can get tricky. Your first prompt is to select a \u201creport type\u201d… which may send you into fits of confusion-which is totally understandable, if you type in \u201cproperties\u201d and see \u00a0this list!\"reportypes\"<\/p>\n

With a little help you’ll get the hang of this!<\/span><\/p>\n

Choosing a Report Type is like choosing which \u201cuniverse of fields\u201d you want to dive into. <\/b><\/h2>\n

We like this definition better than saying “Report Types \u00a0determine which records and data get displayed in the rows of reports,” though that’s true, too. It’s the set of records you’ll then be filtering and grouping and summarizing as you customize \u00a0your report. Luckily for you HomeKeeper comes with a lot of predefined report types, which means you don’t have to build them yourself (just the reports). The name of the report type gives you some big clues about what “universe” you’re diving into.. \u00a0once you know the trick of the rough naming convention, you’ll be ready to start building reports:<\/p>\n

Generally, \u201cX with Y\u201d means each row in the report will be a Y record, but you can also report on the X record’s fields.<\/em><\/p>\n

Enough with X’s and Y’s. For a real example, lets say your program has 3 Homeowners: the Contreras, Theriault and Chaundry families. They each have a Service File, but only the Contreras and Theriault families have had any delinquency related Monitoring Events. If you choose:<\/p>\n

\u00a0Services with Monitoring Events<\/strong><\/span><\/p>\n

\"sWm\"<\/span><\/p>\n

\u00a0You’ll see every single Monitoring Event, along with those Monitoring Events’ Service Files’ fields, but you won’t see any Service Files without Monitoring Events. This means you’ll see the Theriault and Contreras families in the report and can access fields on the Service File level (like Race), but that each row will be one of the unique Monitoring Events.. for example, the Theriault Service File shows on 2 lines, one for their Foreclosure Monitoring Event, and one for their Late Payment Monitoring Event. You’ll also see that the Chaudry family’s Service File doesn’t appear, because they don’t have any Monitoring Events!<\/span><\/p>\n

\"sWmSF\"<\/a><\/strong><\/strong><\/p>\n

 <\/p>\n

Services<\/strong><\/p>\n

\"SF\"You’ll see every single Service File, period! This will include Chaudry Service File, because the report type is plain Services.. not “Services with X Object”.<\/p>\n

\"SSF\"<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Our \u00a05 Favorite Report Types<\/h1>\n

To help you report, we’ve listed the report types we see users using most frequently. Take a look to jump start your reporting!<\/p>\n

1. Properties<\/b><\/h2>\n

Each row is for one Property. Access to all Property fields.<\/span><\/p>\n

Example Reports:<\/span><\/p>\n

    \n
  1. Count Properties by # of Bedrooms<\/span><\/li>\n
  2. Group Properties by Source of Home<\/span><\/li>\n
  3. Graph Properties by Date Placed in Portfolio<\/span><\/li>\n<\/ol>\n

    2. Services with Funding Sources<\/b><\/h2>\n

    Each row is for a Funding Source, and includes each Funding Source’s related Service File fields.<\/span><\/p>\n

    Example Reports<\/span><\/p>\n

      \n
    1. Total the Lenders who’ve lent the largest volume to your buyers<\/span><\/li>\n
    2. See the average amount of Buyer’s Cash your buyers bring to closing<\/span><\/li>\n<\/ol>\n

      3. Services with Property, Applicant & Co-Applicant<\/b><\/h2>\n

      Each row is a Service File, with it’s related Property, Applicant and Co-Applicant fields available on each row, if they are connected. \u00a0<\/span> \u00a0Lookup fields are \u201ckeys\u201d in the universe of fields. \u00a0Another cool thing about report types is that it’s possible to access related fields from the core objects. For example, in when you use the Services with Property, Applicant and Co-Applicant report above, if a Service File has a connected Property, Applicant or Co-Applicant, you can report on those object’s attritbutes.. for example the # of Bedrooms or County of the Property. This is possible with any lookup, but only a few of the report types that come with HomeKeeper have it built in.<\/p>\n

      Example Reports:<\/span><\/p>\n

        \n
      1. Phonebook of Owners’ Applicants and Co-Applicants<\/span><\/li>\n
      2. Report on Buyers and their Desired # Bedrooms vs. actual # of Bedrooms in their Property<\/span><\/li>\n<\/ol>\n

        4. Opportunities w\/ Allocations + Owner Service File<\/b><\/h2>\n

        New with Version 1.11 of HomeKeeper! Each row is an Allocation, with its related Opportunity fields available. If a Service File allocation the related Service File’s income fields are available. If a Property allocation, the related Property’s Current Owner Service File’s income fields are available.<\/span><\/p>\n

        Example:<\/span><\/p>\n

          \n
        1. Show incomes of buyers who accessed a particular opportunity<\/span><\/li>\n
        2. Show all allocations in Salesforce<\/span><\/li>\n<\/ol>\n

          5. Contacts & Accounts (with a Cross \u00a0Filter!)<\/b><\/h2>\n

          Each row in the Contacts report is a Contact Record. Use a Cross Filter to filter the contacts based on their relationship with other objects.<\/span><\/p>\n

            \n
          1. All Loan Officers for Sale Pending Service Files<\/span><\/li>\n
          2. All Current Occupants of a Property<\/span><\/li>\n<\/ol>\n

            It’s confusing, don’t hesitate to reach out!<\/h1>\n

            For more tips \u00a0 \u00a0take a look at our Reporting How-To Forum<\/a>, plus our HomeKeeper Reporting Workbook<\/a>. If in doubt about a report on HomeKeeper objects send in a ticket<\/a>, and we can probably talk you through!<\/p>\n","protected":false},"excerpt":{"rendered":"

            Learn the trick to understanding Salesforce’s report types, plus the our 5 favorite Report Types (Skip to the bottom to see our favorites). When you decide you want to start customizing your own reports in Salesforce, things can get tricky. Your first prompt is to select a \u201creport type\u201d… which may send you into fits<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_mi_skip_tracking":false,"wds_primary_category":0},"categories":[15,9],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/posts\/2913"}],"collection":[{"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/comments?post=2913"}],"version-history":[{"count":0,"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/posts\/2913\/revisions"}],"wp:attachment":[{"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/media?parent=2913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/categories?post=2913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myhomekeeper.org\/wp-json\/wp\/v2\/tags?post=2913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}