One customer dataset, useful segments

The problem

The same users appeared in different tables, with inconsistent destinations and exclusion rules.

My contribution

• Matched users across the source tables.
• Defined segment rules and exclusions.
• Created the working tables while preserving the original contact and usage fields.

Evidence & scope

I compared the original and consolidated fields and checked duplicates and segment boundaries.

What came out of it

One consistent source for the campaign segments.

The team had consistent segment tables and a repeatable way to update them.