Customer Match Translator

A simple command line program to translate a CSV containing customer contact information to Google's Customer Match data format. Written using Python 3. Has options to allow for hashing of the data before exporting it to a CSV.

Usage

Clone repository:

git clone https://github.com/Esquire-Digital/customer-match-tool.git
cd customer-match-tool

Install required packages:

pip install -r requirements.txt

Allow execution of the file (Linux/macOS only)

chmod +x customer-match.py

Run the program on a CSV file:

./customer-match.py ./file.csv          # Linux/macOS
python3 ./customer-match.py ./file.csv  # All other OS

File Requirements

The CSV file must have field types that map to these required Google fields:

• First Name
• Last Name
• Phone
• Email
• Country
• Zip

If a field type is not automatically picked up but exists in the CSV, add it to the translations dictionary.

Options

Translations

The program will automatically match snake case field types to their Google alternatives. For example, if a field name in the header of your CSV file is first_name, it will match against the Google field First Name.

To add manual translations, edit the translation dictionary located in constants.py:

# constants.py
HEADER_TRANSLATIONS = {
    "email1": "Email",
    "phone1": "Phone",
    "person_country": "Country",
    "custom_email_field_name": "Email",
}

Be sure that the translated value is a valid field type. The valid field types are below:

• First Name
• Last Name
• Phone
• Email
• Country
• Zip
• Mobile Device ID