Zendesk Sell
The table below gives information about all the data fields that you can import from Zendesk Sell.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
Active |
active |
boolean |
Indicator of whether the product is active. Line items cannot be created from inactive products. |
dimension |
|
|
Active |
active |
boolean |
Indicator whether or not the stage contains finalized deals. |
dimension |
|
|
Added At |
added_at |
datetime |
Date and time that the deal was started in UTC (ISO8601 format). |
dimension |
|
|
Address |
address |
string |
The contact’s address. |
dimension |
|
|
Address |
address |
json |
The lead’s address. |
dimension |
|
|
Billing Address |
billing_address |
string |
The customers’s billing address. Applicable only if either `customer_status` or `prospect_status` is different from none. |
dimension |
|
|
Category |
category |
string |
The unique category name of the stage. |
dimension |
|
|
Contact ID |
contact_id |
long |
Unique identifier of the contact to be associated with the deal. |
dimension |
|
|
Contact ID |
contact_id |
long |
The unique identifier of the organization the contact belongs to. The field will be set only if the contact is an individual. |
dimension |
|
|
Contact ID |
contact_id |
long |
Unique identifier of a primary contact. |
dimension |
|
|
Cost |
cost |
currency |
Cost of the product. Visible only to account administrators. |
metric |
|
|
Cost Currency |
cost_currency |
string |
Currency of the product cost, specified in 3-character currency code (ISO4217) format. Visible only to account administrators. |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time that the associated contact was created in UTC (ISO8601 format). |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time the record was created in UTC (ISO8601 format). |
dimension |
|
|
Created Ad |
created_at |
datetime |
Date and time that the deal was created in UTC (ISO8601 format). |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time of creation in UTC ISO8601 format. |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time of the creation in UTC (ISO8601 format). |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time that the order was created in UTC (ISO8601 format). |
dimension |
|
|
Created At |
created_at |
datetime |
Date and time that the product was created in UTC (ISO8601 format). |
dimension |
|
|
Creator ID |
creator_id |
long |
The unique identifier of the user the contact was created by. |
dimension |
|
|
Creator ID |
creator_id |
long |
Unique identifier of the user who created the deal. |
dimension |
|
|
Creator ID |
creator_id |
long |
Unique identifier of the user the deal unqualified reason was created by. |
dimension |
|
|
Creator ID |
creator_id |
long |
Unique identifier of the user who created the lead. |
dimension |
|
|
Creator ID |
creator_id |
long |
Unique identifier of the user the loss reason was created by. |
dimension |
|
|
Creator ID |
creator_id |
long |
User ID of the tag’s creator. |
dimension |
|
|
Currency |
currency |
string |
Currency of the deal, specified in 3-character currency code (ISO4217) format. |
dimension |
|
|
Currency |
currency |
string |
Currency of value and price, specified in 3-character currency code (ISO4217) format. |
dimension |
|
|
Custom Fields |
custom_fields |
json |
Custom fields are a key-value pair attached to a contact. |
dimension |
|
|
Custom Fields |
custom_fields |
json |
Custom fields are key-value data attached to a deal. |
dimension |
|
|
Custom Fields |
custom_fields |
json |
Custom fields are a either a single key-value pair attached to a lead or a set of key-value pairs attached to a lead. |
dimension |
|
|
Customer Status |
customer_status |
string |
The customer status of the contact. Possible values: none, current, past. |
dimension |
|
|
Customized Win Likelihood |
customized_win_likelihood |
long |
User-provided win likelihood with value range 0–100. |
metric |
|
|
Deal ID |
deal_id |
long |
Unique identifier of the deal. |
dimension |
|
|
Deal ID |
deal_id |
long |
|
dimension |
|
|
Description |
description |
string |
The contact’s description. |
dimension |
|
|
Description |
description |
string |
Lead description. |
dimension |
|
|
Description |
description |
string |
Description of the product. Value is copied from the product. |
dimension |
|
|
Description |
description |
string |
Description of the product. |
dimension |
|
|
Disabled |
disabled |
boolean |
Indicator whether or not the pipeline is disabled. You cannot add deals to the disabled pipeline. |
dimension |
|
|
Discount |
discount |
percentage |
Discount on the whole order in percents. |
metric |
|
|
Dropbox Email |
dropbox_email |
string |
Dropbox email connected with the deal. |
dimension |
|
|
|
|
string |
The contact’s email address. |
dimension |
|
|
|
|
string |
Lead’s email. |
dimension |
|
|
Estimated Close Date |
estimated_close_date |
date |
Estimated close date of the deal. |
dimension |
|
|
|
|
string |
The contact’s Facebook nickname. |
dimension |
|
|
|
|
string |
Lead’s Facebook nickname. |
dimension |
|
|
Fax |
fax |
string |
The contact’s fax number. |
dimension |
|
|
Fax |
fax |
string |
Lead’s fax number. |
dimension |
|
|
First Name |
first_name |
string |
First name of the contact. |
dimension |
|
|
First Name |
first_name |
string |
First name of the lead. |
dimension |
|
|
Hot |
hot |
boolean |
Indicator of whether or not the deal is hot. |
dimension |
|
|
ID |
id |
long |
The unique identifier of the contact. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the deal. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the deal unqualified reason. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the lead. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the line item. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the loss reason. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the order. |
dimension |
|
|
ID |
id |
long |
The unique identifier of the pipeline. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the product. |
dimension |
|
|
ID |
id |
long |
The unique identifier of the stage. |
dimension |
|
|
ID |
id |
long |
Unique identifier of the tag. |
dimension |
|
|
Industry |
industry |
string |
The contact’s industry. |
dimension |
|
|
Industry |
industry |
string |
Organization’s industry. |
dimension |
|
|
Is Organization |
is_organization |
boolean |
Indicator of whether or not this contact refers to an organization or an individual. This value can be set only during creation and cannot be changed later. The default value is `false`. |
dimension |
|
|
Last Activity At |
last_activity_at |
datetime |
Date and time of the last activity on the deal in UTC (ISO8601 format). |
dimension |
|
|
Last Name |
last_name |
string |
Last name of the contact. Required only if the contact is an individual. |
dimension |
|
|
Last Name |
last_name |
string |
Last name of the lead. Required unless `organization_name` field is provided. |
dimension |
|
|
Last Stage Change At |
last_stage_change_at |
datetime |
Date and time when the deal was moved into the current stage in UTC (ISO8601 format). |
dimension |
|
|
Last Stage Change By ID |
last_stage_change_by_id |
long |
Unique identifier of the user who moved the deal into the current stage. |
dimension |
|
|
Likelihood |
likelihood |
percentage |
The likelihood that a deal will be won, set for the stage as percentage. |
metric |
|
|
|
|
string |
The contact’s Linkedin nickname. |
dimension |
|
|
|
|
string |
Lead’s Linkedin nickname. |
dimension |
|
|
Loss Reason ID |
loss_reason_id |
long |
Reason why the deal was lost. |
dimension |
|
|
Max Discount |
max_discount |
percentage |
Maximum discount that can be applied to the product in percents. |
metric |
|
|
Max Markup |
max_markup |
percentage |
Maximum markup that can be applied to the product in percents. |
metric |
|
|
Mobile |
mobile |
string |
The contact’s mobile phone number. |
dimension |
|
|
Mobile |
mobile |
string |
Lead’s mobile phone number. |
dimension |
|
|
Name |
name |
string |
Name of the contact. Required only if the contact is an organization. |
dimension |
|
|
Name |
name |
string |
Name of the deal. |
dimension |
|
|
Name |
name |
string |
Human-friendly unqualified reason explanation. |
dimension |
|
|
Name |
name |
string |
Name of the product. Value is copied from the product. |
dimension |
|
|
Name |
name |
string |
Human-friendly loss reason explanation. |
dimension |
|
|
Name |
name |
string |
Human-friendly name of the pipeline. |
dimension |
|
|
Name |
name |
string |
Name of the product. |
dimension |
|
|
Name |
name |
string |
Human-friendly name of the stage. |
dimension |
|
|
Name |
name |
string |
Name of the tag. |
dimension |
|
|
Order ID |
order_id |
long |
Unique identifier of the order. |
dimension |
|
|
Organization ID |
organization_id |
long |
Unique identifier of an organization. |
dimension |
|
|
Organization Name |
organization_name |
string |
Organization name of the lead. Required unless `last_name` field is provided. |
dimension |
|
|
Owner ID |
owner_id |
long |
The unique identifier of the user the contact is currently assigned to. |
dimension |
|
|
Owner ID |
owner_id |
string |
Unique identifier of the user that the deal is assigned to. |
dimension |
|
|
Owner ID |
owner_id |
long |
Unique identifier of the user who currently owns the lead. |
dimension |
|
|
Parent Organization ID |
parent_organization_id |
long |
The unique identifier of an organization contact that is parent of this organization. The field will be set only if the contact is an organization and has parent. |
dimension |
|
|
Phone |
phone |
string |
The contact’s phone number. |
dimension |
|
|
Phone |
phone |
string |
Lead’s phone number. |
dimension |
|
|
Pipeline ID |
pipeline_id |
long |
Unique identifier of the pipeline that contains this stage. |
dimension |
|
|
Position |
position |
long |
The stage’s position in the pipeline. |
metric |
|
|
Price |
price |
currency |
|
metric |
|
|
Prices |
prices |
json |
Array specifying products prices in different currencies. |
dimension |
|
|
Product ID |
product_id |
long |
Unique identifier of the product based on which line item is created. It is not available after creation. |
dimension |
|
|
Prospect Status |
prospect_status |
string |
The prospect status of the contact. Possible values: none, current, past. |
dimension |
|
|
Quantity |
quantity |
long |
Quantity of the product included in this line item. Default value is 1. |
metric |
|
|
Resource Type |
resource_type |
string |
Type name of the resource the tag is attached to. Possible values: lead, contact, deal. |
dimension |
|
|
Role |
role |
string |
Role name. Possible values: involved. |
dimension |
|
|
Shipping Address |
shipping_address |
string |
The customer’s shipping address. Applicable only if either `customer_status` or `prospect_status` is different from `none`. |
dimension |
|
|
SKU |
sku |
string |
Stock Keeping Unit identification code. Value is copied from the product. |
dimension |
|
|
SKU |
sku |
string |
Stock Keeping Unit identification code. |
dimension |
|
|
Skype |
skype |
string |
The contact’s Skype nickname. |
dimension |
|
|
Skype |
skype |
string |
Lead’s Skype nickname. |
dimension |
|
|
Source ID |
source_id |
long |
Unique identifier of the Source. |
dimension |
|
|
Source ID |
source_id |
long |
Unique identifier of the Source. |
dimension |
|
|
Stage ID |
stage_id |
long |
Unique identifier of the deal’s current stage in the pipeline. |
dimension |
|
|
Status |
status |
string |
Status of the lead. |
dimension |
|
|
Tags |
tags |
list |
An array of tags for the contact. |
dimension |
|
|
Tags |
tags |
list |
An array of tags for a deal. |
dimension |
|
|
Tags |
tags |
list |
An array of tags for a lead. |
dimension |
|
|
Title |
title |
string |
The contact’s job title. |
dimension |
|
|
Title |
title |
string |
Job title of the lead. |
dimension |
|
|
|
|
string |
The contact’s Twitter handle. |
dimension |
|
|
|
|
string |
Lead’s Twitter handle. |
dimension |
|
|
Unqualified Reason ID |
unqualified_reason_id |
long |
Reason why the deal was unqualied. |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the last update on the associated contact in UTC (ISO8601 format). |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the record’s last update in UTC (ISO8601 format). |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the last update on the deal in UTC (ISO8601 format). |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the last update in UTC ISO8601 format. |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the last update on the order in UTC (ISO8601 format). |
dimension |
|
|
Updated At |
updated_at |
datetime |
Date and time of the last update on the product in UTC (ISO8601 format). |
dimension |
|
|
Value |
value |
currency |
Value of the deal in a currency specified in the `currency` field. |
metric |
|
|
Value |
value |
currency |
Value of one unit of the product. It is product’s price after applying markup. |
metric |
|
|
Variation |
variation |
percentage |
Variation of the product’s price for this line item. Value of 5 means that 5% markup is added, -10 means there is a 10% discount. |
metric |
|
|
Website |
website |
string |
The contact’s website address. |
dimension |
|
|
Website |
website |
string |
Lead’s website. |
dimension |
|
