ADO.NET Provider for Zoho CRM

Build 22.0.8397

Visits

Query information regarding recent visits.

Columns

Name Type Description
Id [KEY] String The Id of the visit.
PageVisited String The name of the visited page.
VisitedBy_Id String The Id of the visitor.
VisitedBy_FirstName String The First Name of the visitor.
VisitedBy_LastName String The Last Name of the visitor.
IPAddress String The IP address of the visitor.
TimeSpent(Minutes) String The time spent in minutes for the visit.
Referrer String The referrer of the visitor.
VisitedPageURL String The URL of the visited page.
CreatedBy_Id String The Id of the object which created the visit.
ModifiedBy_Id String The Id of the object which modified the visit.
ModifiedBy_FirstName String The First Name of the object which modified the visit.
ModifiedBy_LastName String The Last Name of the object which modified the visit.
CreatedTime Datetime The date and time when the visit was created.
ModifiedTime Datetime The date and time when the visit was modified.
AttendedBy String Who attended the visit.
UserDetails String The user details of the visit.
Browser String The browser used for the visit.
TimeVisited Datetime The date and time of the visit.
VisitorType String The type of visitor for the visit.
Revenue Decimal The revenue generated by the visit.
NumberofPages Int The number of pages visited from the visit.
PortalName String The name of the portal used for the visit.
SearchKeyword String The search keyword used for the visit.
SearchEngine String The search engine used for the visit.
OperatingSystem String The operating system of the visitor.
Gclid String The GCLID of the visitor.
Keyword String The keyword used in the visit.
ClickType String The click type of the visit.
Devicetype String The type of the device of the visitor.
AdNetwork String The ad network used in the visit.
SearchPartnerNetwork String The search partner network for the visit.
AdCampaignName String The ad campaign name of the visit.
AdGroupName String The ad group name of the visit.
Ad String The ad used for the visit.
AdClickDate Date The date and time when the ad was clicked.
VisitSource String The source of the visit.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Word String Used to search for a specific word in records.
DuplicateCheckFields String The field/s to be used for checking in an upsert.
Converted Bool Set to true to return only converted records.
Approved Bool Set to true to return only approved records.
CustomViewId String The custom view Id to be used for filtering this record.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 22.0.8397