Your data is powerful, and you can make the most of it by creating a Google Sheets data source in Looker Studio to build customisable reports and interactive dashboards with the data synced from Dotdigital.
You can:
Measure campaign performance against order information to monitor the impact of your campaigns.
Use campaign performance data alongside information in Google Analytics to build views of a specific contact.
Visualize form information against engagement for specific contacts to assess the health of your customer relationships and inform future campaign planning.
Available data
By connecting your Dotdigital account with Google Sheets, you can expose the following data for use in Looker Studio:
Integration | Available data |
Google Sheets: Contacts |
|
Google Sheets: Campaigns |
|
Google Sheets: Forms |
|
Before you start
Things you need to know:
You must have installed and set up the Google Sheets integration for the data you want to use in Looker Studio.
Connect Looker Studio
Log in to your Looker Studio account.
From the homepage, expand the Create drop-down menu and select Data source.
Under Google Connectors, select Google Sheets.
Select the sheet you want to use, then select CONNECT.
Learn more in Google’s documentation.
Create a new report
To use the data from the selected sheet in Looker Studio reporting:
In the data source you created, select CREATE REPORT.
In the report editor, select ADD TO REPORT.
Select Untitled report to enter a new name for your report.
Looker Studio saves all changes to reports automatically.
Learn more
Use Google’s documentation to learn more about:
Explore additional data export options in Dotdigital: