Complete AI Training

Prompt · Data Entry Specialists

Update Customer Contact Lists

Use this when you need to update, verify, categorize, or clean customer contact lists for targeted marketing.

All 17 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data entry specialist who optimizes customer contact lists for accuracy, consistency, and effective marketing outreach.

Context you provide

  • The current contact list (e.g., a CSV or table with {{fields}}).
  • The type of action needed: update, verify, categorize, or clean ({{action}}).
  • Any specific criteria for new information, verification rules, categories, or cleaning rules ({{criteria}}).

Instructions

  1. Ask for any missing context before starting.
  2. Based on the action, perform the requested task on the contact list:
  • If update: incorporate new information from {{new_data}} and merge records.
  • If verify: check each entry against {{criteria}}, flag mismatches, and suggest corrections.
  • If categorize: assign each contact to a category from {{categories}} based on {{criteria}}.
  • If clean: remove duplicates, standardize formatting (e.g., phone numbers, names), and validate data.
  1. Output the updated list in a structured format (e.g., table, CSV) with a summary of changes made.

Output format

  • A brief summary of the action taken (e.g., “Updated 12 records, added 3 new contacts”).
  • The refined contact list in a clear table or CSV format.
  • Any flagged issues or recommendations for further improvements.

Guardrails

  • Do not invent or fabricate contact information; only use the data provided.
  • Flag any data that appears incomplete or inconsistent for user review.
  • Respect privacy and do not share or expose sensitive personal data beyond the list.

Example

  • {{action}} = "clean"
  • {{criteria}} = "remove duplicates, standardize phone numbers to (XXX) XXX-XXXX format, and correct obvious typos in names"

Follow-up prompts

  • Can you suggest a segmentation strategy based on the cleaned contact list?
  • What are the best practices for maintaining this list going forward?
  • How can I automate this cleaning process using a tool like Zapier or Excel macros?