Match log report

Administrators and data managers can run reports on the match logs that are created from source subscriptions. Match logs can contain many records, so using reports makes it easier to analyze the data to discover the effectiveness of your match rules and data groups. Network provides templates to help you begin your analysis.

Available match logs

New match logs are immediately available to report on but are purged after three days. Logs that were created within the past three months can be retrieved for reporting again using the Analyze Match Log button on the source subscription Job Details page. If logs are older than three months, they are purged and cannot be retrieved.

Loading the log might take up to ten minutes. When the log is loaded, users are automatically redirected to the Reports page.

Run a match log report

To run a report on match logs:

  1. On the Network menu bar, click REPORTS > SQL Query Editor.
  2. In the query window, click Load query from template.
  3. In the Load Query dialog, find the Match Log heading. Four templates are available:
    • Count of ACT, ASK and Unmatched
    • Count of Match Type (Act, ASK) by feature set
    • Count of record pairs per data group
    • Match log attribute comparison
  4. Select a template and click Load.

    The report loads into the query window.

  5. Click Run.

The report runs and the results display in the Results section.

Templates

Review the templates and example results to understand the information that you can view in the report results.

Count of ACT, ASK and Unmatched

Use this template to see a summary of the match jobs available.

Count of Match Type (ACT, ASK) by feature set

This template helps you to analyze your match data by feature set.

When you load the template, the job_id and entity_type parameters must be defined to see results; for example, job_id = '9' AND entity_type = 'HCP'.

Count of record pairs per data group

The helps you to analyze the data groups that you have defined in your match configuration.

When you load the template, the job_id and entity_type parameters must be defined to see results; for example, job_id = '9' AND entity_type = 'HCP'.

Match log attribute comparison

This report compares attributes from the match log.

When you load the template, the job_id, entity_type, and attribute_list parameters must be defined to see results.

In the example results below, the parameters are defined as job_id = '721', entity_type = 'HCO' and attribute_list ='addresses__v.address.line_1__v'. The report results compare addresses between the source and match value.

Analyzing match logs using SQL queries

You can also access data from the following match log tables if you have permissions to use the SQL query editor.

The available match log tables and corresponding attributes are as follows: