Open Record Step 11: Bring It Together

Join your API data to your dataset on whatever key they share. Before joining, check both sides for duplicate keys and normalize the key type. After joining, report how many rows matched, how many did not, and what the unmatched ones have in common, because that pattern is usually the interesting part. Then produce the aggregate that answers your question, with group sizes reported alongside every summary number.