Guide: Using Google Ads with Databox


How to connect Google Ads to Databox


How to connect Google Ads to Databox

Pro Tip:  To connect your Google Ads Account to Databox properly, you should have Two-Factor Authentication (2FA) enabled in your Google Ads Account. Learn more here

To connect a Google Ads Account to Databox, go to  Data Manager > + New connection. Type Google Ads 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 Customer Accounts within your Google Ad Account, you will be prompted to select the Customer Account Name that you want to connect with Databox. 

If you have a Google Ads Manager (MCC) Account where you manage multiple Google Ads Accounts through a single login, you can choose the Manager Account and select individual Google Ads Account(s) that you want to connect with Databox. It is recommended that Agencies connect their individual Client Google Ads Accounts in their respective Client Accounts.

Pro Tip: Each Google Ads Account must be connected as a separate Data Source in Databox (1 Account = 1 Data Source). 

What's the maximum amount of historical data initially available when you use a new Google Ads Metric in Databox?

Data is synced for the Metrics that are being used in your Account, so when you first use a new Google Ads Metric, the maximum amount of historical data available is 36 months. 

Pro Tip:  In order to start syncing data for a Metric, you can add it to your Metrics screen, use it in a Scorecard, set a Goal around it, create an Alert for it, or add it to a Databoard. Learn more here.  

The amount of historical data you can access in Databox depends on your Databox plan. Learn more here.

What time zone is Google Ads data synced in?

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

How to access pre-built Google Ads Templates

  1. Navigate to Databoards > Public Templates
  2. In the Data Source drop-down list, select Google Ads
  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 Ads data, click Use Template
  5. Select the appropriate Google Ads Data Source from the drop-down list to complete the process. The Databoard will be re-populated with data from the selected Google Ads 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 Ads Templates

Google Ads Ads PPC Performance
Analyze your Campaigns, Ad Groups, Keywords, and Engagement Metrics to improve your return on investment (ROI).
The Ads PPC dashboard gives a complete view of all the fundamental Ad Metrics, including cost-per-click (CPC), click-through rate (CTR),  and Impressions.

How to build a Databoard using Google Ads data


Popular Use Cases

Learn more about popular Google Ads use cases here.

Popular Google Ads Metrics

Impressions Impressions by Campaign Clicks

Cost Avg CPC Conversions

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

How to build a Databoard

  1. Navigate to  Databoards > + New Databoard > Start Blank
  2. Click on the Metric Library icon on the lefthand side of the Designer
  3. Select the appropriate Google Ads Account from the Data Source drop-down list in the Metric Library
  4. View the list of pre-built Google Ads Datablocks in the Metric 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 Metric 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 Ads Data Source and Metric in the righthand 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

How to use the Metric Builder for Google Ads

With the Metric Builder for Google Ads, you can create Custom Google Ads Metrics using a combination of Metrics, Dimensions, and Filters. Some popular use cases for the Metric Builder for Google Ads include creating Campaign- and Ad-specific Metrics and reports to track your Google Ads data. 

Learn more about the Metric Builder for Google Ads here

Additional Information


Metric Considerations

  • Due to technical limitations, the Date Range ''All Time'' will return a maximum 36 months of historical data.
  • If you have renamed a Campaign in your Google Ads Account, you will see the old Campaign Name and the new Campaign Name in Databox until the old Campaign Name is outdated. For example, if you changed a Campaign Name from "Red" to "Blue" on June 15 and it is currently July, you will see "Red" and "Blue" Campaigns returned for "Last Month" (June), but only the new Campaign Name ("Blue") for "This Month" (July) in Databox. 

    If you have access to Metric Builder, you can create Custom Campaign Metrics and purge data to refetch the Campaign Names. If you don't have access to Metric Builder, you can add a new connection for the Google Ads Account in your Databox Account. You can then duplicate the original Google Ads Databoard(s) and replace the old Google Ads Data Source with the new one. 

Granularity Restrictions

  • Due to API limitations, "by Keyword" Metrics such as "[Clicks] by Keyword" do not support hourly granularity. This may affect visualization options for Charts in Databox. 
    However, the big number above the Chart will accurately reflect the Metric value for the selected Date Range.
    • Learn more about Granularity here