Articles in this section

Data Input Formats

Avatar
Peter Watt
  • Updated
Follow


When sending data to ChurnZero via the JavaScript, the HTTP API, or CSV Uploads there are some requirements for how the data should be formatted so that it can be parsed properly. The table below should help identify how to format each data type so that it gets stored properly and all the calculations within ChurnZero can happen properly.

Type Format Example
String Any ExampleString

Number

No Spaces
No Commas
Decimal Separator

12345667.89

Date

 ISO-8601

2012-03-19T07:22Z


Note: You can add this as a Custom Date Format in Excel or Google Sheets:
yyyy-mm-ddThh:mmZ

Multi-Select List

 Comma separated values within one cell with single space between Value1, Value2, Value4

True/False

We accept the following 3 value sets:

True, False
Yes, No
1, 0

 True, False
Yes, No
1, 0

 

Code Examples

If you are using the Javascript integration reference these examples:

Javascript

//string attribute
ChurnZero.push(['setAttribute', 'contact', 'My String Attribute', 'ExampleString']);

//number attribute
ChurnZero.push(['setAttribute', 'contact', 'My Number Attribute', 1234567.89]);

//date attribute
ChurnZero.push(['setAttribute', 'contact', 'My Date Attribute', new Date('2012-03-19T07:22Z')]);
//or
ChurnZero.push(['setAttribute', 'contact', 'My Date Attribute','2012-03-19T07:22Z']);

If you are using the HTTP API integration reference these examples:

HTTP 

//string attribute
https://analytics.churnzero.net/i?appKey=123&accountExternalId=456&contactExternalId=789&action=setAttribute&entity=account&name=My+String+Attribute&value=ExampleString

//number attribute
https://analytics.churnzero.net/i?appKey=123&accountExternalId=456&contactExternalId=789&action=setAttribute&entity=account&name=My+Number+Attribute&value=1234567.89

//date attribute
https://analytics.churnzero.net/i?appKey=123&accountExternalId=456&contactExternalId=789&action=setAttribute&entity=account&name=My+Date+Attribute&value=2012-03-19T07%3A22Z

Related articles

Comments

0 comments

Article is closed for comments.