Report Summary

Need help figuring out what this report is and what it contains? Below you will find a brief report description as well as necessary data definitions.

The Healthify PHI Searches Extract enables all customers to receive automatic exports of search activity with identifiable patient information included. Customers may receive this file on a selected time interval (typically monthly or weekly) delivered as a zipped CSV file via SFTP upload.

Each row represents a single search performed within Healthify during the report's date range. The file will be filtered by the Network, Company, or Team, as well as the defined date range (i.e. past month, week, day, etc.). The rows will be sorted in chronological order based on the Search Started Time.

Data Definitions

Fields are listed in the order they appear in the Searches Extract.

Search UUID: The unique identifier of the search. A search is one or more search events performed by the same user with identical search queries and filters, where each event occurs within 5 minutes of the last. Search query and filters include: search query (free text), geolocated city or zip code, radius, service offerings, eligibilities, In-Network only, preferred providers only, and wheelchair accessible filters.

Search Started Date: The date the user performed the search in the company or network's time zone. Formatted YYYY-MM-DD (although data analysis tools such as Excel may automatically convert dates to your system’s default date format).

Search Started Time: The time the user performed the search in the company or network's time zone. Formatted in 24-hour time.

Search Completed Time: The time the user completed the search in the company or network's time zone. Formatted in 24-hour time. (Note: In the event that a performed search consists of one search event, this would be identical to the Search Started Time.)

User ID: The unique identifier of the user who performed the search.

User First Name: The current first name of the user who performed the search. (Note: If the user's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

User Last Name: The current last name of the user who performed the search. (Note: if the user's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Team ID: The unique identifier of the team of the user who performed the search at the time of the search starting. A team is a group of users which belongs to a company. (Note: If the user has changed teams after performing the search, this value will still represent the user's team when the search was started, not the user's current team.)

Team Name: The current name of the team of the user who performed the search at the time of the search starting. A team is a group of users which belongs to a company. (Note: If the team's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Company ID: The unique identifier of the company of the user who performed the search at the time of a search starting. (Note: If the user has changed companies after performing the search, this value will still represent the user's company when the search was started, not the user's current company.)

Company Name: The current name of the company of the user who performed the search at the time of a search starting. (Note: If the company's name has changed at any point, this value will represent the most current name as of the time that the report was pulled.)

Search Query: The search query entered by the user as free text.

Geolocated Address Line 1: Line 1 of the geolocated address of the location entered by the user. If the geolocation service cannot determine an address, then this will be empty.

Geolocated Zip Code: The geolocated zip code of the location entered by the user. If the geolocation service cannot determine a zip code, then this will be empty.

Geolocated City: The geolocated city of the location entered by the user. If the geolocation service cannot determine a city, then this will be empty.

Geolocated State: The geolocated state of the location entered by the user. If the geolocation service cannot determine a state, then this will be empty.

Converted to Referral (Yes / No): Whether or not the search resulted in at least one Out-of-Network, In-Network, or In-Network - Preferred referral being created.

Search Highest Page Viewed: The highest search result page number that the user viewed during the search.

Filtered In-Network Partners Only: Whether or not the In-Network Partners Only filter has been applied during the search.

Filtered Preferred Providers Only: Whether or not the Preferred Providers Only filter has been applied during the search.

Filtered Wheelchair Accessible: Whether or not the Wheelchair Accessible filter has been applied during the search.

Filtered Radius: The user-selected radius (in miles) around the search's geolocation within which the search displayed results.

Search Query Category Name: An applied single category for the search query based on keywords, service offerings, and program popularity for reporting purposes.

Filtered Service Offering Name List: The service offering(s) filters included in the search. Values come from Healthify's Service Offerings taxonomy. Users may select zero, one, or many service offerings for a search. Provided as a semicolon-separated list sorted in alphabetical order.

For example, a search may include service offerings filters of "Food pantries" and "Affordable food."

Filtered Service Offering Count: The number of service offering filters applied to the search.

Filtered Service Offering Category Name List: The social determinants of health (SDoH) domain category(ies) of the user-selected service offerings filters. Values come from Healthify's Service Offerings taxonomy. Provided as a semicolon-separated list sorted in alphabetical order.

Each service offering belongs to one category for reporting purposes. Categories which contain multiple service offerings connected to the search will only appear once. For example, if the service offerings list shows "Affordable food" and "Food pantries", both of which are within the "Food" category, the Service Offerings Categories List will display "Food."

Filtered Service Offerings Category Count: The unique number of service offering categories that the service offering filter(s) apply to.

Filtered Eligibility Name List: The eligibility(ies) filters applied to the search. Users may select zero, one, or many eligibilities for a search. Provided as a semicolon-separated list sorted in alphabetical order.

For example, a search may include eligibility filters of "Refugees" and "Veterans".

Filtered Eligibility Count: The number of eligibility filters applied to the search.

Converted Referral Count: The number of referrals created as a result of the search.

Converted Referral ID List: A comma-separated list of unique identifiers of referrals created as a result of the search.