CustomerGauge In: B2C Data Import Formats (XML, XLS, TXT)

How to format data for import into CustomerGauge b2c

You can format data in several ways for CustomerGauge. For the b2c application, it is expected that there will be an automatic upload each day or week.

Methods:

• FTP (you automate sending of file to our Secure FTP site) - preferred
• Email (we supply a special email address for you to send the file to)
• Manual import (from within the CustomerGauge application you can upload a file)
• API – one transaction at a time (used for checkout or similar) or multiple record upload (coming soon)

Available formats:

• XML – preferred (DOWNLOAD example CustomerGaugeImportTemplateJune2010xml.txt) – updated 22 June 2010 with multiple ITEMs per RECORD
• CSV or TXT (see XLS download)
• XLS (DOWNLOAD CustomerGaugeImportTemplate22Mar2010.xls)
• within API (coming soon)

Typically the data file used is from an e-commerce system. Records are sometimes formatted as multiple lines per sales order (if more than one item per line). We can adjust the import template to account for that. CustomerGauge “de-duplicates” data, so you need not worry about sending a file twice.

Fields

We can accept just a few fields if available. Mandatory fields are:

• Email
• SKU
• order_value
• date_of_order

However, most clients send a very rich feed. If you can supply, we can accept around different 20 segment fields (and report on them).

Pre-Built Connectors

We already have pre-built connectors for many systems including SAP, DigitalRiver, Magento etc. Please enquire on how we can help you.