Salesforce Google Data Studio Connector by Windsor.ai

+

About the Connector
The Salesforce Data Studio Connector pulls Metrics and Dimensions from Salesforce. The Insights are retrieved at a contact level.
Prerequisites
The user should have access to a Salesforce account with user rights which allow to grant access to install apps.
Our privacy policy and terms of use: https://windsor.ai/privacy-statement/
Available Metrics and Dimensions
Name | Type | Description |
---|---|---|
Account Source | TEXT | Account Source |
Account Annual Revenue | NUMERIC | Account Annual Revenue |
Account Billing Address | TEXT | Account Billing Address |
Account Billing City | TEXT | Account Billing City |
Account Billing Country | TEXT | Account Billing Country |
Account Billing Geocode Accuracy | TEXT | Account Billing Geocode Accuracy |
Account Billing Latitude | NUMERIC | Account Billing Latitude |
Account Billing Longitude | NUMERIC | Account Billing Longitude |
Account Billing Zip/Postal Code | TEXT | Account Billing Zip/Postal Code |
Account Billing State/Province | TEXT | Account Billing State/Province |
Account Billing Street | TEXT | Account Billing Street |
Account Created By ID | TEXT | Account Created By ID |
Account Created Date | DATE | Account Created date |
Account Description | TEXT | Account Description |
Account Fax | TEXT | Account Fax |
Account ID | TEXT | Account ID |
Account Industry | TEXT | Account Industry |
Account Deleted | BOOLEAN | Account Deleted |
Account Data.com Key | TEXT | Account Data.com Key |
Account Jigsaw Company ID | TEXT | Account Jigsaw Company ID |
Account Last Activity | TEXT | Account Last Activity |
Account Last Modified By ID | TEXT | Account Last Modified By ID |
Account Last Modified Date | DATE | Account Last Modified date |
Account Last Referenced Date | DATE | Account Last Referenced date |
Account Last Viewed Date | DATE | Account Last Viewed date |
Account Master Record ID | TEXT | Account Master Record ID |
Account Name | TEXT | Account Name |
Account Employees | NUMERIC | Account Employees |
Account Operating Hour ID | TEXT | Account Operating Hour ID |
Account Owner ID | TEXT | Account Owner ID |
Account Parent Account ID | TEXT | Account Parent Account ID |
Account Phone | TEXT | Account Phone |
Account Photo URL | TEXT | Account Photo URL |
Account Shipping Address | TEXT | Account Shipping Address |
Account Shipping City | TEXT | Account Shipping City |
Account Shipping Country | TEXT | Account Shipping Country |
Account Shipping Geocode Accuracy | TEXT | Account Shipping Geocode Accuracy |
Account Shipping Latitude | NUMERIC | Account Shipping Latitude |
Account Shipping Longitude | NUMERIC | Account Shipping Longitude |
Account Shipping Zip/Postal Code | TEXT | Account Shipping Zip/Postal Code |
Account Shipping State/Province | TEXT | Account Shipping State/Province |
Account Shipping Street | TEXT | Account Shipping Street |
Account SIC Description | TEXT | Account SIC Description |
Account System Modstamp | TEXT | Account System Modstamp |
Account Type | TEXT | Account Type |
Account Website | TEXT | Account Website |
Campaign Actual Cost in Campaign | NUMERIC | Campaign Actual Cost in Campaign |
Campaign Value Opportunities in Campaign | NUMERIC | Campaign Value Opportunities in Campaign |
Campaign Value Won Opportunities in Campaign | NUMERIC | Campaign Value Won Opportunities in Campaign |
Campaign Budgeted Cost in Campaign | NUMERIC | Campaign Budgeted Cost in Campaign |
Campaign Record Type ID | TEXT | Campaign Record Type ID |
Campaign Created By ID | TEXT | Campaign Created By ID |
Campaign Created Date | DATE | Campaign Created date |
Campaign Description | TEXT | Campaign Description |
Campaign End Date | DATE | Campaign End date |
Campaign Expected Response (%) | NUMERIC | Campaign Expected Response (%) |
Campaign Expected Revenue in Campaign | NUMERIC | Campaign Expected Revenue in Campaign |
Campaign ID | TEXT | Campaign ID |
Campaign Active | BOOLEAN | Campaign Active |
Campaign Deleted | BOOLEAN | Campaign Deleted |
Campaign Last Activity | TEXT | Campaign Last Activity |
Campaign Last Modified By ID | TEXT | Campaign Last Modified By ID |
Campaign Last Modified Date | DATE | Campaign Last Modified date |
Campaign Last Referenced Date | DATE | Campaign Last Referenced date |
Campaign Last Viewed Date | DATE | Campaign Last Viewed date |
Campaign Name | TEXT | Campaign Name |
Campaign Contacts in Campaign | NUMERIC | Campaign Contacts in Campaign |
Campaign Converted Leads in Campaign | NUMERIC | Campaign Converted Leads in Campaign |
Campaign Leads in Campaign | NUMERIC | Campaign Leads in Campaign |
Campaign Opportunities in Campaign | NUMERIC | Campaign Opportunities in Campaign |
Campaign Responses in Campaign | NUMERIC | Campaign Responses in Campaign |
Campaign Won Opportunities in Campaign | NUMERIC | Campaign Won Opportunities in Campaign |
Campaign Num Sent in Campaign | NUMERIC | Campaign Num Sent in Campaign |
Campaign Owner ID | TEXT | Campaign Owner ID |
Campaign Parent Campaign ID | TEXT | Campaign Parent Campaign ID |
Campaign Start Date | DATE | Campaign Start date |
Campaign Status | TEXT | Campaign Status |
Campaign System Modstamp | TEXT | Campaign System Modstamp |
Campaign Type | TEXT | Campaign Type |
Contact Account ID | TEXT | ID of the account that’s the parent of this contact. |
Contact Assistants Name | TEXT | The assistant’s name. |
Contact Assitants Phone Number | TEXT | The assistant’s telephone number. |
Contact Birthdate | DATE | The contact’s birthdate. |
Contact Created By | TEXT | The user who created the contact |
Contact Creation Date | DATE | The Creation Date (Duplicate) |
Contact Date | DATE | The Creation Date |
Contact Department | TEXT | The contact’s department. |
Contact Description | TEXT | Contact's description |
Contact Email | TEXT | The contact’s email address. |
Contact Email Bounced Date | TIMESTAMP | If bounce management is activated and an email sent to the contact bounces, the date and time of the bounce. |
Contact Email Bounced Reason | TEXT | If bounce management is activated and an email sent to the contact bounces, the reason for the bounce. |
Contact Fax | TEXT | The contact’s fax number (Label is Business Fax). |
Contact First Name | TEXT | The contact’s first name (up to 40 characters). |
Contact Home Phone | TEXT | The contact’s home telephone number. |
Contact Is Deleted | TEXT | Is contact deleted |
Contact Is Email Bounced | TEXT | Contact's description |
Contact Last Activity Date | DATE | Value is the most recent of either: Due date of the most recent event logged against the record or due date of the most recently closed task associated with the record. |
Contact Last Modified Date | TIMESTAMP | Contact last modified date |
Contact Last Name | TEXT | RequiredLast name of the contact (up to 80 characters). |
Contact Lead Source | TEXT | The lead’s source. |
Contact Mailing City | TEXT | Mailing address details. |
Contact Mailing Country | TEXT | Mailing country. |
Contact Mailing Postal Code | TEXT | The zip or postal code in the mailing address |
Contact Mailing State | TEXT | Mailing state details. |
Contact Mailing Street | TEXT | Street address for mailing address. |
Contact Mobile Phone | TEXT | Contact’s mobile phone number. |
Contact Name | TEXT | Contact full name |
Contact Other City | TEXT | Alternative city details. |
Contact Other Country | TEXT | Alternative country details. |
Contact Other Phone | TEXT | Telephone for alternate address. |
Contact Other Postal Code | TEXT | Alternative postal code details. |
Contact Other State | TEXT | Alternate address details (state). |
Contact Other Street | TEXT | Street for alternate address. |
Contact Owner ID | TEXT | The ID of the owner of the account associated with this contact. |
Contact Business Phone | TEXT | Telephone number for the contact |
Contact Reports to ID | TEXT | ID of contact's manager |
Contact Salutation | TEXT | Honorific abbreviation, word, or phrase to be used in front of name in greetings, such as Dr. or Mrs. |
Contact Title | TEXT | Title of the contact, such as CEO or Vice President. |
Last Modified Date | DATE | The Last Modified Date of the selected Object |
Lead Email (duplicate) | TEXT | Lead Email |
Lead Address | TEXT | Lead Address |
Lead Annual Revenue | NUMERIC | Lead Annual Revenue |
Lead City | TEXT | Lead City |
Lead Company | TEXT | Lead Company |
Lead Converted Account ID | TEXT | Lead Converted Account ID |
Lead Converted Contact ID | TEXT | Lead Converted Contact ID |
Lead Converted Date | DATE | Lead Converted date |
Lead Converted Opportunity ID | TEXT | Lead Converted Opportunity ID |
Lead Country | TEXT | Lead Country |
Lead Created By ID | TEXT | Lead Created By ID |
Lead Created Date | DATE | Lead Created date |
Lead Description | TEXT | Lead Description |
Lead Email | TEXT | Lead Email |
Lead Email Bounced Date | DATE | Lead Email Bounced date |
Lead Email Bounced Reason | TEXT | Lead Email Bounced Reason |
Lead First Name | TEXT | Lead First Name |
Lead Geocode Accuracy | TEXT | Lead Geocode Accuracy |
Lead ID | TEXT | Lead ID |
Lead Individual ID | TEXT | Lead Individual ID |
Lead Industry | TEXT | Lead Industry |
Lead Converted | BOOLEAN | Lead Converted |
Lead Deleted | BOOLEAN | Lead Deleted |
Lead Unread By Owner | TEXT | Lead Unread By Owner |
Lead Data.com Key | TEXT | Lead Data.com Key |
Lead Jigsaw Contact ID | TEXT | Lead Jigsaw Contact ID |
Lead Last Activity | TEXT | Lead Last Activity |
Lead Last Modified By ID | TEXT | Lead Last Modified By ID |
Lead Last Modified Date | DATE | Lead Last Modified date |
Lead Last Name | TEXT | Lead Last Name |
Lead Last Referenced Date | DATE | Lead Last Referenced date |
Lead Last Viewed Date | DATE | Lead Last Viewed date |
Lead Latitude | NUMERIC | Lead Latitude |
Lead Source | TEXT | Lead Source |
Lead Longitude | NUMERIC | Lead Longitude |
Lead Master Record ID | TEXT | Lead Master Record ID |
Lead Full Name | TEXT | Lead Full Name |
Lead Employees | NUMERIC | Lead Employees |
Lead Owner ID | TEXT | Lead Owner ID |
Lead Phone | TEXT | Lead Phone |
Lead Photo URL | TEXT | Lead Photo URL |
Lead Zip/Postal Code | TEXT | Lead Zip/Postal Code |
Lead Rating | TEXT | Lead Rating |
Lead Salutation | TEXT | Lead Salutation |
Lead State/Province | TEXT | Lead State/Province |
Lead Status | TEXT | Lead Status |
Lead Street | TEXT | Lead Street |
Lead System Modstamp | TEXT | Lead System Modstamp |
Lead Title | TEXT | Lead Title |
Lead Website | TEXT | Lead Website |
Opportunity Account ID | TEXT | Opportunity Account ID |
Opportunity Amount | NUMERIC | Opportunity Amount |
Opportunity Campaign ID | TEXT | Opportunity Campaign ID |
Opportunity Close Date | DATE | Opportunity Close date |
Opportunity Contact ID | TEXT | Opportunity Contact ID |
Opportunity Created By ID | TEXT | Opportunity Created By ID |
Opportunity Created Date | DATE | Opportunity Created date |
Opportunity Description | TEXT | Opportunity Description |
Opportunity Fiscal Period | TEXT | Opportunity Fiscal Period |
Opportunity Fiscal Quarter | NUMERIC | Opportunity Fiscal Quarter |
Opportunity Fiscal Year | NUMERIC | Opportunity Fiscal Year |
Opportunity Forecast Category | TEXT | Opportunity Forecast Category |
Opportunity Forecast Category Name | TEXT | Opportunity Forecast Category Name |
Opportunity Has Open Activity | BOOLEAN | Opportunity Has Open Activity |
Opportunity Has Line Item | BOOLEAN | Opportunity Has Line Item |
Opportunity Has Overdue Task | BOOLEAN | Opportunity Has Overdue Task |
Opportunity ID | TEXT | Opportunity ID |
Opportunity Closed | BOOLEAN | Opportunity Closed |
Opportunity Deleted | BOOLEAN | Opportunity Deleted |
Opportunity Won | BOOLEAN | Opportunity Won |
Opportunity Last Activity | DATE | Opportunity Last Activity |
Opportunity Amount Changed History ID | DATE | Last amount changed history ID |
Opportunity Last Close Date Changed | TEXT | Last close date changed history Id |
Opportunity Last Modified By ID | TEXT | Opportunity Last Modified By ID |
Opportunity Last Modified Date | DATE | Opportunity Last Modified date |
Opportunity Last Referenced Date | DATE | Opportunity Last Referenced date |
Opportunity Last Viewed Date | DATE | Opportunity Last Viewed date |
Opportunity Lead Source | TEXT | Opportunity Lead Source |
Opportunity Name | TEXT | Opportunity Name |
Opportunity Next Step | TEXT | Opportunity Next Step |
Opportunity Owner ID | TEXT | Opportunity Owner ID |
Opportunity Price Book ID | TEXT | Opportunity Price Book ID |
Opportunity Probability (%) | NUMERIC | Opportunity Probability (%) |
Opportunity Stage | TEXT | Opportunity Stage |
Opportunity System Modstamp | TEXT | Opportunity System Modstamp |
Opportunity Type | TEXT | Opportunity Type |
Task Account ID | TEXT | Task Account ID |
Task Due Date Only | DATE | Task Due Date Only |
Task Call Result | TEXT | Task Call Result |
Task Call Duration | NUMERIC | Task Call Duration |
Task Call Object Identifier | TEXT | Task Call Object Identifier |
Task Call Type | TEXT | Task Call Type |
Task Completed Date | DATE | Task Completed date |
Task Created By ID | TEXT | Task Created By ID |
Task Created Date | DATE | Task Created date |
Task Description | TEXT | Task Description |
Task Activity ID | TEXT | Task Activity ID |
Task Archived | BOOLEAN | Task Archived |
Task Closed | BOOLEAN | Task Closed |
Task Deleted | BOOLEAN | Task Deleted |
Task High Priority | BOOLEAN | Task High Priority |
Task Create Recurring Series of Tasks | BOOLEAN | Task Create Recurring Series of Tasks |
Task Reminder Set | BOOLEAN | Task Reminder Set |
Task Last Modified By ID | TEXT | Task Last Modified By ID |
Task Last Modified Date | DATE | Task Last Modified date |
Task Assigned To ID | TEXT | Task Assigned To ID |
Task Priority | TEXT | Task Priority |
Task Recurrence Activity ID | TEXT | Task Recurrence Activity ID |
Task Recurrence Day of Month | NUMERIC | Task Recurrence Day of Month |
Task Recurrence Day of Week Mask | NUMERIC | Task Recurrence Day of Week Mask |
Task Recurrence End | TEXT | Task Recurrence End |
Task Recurrence Instance | TEXT | Task Recurrence Instance |
Task Recurrence Interval | NUMERIC | Task Recurrence Interval |
Task Recurrence Month of Year | TEXT | Task Recurrence Month of Year |
Task Repeat This Task | TEXT | Task Repeat This Task |
Task Recurrence Start | TEXT | Task Recurrence Start |
Task Recurrence Time Zone | TEXT | Task Recurrence Time Zone |
Task Recurrence Type | TEXT | Task Recurrence Type |
Task Reminder Date/Time | TEXT | Task Reminder Date/Time |
Task Status | TEXT | Task Status |
Task Subject | TEXT | Task Subject |
Task System Modstamp | TEXT | Task System Modstamp |
Task Subtype | TEXT | Task Subtype |
Task Related To ID | TEXT | Task Related To ID |
Task Name ID | TEXT | Task Name ID |