Rockerbox Data Sync for Google Sheets

Overview

The Rockerbox Data Sync is a Google Sheets Add-On that allows you to sync Rockerbox data directly into google sheets and leverage pre-built templates for analysis - all from within Google sheets itself.

This means no more manually downloading Rockerbox reports, importing to google sheets, and building custom pivot tables!

Watch our Google Sheets training here on-demand for step-by-step instructions on how to leverage this feature!

Rockerbox reports available

Paid users can sync two datasets to Google Sheets:

1. Buckets Breakdown Report (Report Schema)

2. Platform Performance Report for Facebook, Adwords, Bing, TikTok, Pinterest, and LinkedIn (Report Schema)

Free users can sync the Platform Performance Report to Google Sheets..

1. Getting Started - Downloading Rockerbox Data Sync

There are two ways to get started based on your specific use case:

1. To leverage one of our pre-built marketing performance templates

Open one of our pre-built templates from our Template Gallery and follow the guidance in the Instructions tab.

2. To start from a fresh spreadsheet:

  1. Download the Rockerbox Data Sync from the Google Workspace Marketplace
  2. Open a Google Sheets document and launch the Rockerbox Data Sync from the Extensions Menu (Extensions -> Rockerbox -> Sync Data).
  3. New users can sign up for Rockerbox Free and existing customers can sign in with your Rockerbox credentials and start syncing your data directly to Sheets!

Authenticating Rockerbox Data sync in Google Sheets
If this is your first time opening the add-on, you must then authenticate the add-on with your Google account and re-launch the add-on from the Extensions menu.
Make sure you use the default Gmail account in your browser
You must use the default Gmail account in your browser to download and authenticate the Rockerbox Data Sync. The default Gmail account is the first Gmail account that you logged in to in the current browser session. If using a Chrome Profile in Google Chrome, then the default Gmail account is the Gmail account associated with the Chrome Profile. See here for troubleshooting guidance.


2. Accessing the plug-in within Google Sheets

You can access the plug-in under the “Extensions” tab.

Select Rockerbox Data Sync and then click on Sync data.


3. Syncing Rockerbox data to Google sheets

Once you have selected the plug-in from the Extensions tab take the following step to sync Rockerbox data to Google Sheets:

1. Click on “Create New Dataset

2. Select your report type


3. Select your conversion segment


4. Select your date range

Rolling Reports vs. Fixed Date Range

Rolling reports refresh on a daily basis with the latest data based on the time period you select. All rolling date ranges provide data through yesterday, at the latest. Reports based on a fixed date range return only the data within the specified date range.


5. Name your sheet and click submit

Changing the sheet name after clicking "Submit" will will break the data sync. Double check your destination sheet name before proceeding.

6. Wait for your sheet to sync

You will see the progress in a green bar and data beginning to flow into your spreadsheet!


You will see the below screen once your sync is completed!

Once you setup a synced dataset, the Rockerbox Data Sync will automatically refresh all datasets in that workbook on a daily basis between 9-10AM EST (10-11AM EDT). You don't even need to open your spreadsheet or the plugin. This ensures that you are always analyzing the latest and greatest data.

4. Frequently Asked Questions

Rockerbox Data Sync FAQ

How did we do?