QWANZ wireframesManagement: AdminRecipient import and duplicates14 / 18

Q

QWANZManagement

Dashboard Ad-hoc analysis Sources and campaigns Spend VORs NEXT VOR and interests QWZit Recipients Recipient tags and groups Members Audit export Email to members Settings and users

[USER NAME]Admin

Import recipients

Sample data

Column mapping: provider_export.csv

File column	QWANZ field
full_name	Name	Matched
role	Office	Matched
outlet	Organisation	Matched
state	State or area	Matched
beat	Subject	Check
provider_id	External ID (for updates)	Matched

4,812 rows: 4,650 new, 148 updates by External ID, 14 possible duplicates

Possible duplicates (14)

[NAME], [PUBLICATION]

Existing

[NAME], [PUBLICATION]

Incoming · same email

Merge Keep both

[NAME], U.S. House CA-[N]

Existing

[NAME], House of Representatives

Incoming · same name and office

Merge Keep both

[NAME], [COMPANY]

Existing

[NAME], [COMPANY] Inc.

Incoming · same name, similar organisation

Merge Keep both