Common values

Use this query to return common values across semantics in a single view that shows cardinality for semantic values and shows the context for values that occur across multiple records and clusters.

When to use

  1. Run this query to display common values.

  2. Review the top results and investigate records to identify trends (~30 minutes).

  3. For each common value, attempt to identify why it has so many records associated with it. For example, is it a company email address? A business address?

  4. Review all associated records to ensure that records associated with it are clustered or split appropriately.

  5. Identify if any values should be added to the bad-values blocklist.

  6. If anomalies are present, investigate each cluster individually.