{
  "file_rows": 12,
  "fields": 14,
  "sparse_threshold_pct": 10,
  "summary": {
    "empty": 1,
    "sparse": 1,
    "constant": 1,
    "default_heavy": 1,
    "placeholders": 1,
    "possible_duplicates": 1,
    "healthy": 7
  },
  "key_fields": [
    {
      "field": "Industry",
      "fill_rate": 91.7
    },
    {
      "field": "Employees",
      "fill_rate": 100
    },
    {
      "field": "Owner",
      "fill_rate": 91.7
    }
  ],
  "duplicates": [
    {
      "fields": [
        "Industry",
        "Industry (Custom)"
      ],
      "fill_rates": [
        91.7,
        83.3
      ],
      "reasons": [
        "similar names",
        "same value on 10 of 10 rows where both are filled"
      ]
    }
  ],
  "by_group": {
    "(blank)": {
      "rows": 1,
      "average_fill_rate": 66.7,
      "fill_rates": {
        "Industry": 100,
        "Employees": 100,
        "Owner": 0
      }
    },
    "Rep A": {
      "rows": 4,
      "average_fill_rate": 100,
      "fill_rates": {
        "Industry": 100,
        "Employees": 100,
        "Owner": 100
      }
    },
    "Rep B": {
      "rows": 3,
      "average_fill_rate": 100,
      "fill_rates": {
        "Industry": 100,
        "Employees": 100,
        "Owner": 100
      }
    },
    "Rep C": {
      "rows": 4,
      "average_fill_rate": 91.7,
      "fill_rates": {
        "Industry": 75,
        "Employees": 100,
        "Owner": 100
      }
    }
  },
  "field_profiles": [
    {
      "field": "Record ID",
      "type": "identifier",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 12,
      "top_values": [
        {
          "value": "1",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "10",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "11",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [],
      "key_field": false
    },
    {
      "field": "Company Name",
      "type": "identifier",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 12,
      "top_values": [
        {
          "value": "Adventure Works",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "Alpine Ski House",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "Coho Winery",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [],
      "key_field": false
    },
    {
      "field": "Domain",
      "type": "identifier",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 12,
      "top_values": [
        {
          "value": "adventure.example",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "alpine.example",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "coho.example",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [],
      "key_field": false
    },
    {
      "field": "Industry",
      "type": "text",
      "filled": 11,
      "fill_rate": 91.7,
      "placeholders": 0,
      "distinct": 8,
      "top_values": [
        {
          "value": "Retail",
          "count": 3,
          "share": 27.3
        },
        {
          "value": "Software",
          "count": 2,
          "share": 18.2
        },
        {
          "value": "Financial services",
          "count": 1,
          "share": 9.1
        }
      ],
      "flags": [
        "possible_duplicate"
      ],
      "key_field": true
    },
    {
      "field": "Industry (Custom)",
      "type": "text",
      "filled": 10,
      "fill_rate": 83.3,
      "placeholders": 0,
      "distinct": 8,
      "top_values": [
        {
          "value": "Retail",
          "count": 3,
          "share": 30
        },
        {
          "value": "Financial services",
          "count": 1,
          "share": 10
        },
        {
          "value": "Food and beverage",
          "count": 1,
          "share": 10
        }
      ],
      "flags": [
        "possible_duplicate"
      ],
      "key_field": false
    },
    {
      "field": "Employees",
      "type": "number",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 12,
      "top_values": [
        {
          "value": "12",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "1200",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "150",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [],
      "key_field": true
    },
    {
      "field": "Annual Revenue",
      "type": "number",
      "filled": 4,
      "fill_rate": 33.3,
      "placeholders": 0,
      "distinct": 4,
      "top_values": [
        {
          "value": "21000000",
          "count": 1,
          "share": 25
        },
        {
          "value": "42000000",
          "count": 1,
          "share": 25
        },
        {
          "value": "610000000",
          "count": 1,
          "share": 25
        }
      ],
      "flags": [],
      "key_field": false
    },
    {
      "field": "Lifecycle Stage",
      "type": "picklist",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 2,
      "top_values": [
        {
          "value": "Lead",
          "count": 11,
          "share": 91.7
        },
        {
          "value": "Customer",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [
        "default_heavy"
      ],
      "key_field": false
    },
    {
      "field": "Country",
      "type": "picklist",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 5,
      "top_values": [
        {
          "value": "US",
          "count": 8,
          "share": 66.7
        },
        {
          "value": "CA",
          "count": 1,
          "share": 8.3
        },
        {
          "value": "CH",
          "count": 1,
          "share": 8.3
        }
      ],
      "flags": [],
      "key_field": false
    },
    {
      "field": "Legacy Score",
      "type": "empty",
      "filled": 0,
      "fill_rate": 0,
      "placeholders": 0,
      "distinct": 0,
      "top_values": [],
      "flags": [
        "empty"
      ],
      "key_field": false
    },
    {
      "field": "Partner Tier",
      "type": "text",
      "filled": 1,
      "fill_rate": 8.3,
      "placeholders": 0,
      "distinct": 1,
      "top_values": [
        {
          "value": "Gold",
          "count": 1,
          "share": 100
        }
      ],
      "flags": [
        "sparse"
      ],
      "key_field": false
    },
    {
      "field": "Original Source",
      "type": "text",
      "filled": 6,
      "fill_rate": 50,
      "placeholders": 5,
      "distinct": 5,
      "top_values": [
        {
          "value": "Organic search",
          "count": 2,
          "share": 33.3
        },
        {
          "value": "Event",
          "count": 1,
          "share": 16.7
        },
        {
          "value": "Paid search",
          "count": 1,
          "share": 16.7
        }
      ],
      "flags": [
        "placeholders"
      ],
      "key_field": false
    },
    {
      "field": "Owner",
      "type": "picklist",
      "filled": 11,
      "fill_rate": 91.7,
      "placeholders": 0,
      "distinct": 3,
      "top_values": [
        {
          "value": "Rep A",
          "count": 4,
          "share": 36.4
        },
        {
          "value": "Rep C",
          "count": 4,
          "share": 36.4
        },
        {
          "value": "Rep B",
          "count": 3,
          "share": 27.3
        }
      ],
      "flags": [],
      "key_field": true
    },
    {
      "field": "Region",
      "type": "picklist",
      "filled": 12,
      "fill_rate": 100,
      "placeholders": 0,
      "distinct": 1,
      "top_values": [
        {
          "value": "NA",
          "count": 12,
          "share": 100
        }
      ],
      "flags": [
        "constant"
      ],
      "key_field": false
    }
  ]
}