Advanced: Dashboards with Google Data Studio

Google Data Studio is a free data visualization product from Google.

In the following videos, we will show you how to:

1. Connect Salesforce to Google Sheets using the Data Connector for Salesforce add-on
2. Connect Google Sheets to Google Data Studio
3. Build an Interactive Multi-Touch Attribution Dashboard in Google Data Studio

1.) Connecting Salesforce to Google Sheets using the Data Connector for Salesforce add-on

Below is an example SOQL query. Please note that some fields may not exist in your Salesforce environment and the query may need modifying.

SELECT Id, LeadOrContactId, algnatt__Engagement_Date__c, AB_First_Touch_Sourced_Amount__c, AB_Last_Touch_Sourced_Amount__c, AB_Equal_Weight_Sourced_Amount__c, AB_U_Shaped_Sourced_Amount__c, AB_Time_Decay_Sourced_Amount__c, algnatt__AB_Attribution_Type__c, Account_Id__c, Account_Stage__c, Industry__c, Region__c, Target_Account__c, Campaign.Name, Campaign.Type, Status, UTM_Campaign__c, UTM_Content__c, UTM_Medium__c, UTM_Source__c, UTM_Term__c, Persona__c, algnatt__AB_Associated_Opportunity__r.Id, algnatt__AB_Associated_Opportunity__r.Name, algnatt__AB_Associated_Opportunity__r.Type, algnatt__AB_Associated_Opportunity__r.IsWon FROM CampaignMember WHERE HasResponded = True ORDER BY algnatt__Engagement_Date__c

2.) Connecting Google Sheets to Google Data Studio

3.) Building an Interactive Multi-Touch Attribution Dashboard in Google Data Studio