Guide: Using Google Analytics with Databox

HOW TO

How to connect Google Analytics to Databox

IN THIS SECTION

How to connect Google Analytics to Databox

To connect a Google Analytics Account in Databox, go to  Data Manager > + New connection. Type Google Analytics in the search bar and click on the green Connect button. 

This will open the  Authorization window, which is where you will be prompted to enter your Google login credentials and authorize the Databox app. 

If you have multiple web properties within your Google Analytics Account, you will be prompted to select the web property that you want to connect with Databox. This will determine the web pages that data is synced for. Learn more about Google web properties here

If you have multiple Views set in your Google Analytics Account, you'll also be prompted to select the View that you want to connect with Databox. If you don't have multiple Views, All Web Site Data will automatically be connected. 

How much historical data is synced when you first connect Google Analytics to Databox?

When you connect a new Google Analytics Data Source in Databox, 3 months worth of historical data is initially synced for all Basic Metrics. 

Pro Tip: Each Google Analytics Account has a limit set for the number of API calls that can be made within a 24 hour period. If the limit is hit, the API is inaccessible until the next 24 hour period begins. In An effort to prevent this, only 3 months worth of historical data is synced for all Basic Google Analytics Metrics.

Using the Query Builder for Google Analytics, you can recreate Basic Metrics and access up to 2 years worth of historical data. Learn more about the Query Builder for Google Analytics here

What time zone does Google Analytics data sync in?

Google Analytics data is synced in the time zone set in the Google Analytics Account. For example, if your Google Analytics Account time zone is set as EST, your Google Analytics data will sync with Databox in EST. 

How many API calls can Databox make to Google Analytics API?

Based on Google Analytics rate limits, Databox is able to make the following API requests: 
  • 1,600,000 requests per day
  • 2,000 requests per 100 seconds
  • 1,000 requests per 100 seconds per user

How to access pre-built Google Analytics Templates

1
 Navigate to the  Templates page
2
 In the Data Source drop-down list, select Google Analytics
3
 To view a preview of the Template populated with dummy data, click Preview
4
 To pull the Template into your Account and re-populate it with your own Google data, click Use Template
5
 Select the appropriate Google Analytics Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected Google Analytics Account and can be found on the  Databoards page
Pro Tip: Once the Databoard is available on the Databoards page, it is completely disconnected from the public Template. Therefore, you can further customize this Databoard to meet your specific needs using the Designer.

Popular Google Analytics Templates

Google Analytics Website Traffic Google Analytics Acquisition Snapshot
This dashboard helps provide insights on your  Website Analytics, such as Users, Sessions, Referrals and more.
This dashboard dives deeper into your Sources data and reveals which marketing campaigns have been most productive.

How to build a Databoard using Google Analytics data

1
 Navigate to  Databoards > + New Databoard > Start Blank
2
 Click on the Datablock Library icon on the lefthand side of the Designer
3
 Select the appropriate Google Analytics Account from the Data Source drop-down list in the Datablock Library
4
 View the list of pre-built Google Analytics Datablocks in the Datablock Library. Drag and drop your selected Datablock onto your Databoard    
5

 If a pre-built Datablock isn't available for your use case, click on the  Visualization Types icon under the Datablock Library icon

6
 View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
7
 Click on the Datablock on the Databoard to open the corresponding Datablock Settings on the righthand side of the Designer
8
 Select the appropriate Google Analytics Data Source and Metric in the Datablock Settings. This will update the Datablock and it will populate the Datablock with the corresponding data
 
9
 Complete steps 4-8 until your Databoard is complete

Popular Google Analytics Metrics

Sessions

Sessions by Channel

New Users




Pageviews by Page Avg Session Duration Goal Completions

View a full list of Google Analytics Metrics available in Databox here.

Additional Information

  • If you're on a paid plan, your Data Sources are set to sync hourly. However, Google Analytics syncing may be less frequent due to API limitations. Learn more about Google Analytics syncing and how to manually sync your Google Analytics data here
  • For all Basic Metrics, a maximum of 3,000 results are synced from Google Analytics. For all Custom Metrics, a maximum of 2,000 results are synced from Google Analytics.
  • For the following Metrics, only "Today" and "Yesterday" Date Ranges are supported: "Users by Channels," "Goal Conversion Rate by Channels," "Goal Conversion Rate by Goals," "Ecommerce Conv % by Channels," "AOV by Channels," "Avg Quantity by Channels," and "Unique screen views by Screen name."

    These are all Unique Metrics, meaning it would be inaccurate to add together daily values to produce weekly, monthly, quarterly, or yearly values. Since only daily values are accessible from Google Analytics API for these Metrics, Date Ranges are limited. 
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us