+
Stream marketing data from Zoho CRM to Snowflake
About Zoho CRM
About SnowFlake
Connect Zoho CRM to Snowflake
It is very simple to connect Zoho CRM to Snowflake, it can be done in a fast and easy manner with Windsor.ai.
First Step
Follow the Tutorial Below:
- Add all the columns that are returned by your connector’s URL.
- Create the WINDSOR_UPLOAD role (name has no importance)
- Create a user and add the previously created role to that user
- Grant rights to the DATABASE to the created user
- Grand the rights to the destination table
- Get the required fields from Snowflake to use the Snowflake destination in Onboard Form
- Get the username
- Get the password
- Get the account
- Get the warehouse
- Get the database
- Get the schema
- Get the table name
Second step
1.You need to select Zoho CRM as a Data Source and Grant Access to Windsor.ai.
2. In Select Destination select Snowflake as destination
3. Enter all the credentials required and click Save
4.Your data will now be streamed to Snowflake. In case there is an error you will be notified.
Zoho CRM metrics and dimensions available for streaming into Snowflake
| name | type | description |
|---|---|---|
| Accounts Account Name | TEXT | Account Name |
| Accounts Account Number | TEXT | Account Number |
| Accounts Account Site | TEXT | Account Site |
| Accounts Account Type | TEXT | Account Type |
| Accounts Annual Revenue | TEXT | Annual Revenue |
| Accounts Billing City | CITY | Billing City |
| Accounts Billing Code | TEXT | Billing Code |
| Accounts Billing Country | COUNTRY | Billing Country |
| Accounts Billing State | TEXT | Billing State |
| Accounts Billing Street | TEXT | Billing Street |
| Accounts Change Log Time | TIMESTAMP | Change Log Time |
| Accounts Created By | TEXT | Created By |
| Accounts Created Time | TIMESTAMP | Created Time |
| Accounts Description | TEXT | Description |
| Accounts Employees | TEXT | Employees |
| Accounts Enrich Status | TEXT | Enrich Status |
| Accounts Fax | TEXT | Fax |
| Accounts Record Id | TEXT | Record Id |
| Accounts Industry | TEXT | Industry |
| Accounts Last Activity Time | TIMESTAMP | Last Activity Time |
| Accounts Last Enriched Time | TIMESTAMP | Last Enriched Time |
| Accounts Locked | TEXT | Locked |
| Accounts Modified By | TEXT | Modified By |
| Accounts Modified Time | TIMESTAMP | Modified Time |
| Accounts Account Owner id | TEXT | Account Owner id |
| Accounts Owner First Name | TEXT | Accounts Owner First Name |
| Accounts Owner Last Name | TEXT | Accounts Owner Last Name |
| Accounts Ownership | TEXT | Ownership |
| Accounts Parent Account | TEXT | Parent Account |
| Accounts Phone | TEXT | Phone |
| Accounts Rating | TEXT | Rating |
| Accounts Account Image | TEXT | Account Image |
| Accounts Shipping City | CITY | Shipping City |
| Accounts Shipping Code | TEXT | Shipping Code |
| Accounts Shipping Country | COUNTRY | Shipping Country |
| Accounts Shipping State | TEXT | Shipping State |
| Accounts Shipping Street | TEXT | Shipping Street |
| Accounts Sic Code | TEXT | Sic Code |
| Accounts Tag | TEXT | Tag |
| Accounts Ticker Symbol | TEXT | Ticker Symbol |
| Accounts Website | TEXT | Website |
| Call Agenda | TEXT | Call Agenda |
| Call Duration | TEXT | Call Duration |
| Call Duration (In Seconds) | TEXT | Call Duration (In Seconds) |
| Call Purpose | TEXT | Call Purpose |
| Call Result | TEXT | Call Result |
| Call Start Time | TIMESTAMP | Call Start Time |
| Call Type | TEXT | Call Type |
| Caller Id | TEXT | Caller Id |
| Calls Created By | TEXT | Created By |
| Calls Created Time | TIMESTAMP | Created Time |
| Cti Entry | TEXT | Cti Entry |
| Calls Description | TEXT | Description |
| Dialled Number | TEXT | Dialled Number |
| Calls Record Id | TEXT | Record Id |
| Calls Modified By | TEXT | Modified By |
| Calls Modified Time | TIMESTAMP | Modified Time |
| Outgoing Call Status | TEXT | Outgoing Call Status |
| Calls Call Owner id | TEXT | Call Owner id |
| Calls Owner First Name | TEXT | Calls Owner First Name |
| Calls Owner Last Name | TEXT | Calls Owner Last Name |
| Calls Reminder | TEXT | Reminder |
| Scheduled In Crm | TEXT | Scheduled In Crm |
| Calls Subject | TEXT | Subject |
| Calls Tag | TEXT | Tag |
| Voice Recording | TEXT | Voice Recording |
| Related To | TEXT | Related To |
| Calls Contact Name | TEXT | Contact Name |
| Campaign management campaign by loaction ad | NUMERIC | Campaign management campaign by loaction ad |
| Campaign management campaign by loaction ae | NUMERIC | Campaign management campaign by loaction ae |
| Campaign management campaign by loaction af | NUMERIC | Campaign management campaign by loaction af |
| Campaign management campaign by loaction al | NUMERIC | Campaign management campaign by loaction al |
| Campaign management campaign by loaction am | NUMERIC | Campaign management campaign by loaction am |
| Campaign management campaign by loaction ar | NUMERIC | Campaign management campaign by loaction ar |
| Campaign management campaign by loaction at | NUMERIC | Campaign management campaign by loaction at |
| Campaign management campaign by loaction au | NUMERIC | Campaign management campaign by loaction au |
| Campaign management campaign by loaction az | NUMERIC | Campaign management campaign by loaction az |
| Campaign management campaign by loaction ba | NUMERIC | Campaign management campaign by loaction ba |
| Campaign management campaign by loaction bd | NUMERIC | Campaign management campaign by loaction bd |
| Campaign management campaign by loaction be | NUMERIC | Campaign management campaign by loaction be |
| Campaign management campaign by loaction bg | NUMERIC | Campaign management campaign by loaction bg |
| Campaign management campaign by loaction bh | NUMERIC | Campaign management campaign by loaction bh |
| Campaign management campaign by loaction bo | NUMERIC | Campaign management campaign by loaction bo |
| Campaign management campaign by loaction br | NUMERIC | Campaign management campaign by loaction br |
| Campaign management campaign by loaction by | NUMERIC | Campaign management campaign by loaction by |
| Campaign management campaign by loaction bz | NUMERIC | Campaign management campaign by loaction bz |
| Campaign management campaign by loaction ca | NUMERIC | Campaign management campaign by loaction ca |
| Campaign management campaign by loaction cd | NUMERIC | Campaign management campaign by loaction cd |
| Campaign management campaign by loaction ch | NUMERIC | Campaign management campaign by loaction ch |
| Campaign management campaign by loaction ci | NUMERIC | Campaign management campaign by loaction ci |
| Campaign management campaign by loaction cl | NUMERIC | Campaign management campaign by loaction cl |
| Campaign management campaign by loaction cm | NUMERIC | Campaign management campaign by loaction cm |
| Campaign management campaign by loaction cn | NUMERIC | Campaign management campaign by loaction cn |
| Campaign management campaign by loaction co | NUMERIC | Campaign management campaign by loaction co |
| Campaign management campaign by loaction cr | NUMERIC | Campaign management campaign by loaction cr |
| Campaign management campaign by loaction cw | NUMERIC | Campaign management campaign by loaction cw |
| Campaign management campaign by loaction cy | NUMERIC | Campaign management campaign by loaction cy |
| Campaign management campaign by loaction cz | NUMERIC | Campaign management campaign by loaction cz |
| Campaign management campaign by loaction de | NUMERIC | Campaign management campaign by loaction de |
| Campaign management campaign by loaction dk | NUMERIC | Campaign management campaign by loaction dk |
| Campaign management campaign by loaction do | NUMERIC | Campaign management campaign by loaction do |
| Campaign management campaign by loaction ec | NUMERIC | Campaign management campaign by loaction ec |
| Campaign management campaign by loaction ee | NUMERIC | Campaign management campaign by loaction ee |
| Campaign management campaign by loaction eg | NUMERIC | Campaign management campaign by loaction eg |
| Campaign management campaign by loaction es | NUMERIC | Campaign management campaign by loaction es |
| Campaign management campaign by loaction fi | NUMERIC | Campaign management campaign by loaction fi |
| Campaign management campaign by loaction fr | NUMERIC | Campaign management campaign by loaction fr |
| Campaign management campaign by loaction gb | NUMERIC | Campaign management campaign by loaction gb |
| Campaign management campaign by loaction ge | NUMERIC | Campaign management campaign by loaction ge |
| Campaign management campaign by loaction gh | NUMERIC | Campaign management campaign by loaction gh |
| Campaign management campaign by loaction gp | NUMERIC | Campaign management campaign by loaction gp |
| Campaign management campaign by loaction gr | NUMERIC | Campaign management campaign by loaction gr |
| Campaign management campaign by loaction gt | NUMERIC | Campaign management campaign by loaction gt |
| Campaign management campaign by loaction hk | NUMERIC | Campaign management campaign by loaction hk |
| Campaign management campaign by loaction hn | NUMERIC | Campaign management campaign by loaction hn |
| Campaign management campaign by loaction hr | NUMERIC | Campaign management campaign by loaction hr |
| Campaign management campaign by loaction hu | NUMERIC | Campaign management campaign by loaction hu |
| Campaign management campaign by loaction id | NUMERIC | Campaign management campaign by loaction id |
| Campaign management campaign by loaction ie | NUMERIC | Campaign management campaign by loaction ie |
| Campaign management campaign by loaction il | NUMERIC | Campaign management campaign by loaction il |
| Campaign management campaign by loaction im | NUMERIC | Campaign management campaign by loaction im |
| Campaign management campaign by loaction in | NUMERIC | Campaign management campaign by loaction in |
| Campaign management campaign by loaction iq | NUMERIC | Campaign management campaign by loaction iq |
| Campaign management campaign by loaction ir | NUMERIC | Campaign management campaign by loaction ir |
| Campaign management campaign by loaction is | NUMERIC | Campaign management campaign by loaction is |
| Campaign management campaign by loaction it | NUMERIC | Campaign management campaign by loaction it |
| Campaign management campaign by loaction jo | NUMERIC | Campaign management campaign by loaction jo |
| Campaign management campaign by loaction jp | NUMERIC | Campaign management campaign by loaction jp |
| Campaign management campaign by loaction ke | NUMERIC | Campaign management campaign by loaction ke |
| Campaign management campaign by loaction kg | NUMERIC | Campaign management campaign by loaction kg |
| Campaign management campaign by loaction kh | NUMERIC | Campaign management campaign by loaction kh |
| Campaign management campaign by loaction kr | NUMERIC | Campaign management campaign by loaction kr |
| Campaign management campaign by loaction kw | NUMERIC | Campaign management campaign by loaction kw |
| Campaign management campaign by loaction kz | NUMERIC | Campaign management campaign by loaction kz |
| Campaign management campaign by loaction la | NUMERIC | Campaign management campaign by loaction la |
| Campaign management campaign by loaction lb | NUMERIC | Campaign management campaign by loaction lb |
| Campaign management campaign by loaction li | NUMERIC | Campaign management campaign by loaction li |
| Campaign management campaign by loaction lk | NUMERIC | Campaign management campaign by loaction lk |
| Campaign management campaign by loaction lt | NUMERIC | Campaign management campaign by loaction lt |
| Campaign management campaign by loaction lu | NUMERIC | Campaign management campaign by loaction lu |
| Campaign management campaign by loaction lv | NUMERIC | Campaign management campaign by loaction lv |
| Campaign management campaign by loaction ma | NUMERIC | Campaign management campaign by loaction ma |
| Campaign management campaign by loaction mc | NUMERIC | Campaign management campaign by loaction mc |
| Campaign management campaign by loaction md | NUMERIC | Campaign management campaign by loaction md |
| Campaign management campaign by loaction me | NUMERIC | Campaign management campaign by loaction me |
| Campaign management campaign by loaction mg | NUMERIC | Campaign management campaign by loaction mg |
| Campaign management campaign by loaction mk | NUMERIC | Campaign management campaign by loaction mk |
| Campaign management campaign by loaction mm | NUMERIC | Campaign management campaign by loaction mm |
| Campaign management campaign by loaction mn | NUMERIC | Campaign management campaign by loaction mn |
| Campaign management campaign by loaction mq | NUMERIC | Campaign management campaign by loaction mq |
| Campaign management campaign by loaction mt | NUMERIC | Campaign management campaign by loaction mt |
| Campaign management campaign by loaction mu | NUMERIC | Campaign management campaign by loaction mu |
| Campaign management campaign by loaction mv | NUMERIC | Campaign management campaign by loaction mv |
| Campaign management campaign by loaction mx | NUMERIC | Campaign management campaign by loaction mx |
| Campaign management campaign by loaction my | NUMERIC | Campaign management campaign by loaction my |
| Campaign management campaign by loaction nc | NUMERIC | Campaign management campaign by loaction nc |
| Campaign management campaign by loaction ng | NUMERIC | Campaign management campaign by loaction ng |
| Campaign management campaign by loaction ni | NUMERIC | Campaign management campaign by loaction ni |
| Campaign management campaign by loaction nl | NUMERIC | Campaign management campaign by loaction nl |
| Campaign management campaign by loaction no | NUMERIC | Campaign management campaign by loaction no |
| Campaign management campaign by loaction np | NUMERIC | Campaign management campaign by loaction np |
| Campaign management campaign by loaction nz | NUMERIC | Campaign management campaign by loaction nz |
| Campaign management campaign by loaction om | NUMERIC | Campaign management campaign by loaction om |
| Campaign management campaign by loaction pa | NUMERIC | Campaign management campaign by loaction pa |
| Campaign management campaign by loaction pe | NUMERIC | Campaign management campaign by loaction pe |
| Campaign management campaign by loaction ph | NUMERIC | Campaign management campaign by loaction ph |
| Campaign management campaign by loaction pk | NUMERIC | Campaign management campaign by loaction pk |
| Campaign management campaign by loaction pl | NUMERIC | Campaign management campaign by loaction pl |
| Campaign management campaign by loaction pr | NUMERIC | Campaign management campaign by loaction pr |
| Campaign management campaign by loaction ps | NUMERIC | Campaign management campaign by loaction ps |
| Campaign management campaign by loaction pt | NUMERIC | Campaign management campaign by loaction pt |
| Campaign management campaign by loaction py | NUMERIC | Campaign management campaign by loaction py |
| Campaign management campaign by loaction qa | NUMERIC | Campaign management campaign by loaction qa |
| Campaign management campaign by loaction re | NUMERIC | Campaign management campaign by loaction re |
| Campaign management campaign by loaction ro | NUMERIC | Campaign management campaign by loaction ro |
| Campaign management campaign by loaction rs | NUMERIC | Campaign management campaign by loaction rs |
| Campaign management campaign by loaction ru | NUMERIC | Campaign management campaign by loaction ru |
| Campaign management campaign by loaction rw | NUMERIC | Campaign management campaign by loaction rw |
| Campaign management campaign by loaction sa | NUMERIC | Campaign management campaign by loaction sa |
| Campaign management campaign by loaction se | NUMERIC | Campaign management campaign by loaction se |
| Campaign management campaign by loaction sg | NUMERIC | Campaign management campaign by loaction sg |
| Campaign management campaign by loaction si | NUMERIC | Campaign management campaign by loaction si |
| Campaign management campaign by loaction sk | NUMERIC | Campaign management campaign by loaction sk |
| Campaign management campaign by loaction sn | NUMERIC | Campaign management campaign by loaction sn |
| Campaign management campaign by loaction sr | NUMERIC | Campaign management campaign by loaction sr |
| Campaign management campaign by loaction sv | NUMERIC | Campaign management campaign by loaction sv |
| Campaign management campaign by loaction th | NUMERIC | Campaign management campaign by loaction th |
| Campaign management campaign by loaction tn | NUMERIC | Campaign management campaign by loaction tn |
| Campaign management campaign by loaction tr | NUMERIC | Campaign management campaign by loaction tr |
| Campaign management campaign by loaction tt | NUMERIC | Campaign management campaign by loaction tt |
| Campaign management campaign by loaction tw | NUMERIC | Campaign management campaign by loaction tw |
| Campaign management campaign by loaction tz | NUMERIC | Campaign management campaign by loaction tz |
| Campaign management campaign by loaction ua | NUMERIC | Campaign management campaign by loaction ua |
| Campaign management campaign by loaction ug | NUMERIC | Campaign management campaign by loaction ug |
| Campaign management campaign by loaction us | NUMERIC | Campaign management campaign by loaction us |
| Campaign management campaign by loaction uy | NUMERIC | Campaign management campaign by loaction uy |
| Campaign management campaign by loaction ve | NUMERIC | Campaign management campaign by loaction ve |
| Campaign management campaign by loaction vn | NUMERIC | Campaign management campaign by loaction vn |
| Campaign management campaign by loaction ye | NUMERIC | Campaign management campaign by loaction ye |
| Campaign management campaign by loaction za | NUMERIC | Campaign management campaign by loaction za |
| Campaign management campaign by loaction zw | NUMERIC | Campaign management campaign by loaction zw |
| Campaign management campaign details campaign key | TEXT | Campaign management campaign details campaign key |
| Campaign management campaign details campaign name | TEXT | Campaign management campaign details campaign name |
| Campaign management campaign details created time | TIMESTAMP | Campaign management campaign details created time |
| Campaign management campaign details email from | TEXT | Campaign management campaign details email from |
| Campaign management campaign details email options | TEXT | Campaign management campaign details email options |
| Campaign management campaign details email subject | TEXT | Campaign management campaign details email subject |
| Campaign management campaign details email type | TEXT | Campaign management campaign details email type |
| Campaign management campaign details reply to | TEXT | Campaign management campaign details reply to |
| Campaign management campaign details sent time | TIMESTAMP | Campaign management campaign details sent time |
| Campaign management campaign reports autoreply count | NUMERIC | Campaign management campaign reports autoreply count |
| Campaign management campaign reports bounce percent | PERCENT | Campaign management campaign reports bounce percent |
| Campaign management campaign reports bounces count | NUMERIC | Campaign management campaign reports bounces count |
| Campaign management campaign reports campaign name | TEXT | Campaign management campaign reports campaign name |
| Campaign management campaign reports clicksperopenrate | PERCENT | Campaign management campaign reports clicksperopenrate |
| Campaign management campaign reports complaints count | NUMERIC | Campaign management campaign reports complaints count |
| Campaign management campaign reports complaints percent | PERCENT | Campaign management campaign reports complaints percent |
| Campaign management campaign reports delivered count | NUMERIC | Campaign management campaign reports delivered count |
| Campaign management campaign reports delivered percent | PERCENT | Campaign management campaign reports delivered percent |
| Campaign management campaign reports emails sent count | NUMERIC | Campaign management campaign reports emails sent count |
| Campaign management campaign reports forward percent | PERCENT | Campaign management campaign reports forward percent |
| Campaign management campaign reports forwards count | NUMERIC | Campaign management campaign reports forwards count |
| Campaign management campaign reports hardbounce count | NUMERIC | Campaign management campaign reports hardbounce count |
| Campaign management campaign reports open percent | PERCENT | Campaign management campaign reports open percent |
| Campaign management campaign reports opens count | NUMERIC | Campaign management campaign reports opens count |
| Campaign management campaign reports softbounce count | NUMERIC | Campaign management campaign reports softbounce count |
| Campaign management campaign reports spam percent | PERCENT | Campaign management campaign reports spam percent |
| Campaign management campaign reports spams count | NUMERIC | Campaign management campaign reports spams count |
| Campaign management campaign reports unique clicked percent | PERCENT | Campaign management campaign reports unique clicked percent |
| Campaign management campaign reports unique clicks count | NUMERIC | Campaign management campaign reports unique clicks count |
| Campaign management campaign reports unopened | TEXT | Campaign management campaign reports unopened |
| Campaign management campaign reports unopened percent | PERCENT | Campaign management campaign reports unopened percent |
| Campaign management campaign reports unsent count | NUMERIC | Campaign management campaign reports unsent count |
| Campaign management campaign reports unsent percent | PERCENT | Campaign management campaign reports unsent percent |
| Campaign management campaign reports unsub count | NUMERIC | Campaign management campaign reports unsub count |
| Campaign management campaign reports unsubscribe percent | PERCENT | Campaign management campaign reports unsubscribe percent |
| Actual Cost | TEXT | The actual cost spent on the campaign |
| Budgeted Cost | TEXT | The planned amount to be spent on the campaign |
| Campaigns Campaign Name | TEXT | Name of the Campaign |
| Campaigns Created By | TEXT | Created By |
| Campaigns Created Time | TIMESTAMP | Date and time at which the record was created. This is a system-generated field. You cannot modify it. |
| Campaign Currency | TEXT | The currency in which the revenue is generated |
| Campaigns Description | TEXT | Description about the Campaign |
| End Date | DATE | The date on which the Campaign ends |
| Exchange Rate | TEXT | Represents the exchange rate of the currency of the campaign amount |
| Expected Response | TEXT | Expected response |
| Campaigns Expected Revenue | TEXT | Represents the expected revenue of the campaign. |
| Campaigns Id | TEXT | The unique ID of the campaign |
| Campaigns Layout | TEXT | Layout |
| Campaigns Modified By | TEXT | Modified By |
| Campaigns Modified Time | TIMESTAMP | Date and time at which the record was last modified. This is a system-generated field. You cannot modify it. |
| Num Sent | TEXT | The number of leads/contacts to whom the campaign details have been sent |
| Campaigns Campaign Owner id | TEXT | Campaign Owner id |
| Campaigns Owner First Name | TEXT | Campaigns Owner First Name |
| Campaigns Owner Last Name | TEXT | Campaigns Owner Last Name |
| Parent Campaign | TEXT | Represents the details of the parent campaign, if any |
| Start Date | DATE | The date on which the Campaign starts |
| Campaigns Status | TEXT | Represents the status of the campaign |
| Campaigns Tag | TEXT | Tag |
| Campaigns Type | TEXT | Represents the type of Campaign |
| Cases Account Name | TEXT | Account Name |
| Cases Add Comment | TEXT | Add Comment |
| Case Number | TEXT | Case Number |
| Case Origin | TEXT | Case Origin |
| Cases Comments | TEXT | Comments |
| Cases Created By | TEXT | Created By |
| Cases Created Time | TIMESTAMP | Created Time |
| Cases Deal Name | TEXT | Deal Name |
| Cases Description | TEXT | Description |
| Cases Email | TEXT | |
| Cases Record Id | TEXT | Record Id |
| Cases Internal Comments | TEXT | Internal Comments |
| Cases Locked | TEXT | Locked |
| Cases Modified By | TEXT | Modified By |
| Cases Modified Time | TIMESTAMP | Modified Time |
| Cases No. Of Comments | TEXT | No. Of Comments |
| Cases Case Owner id | TEXT | Case Owner id |
| Cases Owner First Name | TEXT | Cases Owner First Name |
| Cases Owner Last Name | TEXT | Cases Owner Last Name |
| Cases Phone | TEXT | Phone |
| Cases Priority | TEXT | Priority |
| Cases Product Name | TEXT | Product Name |
| Cases Related To | TEXT | Related To |
| Cases Reported By | TEXT | Reported By |
| Cases Solution | TEXT | Solution |
| Cases Status | TEXT | Status |
| Cases Subject | TEXT | Subject |
| Cases Cases Tag | TEXT | Tag |
| Cases Type | TEXT | Type |
| Contacts Account Name | TEXT | Account Name |
| Contact Ad | TEXT | Ad |
| Contacts Ad campaign name | TEXT | Ad campaign name |
| Contacts Ad click date | DATE | Ad click date |
| Contacts Ad network | TEXT | Ad Network |
| Contacts Adgroup name | TEXT | Adgroup name |
| Contacts Adgroupid | TEXT | Adgroupid |
| Contacts Adid | TEXT | Adid |
| Contacts Assistant | TEXT | Name of the contact's assistant |
| Contacts Asst phone | TEXT | Phone number of the Contact's assistant, if any |
| Contacts Average time spent minutes | TIMESTAMP | Average time spent minutes |
| Contacts Change Log Time | TIMESTAMP | Change Log Time |
| Contacts Contact Click type | TEXT | Click type |
| Contacts Conversion export status | TEXT | Conversion export status |
| Contacts Conversion exported on | TEXT | Conversion exported on |
| Contacts Cost per click | TEXT | Cost per click |
| Contacts Contact Cost per conversion | TEXT | Cost per conversion |
| Contacts Created By | TEXT | Created By |
| Contacts Created time | TIMESTAMP | Date and time at which the record was created. This is a system-generated field. You cannot modify it. |
| Contacts Date of birth | DATE | Date of birth of the Contact in mm/dd/yyyy format |
| Contacts Days visited | TEXT | The number of days the contact visited Zoho CRM |
| Contacts Department | TEXT | Represents the department of the contact |
| Contacts Contact Description | TEXT | Description of the Contact |
| Contacts Contact Device type | TEXT | Device type |
| Contacts Email | TEXT | Email ID of the contact |
| Contacts Email opt out | TEXT | Specifies whether the contact has opted out of email notifications from Zoho CRM |
| Contacts Enrich Status | TEXT | Enrich Status |
| Contacts Fax | TEXT | Fax number of the Contact |
| Contacts First name | TEXT | Represents the first name of the Contact |
| Contacts First visited time | TIMESTAMP | Date and time at which the Contact first visited Zoho CRM. This is a system-generated field. You cannot modify it. |
| Contacts First visited url | TEXT | The URL address of the page that the contact visited first. This is a system-generated field. You cannot modify it. |
| Contacts Full name | TEXT | Represents the full name of the Contact |
| Contacts Gadconfigid | TEXT | Gadconfigid |
| Contacts Gclid | TEXT | GCL ID |
| Home Phone | TEXT | Home Phone |
| Contacts Id | TEXT | Unique ID of the Contact |
| Contacts Contact Keyword | TEXT | keyword |
| Contacts Last activity time | TIMESTAMP | The date and time at which the record was last used in an operation. This is a system-generated field. You cannot modify it. |
| Contacts Last Enriched Time | TIMESTAMP | Last Enriched Time |
| Contacts Last name | TEXT | Last name of the Contact. This is a mandatory field. |
| Contacts Last visited time | TIMESTAMP | The date and time at which the Contact last visited Zoho CRM. This is a system-generated field. You cannot modify it. |
| Contacts Lead source | TEXT | Contacts Lead Source |
| Contacts Locked | TEXT | Locked |
| Contacts Mailing city | CITY | Represents address details of the Contact |
| Contacts Mailing country | COUNTRY | The other address of the contact, if any |
| Contacts Mailing state | TEXT | Primary mailing address of the contact |
| Contacts Mailing street | TEXT | Represents address details of the Contact |
| Contacts Mailing zip | TEXT | Represents address details of the Contact |
| Contacts Mobile | TEXT | Mobile number of the Contact |
| Contacts Modified By | TEXT | Modified By |
| Contacts Modified time | TIMESTAMP | Date and time at which the record was last modified. This is a system-generated field. You cannot modify it. |
| Contacts Number of chats | TEXT | The number of times the contact has had a chat with the Zoho CRM team. This is a system-generated field. You cannot modify it. |
| Contacts Other city | CITY | Represents address details of the Contact |
| Contacts Other country | COUNTRY | The other address of the contact, if any |
| Contacts Other phone | TEXT | The other phone number of the contact, if any |
| Contacts Other state | REGION | The other address of the contact, if any |
| Contacts Other street | TEXT | Represents address details of the Contact |
| Contacts Other zip | TEXT | Represents address details of the Contact |
| Contacts Contact Owner id | TEXT | Contact Owner id |
| Contacts Owner First Name | TEXT | Contacts Owner First Name |
| Contacts Owner Last Name | TEXT | Contacts Owner Last Name |
| Contacts Phone | TEXT | The phone number of the Contact |
| Contacts Reason for conversion failure | TEXT | Reason for conversion failure |
| Contacts Contact Referrer | TEXT | Referrer |
| Contacts Reporting to | TEXT | Reporting to |
| Contacts Salutation | TEXT | Mr., Ms, Mrs., or others |
| Contacts Search partner network | TEXT | Search partner network |
| Contacts Secondary email | TEXT | Alternate email address of the contact |
| Contacts Skype id | TEXT | The Skype ID of the Contact |
| Contacts Contact Tag | TEXT | Name and ID of the Contact who referred this Contact |
| Contacts Contact Title | TEXT | Title/job position of the Contact |
| Contacts Twitter | TEXT | The Twitter handle of the contact |
| Contacts Unsubscribed mode | TEXT | Unsubscribed mode |
| Contacts Unsubscribed time | TIMESTAMP | Unsubscribed time |
| Contacts Vendor name | TEXT | Vendor Name |
| Contacts Visitor score | TEXT | Score for the contact obtained from SalesIQ |
| Contacts Zcampaignid | TEXT | Zcampaignid |
| Country | COUNTRY | Country |
| Data Source | TEXT | The name of the Windsor connector returning the row |
| Date | DATE | Date at which the record was created. |
| Day of month | TEXT | Day of the month |
| Deals Account Name | TEXT | Account Name |
| Deals Ad | TEXT | Ad |
| Deals Ad Campaign Name | TEXT | Ad Campaign Name |
| Deals Ad Click Date | DATE | Ad Click Date |
| Deals Ad Network | TEXT | Ad Network |
| Deals Adgroup Name | TEXT | Adgroup Name |
| Deals Adgroupid | TEXT | Adgroupid |
| Deals Adid | TEXT | Adid |
| Deals Amount | NUMERIC | Amount |
| Deals Campaign Source | TEXT | Campaign Source |
| Deals Change Log Time | TIMESTAMP | Change Log Time |
| Deals Click Type | TEXT | Click Type |
| Deals Closing Date | DATE | Closing Date |
| Deals Contact First Name | TEXT | Deals Contact First Name |
| Deals Contact id | TEXT | Deals Contact id |
| Deals Contact last Name | TEXT | Deals Contact last Name |
| Deals Contact First Name (alias for deals_contact_first_name) | TEXT | Deals Contact First Name |
| Deals Conversion Export Status | TEXT | Conversion Export Status |
| Deals Conversion Exported On | TEXT | Conversion Exported On |
| Deals Cost Per Click | TEXT | Cost Per Click |
| Deals Cost Per Conversion | TEXT | Cost Per Conversion |
| Deals Created By | TEXT | Created By |
| Deals Created Time | TIMESTAMP | Created Time |
| Deals Deal Name | TEXT | Deal Name |
| Deals Description | TEXT | Description |
| Deals Device Type | TEXT | Device Type |
| Deals Expected Revenue | TEXT | Expected Revenue |
| Deals Gadconfigid | TEXT | Gadconfigid |
| Deals Gclid | TEXT | Gclid |
| Deals Record Id | TEXT | Record Id |
| Deals Keyword | TEXT | Keyword |
| Deals Keywordid | TEXT | Keywordid |
| Deals Last Activity Time | TIMESTAMP | Last Activity Time |
| Deals Lead Conversion Time | TIMESTAMP | Lead Conversion Time |
| Deals Lead Source | TEXT | Lead Source |
| Deals Locked | TEXT | Locked |
| Deals Modified By | TEXT | Modified By |
| Deals Modified Time | TIMESTAMP | Modified Time |
| Deals Next Step | TEXT | Next Step |
| Deals Overall Sales Duration | TEXT | Overall Sales Duration |
| Deals Deal Owner id | TEXT | Deal Owner id |
| Deals Owner First Name | TEXT | Deals Owner First Name |
| Deals Owner Last Name | TEXT | Deals Owner Last Name |
| Deals Probability (%) | TEXT | Probability (%) |
| Deals Reason For Conversion Failure | TEXT | Reason For Conversion Failure |
| Deals Sales Cycle Duration | TEXT | Sales Cycle Duration |
| Deals Search Partner Network | TEXT | Search Partner Network |
| Deals Stage | TEXT | Stage |
| Deals Tag | TEXT | Tag |
| Deals Type | TEXT | Type |
| Deals Zcampaignid | TEXT | Zcampaignid |
| TEXT | ||
| Events All Day | TEXT | All Day |
| Check-In Address | TEXT | Check-In Address |
| Check-In By | TEXT | Check-In By |
| Check-In City | CITY | Check-In City |
| Check-In Comment | TEXT | Check-In Comment |
| Check-In Country | COUNTRY | Check-In Country |
| Check-In State | TEXT | Check-In State |
| Checked In Status | TEXT | Checked In Status |
| Check-In Sub-Locality | TEXT | Check-In Sub-Locality |
| Check-In Time | TIMESTAMP | Check-In Time |
| Events Created By | TEXT | Created By |
| Events Created Time | TIMESTAMP | Created Time |
| Events Description | TEXT | Description |
| Events To | TIMESTAMP | To |
| Events Title | TEXT | Title |
| Events Record Id | TEXT | Record Id |
| Events Latitude | TEXT | Latitude |
| Events Longitude | TEXT | Longitude |
| Events Modified By | TEXT | Modified By |
| Events Modified Time | TIMESTAMP | Modified Time |
| Events Event Owner id | TEXT | Event Owner id |
| Events Owner First Name | TEXT | Events Owner First Name |
| Events Owner Last Name | TEXT | Events Owner Last Name |
| Events Participants | TEXT | Participants |
| Events Repeat | TEXT | Repeat |
| Event Reminder | TEXT | Reminder |
| Events Participants Reminder | TEXT | Participants Reminder |
| Events From | TIMESTAMP | From |
| Events Tag | TEXT | Tag |
| Events Location | TEXT | Location |
| Events Related To | TEXT | Related To |
| Events Contact Name | TEXT | Contact Name |
| Events Zip Code | TEXT | Zip Code |
| First Visited Time | TIMESTAMP | First Visited Time |
| First Visited URL | TEXT | First Visited URL |
| First Name | TEXT | First Name |
| Invoices Account Name | TEXT | Account Name |
| Invoices Adjustment | TEXT | Adjustment |
| Invoices Billing City | CITY | Billing City |
| Invoices Billing Code | TEXT | Billing Code |
| Invoices Billing Country | COUNTRY | Billing Country |
| Invoices Billing State | TEXT | Billing State |
| Invoices Billing Street | TEXT | Billing Street |
| Invoices Contact First Name | TEXT | Invoices Contact First Name |
| Invoices Contact id | TEXT | Invoices Contact id |
| Invoices Contact last Name | TEXT | Invoices Contact last Name |
| Invoices Contact First Name (alias for invoices_contact_first_name) | TEXT | Invoices Contact First Name |
| Invoices Created By | TEXT | Created By |
| Invoices Created Time | TIMESTAMP | Created Time |
| Invoices Description | TEXT | Description |
| Invoices Discount | TEXT | Discount |
| Invoices Due Date | DATE | Due Date |
| Invoices Excise Duty | TEXT | Excise Duty |
| Invoices Grand Total | TEXT | Grand Total |
| Invoices Record Id | TEXT | Record Id |
| Invoice Date | DATE | Invoice Date |
| Invoices Invoice Number | TEXT | Invoice Number |
| Invoices Invoiced Items | TEXT | Invoiced Items |
| Invoices Locked | TEXT | Locked |
| Invoices Modified By | TEXT | Modified By |
| Invoices Modified Time | TIMESTAMP | Modified Time |
| Invoices Invoice Owner id | TEXT | Invoice Owner id |
| Invoices Owner First Name | TEXT | Invoices Owner First Name |
| Invoices Owner Last Name | TEXT | Invoices Owner Last Name |
| Invoices Purchase Order | TEXT | Purchase Order |
| Invoices Sales Commission | TEXT | Sales Commission |
| Invoices Sales Order | TEXT | Sales Order |
| Invoices Shipping City | CITY | Shipping City |
| Invoices Shipping Code | TEXT | Shipping Code |
| Invoices Shipping Country | COUNTRY | Shipping Country |
| Invoices Shipping State | TEXT | Shipping State |
| Invoices Shipping Street | TEXT | Shipping Street |
| Invoices Status | TEXT | Status |
| Invoices Sub Total | TEXT | Sub Total |
| Invoices Subject | TEXT | Subject |
| Invoices Tag | TEXT | Tag |
| Invoices Tax | TEXT | Tax |
| Invoices Terms And Conditions | TEXT | Terms And Conditions |
| Last Name | TEXT | Last Name |
| Lead Status | TEXT | Lead Status |
| Leads Ad | TEXT | Ad |
| Leads Ad Campaign Name | TEXT | Ad Campaign Name |
| Leads Ad Click Date | DATE | Ad Click Date |
| Leads Ad Network | TEXT | Ad Network |
| Leads AdGroup Name | TEXT | Leads AdGroup Name |
| Adgroupid | TEXT | Adgroupid |
| Leads Adid | TEXT | Adid |
| Leads Annual Revenue | TEXT | Annual Revenue |
| Average Time Spent (Minutes) | TEXT | Average Time Spent (Minutes) |
| Leads Change Log Time | TIMESTAMP | Change Log Time |
| Leads City | CITY | City |
| Leads Click Type | TEXT | Click Type |
| Company | TEXT | Company |
| Leads Conversion Export Status | TEXT | Conversion Export Status |
| Leads Conversion Exported On | TEXT | Conversion Exported On |
| Is Converted | TEXT | Is Converted |
| Converted Account | TEXT | Converted Account |
| Converted Contact | TEXT | Converted Contact |
| Converted Date Time | TIMESTAMP | Converted Date Time |
| Converted Deal | TEXT | Converted Deal |
| Cost Per Click | TEXT | Cost Per Click |
| Leads Cost Per Conversion | TEXT | Cost Per Conversion |
| Leads Country | COUNTRY | Country |
| Created By | TEXT | Created By |
| Leads Created Time | TIMESTAMP | Created Time |
| Days Visited | TEXT | Days Visited |
| Leads Description | TEXT | Description |
| Leads Title | TEXT | Title |
| Leads Device Type | TEXT | Device Type |
| Leads Email | TEXT | |
| Email Opt Out | TEXT | Email Opt Out |
| Enrich Status | TEXT | Enrich Status |
| Fax | TEXT | Fax |
| Leads First Name | TEXT | First Name |
| First Visit | TIMESTAMP | First Visit |
| First Page Visited | TEXT | First Page Visited |
| Leads Full Name | TEXT | Full Name |
| Leads Gadconfigid | TEXT | Gadconfigid |
| Leads Gclid | TEXT | Gclid |
| Leads Record Id | TEXT | Record Id |
| Leads Industry | TEXT | Industry |
| Leads Keyword | TEXT | Keyword |
| Leads Keywordid | TEXT | Keywordid |
| Last Activity Time | TIMESTAMP | Last Activity Time |
| Leads Last Enriched Time | TIMESTAMP | Last Enriched Time |
| Leads Last Name | TEXT | Last Name |
| Most Recent Visit | TIMESTAMP | Most Recent Visit |
| Lead Conversion Time | TIMESTAMP | Lead Conversion Time |
| Leads Lead Source | TEXT | Lead Source |
| Leads Lead Status | TEXT | Lead Status |
| Leads Locked | TEXT | Locked |
| Mobile | TEXT | Mobile |
| Leads Modified By | TEXT | Modified By |
| Leads Modified Time | TIMESTAMP | Modified Time |
| No. Of Employees | TEXT | No. Of Employees |
| Number Of Chats | TEXT | Number Of Chats |
| Leads Lead Owner id | TEXT | Lead Owner id |
| Leads Owner First Name | TEXT | Leads Owner First Name |
| Leads Owner Last Name | TEXT | Leads Owner Last Name |
| Phone | TEXT | Phone |
| Leads Rating | TEXT | Rating |
| Reason For Conversion Failure | TEXT | Reason For Conversion Failure |
| Leads Referrer | TEXT | Referrer |
| Leads Salutation | TEXT | Salutation |
| Leads Search Partner Network | TEXT | Search Partner Network |
| Secondary Email | TEXT | Secondary Email |
| Skype Id | TEXT | Skype Id |
| Leads State | TEXT | State |
| Leads Street | TEXT | Street |
| Leads Tag | TEXT | Tag |
| Leads Twitter | TEXT | |
| Unsubscribed Mode | TEXT | Unsubscribed Mode |
| Unsubscribed Time | TIMESTAMP | Unsubscribed Time |
| Visitor Score | TEXT | Visitor Score |
| Leads Website | TEXT | Website |
| Zcampaignid | TEXT | Zcampaignid |
| Leads Zip Code | TEXT | Zip Code |
| Month | TEXT | Number of the month |
| Onboarding Completed | TEXT | Onboarding Completed |
| Onboarding Started | TEXT | Onboarding Started |
| Price Active | TEXT | Active |
| Price Created By | TEXT | Created By |
| Price Created Time | TIMESTAMP | Created Time |
| Price Description | TEXT | Description |
| Price Record Id | TEXT | Record Id |
| Price Locked | TEXT | Locked |
| Price Modified By | TEXT | Modified By |
| Price Modified Time | TIMESTAMP | Modified Time |
| Price Books Price Book Owner id | TEXT | Price Book Owner id |
| Price Books Owner First Name | TEXT | Price Books Owner First Name |
| Price Books Owner Last Name | TEXT | Price Books Owner Last Name |
| Price Book Name | TEXT | Price Book Name |
| Price Pricing Details | TEXT | Pricing Details |
| Price Pricing Model | TEXT | Pricing Model |
| Price Tag | TEXT | Tag |
| Commission Rate | TEXT | Commission Rate |
| Products Created By | TEXT | Created By |
| Products Created Time | TIMESTAMP | Created Time |
| Products Description | TEXT | Description |
| Handler | TEXT | Handler |
| Products Record Id | TEXT | Record Id |
| Manufacturer | TEXT | Manufacturer |
| Products Modified By | TEXT | Modified By |
| Products Modified Time | TIMESTAMP | Modified Time |
| Products Product Owner id | TEXT | Product Owner id |
| Products Owner First Name | TEXT | Products Owner First Name |
| Products Owner Last Name | TEXT | Products Owner Last Name |
| Product Active | TEXT | Product Active |
| Products Product Category | TEXT | Product Category |
| Product Code | TEXT | Product Code |
| Products Product Name | TEXT | Product Name |
| Quantity In Demand | TEXT | Quantity In Demand |
| Quantity In Stock | TEXT | Quantity In Stock |
| Qty Ordered | TEXT | Qty Ordered |
| Product Image | TEXT | Product Image |
| Reorder Level | TEXT | Reorder Level |
| Sales End Date | DATE | Sales End Date |
| Sales Start Date | DATE | Sales Start Date |
| Support End Date | DATE | Support End Date |
| Support Start Date | DATE | Support Start Date |
| Products Tag | TEXT | Tag |
| Products Tax | TEXT | Tax |
| Taxable | TEXT | Taxable |
| Unit Price | TEXT | Unit Price |
| Usage Unit | TEXT | Usage Unit |
| Products Vendor Name | TEXT | Vendor Name |
| Purchase Adjustment | TEXT | Adjustment |
| Purchase Billing City | CITY | Billing City |
| Purchase Billing Code | TEXT | Billing Code |
| Purchase Billing Country | COUNTRY | Billing Country |
| Purchase Billing State | TEXT | Billing State |
| Purchase Billing Street | TEXT | Billing Street |
| Purchase Carrier | TEXT | Carrier |
| Purchase Orders Contact First Name | TEXT | Purchase Orders Contact First Name |
| Purchase Orders Contact id | TEXT | Purchase Orders Contact id |
| Purchase Orders Contact last Name | TEXT | Purchase Orders Contact last Name |
| Purchase Orders Contact First Name (alias for purchase_orders_contact_first_name) | TEXT | Purchase Orders Contact First Name |
| Purchase Created By | TEXT | Created By |
| Purchase Description | TEXT | Description |
| Purchase Discount | TEXT | Discount |
| Purchase Due Date | DATE | Due Date |
| Purchase Excise Duty | TEXT | Excise Duty |
| Purchase Grand Total | TEXT | Grand Total |
| Purchase Record Id | TEXT | Record Id |
| Purchase Locked | TEXT | Locked |
| Purchase Modified By | TEXT | Modified By |
| Purchase Modified Time | TIMESTAMP | Modified Time |
| Purchase Orders Purchase Order Owner id | TEXT | Purchase Order Owner id |
| Purchase Orders Owner First Name | TEXT | Purchase Orders Owner First Name |
| Purchase Orders Owner Last Name | TEXT | Purchase Orders Owner Last Name |
| Purchase Po Date | DATE | Po Date |
| Purchase Po Number | TEXT | Po Number |
| Purchase Items | TEXT | Purchase Items |
| Purchase Sales Commission | TEXT | Sales Commission |
| Purchase Shipping City | CITY | Shipping City |
| Purchase Shipping Code | TEXT | Shipping Code |
| Shipping Country | COUNTRY | Shipping Country |
| Purchase Shipping State | TEXT | Shipping State |
| Purchase Shipping Street | TEXT | Shipping Street |
| Purchase Status | TEXT | Status |
| Purchase Sub Total | TEXT | Sub Total |
| Purchase Subject | TEXT | Subject |
| Purchase Tag | TEXT | Tag |
| Purchase Tax | TEXT | Tax |
| Purchase Terms And Conditions | TEXT | Terms And Conditions |
| Purchase Vendor Name | TEXT | Vendor Name |
| Quotes Account Name | TEXT | Account Name |
| Quotes Adjustment | TEXT | Adjustment |
| Quotes Billing City | CITY | Billing City |
| Quotes Billing Code | TEXT | Billing Code |
| Quotes Billing Country | COUNTRY | Billing Country |
| Quotes Billing State | TEXT | Billing State |
| Quotes Billing Street | TEXT | Billing Street |
| Quotes Carrier | TEXT | Carrier |
| Quotes Contact First Name | TEXT | Quotes Contact First Name |
| Quotes Contact id | TEXT | Quotes Contact id |
| Quotes Contact last Name | TEXT | Quotes Contact last Name |
| Quotes Contact First Name (alias for quotes_contact_first_name) | TEXT | Quotes Contact First Name |
| Quotes Created By | TEXT | Created By |
| Quotes Created Time | TIMESTAMP | Created Time |
| Quotes Deal Name | TEXT | Deal Name |
| Quotes Description | TEXT | Description |
| Quotes Discount | TEXT | Discount |
| Quotes Grand Total | TEXT | Grand Total |
| Quotes Record Id | TEXT | Record Id |
| Locked | TEXT | Locked |
| Quotes Modified By | TEXT | Modified By |
| Quotes Modified Time | TIMESTAMP | Modified Time |
| Quotes Quote Owner id | TEXT | Quote Owner id |
| Quotes Owner First Name | TEXT | Quotes Owner First Name |
| Quotes Owner Last Name | TEXT | Quotes Owner Last Name |
| Quote Number | TEXT | Quote Number |
| Quote Stage | TEXT | Quote Stage |
| Quoted Items | TEXT | Quoted Items |
| Quotes Shipping City | CITY | Shipping City |
| Quotes Shipping Code | TEXT | Shipping Code |
| Quotes Shipping Country | COUNTRY | Shipping Country |
| Quotes Shipping State | TEXT | Shipping State |
| Quotes Shipping Street | TEXT | Shipping Street |
| Quotes Sub Total | TEXT | Sub Total |
| Quotes Subject | TEXT | Subject |
| Quotes Tag | TEXT | Tag |
| Quotes Tax | TEXT | Tax |
| Quotes Terms And Conditions | TEXT | Terms And Conditions |
| Valid Until | TEXT | Valid Until |
| Referrer | TEXT | Referrer |
| Sales Orders Account Name | TEXT | Account Name |
| Sales Adjustment | TEXT | Adjustment |
| Sales Billing City | CITY | Billing City |
| Sales Billing Code | TEXT | Billing Code |
| Sales Billing Country | COUNTRY | Billing Country |
| Sales Billing State | TEXT | Billing State |
| Sales Billing Street | TEXT | Billing Street |
| Sales Carrier | TEXT | Carrier |
| Sales Orders Contact First Name | TEXT | Sales Orders Contact First Name |
| Sales Orders Contact id | TEXT | Sales Orders Contact id |
| Sales Orders Contact last Name | TEXT | Sales Orders Contact last Name |
| Sales Orders Contact First Name (alias for sales_orders_contact_first_name) | TEXT | Sales Orders Contact First Name |
| Sales Created By | TEXT | Created By |
| Sales Created Time | TIMESTAMP | Created Time |
| Sales Deal Name | TEXT | Deal Name |
| Sales Description | TEXT | Description |
| Sales Discount | TEXT | Discount |
| Due Date | DATE | Due Date |
| Excise Duty | TEXT | Excise Duty |
| Sales Grand Total | TEXT | Grand Total |
| Sales Record Id | TIMESTAMP | Record Id |
| Sales Locked | TEXT | Locked |
| Sales Modified By | TEXT | Modified By |
| Sales Modified Time | TIMESTAMP | Modified Time |
| Sales Ordered Items | TEXT | Ordered Items |
| Sales Orders Sales Order Owner id | TEXT | Sales Order Owner id |
| Sales Orders Owner First Name | TEXT | Sales Orders Owner First Name |
| Sales Orders Owner Last Name | TEXT | Sales Orders Owner Last Name |
| Pending | TEXT | Pending |
| Purchase Order | TEXT | Purchase Order |
| Quote Name | TEXT | Quote Name |
| Sales Sales Commission | TEXT | Sales Commission |
| Sales Shipping City | CITY | Shipping City |
| Sales Shipping Code | TEXT | Shipping Code |
| Sales Shipping Country | COUNTRY | Shipping Country |
| Sales Shipping State | TEXT | Shipping State |
| Sales Shipping Street | TEXT | Shipping Street |
| So Number | TEXT | So Number |
| Sales Orders Status | TEXT | Status |
| Sales Sub Total | TEXT | Sub Total |
| Sales Subject | TEXT | Subject |
| Sales Tag | TEXT | Tag |
| Sales Tax | TEXT | Tax |
| Sales Terms And Conditions | TEXT | Terms And Conditions |
| Solutions Add Comment | TEXT | Add Comment |
| Solutions Answer | TEXT | Answer |
| Solutions Comments | TEXT | Comments |
| Solutions Created By | TEXT | Created By |
| Solutions Created Time | TIMESTAMP | Created Time |
| Solutions Record Id | TEXT | Record Id |
| Solutions Locked | TEXT | Locked |
| Solutions Modified By | TEXT | Modified By |
| Solutions Modified Time | TIMESTAMP | Modified Time |
| Solutions No. Of Comments | TEXT | No. Of Comments |
| Solutions Solution Owner id | TEXT | Solution Owner id |
| Solutions Owner First Name | TEXT | Solutions Owner First Name |
| Solutions Owner Last Name | TEXT | Solutions Owner Last Name |
| Solutions Product Name | TEXT | Product Name |
| Solutions Published | TEXT | Published |
| Solutions Question | TEXT | Question |
| Solution Number | TEXT | Solution Number |
| Solution Title | TEXT | Solution Title |
| Solutions Status | TEXT | Status |
| Solutions Tag | TEXT | Tag |
| Source | TEXT | The name of the Windsor connector returning the row |
| Tasks Closed Time | TIMESTAMP | Closed Time |
| Tasks Created By | TEXT | Created By |
| Tasks Created Time | TIMESTAMP | Created Time |
| Tasks Description | TEXT | Description |
| Tasks Due Date | DATE | Due Date |
| Tasks Record Id | TEXT | Record Id |
| Tasks Locked | TEXT | Locked |
| Tasks Modified By | TEXT | Modified By |
| Tasks Modified Time | TIMESTAMP | Modified Time |
| Tasks Task Owner id | TEXT | Task Owner id |
| Tasks Owner First Name | TEXT | Tasks Owner First Name |
| Tasks Owner Last Name | TEXT | Tasks Owner Last Name |
| Tasks Priority | TEXT | Priority |
| Tasks Repeat | TEXT | Repeat |
| Tasks Reminder | TEXT | Reminder |
| Tasks Send Notification Email | TEXT | Send Notification Email |
| Tasks Status | TEXT | Status |
| Tasks Subject | TEXT | Subject |
| Tasks Tag | TEXT | Tag |
| Tasks Related To | TEXT | Related To |
| Tasks Contact Name | TEXT | Contact Name |
| Ticket approval count | NUMERIC | Number of approvals associated with the ticket |
| Ticket assignee details | OBJECT | Agent assigned to resolve the ticket |
| Ticket assignee ID | TEXT | ID of agent to whom the ticket is assigned |
| Ticket attachment count | NUMERIC | Number of attachments in the ticket |
| Ticket category | TEXT | Category of the ticket |
| Ticket channel | TEXT | Channel through which the ticket originated (e.g. email) |
| Ticket channel code | TEXT | Code of the ticket's source channel |
| Ticket type | TEXT | Type of ticket. Values supported are Problem, Request, Question, and Others. |
| Ticket closed date and time | DATE | Time of closing the ticket |
| Ticket comments count | NUMERIC | Number of comments in the ticket |
| Ticket contact details | OBJECT | Details of the contact who raised the ticket |
| Ticket contact ID | TEXT | ID of the contact who raised the ticket |
| Ticket created datetime | DATE | Date and time of creating the ticket |
| Ticket custom fields | OBJECT | Custom fields in the ticket |
| Ticket customer response date and time | DATE | Time of receiving customer response |
| Ticket department details | OBJECT | Details of the department to which the ticket belongs |
| Ticket department ID | TEXT | ID of the department to which the ticket belongs |
| Ticket due date and time | DATE | Due date and time for resolving the ticket |
| Ticket email | TEXT | Email in the ticket |
| Zoho Desk Ticket ID | TEXT | ID of the ticket |
| Is ticket deleted | BOOLEAN | Key that returns if the ticket is deleted or not |
| Is ticket following | BOOLEAN | Key that returns if the current user follows the ticket or not |
| Is ticket read | BOOLEAN | Key that denotes if the current user has read the ticket or not |
| Is ticket trashed | BOOLEAN | Field that denotes whether the ticket is in trash |
| Ticket language | TEXT | Language preference to set for the ticket |
| Ticket modified datetime | DATE | Date and time of modifying the ticket |
| Ticket number | TEXT | Index/Serial number of the ticket |
| Ticket phone | TEXT | Phone number in the ticket |
| Ticket priority | TEXT | Priority of the ticket |
| Ticket product details | OBJECT | Product associated with the ticket |
| Ticket resolution | TEXT | Resolution notes recorded in the ticket |
| Ticket response due date and time | DATE | Date on or before which a response must be sent for the ticket |
| Ticket source details | OBJECT | Details of the ticket source from channel |
| Zoho Desk Ticket status | TEXT | Status of the ticket. Includes the custom statuses configured in your help desk portal. |
| Ticket Status Type | TEXT | Type of ticket resolution status.The values supported are OPEN and ON HOLD and CLOSED. |
| Ticket subcategory | TEXT | Subcategory of the ticket |
| Ticket subject | TEXT | Subject of the ticket |
| Ticket tags | TEXT | Comma-separated list of ticket tags |
| Ticket task count | NUMERIC | Number of tasks associated with the ticket |
| Ticket team details | OBJECT | Details of the team assigned to resolve the ticket |
| Ticket team ID | TEXT | ID of the team assigned to resolve the ticket |
| Ticket thread count | NUMERIC | Number of threads associated in the ticket |
| Ticket time entry count | NUMERIC | Number of time entries recorded in the ticket |
| Ticket URL | TEXT | URL to access the resource |
| Today | DATE | Today's date |
| Trial Started Date | DATE | Trial Started Date |
| Vendors Category | TEXT | Category |
| Vendors City | CITY | City |
| Vendors Country | COUNTRY | Country |
| Vendors Created By | TEXT | Created By |
| Vendors Created Time | TIMESTAMP | Created Time |
| Vendors Description | TEXT | Description |
| Vendors Email | TEXT | |
| Vendors Gl Account | TEXT | Gl Account |
| Vendors Record Id | TEXT | Record Id |
| Vendors Locked | TEXT | Locked |
| Vendors Modified By | TEXT | Modified By |
| Vendors Modified Time | TIMESTAMP | Modified Time |
| Vendors Vendor Owner id | TEXT | Vendor Owner id |
| Vendors Owner First Name | TEXT | Vendors Owner First Name |
| Vendors Owner Last Name | TEXT | Vendors Owner Last Name |
| Vendors Phone | TEXT | Phone |
| Vendor Image | TEXT | Vendor Image |
| Vendors State | TEXT | State |
| Vendors Street | TEXT | Street |
| Vendors Tag | TEXT | Tag |
| Vendors Vendor Name | TEXT | Vendor Name |
| Vendors Website | TEXT | Website |
| Vendors Zip Code | TEXT | Zip Code |
| Week | TEXT | Week (Sun-Sat). |
| Day of week and day number | TEXT | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
| Day of week and day number, ISO | TEXT | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
| Week ISO | TEXT | Week, ISO format (Mon-Sun). |
| Year | TEXT | Year |
| Yearmonth | TEXT | Year and month, e.g. 2024|3 |
| Year of week | TEXT | The year that contains first day of the week (Sun-Sat). |
| Year of week, ISO | TEXT | The year that contains first day of the ISO week (Mon-Sun). |
| Year week | TEXT | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
| Year week ISO | TEXT | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |
Easily connect Zoho CRM to Snowflake
See the value and return on every marketing touchpoint
Providing 70+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.