• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Medicom Health HomepageMedicom Health

Contact Us
  • Health Risk Assessments
  • Company
  • Support
    • HRA Management Portal
    • HRA Support Articles
    • Contact Support

Support Articles

  • Overview
  • Case Studies
  • Blog & News
  • Events & Webinars
  • Support Articles

Support Topic: Common Questions

How to Use Raw Data Reports to Create Targeted Lists

You can use raw data reports to create highly targeted follow-up lists using the filter function in Excel. This function allows you to more quickly identify the individuals you want to reach out to the most, based on a variety of different data collected from their Profiler results.

Download Your Raw Data Report

You’ll need to download your raw data report to be able to create a targeted list.

  1. On your Client Portal, click ‘Raw Data’ on the left sidebar (under ‘Reports’ tab)
  2. Click ‘Generate Raw Data Report’
  3. Select Profiler & App from dropdown
  4. Select Protected Health Information from User Completions in ‘Report Details’ Section
  5. Click ‘Create Raw Data Report’
  6. Scroll to the report you wish to download, click the dropdown and select ‘Raw Data Report’
  7. Report will download as CSV. Double-click to open report.
  8. Copy/Paste the links from the CSV file into the SAME web browser used to generate report (you must be logged-in to your Client Portal for access)
  9. Your report will download automatically

Filter by Your Desired Metrics

Once you have your raw data report, you can use the filter function to identify users who match any set of specific criteria you’d like to message to.

On Mac:

  1. Select the column you’re interested in sorting. For example, this might be BMI Risk Category, Smoking Status, Diabetes Status, or Exercise Level.
  2. Select the “Sort & Filter” button from the Home menu
  3. Filter the column alphabetically or numerically
    • You can sort alphabetically from A to Z or Z to A
    • You can sort numerically from Smallest to Largest or Largest to Smallest
  4. From the first column on the far left, you can select and copy all of the email addresses associated with your desired result; for example, you can grab all of the email addresses associated with “High” BMI Risk results or “Current” smoking status results.
  5. Pull these emails into your external email program to form your customized, targeted list.

On Windows:

  1. Select the column you’re interested in sorting. For example, this might be BMI Risk Category, Smoking Status, Diabetes Status, or Exercise Level.
  2. Select the “Sort & Filter” button from the Home menu
  3. On the Data tab, in the Sort & Filter group, filter the data alphabetically or numerically
    • You can sort alphabetically from A to Z or Z to A
    • You can sort numerically from Smallest to Largest or Largest to Smallest
  4. From the first column on the far left, you can select and copy all of the email addresses associated with your desired result; for example, you can grab all of the email addresses associated with “High” BMI Risk results or “Current” smoking status results.
  5. Pull these emails into your external email program to form your customized, targeted list.

Primary Sidebar

Generic filters
Exact matches only

HRA Support Topics

Special pricing offer! Discounts are available on new HRAs purchased for health month promotions. Contact us to learn more.

Footer

Company Posts

Reminder about HRA Data Security
Eruptr Privacy DefenderEruptr Privacy Defender – New HIPAA-Compliant Ad Tracking for Google & Meta
We’ll be at NESHCo 2023 in Boston!
Eruptr, HealthAware and Medicom Health Join Unlock Health

HRA Posts

Clearing the Air: The Transformative Impact of Lung Cancer Screening
Staff Spotlight – Danelle Smit – Senior Account Manager, Eruptr
Diabetes Awareness Month, Don’t Sugarcoat It!
Transform Web Visits into Patient Care: Leveraging Assessments for Chiropractic Health Month

HRA Case Studies

henrey-ford-200-02How Facebook Campaigns Supercharge Health Risk Assessments
How Banner Health’s HRAs Drove Patient Engagement & Service Line Revenue
How Baptist Health Increased HRA Completions & Service Line Revenue
completion rates Heart Health HRA – Improved Global Completion Rates

Medicom Health LLC

Get Directions
(800) 971-0785
  • Email
  • Facebook
  • LinkedIn
  • Twitter
Return to Top

Copyright © 2025 · Medicom Health LLC – View Privacy Policy

Thank you for your interest.

If you have any questions, please email
sales@medicomhealth.com.

Thank you for your interest.

A link to the PDF will be sent to your email address shortly.

If you have any questions, please email
sales@medicomhealth.com.

Cost

We are waving our 1-time fee for new customers for a limited time.
We typically charge $25k to health systems for a 3-yr. service period.

Rx Savings Assistant® has no ongoing costs for providers.
Pharma manufacturers fund the discounts. We receive a small commission for each discount used. There is no impact on pharmacy profit margins.

Health systems do shoulder the cost of the IT implementation.
This includes paying for any additional EHR data feeds if necessary.