If your Salesforce org is already running the Digital Source Tracker Daily Aggregate Database and retrieving Google Analytics data from a Universal Analytics view, follow this guide to integrate the Daily Aggregate Database with Google Analytics 4.
Before starting the configuration below, make sure you have reviewed all Installation & Configuration: Considerations.
Step 1: Get the Property ID from Google Analytics
You will need to copy a Property ID from Google Analytics, then paste it into the Daily Aggregate Database configuration. View permissions are acceptable.
A Property ID is a unique ID for a particular property in Google Analytics that allows you to retrieve Google Analytics 4 data.
- Navigate to your Google Analytics dashboard.
- In the upper left corner, you will see your current Property.
- Click on the Property name, which brings up a list of all the Properties that you have access to, with each Property's ID under the Property's Name.
- Copy the Property ID of the Property that contains the set of data you want to be captured in Salesforce.
Step 2: Enable Google Analytics Data API in Google Cloud Project
If you are using your own Google Cloud Project for authentication, you will need to enable an additional API in order to retrieve Google Analytics 4 data. If you are using our Google Cloud Project, skip this step.
- Open the Google Cloud Platform dashboard.
- Select the appropriate project in the top-left corner.
- Click on Enable APIs and Services.
- Search for Google Analytics Data API and click Enable on the API page.
Step 3: Update the Named Credential Record in Salesforce
The managed package contains a new Named Credential record for Google Analytics 4 that must be authenticated in your Salesforce org:
- Click the name of the Named Credential provided by Full Circle: FCR_Google_Analytics_4_Credential. You arrive at the Named Credential detail page for this credential.
- Click Edit and change the Authentication Protocol field to OAuth 2.0. At this time, more fields should appear.
- In the Authentication Provider field, enter the name of the Auth. Provider record that was created upon initial setup of Digital Source Tracker:
FCR_Google_OpenID_Provider - In the Scope field, enter the same information as was in the Default Scopes field of the Auth. Provider record:
openid profile https://www.googleapis.com/auth/analytics.readonly - In the Authentication section, look for the Authentication Status field. The status should be Pending.
- If you are a G Suite customer and are using your own internal app for authentication, check the Start Authentication Flow on Save checkbox so that the field is checked.
- Click Save. This starts the authentication process if you have checked the Start Authentication Flow on Save checkbox in the previous step.
- If you get a Google Error page, this means the authentication process was not able to start. Review the previous steps to confirm the correct data was added to noted fields.
Step 4: Commence Authentication
This process authenticates Google Analytics with Salesforce through your own Google Cloud Project or Full Circle's Google Cloud middleware.
If you are a G Suite customer and are using your own internal app for authentication, follow these steps to authenticate using your Google Analytics account:
- A Sign in with Google > Choose an account to continue to salesforce.com page appears.
- It displays a Google account for you to choose, which enables you to authenticate with Salesforce.
- You also have an option to Use Another Account.
- This Google account must have access to your company's Google Analytics. Specifically, the Google account should have access to the same Google Analytics Property that has its Property ID captured in Step 1.
- Select the appropriate Google account.
If you are not a G Suite customer and will use Full Circle's Google Cloud Project, your CSM will authenticate with the user under the fullcircleinsightsdst.com domain that you have granted Google Analytics view access to.
This information is only visible to Full Circle Employees. Only follow these instructions for customers who are not G Suite customers.
NOTE: Make sure the customer has granted Google Analytics view access to the user we have created for them under the fullcircleinsightsdst.com domain before proceeding.
- Log in to the customer's Salesforce org and navigate to the Named Credentials page as in Step 5.
- Click the name of the Named Credential provided by Full Circle: FCR_Google_Analytics_4_Credential. You arrive at the Named Credential detail page for this credential.
- Click Edit and check the Start Authentication Flow on Save checkbox.
- Click Save.
- If you get a Google Error page, this means the authentication process was not able to start. Review the previous steps to confirm the correct data was added to noted fields.
- A Sign in with Google > Choose an account to continue to salesforce.com page appears.
- It displays a Google account for you to choose, which enables you to authenticate with Salesforce.
- You also have an option to Use Another Account.
- Choose the customer-specific Google account created under the fullcircleinsightsdst.com domain, which the customer has already granted Google Analytics view access to.
- Specifically, the Google account should have access to the same Google Analytics Property that has its Property ID captured in Step 1.
Step 5: Approve Authentication Request
If you are a G Suite customer and are using your own internal app for authentication, a Sign in with Google > salesforce.com wants to access your Google Account page appears. Click Allow. The Named Credential record appears.
If you are not a G Suite customer and will use Full Circle's Google Cloud Project, your CSM will complete this step.
Step 6: Confirm Successful Authentication
Look at the Authentication Status field. The status should now display "Authenticated as of..." with some additional information.
Step 7: Configure Google Analytics 4 Integration on Digital Source Tracker Configuration Page
-
Go to the Ad Platform Configuration page.
- Navigate to Setup | Build | Installed Packages | Full Circle Response Management | Configure | Digital Source Tracker | Ad Platform Configuration.
- Under the Google Analytics Configuration section, add your Google Property ID.
- If you do not want the Daily Aggregate Database to retrieve any more Universal Analytics data, clear the Google View ID field and leave it blank. If you want the Daily Aggregate Database to retrieve both Universal Analytics and Google Analytics 4 data, leave the Google View ID that is already entered.
Step 8: Update reports for GA4 data
Now that you have configured GA4, the next step is to change your reports to accommodate this data. If you do not complete this step, you will continue to report from universal analytics, rather than GA4. Once you have configured GA4, you will be able to report from both data sets.
Instructions for this process can be found here.
Step 8 below is for FCI employees only.
Step 8: Verify Successful Data Flow
There are a couple approaches to verifying that information from Google Analytics 4 is properly integrated with your Salesforce org. Do not skip this step. Without this additional verification, there is no way of confirming that the Google Analytics 4 integration is successful, even if the authentication flow seemed to succeed.
-
Confirm that no errors are happening.
-
Navigate to Setup | Build | Installed Packages | Full Circle Response Management | Event Logs.
- Check that there are no unexpected events logged for today (or, the day that your authentication occurred).
-
Navigate to Setup | Build | Installed Packages | Full Circle Response Management | Event Logs.
-
Confirm that you are able to report on the data.
- Navigate to Reports | FCI Reports | Full Circle Daily Aggregate Database Ops Reports
- Run any of the reports with names that start with "GA:".
- Confirm that the information from the GA4 Segments Data Source is reflecting information from Google Analytics for the corresponding day.
- For more information on what the fields in the report mean, review their definitions at the Aggregate Database Entry Fields and Descriptions section.
- NOTE: The Full Circle Response Management permission set must be assigned in order to view all Aggregate Database Entry fields.
Comments
0 comments
Please sign in to leave a comment.