Connect Salesforce to Google Data Studio with Windsor.ai

Directly connect Salesforce to Google Data Studio, in minutes, and in an easy-to-use format.

data integration

All your marketing data in one place, just in a few clicks.

In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.

Automate and save time.

No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Data Automation
data warehouse

Use all your data where and when you need it.

We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).

About Salesforce

Salesforce, founded in California in 1999, is a customer relationship management (CRM) platform that assists businesses in managing customer data, interactions, and communications. Salesforce allows businesses to centralize and organize customer information, streamline processes, and improve communication and collaboration across teams and is used by over 150,000 companies globally. The software company offers a centralized platform for managing customer data and interactions, as well as a variety of tools and features to assist businesses in connecting with customers, closing deals, and providing excellent service.

 

Learn more about Salesforce

About Google Data Studio

Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.

 

Learn more about Google Data Studio

Why integrate Salesforce with Google Data Studio?

  • Integrating Salesforce with Google Data Studio can help you streamline your sales processes and gain a better understanding of your customer data. You can be able to more informed decisions faster and improve your sales process overall.

 

  • Google Data Studio provides a range of customizable charts, graphs, and other visualizations that can help you to track leads through different stages of the buying process and identify where you have the most churn across the customer journey.

 

  • Google Data Studio allows you to share your reports with others in your organization or with third parties. This can make it easier to collaborate on business strategies and track progress, especially for larger teams.

 

  • Connecting Salesforce with Google Data Studio can help you integrate sales and marketing data together. It’s easy to create powerful visualizations which will assist you in determining which channels are providing the most leads and income and adjusting your marketing strategies accordingly.

About the Salesforce Google Data Studio Connector

The Salesforce Google Data Studio Connector pulls Metrics and Dimensions from Salesforce. The Insights are retrieved at a contact level.

Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.

About Google Data Studio

To set up the connector, the user should have:

How to connect Salesforce to Google Data Studio?

Select the fields on the right to later use in your data source. For example, you can include metrics such as Account Name, Contact Birthdate, or Contact Department.

select fields on the right

Go to “Select Destination” and choose Google Data Studio.

Once done, select “connect” and authorize access to your data source.

Windsor.ai Salesforce Google Data Studio connector

Windsor.ai: All your marketing data in one place

Power up your marketing performance with result-driven marketing solutions

  • Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
  • The setup is done in minutes. No coding is required.
  • Currently, we support more than 3000 dimensions and metrics.
  • See the value and return on every marketing touchpoint.
  • Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.

Google Data Studio Templates for Salesforce

Do you plan to connect and visualize your Salesforce in Google Data Studio? 

These free and customizable Google Data Studio Salesforce templates will assist you in visualizing your data for easy reporting and analysis.

Google Data Studio Tutorials for Salesforce

Would you like to take your Google Data Studio Salesforce dashboards to the next level? 

Here are some of our favorite tutorials to help you:

Available Salesforce Metrics and Dimensions

NameTypeDescription
Account SourceTEXTAccount Source
Account Annual RevenueNUMERICAccount Annual Revenue
Account Billing AddressTEXTAccount Billing Address
Account Billing CityTEXTAccount Billing City
Account Billing CountryTEXTAccount Billing Country
Account Billing Geocode AccuracyTEXTAccount Billing Geocode Accuracy
Account Billing LatitudeNUMERICAccount Billing Latitude
Account Billing LongitudeNUMERICAccount Billing Longitude
Account Billing Zip/Postal CodeTEXTAccount Billing Zip/Postal Code
Account Billing State/ProvinceTEXTAccount Billing State/Province
Account Billing StreetTEXTAccount Billing Street
Account Created By IDTEXTAccount Created By ID
Account Created DateDATEAccount Created date
Account DescriptionTEXTAccount Description
Account FaxTEXTAccount Fax
Account IDTEXTAccount ID
Account IndustryTEXTAccount Industry
Account DeletedBOOLEANAccount Deleted
Account Data.com KeyTEXTAccount Data.com Key
Account Jigsaw Company IDTEXTAccount Jigsaw Company ID
Account Last ActivityTEXTAccount Last Activity
Account Last Modified By IDTEXTAccount Last Modified By ID
Account Last Modified DateDATEAccount Last Modified date
Account Last Referenced DateDATEAccount Last Referenced date
Account Last Viewed DateDATEAccount Last Viewed date
Account Master Record IDTEXTAccount Master Record ID
Account NameTEXTAccount Name
Account EmployeesNUMERICAccount Employees
Account Operating Hour IDTEXTAccount Operating Hour ID
Account Owner IDTEXTAccount Owner ID
Account Parent Account IDTEXTAccount Parent Account ID
Account PhoneTEXTAccount Phone
Account Photo URLTEXTAccount Photo URL
Account Shipping AddressTEXTAccount Shipping Address
Account Shipping CityTEXTAccount Shipping City
Account Shipping CountryTEXTAccount Shipping Country
Account Shipping Geocode AccuracyTEXTAccount Shipping Geocode Accuracy
Account Shipping LatitudeNUMERICAccount Shipping Latitude
Account Shipping LongitudeNUMERICAccount Shipping Longitude
Account Shipping Zip/Postal CodeTEXTAccount Shipping Zip/Postal Code
Account Shipping State/ProvinceTEXTAccount Shipping State/Province
Account Shipping StreetTEXTAccount Shipping Street
Account SIC DescriptionTEXTAccount SIC Description
Account System ModstampTEXTAccount System Modstamp
Account TypeTEXTAccount Type
Account WebsiteTEXTAccount Website
Campaign Actual Cost in CampaignNUMERICCampaign Actual Cost in Campaign
Campaign Value Opportunities in CampaignNUMERICCampaign Value Opportunities in Campaign
Campaign Value Won Opportunities in CampaignNUMERICCampaign Value Won Opportunities in Campaign
Campaign Budgeted Cost in CampaignNUMERICCampaign Budgeted Cost in Campaign
Campaign Record Type IDTEXTCampaign Record Type ID
Campaign Created By IDTEXTCampaign Created By ID
Campaign Created DateDATECampaign Created date
Campaign DescriptionTEXTCampaign Description
Campaign End DateDATECampaign End date
Campaign Expected Response (%)NUMERICCampaign Expected Response (%)
Campaign Expected Revenue in CampaignNUMERICCampaign Expected Revenue in Campaign
Campaign IDTEXTCampaign ID
Campaign ActiveBOOLEANCampaign Active
Campaign DeletedBOOLEANCampaign Deleted
Campaign Last ActivityTEXTCampaign Last Activity
Campaign Last Modified By IDTEXTCampaign Last Modified By ID
Campaign Last Modified DateDATECampaign Last Modified date
Campaign Last Referenced DateDATECampaign Last Referenced date
Campaign Last Viewed DateDATECampaign Last Viewed date
Campaign NameTEXTCampaign Name
Campaign Contacts in CampaignNUMERICCampaign Contacts in Campaign
Campaign Converted Leads in CampaignNUMERICCampaign Converted Leads in Campaign
Campaign Leads in CampaignNUMERICCampaign Leads in Campaign
Campaign Opportunities in CampaignNUMERICCampaign Opportunities in Campaign
Campaign Responses in CampaignNUMERICCampaign Responses in Campaign
Campaign Won Opportunities in CampaignNUMERICCampaign Won Opportunities in Campaign
Campaign Num Sent in CampaignNUMERICCampaign Num Sent in Campaign
Campaign Owner IDTEXTCampaign Owner ID
Campaign Parent Campaign IDTEXTCampaign Parent Campaign ID
Campaign Start DateDATECampaign Start date
Campaign StatusTEXTCampaign Status
Campaign System ModstampTEXTCampaign System Modstamp
Campaign TypeTEXTCampaign Type
Campaign Member Campaign IDTEXTCampaign Member ID of the Campaign to which this Lead or Contact is associated.
Campaign Member CompanyOrAccountTEXTCampaign Member The company or account of the lead or contact.
Campaign Member ContactIdTEXTCampaign Member ID of the Contact who is associated with a Campaign.
Campaign Member CountryTEXTCampaign Member The country for the address of the lead or contact.
Campaign Member DescriptionTEXTCampaign Member The description of the associated lead or contact.
Campaign Member DoNotCallBOOLEANCampaign Member Indicates that the contact doesn’t wish to be called.
Campaign Member FaxTEXTCampaign Member Fax number for the contact or lead.
FirstNameTEXTCampaign Member The first name of the contact or lead.
Campaign Member FirstRespondedDateDATECampaign Member Indicates the date on which the campaign member was first given a responded status.
Campaign Member HasOptedOutOfFaxBOOLEANCampaign Member Indicates that the contact or lead doesn’t wish to receive faxes.
Campaign Member HasRespondedBOOLEANCampaign Member Indicates whether the campaign member has responded to the campaign (true) or not (false). Label is Responded.
Campaign Member LastNameTEXTCampaign Member The last name of the contact or lead. Limit is 80 characters.
Campaign Member LeadIdTEXTCampaign Member ID of the Lead who is associated with a Campaign.
Campaign Member LeadOrContactIdTEXTCampaign Member The ID of the associated lead or contact.
Campaign Member LeadOrContactOwnerIdTEXTCampaign Member The ID of the owner of the associated lead or contact.
Campaign Member LeadSourceTEXTCampaign Member The source from which the lead was obtained.
Campaign Member NameTEXTCampaign Member First and last name of the contact or lead with which the campaign member is associated.
Campaign Member PostalCodeTEXTCampaign Member The postal code of the lead or contact.
Campaign Member SalutationTEXTCampaign Member Salutation for the lead or contact.
Campaign Member StateTEXTCampaign Member The state for the address of the lead or contact. Limit is 80 characters.
Campaign Member StatusTEXTCampaign Member Controls the HasResponded flag on this object. You can't directly set the HasResponded flag, as it’s read-only. You can set it indirectly by setting this field in a create or update call. Each predefined value implies a HasResponded flag value. Each time you update this field, you implicitly update the HasResponded flag. In the Salesforce user interface, Marketing users can define valid status values for the Status Text. They can choose one status as the default status. For each Status field value, they can also select which values to count as “Responded,” meaning that the HasResponded flag is set to true for those values. 40 character limit.
Campaign Member StreetTEXTCampaign Member The street for the address of the lead or contact.
Campaign Member TextTEXTCampaign Member Text address for the contact or lead.
Campaign Member TitleTEXTCampaign Member Title for the lead or contact.
Campaign Member TypeTEXTIndicates whether the campaign member is a lead or a contact.
Contact Account IDTEXTID of the account that’s the parent of this contact.
Contact Assistants NameTEXTThe assistant’s name.
Contact Assitants Phone NumberTEXTThe assistant’s telephone number.
Contact BirthdateDATEThe contact’s birthdate.
Contact Created ByTEXTThe user who created the contact
Contact Creation DateDATEThe Creation Date (Duplicate)
Contact DateDATEThe Creation Date
Contact DepartmentTEXTThe contact’s department.
Contact DescriptionTEXTContact's description
Contact EmailTEXTThe contact’s email address.
Contact Email Bounced DateTIMESTAMPIf bounce management is activated and an email sent to the contact bounces, the date and time of the bounce.
Contact Email Bounced ReasonTEXTIf bounce management is activated and an email sent to the contact bounces, the reason for the bounce.
Contact FaxTEXTThe contact’s fax number (Label is Business Fax).
Contact First NameTEXTThe contact’s first name (up to 40 characters).
Contact Home PhoneTEXTThe contact’s home telephone number.
Contact IdTEXTThe Contact ID
Contact Is DeletedTEXTIs contact deleted
Contact Is Email BouncedTEXTContact's description
Contact Last Activity DateDATEValue 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 DateTIMESTAMPContact last modified date
Contact Last NameTEXTRequiredLast name of the contact (up to 80 characters).
Contact Lead SourceTEXTThe lead’s source.
Contact Mailing CityTEXTMailing address details.
Contact Mailing CountryTEXTMailing country.
Contact Mailing Postal CodeTEXTThe zip or postal code in the mailing address
Contact Mailing StateTEXTMailing state details.
Contact Mailing StreetTEXTStreet address for mailing address.
Contact Mobile PhoneTEXTContact’s mobile phone number.
Contact NameTEXTContact full name
Contact Other CityTEXTAlternative city details.
Contact Other CountryTEXTAlternative country details.
Contact Other PhoneTEXTTelephone for alternate address.
Contact Other Postal CodeTEXTAlternative postal code details.
Contact Other StateTEXTAlternate address details (state).
Contact Other StreetTEXTStreet for alternate address.
Contact Owner IDTEXTThe ID of the owner of the account associated with this contact.
Contact Business PhoneTEXTTelephone number for the contact
Contact Reports to IDTEXTID of contact's manager
Contact SalutationTEXTHonorific abbreviation, word, or phrase to be used in front of name in greetings, such as Dr. or Mrs.
Contact TitleTEXTTitle of the contact, such as CEO or Vice President.
Last Modified DateDATEThe Last Modified Date of the selected Object
Lead EmailTEXTLead Email
Lead AddressTEXTLead Address
Lead Annual RevenueNUMERICLead Annual Revenue
Lead CityTEXTLead City
Lead CompanyTEXTLead Company
Lead Converted Account IDTEXTLead Converted Account ID
Lead Converted Contact IDTEXTLead Converted Contact ID
Lead Converted DateDATELead Converted date
Lead Converted Opportunity IDTEXTLead Converted Opportunity ID
Lead CountryTEXTLead Country
Lead Created By IDTEXTLead Created By ID
Lead Created DateDATELead Created date
Lead DescriptionTEXTLead Description
Lead Email (duplicate)TEXTLead Email
Lead Email Bounced DateDATELead Email Bounced date
Lead Email Bounced ReasonTEXTLead Email Bounced Reason
Lead First NameTEXTLead First Name
Lead Geocode AccuracyTEXTLead Geocode Accuracy
Lead IDTEXTLead ID
Lead Individual IDTEXTLead Individual ID
Lead IndustryTEXTLead Industry
Lead ConvertedBOOLEANLead Converted
Lead DeletedBOOLEANLead Deleted
Lead Unread By OwnerTEXTLead Unread By Owner
Lead Data.com KeyTEXTLead Data.com Key
Lead Jigsaw Contact IDTEXTLead Jigsaw Contact ID
Lead Last ActivityTEXTLead Last Activity
Lead Last Modified By IDTEXTLead Last Modified By ID
Lead Last Modified DateDATELead Last Modified date
Lead Last NameTEXTLead Last Name
Lead Last Referenced DateDATELead Last Referenced date
Lead Last Viewed DateDATELead Last Viewed date
Lead LatitudeNUMERICLead Latitude
Lead SourceTEXTLead Source
Lead LongitudeNUMERICLead Longitude
Lead Master Record IDTEXTLead Master Record ID
Lead Full NameTEXTLead Full Name
Lead EmployeesNUMERICLead Employees
Lead Owner IDTEXTLead Owner ID
Lead PhoneTEXTLead Phone
Lead Photo URLTEXTLead Photo URL
Lead Zip/Postal CodeTEXTLead Zip/Postal Code
Lead RatingTEXTLead Rating
Lead SalutationTEXTLead Salutation
Lead State/ProvinceTEXTLead State/Province
Lead StatusTEXTLead Status
Lead StreetTEXTLead Street
Lead System ModstampTEXTLead System Modstamp
Lead TitleTEXTLead Title
Lead WebsiteTEXTLead Website
Opportunity Account IDTEXTOpportunity Account ID
Opportunity AmountNUMERICOpportunity Amount
Opportunity Campaign IDTEXTOpportunity Campaign ID
Opportunity Close DateDATEOpportunity Close date
Opportunity Contact IDTEXTOpportunity Contact ID
Opportunity Created By IDTEXTOpportunity Created By ID
Opportunity Created DateDATEOpportunity Created date
Opportunity DescriptionTEXTOpportunity Description
Opportunity Fiscal PeriodTEXTOpportunity Fiscal Period
Opportunity Fiscal QuarterNUMERICOpportunity Fiscal Quarter
Opportunity Fiscal YearNUMERICOpportunity Fiscal Year
Opportunity Forecast CategoryTEXTOpportunity Forecast Category
Opportunity Forecast Category NameTEXTOpportunity Forecast Category Name
Opportunity Has Open ActivityBOOLEANOpportunity Has Open Activity
Opportunity Has Line ItemBOOLEANOpportunity Has Line Item
Opportunity Has Overdue TaskBOOLEANOpportunity Has Overdue Task
Opportunity IDTEXTOpportunity ID
Opportunity ClosedBOOLEANOpportunity Closed
Opportunity DeletedBOOLEANOpportunity Deleted
Opportunity WonBOOLEANOpportunity Won
Opportunity Last ActivityDATEOpportunity Last Activity
Opportunity Amount Changed History IDDATELast amount changed history ID
Opportunity Last Close Date ChangedTEXTLast close date changed history Id
Opportunity Last Modified By IDTEXTOpportunity Last Modified By ID
Opportunity Last Modified DateDATEOpportunity Last Modified date
Opportunity Last Referenced DateDATEOpportunity Last Referenced date
Opportunity Last Viewed DateDATEOpportunity Last Viewed date
Opportunity Lead SourceTEXTOpportunity Lead Source
Opportunity NameTEXTOpportunity Name
Opportunity Next StepTEXTOpportunity Next Step
Opportunity Owner IDTEXTOpportunity Owner ID
Opportunity Price Book IDTEXTOpportunity Price Book ID
Opportunity Probability (%)NUMERICOpportunity Probability (%)
Opportunity StageTEXTOpportunity Stage
Opportunity System ModstampTEXTOpportunity System Modstamp
Opportunity TypeTEXTOpportunity Type
Task Account IDTEXTTask Account ID
Task Due Date OnlyDATETask Due Date Only
Task Call ResultTEXTTask Call Result
Task Call DurationNUMERICTask Call Duration
Task Call Object IdentifierTEXTTask Call Object Identifier
Task Call TypeTEXTTask Call Type
Task Completed DateDATETask Completed date
Task Created By IDTEXTTask Created By ID
Task Created DateDATETask Created date
Task DescriptionTEXTTask Description
Task Activity IDTEXTTask Activity ID
Task ArchivedBOOLEANTask Archived
Task ClosedBOOLEANTask Closed
Task DeletedBOOLEANTask Deleted
Task High PriorityBOOLEANTask High Priority
Task Create Recurring Series of TasksBOOLEANTask Create Recurring Series of Tasks
Task Reminder SetBOOLEANTask Reminder Set
Task Last Modified By IDTEXTTask Last Modified By ID
Task Last Modified DateDATETask Last Modified date
Task Assigned To IDTEXTTask Assigned To ID
Task PriorityTEXTTask Priority
Task Recurrence Activity IDTEXTTask Recurrence Activity ID
Task Recurrence Day of MonthNUMERICTask Recurrence Day of Month
Task Recurrence Day of Week MaskNUMERICTask Recurrence Day of Week Mask
Task Recurrence EndTEXTTask Recurrence End
Task Recurrence InstanceTEXTTask Recurrence Instance
Task Recurrence IntervalNUMERICTask Recurrence Interval
Task Recurrence Month of YearTEXTTask Recurrence Month of Year
Task Repeat This TaskTEXTTask Repeat This Task
Task Recurrence StartTEXTTask Recurrence Start
Task Recurrence Time ZoneTEXTTask Recurrence Time Zone
Task Recurrence TypeTEXTTask Recurrence Type
Task Reminder Date/TimeTEXTTask Reminder Date/Time
Task StatusTEXTTask Status
Task SubjectTEXTTask Subject
Task System ModstampTEXTTask System Modstamp
Task SubtypeTEXTTask Subtype
TEXTTask Related To ID
Task Name IDTEXTTask Name ID