Knowledge Base

Need help getting set up? You’re in the right place.
Find step-by-step guides to help set up connectors or create custom dashboards 

Guide to setup the Roller API Connector

This guide will walk you through the steps needed to setup your 14 day trial to the ROLLER API connecter and start working with your ROLLER data in your own Google Data Studio Dashboard.

Step 1 :

Click on the below button to start the setup.

Step 2 :

Select the region you want your ROLLER data to be stored.

Step 3 :

Sign it with Google or Sign in with your email of choice.

Step 4 :

Choose to Sign Up for a Monthly or a Yearly subscription (20% discounted compared to Monthly Subscription) and walk through the checkout steps. IMPORTANT: At the second step of the checkout use the same email as you used under step 3! Confirm all details and after going through the Terms and Conditions and Privacy Policyconfirm your purchase.

Step 5 :

After you completed the checkout you need to refresh the page for the connector to recognize you are a subscribed user. The refreshed page looks like below. Now click on “New Roller Connection”.

Step 6 :

  • Connection Name: First give your connection a new of your choosing.
  • Client ID, Client Secret: Next navigate to your ROLLER Venue Manager to Settings->Integrationts->API Keys and copy the client key and client secret from here and paste in the corresponding field in the connector setup page. If you don’t see your API Keys in your Venue Manager please contact ROLLER support to upgrade your subscription to include API access.
  • Venue Timzone: Choose your timezone
  • First Fiscal Month: Select the Month at which in your Venue’s Country the fiscal year starts. This will be used to consolidate the summary Tables the connector will create for you.
  • Sync Start Date: The historic date you like to start collecting your ROLLER Venue data. This might be the date you first started using the ROLLER systems.
  • Sync Frequency: How often do you like the connector to fetch the latest data? The hourly will fetch your data every 2 hours (to remain in the TIER 1 ROLLER API plan). If you like this to be more frequent please contact us or ROLLER support.
  • Entities To Sync: Select which Data Endpoints you like to fetch from the ROLLER API. Note that this selection can’t be changed after the setup. A description of the Data in each endpoint can be found here
Next click “Continue”

Step 7 :

For the following steps you need your own Google Cloud Project in your own Google Cloud Platform. Click on this link and follow the steps to setup your own Google Cloud Account. For the connector to work correctly you need to upgrade the Free Trial Google Cloud Account. Do this by clicking on “Billing” on the left Menu and then click “Upgrade”. Note that the ROLLER API connector is likely to remain in the free tier for your Google Cloud Account so the charges should remain zero.

Step 8 :

After you finished step 7 you need the details from your Google Cloud Project to finish the final step. Hover over the fields on this page form again to get more details.
  • Project ID: Copy your Project ID from your Google Cloud Project as per this screenshot and copy in the corresponding field in the setup page.
  • BigQuery Dataset Name: Choose a name you like to give your Dataset in BigQuery. Don’t use spaces or any special characters. The connector will create this dataset for you but if you have already created a dataset yourself use that dataset name.
  • BigQuery Dataset Location: Choose the location you like to use for your dataset. Note that if you are using a preexisting dataset make sure you select the same location here!
  • Use Your Own Service Account: To access your Google Cloud Project we use a Service Account. We recommend selecting NO here. If you select NO please grant ss-tools-roller-bq-connect@appspot.gserviceaccount.com (for connections outside Europe) and ss-tools-roller-bq-conn-eu@appspot.gserviceaccount.com (for connections in Europe) the BigQuery Admin role from IAM .
  • If you select YES please upload the JSON key file generated from a service account  with at least BigQuery Admin role in your Google Cloud project

Step 9 :

Finally click “Complete Setup”. The next screenindicates the setup was successfull.

If you now navigate to your BigQuery Instance you will see your data getting loaded.

Step 10 :

After your tables are loaded successfully in BigQuery, you will see consolidated tables generated in path- ‘Project_Id > Dataset_Name > reporting’, the dashboard will need access to the following list of tables from this directory path:

  • joined_revenue_entries_roller_api_ds
  • attendances
  • roller_customer_geo_data

Step 11 :

Open the dashboard template link and navigate to the right hand corner to make a copy of the template.

Step 12 :

To copy the report you will need to select your BigQuery tables as data source in the ‘new data source’ dropdown and replace the sample  tables with the tables from your dataset as highlighted in point step 10. Click on the dropdown on the right.

Step 13 :

Click on ‘Create data source’.

Step 14 :

Select BigQuery from the connectors options available

Step 15 :

Navigate to your ProjectId > reporting > joined_revenue_entries_roller_api_ds

Step 16:

Click on ‘add to report’. You will be directed back to Step 12 with one table replaced as shown below.

Step 17:

Repeat STEPS 13 & 14 for the below connections as shown in the picture

  • Replace ‘sample_attendances’ with ‘attendances’
  • Replace ‘sample_roller_customer_geo_data’ with ‘roller_customer_geo_data’


There might be a visual glitch as seen in the above picture where after replacing the dataset it still shows ‘Select a data source’. But that should be fine.  Apart from that, the other data sources are for the membership page and the guest experience page. They will need to be enabled through a custom setup. Please reach out to us for more info.

Step 18:

Click on ‘Copy Report’ to finish adding data to your dashboard. Enjoy!

Related articales :

Haven't found what you're looking for?

Search our knowledge base to find more information, step-by-step guides, and usage tips for our connector tools.

We are here to help :

If you are having trouble setting up the connection book a free 30 minute consultation and we will make sure its all working

Select your Venue Location