Before you start
Things you need to know:
You must have a Google Account with access to Google Sheets.
The integration first brings in any campaigns that have had activity in the last 24 hours. It then adds data for campaigns that have had activity in the last hour, every hour.
You can use Google Data Studio with Google Sheets to summarise and visualise your exported data.
1. Find the integration
To find the Google sheets: Campaign Reports integration:
Go to Connect > Integrations.
In the left menu, under SHOW, select Self-serve.
Find Google sheets: Campaigns, then select +ADD.
2. Connect Google Sheets to Dotdigital
On Get to know the integration, read the information, then select NEXT.
Either select New Authentication to create a Google Sheets authentication, or if you’ve already authenticated a Google account, select an existing one.
Follow the Google account authentication instructions.
Expand the Select what Dotdigital can access drop-down menu and select the checkbox for See, edit, create, and delete all your Google Sheets spreadsheets.
For Sheet name, enter the name of the Google sheet you want to save the data to.
Under Update frequency, expand the Frequency drop-down menu and choose either Single sheet, Daily sheet, or Every 30 days.
Single sheet = Append data to a single sheet
Daily sheet = Add the data to a new sheet each day
Every 30 days = Add the data to a new sheet every 30 days
Expand the Update or append rows drop-down menu and choose whether to Update, Append daily or Append every 30 days existing rows in the Google sheet for each campaign.
Update = Always overwrites the existing rows.
Append daily = Every day creates new rows alongside any previous ones. Cannot use historical data, but works from the moment it is activated.
Append every 30 days = Every 30 days creates new rows alongside any previous ones.
For all options the data is updated on a hourly basis if a campaign has had activity within the last hour.
On the first installation, you must choose how far back to look for campaigns with activity. Your Google Sheet includes data for campaigns that have had activity within a specific period.
To choose your time period, expand the Activity within drop-down menu and choose either Last day, 7 days, 30 days, 90 days, Last year, or All time.
Expand the Timezone drop-down menu, then select your timezone.
That's it! You'll find your campaign reports spreadsheet in your Google Sheets account.