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!


Rockerbox reports available


You can sync two datasets to Google Sheets:


1. Buckets Breakdown Report (Report Schema)


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

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 leverage our in-platform reporting feature:


  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. Login with you 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

📘

Auto Syncing

The auto-syncing feature enables automatic updates to your sheet - there is no need to create scheduled Bucket Breakdown reports in the Rockerbox UI!

When you open the Rockerbox Data Sync in the future, the auto-syncing feature automatically syncs the next day of data to your sheet for any datasets in the sheet with this feature enabled. For example, let's say you select a report for the last 7 days. When you access the sheet 1 day later and launch the Rockerbox Data Sync, you will have 8 days worth of data synced to your sheet.

You must open the Rockerbox Data Sync for the data to automatically update.



5. Name your sheet and click submit



6. Wait for your sheet to sync

You will see the progress in a green bar



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


The sync has completedThe sync has completed

The sync has completed


4. Frequency Asked Questions


Rockerbox Data Sync FAQ



Did this page help you?