Export your campaign reports data into Google Sheets

Learn how to import your campaign summary report data into Google Sheets using our integration hub.

Overview

Connect your dotdigital account to your Google Sheets account to export your campaign report data straight into a handy Google Sheet spreadsheet.

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.

Step 1: Find the integration

To find the Campaign reports to Google Sheets integration:

  1. Go to Settings > Integration hub.
  2. Choose the Self-serve tab.
  3. Under the category Reporting, select Campaign reports to Google Sheets.
    1-google-sheets-tile.png
  4. Select Use Integration.


Step 2: Connect Google Sheets to dotdigital

To connect Campaign reports to Google Sheets to dotdigital:

  1. In the Integration Hub, select +Connect your Google Sheets.
  2. In the popup, sign in to your Google account, and select Allow to allow access to the integration.
  3. Select Ok to complete the integration, then select Next.
  4. Read the integration information, then select Next.

Step 3: Set up your settings

To set up your Google Sheets to dotdigital settings:

  1. On Settings, expand the Single or daily spreadsheet drop-down menu and choose Single sheet or Daily sheet.
    • Single sheet = Append data to a single sheet
    • Daily sheet = Add the data to a new sheet each day
    3.2-google-sheets-settings-name.png
  2. For Name of spreadsheet, enter the name of the Google sheet you want to save the data to.
  3. Select Next.
  4. Expand the Update or append rows drop-down menu and choose whether to Update, Append hourly, or Append daily existing rows in the Google sheet for each campaign.
    • Update = Always overwrites the existing rows.
    • Append hourly = Every hour creates new rows alongside any previous ones.
    • Append daily = Every day creates new rows alongside any previous ones. Cannot use historical data, but works from the moment it is activated.
    For all options the data is updated on a hourly basis if a campaign has had activity within the last hour.
  5. Select Next.
  6. For the first run 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.
    5-google-sheets-settings-activity-within.png
  7. Select Next.

4-google-sheets-complete.png

That's it! You'll find your campaign reports spreadsheet in your Google Sheets account.

Google Sheets Maximum Cell Count

The maximum cell count for Google Sheets is 5 million cells. When our Google Sheets integration detects over 4.75 million cells, it appends a number to the spreadsheet name and creates a new one.

For example, a spreadsheet called My Data would have appended spreadsheets that look like My Data_1, My Data_2, My Data_3, and so on.

See also

Did you find this article helpful?

Can we help?

Thanks for using Engagement Cloud. If you need more help or support, then contact our support team.