Windsor brings all your Zendesk Sell data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Zendesk Sell Field Reference
Fields
ID | Type | Name | Description | Report |
---|---|---|---|---|
call_outcomes__created_at | TEXT | call_outcomes.created_at | call_outcomes.created_at | call_outcomes |
call_outcomes__creator_id | NUMERIC | call_outcomes.creator_id | call_outcomes.creator_id | call_outcomes |
call_outcomes__id | NUMERIC | call_outcomes.id | call_outcomes.id | call_outcomes |
call_outcomes__name | TEXT | call_outcomes.name | call_outcomes.name | call_outcomes |
call_outcomes__updated_at | TEXT | call_outcomes.updated_at | call_outcomes.updated_at | call_outcomes |
calls__associated_deal_ids | OBJECT | calls.associated_deal_ids | calls.associated_deal_ids | calls |
calls__created_at | TEXT | calls.created_at | calls.created_at | calls |
calls__duration | NUMERIC | calls.duration | calls.duration | calls |
calls__id | NUMERIC | calls.id | calls.id | calls |
calls__incoming | BOOLEAN | calls.incoming | calls.incoming | calls |
calls__made_at | TEXT | calls.made_at | calls.made_at | calls |
calls__missed | BOOLEAN | calls.missed | calls.missed | calls |
calls__outcome_id | NUMERIC | calls.outcome_id | calls.outcome_id | calls |
calls__phone_number | TEXT | calls.phone_number | calls.phone_number | calls |
calls__recording_url | TEXT | calls.recording_url | calls.recording_url | calls |
calls__resource_id | NUMERIC | calls.resource_id | calls.resource_id | calls |
calls__resource_type | TEXT | calls.resource_type | calls.resource_type | calls |
calls__summary | TEXT | calls.summary | calls.summary | calls |
calls__updated_at | TEXT | calls.updated_at | calls.updated_at | calls |
calls__user_id | NUMERIC | calls.user_id | calls.user_id | calls |
collaborations__collaborator_id | NUMERIC | collaborations.collaborator_id | collaborations.collaborator_id | collaborations |
collaborations__created_at | TEXT | collaborations.created_at | collaborations.created_at | collaborations |
collaborations__creator_id | NUMERIC | collaborations.creator_id | collaborations.creator_id | collaborations |
collaborations__id | NUMERIC | collaborations.id | collaborations.id | collaborations |
collaborations__resource_id | NUMERIC | collaborations.resource_id | collaborations.resource_id | collaborations |
collaborations__resource_type | TEXT | collaborations.resource_type | collaborations.resource_type | collaborations |
collaborations__updated_at | TEXT | collaborations.updated_at | collaborations.updated_at | collaborations |
contacts__address | OBJECT | contacts.address | contacts.address | contacts |
contacts__billing_address | OBJECT | contacts.billing_address | contacts.billing_address | contacts |
contacts__contact_id | NUMERIC | contacts.contact_id | contacts.contact_id | contacts |
contacts__created_at | TEXT | contacts.created_at | contacts.created_at | contacts |
contacts__creator_id | NUMERIC | contacts.creator_id | contacts.creator_id | contacts |
contacts__custom_fields | OBJECT | contacts.custom_fields | contacts.custom_fields | contacts |
contacts__customer_status | TEXT | contacts.customer_status | contacts.customer_status | contacts |
contacts__description | TEXT | contacts.description | contacts.description | contacts |
contacts__email | TEXT | contacts.email | contacts.email | contacts |
contacts__facebook | TEXT | contacts.facebook | contacts.facebook | contacts |
contacts__fax | TEXT | contacts.fax | contacts.fax | contacts |
contacts__first_name | TEXT | contacts.first_name | contacts.first_name | contacts |
contacts__id | NUMERIC | contacts.id | contacts.id | contacts |
contacts__industry | TEXT | contacts.industry | contacts.industry | contacts |
contacts__is_organization | BOOLEAN | contacts.is_organization | contacts.is_organization | contacts |
contacts__last_name | TEXT | contacts.last_name | contacts.last_name | contacts |
contacts__linkedin | TEXT | contacts.linkedin | contacts.linkedin | contacts |
contacts__mobile | TEXT | contacts.mobile | contacts.mobile | contacts |
contacts__name | TEXT | contacts.name | contacts.name | contacts |
contacts__owner_id | NUMERIC | contacts.owner_id | contacts.owner_id | contacts |
contacts__parent_organization_id | NUMERIC | contacts.parent_organization_id | contacts.parent_organization_id | contacts |
contacts__phone | TEXT | contacts.phone | contacts.phone | contacts |
contacts__prospect_status | TEXT | contacts.prospect_status | contacts.prospect_status | contacts |
contacts__shipping_address | OBJECT | contacts.shipping_address | contacts.shipping_address | contacts |
contacts__skype | TEXT | contacts.skype | contacts.skype | contacts |
contacts__tags | OBJECT | contacts.tags | contacts.tags | contacts |
contacts__title | TEXT | contacts.title | contacts.title | contacts |
contacts__twitter | TEXT | contacts.twitter | contacts.twitter | contacts |
contacts__updated_at | TEXT | contacts.updated_at | contacts.updated_at | contacts |
contacts__website | TEXT | contacts.website | contacts.website | contacts |
datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
deal_sources__created_at | TEXT | deal_sources.created_at | deal_sources.created_at | deal_sources |
deal_sources__creator_id | NUMERIC | deal_sources.creator_id | deal_sources.creator_id | deal_sources |
deal_sources__id | NUMERIC | deal_sources.id | deal_sources.id | deal_sources |
deal_sources__name | TEXT | deal_sources.name | deal_sources.name | deal_sources |
deal_sources__resource_type | TEXT | deal_sources.resource_type | deal_sources.resource_type | deal_sources |
deal_sources__updated_at | TEXT | deal_sources.updated_at | deal_sources.updated_at | deal_sources |
deal_unqualified_reasons__created_at | TEXT | deal_unqualified_reasons.created_at | deal_unqualified_reasons.created_at | deal_unqualified_reasons |
deal_unqualified_reasons__creator_id | NUMERIC | deal_unqualified_reasons.creator_id | deal_unqualified_reasons.creator_id | deal_unqualified_reasons |
deal_unqualified_reasons__id | NUMERIC | deal_unqualified_reasons.id | deal_unqualified_reasons.id | deal_unqualified_reasons |
deal_unqualified_reasons__name | TEXT | deal_unqualified_reasons.name | deal_unqualified_reasons.name | deal_unqualified_reasons |
deal_unqualified_reasons__updated_at | TEXT | deal_unqualified_reasons.updated_at | deal_unqualified_reasons.updated_at | deal_unqualified_reasons |
deals__added_at | TEXT | deals.added_at | deals.added_at | deals |
deals__contact_id | NUMERIC | deals.contact_id | deals.contact_id | deals |
deals__created_at | TEXT | deals.created_at | deals.created_at | deals |
deals__creator_id | NUMERIC | deals.creator_id | deals.creator_id | deals |
deals__currency | TEXT | deals.currency | deals.currency | deals |
deals__custom_fields | OBJECT | deals.custom_fields | deals.custom_fields | deals |
deals__customized_win_likelihood | NUMERIC | deals.customized_win_likelihood | deals.customized_win_likelihood | deals |
deals__dropbox_email | TEXT | deals.dropbox_email | deals.dropbox_email | deals |
deals__estimated_close_date | TEXT | deals.estimated_close_date | deals.estimated_close_date | deals |
deals__hot | BOOLEAN | deals.hot | deals.hot | deals |
deals__id | NUMERIC | deals.id | deals.id | deals |
deals__last_activity_at | TEXT | deals.last_activity_at | deals.last_activity_at | deals |
deals__last_stage_change_at | TEXT | deals.last_stage_change_at | deals.last_stage_change_at | deals |
deals__last_stage_change_by_id | NUMERIC | deals.last_stage_change_by_id | deals.last_stage_change_by_id | deals |
deals__loss_reason_id | NUMERIC | deals.loss_reason_id | deals.loss_reason_id | deals |
deals__name | TEXT | deals.name | deals.name | deals |
deals__organization_id | NUMERIC | deals.organization_id | deals.organization_id | deals |
deals__owner_id | NUMERIC | deals.owner_id | deals.owner_id | deals |
deals__source_id | NUMERIC | deals.source_id | deals.source_id | deals |
deals__stage_id | NUMERIC | deals.stage_id | deals.stage_id | deals |
deals__tags | OBJECT | deals.tags | deals.tags | deals |
deals__unqualified_reason_id | NUMERIC | deals.unqualified_reason_id | deals.unqualified_reason_id | deals |
deals__updated_at | TEXT | deals.updated_at | deals.updated_at | deals |
deals__value | NUMERIC | deals.value | deals.value | deals |
lead_conversions__created_at | TEXT | lead_conversions.created_at | lead_conversions.created_at | lead_conversions |
lead_conversions__creator_id | NUMERIC | lead_conversions.creator_id | lead_conversions.creator_id | lead_conversions |
lead_conversions__deal_id | NUMERIC | lead_conversions.deal_id | lead_conversions.deal_id | lead_conversions |
lead_conversions__id | NUMERIC | lead_conversions.id | lead_conversions.id | lead_conversions |
lead_conversions__individual_id | NUMERIC | lead_conversions.individual_id | lead_conversions.individual_id | lead_conversions |
lead_conversions__lead_id | NUMERIC | lead_conversions.lead_id | lead_conversions.lead_id | lead_conversions |
lead_conversions__organization_id | NUMERIC | lead_conversions.organization_id | lead_conversions.organization_id | lead_conversions |
lead_sources__created_at | TEXT | lead_sources.created_at | lead_sources.created_at | lead_sources |
lead_sources__creator_id | NUMERIC | lead_sources.creator_id | lead_sources.creator_id | lead_sources |
lead_sources__id | NUMERIC | lead_sources.id | lead_sources.id | lead_sources |
lead_sources__name | TEXT | lead_sources.name | lead_sources.name | lead_sources |
lead_sources__resource_type | TEXT | lead_sources.resource_type | lead_sources.resource_type | lead_sources |
lead_sources__updated_at | TEXT | lead_sources.updated_at | lead_sources.updated_at | lead_sources |
lead_unqualified_reasons__created_at | TEXT | lead_unqualified_reasons.created_at | lead_unqualified_reasons.created_at | lead_unqualified_reasons |
lead_unqualified_reasons__creator_id | NUMERIC | lead_unqualified_reasons.creator_id | lead_unqualified_reasons.creator_id | lead_unqualified_reasons |
lead_unqualified_reasons__id | NUMERIC | lead_unqualified_reasons.id | lead_unqualified_reasons.id | lead_unqualified_reasons |
lead_unqualified_reasons__name | TEXT | lead_unqualified_reasons.name | lead_unqualified_reasons.name | lead_unqualified_reasons |
lead_unqualified_reasons__updated_at | TEXT | lead_unqualified_reasons.updated_at | lead_unqualified_reasons.updated_at | lead_unqualified_reasons |
leads__address | OBJECT | leads.address | leads.address | leads |
leads__created_at | TEXT | leads.created_at | leads.created_at | leads |
leads__creator_id | NUMERIC | leads.creator_id | leads.creator_id | leads |
leads__custom_fields | OBJECT | leads.custom_fields | leads.custom_fields | leads |
leads__description | TEXT | leads.description | leads.description | leads |
leads__email | TEXT | leads.email | leads.email | leads |
leads__facebook | TEXT | leads.facebook | leads.facebook | leads |
leads__fax | TEXT | leads.fax | leads.fax | leads |
leads__first_name | TEXT | leads.first_name | leads.first_name | leads |
leads__id | NUMERIC | leads.id | leads.id | leads |
leads__industry | TEXT | leads.industry | leads.industry | leads |
leads__last_name | TEXT | leads.last_name | leads.last_name | leads |
leads__linkedin | TEXT | leads.linkedin | leads.linkedin | leads |
leads__mobile | TEXT | leads.mobile | leads.mobile | leads |
leads__organization_name | TEXT | leads.organization_name | leads.organization_name | leads |
leads__owner_id | NUMERIC | leads.owner_id | leads.owner_id | leads |
leads__phone | TEXT | leads.phone | leads.phone | leads |
leads__skype | TEXT | leads.skype | leads.skype | leads |
leads__source_id | NUMERIC | leads.source_id | leads.source_id | leads |
leads__status | TEXT | leads.status | leads.status | leads |
leads__tags | OBJECT | leads.tags | leads.tags | leads |
leads__title | TEXT | leads.title | leads.title | leads |
leads__twitter | TEXT | leads.twitter | leads.twitter | leads |
leads__unqualified_reason_id | TEXT | leads.unqualified_reason_id | leads.unqualified_reason_id | leads |
leads__updated_at | TEXT | leads.updated_at | leads.updated_at | leads |
leads__website | TEXT | leads.website | leads.website | leads |
loss_reasons__created_at | TEXT | loss_reasons.created_at | loss_reasons.created_at | loss_reasons |
loss_reasons__creator_id | NUMERIC | loss_reasons.creator_id | loss_reasons.creator_id | loss_reasons |
loss_reasons__id | NUMERIC | loss_reasons.id | loss_reasons.id | loss_reasons |
loss_reasons__name | TEXT | loss_reasons.name | loss_reasons.name | loss_reasons |
loss_reasons__updated_at | TEXT | loss_reasons.updated_at | loss_reasons.updated_at | loss_reasons |
notes__content | TEXT | notes.content | notes.content | notes |
notes__created_at | TEXT | notes.created_at | notes.created_at | notes |
notes__creator_id | NUMERIC | notes.creator_id | notes.creator_id | notes |
notes__id | NUMERIC | notes.id | notes.id | notes |
notes__is_important | BOOLEAN | notes.is_important | notes.is_important | notes |
notes__resource_id | NUMERIC | notes.resource_id | notes.resource_id | notes |
notes__resource_type | TEXT | notes.resource_type | notes.resource_type | notes |
notes__tags | OBJECT | notes.tags | notes.tags | notes |
notes__type | TEXT | notes.type | notes.type | notes |
notes__updated_at | TEXT | notes.updated_at | notes.updated_at | notes |
orders__created_at | TEXT | orders.created_at | orders.created_at | orders |
orders__deal_id | NUMERIC | orders.deal_id | orders.deal_id | orders |
orders__discount | NUMERIC | orders.discount | orders.discount | orders |
orders__id | NUMERIC | orders.id | orders.id | orders |
orders__updated_at | TEXT | orders.updated_at | orders.updated_at | orders |
pipelines__created_at | TEXT | pipelines.created_at | pipelines.created_at | pipelines |
pipelines__disabled | BOOLEAN | pipelines.disabled | pipelines.disabled | pipelines |
pipelines__id | NUMERIC | pipelines.id | pipelines.id | pipelines |
pipelines__locale_key | TEXT | pipelines.locale_key | pipelines.locale_key | pipelines |
pipelines__name | TEXT | pipelines.name | pipelines.name | pipelines |
pipelines__updated_at | TEXT | pipelines.updated_at | pipelines.updated_at | pipelines |
products__active | BOOLEAN | products.active | products.active | products |
products__cost | TEXT | products.cost | products.cost | products |
products__cost_currency | TEXT | products.cost_currency | products.cost_currency | products |
products__created_at | TEXT | products.created_at | products.created_at | products |
products__description | TEXT | products.description | products.description | products |
products__id | NUMERIC | products.id | products.id | products |
products__max_discount | NUMERIC | products.max_discount | products.max_discount | products |
products__max_markup | NUMERIC | products.max_markup | products.max_markup | products |
products__name | TEXT | products.name | products.name | products |
products__prices | OBJECT | products.prices | products.prices | products |
products__sku | TEXT | products.sku | products.sku | products |
products__updated_at | TEXT | products.updated_at | products.updated_at | products |
products__version | NUMERIC | products.version | products.version | products |
source | TEXT | Source | The name of the Windsor connector returning the row | |
stages__active | BOOLEAN | stages.active | stages.active | stages |
stages__category | TEXT | stages.category | stages.category | stages |
stages__created_at | TEXT | stages.created_at | stages.created_at | stages |
stages__has_original_name | BOOLEAN | stages.has_original_name | stages.has_original_name | stages |
stages__id | NUMERIC | stages.id | stages.id | stages |
stages__likelihood | NUMERIC | stages.likelihood | stages.likelihood | stages |
stages__locale_key | TEXT | stages.locale_key | stages.locale_key | stages |
stages__name | TEXT | stages.name | stages.name | stages |
stages__pipeline_id | NUMERIC | stages.pipeline_id | stages.pipeline_id | stages |
stages__position | NUMERIC | stages.position | stages.position | stages |
stages__position_hash | TEXT | stages.position_hash | stages.position_hash | stages |
stages__updated_at | TEXT | stages.updated_at | stages.updated_at | stages |
tags__created_at | TEXT | tags.created_at | tags.created_at | tags |
tags__creator_id | NUMERIC | tags.creator_id | tags.creator_id | tags |
tags__id | NUMERIC | tags.id | tags.id | tags |
tags__name | TEXT | tags.name | tags.name | tags |
tags__resource_type | TEXT | tags.resource_type | tags.resource_type | tags |
tags__updated_at | TEXT | tags.updated_at | tags.updated_at | tags |
tasks__completed | BOOLEAN | tasks.completed | tasks.completed | tasks |
tasks__completed_at | TEXT | tasks.completed_at | tasks.completed_at | tasks |
tasks__content | TEXT | tasks.content | tasks.content | tasks |
tasks__created_at | TEXT | tasks.created_at | tasks.created_at | tasks |
tasks__creator_id | NUMERIC | tasks.creator_id | tasks.creator_id | tasks |
tasks__due_date | TEXT | tasks.due_date | tasks.due_date | tasks |
tasks__id | NUMERIC | tasks.id | tasks.id | tasks |
tasks__overdue | BOOLEAN | tasks.overdue | tasks.overdue | tasks |
tasks__owner_id | NUMERIC | tasks.owner_id | tasks.owner_id | tasks |
tasks__remind_at | TEXT | tasks.remind_at | tasks.remind_at | tasks |
tasks__resource_id | NUMERIC | tasks.resource_id | tasks.resource_id | tasks |
tasks__resource_type | TEXT | tasks.resource_type | tasks.resource_type | tasks |
tasks__updated_at | TEXT | tasks.updated_at | tasks.updated_at | tasks |
text_messages__associated_deal_ids | OBJECT | text_messages.associated_deal_ids | text_messages.associated_deal_ids | text_messages |
text_messages__content | TEXT | text_messages.content | text_messages.content | text_messages |
text_messages__created_at | TEXT | text_messages.created_at | text_messages.created_at | text_messages |
text_messages__id | NUMERIC | text_messages.id | text_messages.id | text_messages |
text_messages__incoming | BOOLEAN | text_messages.incoming | text_messages.incoming | text_messages |
text_messages__resource_id | NUMERIC | text_messages.resource_id | text_messages.resource_id | text_messages |
text_messages__resource_phone_number | TEXT | text_messages.resource_phone_number | text_messages.resource_phone_number | text_messages |
text_messages__resource_type | TEXT | text_messages.resource_type | text_messages.resource_type | text_messages |
text_messages__sent_at | TEXT | text_messages.sent_at | text_messages.sent_at | text_messages |
text_messages__updated_at | TEXT | text_messages.updated_at | text_messages.updated_at | text_messages |
text_messages__user_id | NUMERIC | text_messages.user_id | text_messages.user_id | text_messages |
text_messages__user_phone_number | TEXT | text_messages.user_phone_number | text_messages.user_phone_number | text_messages |
today | DATE | Today | Today's date | |
users__confirmed | BOOLEAN | users.confirmed | users.confirmed | users |
users__created_at | TEXT | users.created_at | users.created_at | users |
users__deleted_at | TEXT | users.deleted_at | users.deleted_at | users |
users__detached | BOOLEAN | users.detached | users.detached | users |
users__email | TEXT | users.email | users.email | users |
users__group | OBJECT | users.group | users.group | users |
users__id | NUMERIC | users.id | users.id | users |
users__identity_type | TEXT | users.identity_type | users.identity_type | users |
users__invited | BOOLEAN | users.invited | users.invited | users |
users__name | TEXT | users.name | users.name | users |
users__phone_number | TEXT | users.phone_number | users.phone_number | users |
users__reports_to | NUMERIC | users.reports_to | users.reports_to | users |
users__role | TEXT | users.role | users.role | users |
users__roles | OBJECT | users.roles | users.roles | users |
users__sell_login_disabled | BOOLEAN | users.sell_login_disabled | users.sell_login_disabled | users |
users__status | TEXT | users.status | users.status | users |
users__system_tags | OBJECT | users.system_tags | users.system_tags | users |
users__team_name | TEXT | users.team_name | users.team_name | users |
users__timezone | TEXT | users.timezone | users.timezone | users |
users__updated_at | TEXT | users.updated_at | users.updated_at | users |
users__zendesk_user_id | TEXT | users.zendesk_user_id | users.zendesk_user_id | users |
visit_outcomes__created_at | TEXT | visit_outcomes.created_at | visit_outcomes.created_at | visit_outcomes |
visit_outcomes__creator_id | NUMERIC | visit_outcomes.creator_id | visit_outcomes.creator_id | visit_outcomes |
visit_outcomes__id | NUMERIC | visit_outcomes.id | visit_outcomes.id | visit_outcomes |
visit_outcomes__name | TEXT | visit_outcomes.name | visit_outcomes.name | visit_outcomes |
visit_outcomes__updated_at | TEXT | visit_outcomes.updated_at | visit_outcomes.updated_at | visit_outcomes |
visits__created_at | TEXT | visits.created_at | visits.created_at | visits |
visits__creator_id | NUMERIC | visits.creator_id | visits.creator_id | visits |
visits__id | NUMERIC | visits.id | visits.id | visits |
visits__outcome_id | NUMERIC | visits.outcome_id | visits.outcome_id | visits |
visits__rep_location_verification_status | TEXT | visits.rep_location_verification_status | visits.rep_location_verification_status | visits |
visits__resource_address | TEXT | visits.resource_address | visits.resource_address | visits |
visits__resource_id | NUMERIC | visits.resource_id | visits.resource_id | visits |
visits__resource_type | TEXT | visits.resource_type | visits.resource_type | visits |
visits__summary | TEXT | visits.summary | visits.summary | visits |
visits__updated_at | TEXT | visits.updated_at | visits.updated_at | visits |
visits__visited_at | TEXT | visits.visited_at | visits.visited_at | visits |