Guide: Using Google Ads with Databox


How to connect Google Ads to Databox


How to connect Google Ads to Databox

To connect a Google Ads Account in 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  Activation window, which is where you will be prompted to enter your Google Ads Customer ID to authorize the Databox app. After logging into your Google Ads Account, your Customer ID can be found in the top right corner above your email address. 

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

Can I connect a Manager Google Ads Account?

Due to API limitations, connecting Google Ads Manager Accounts to Databox is not possible. Learn more here.

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 TipIn 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

 Navigate to Databoards > Public Templates
 In the Data Source drop-down list, select Google Ads
 To view a preview of the Template populated with dummy data, click Preview
 To pull the Template into your Account and re-populate it with your own Google Ads data, click Use Template
 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

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

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

 View the list of Visualizations available in Databox. Drag and drop your selected Visualization onto your Databoard
 Click on the Datablock on the Databoard to open the corresponding Datablock Settings on the righthand side of the Designer
 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
 Complete steps 4-8 until your Databoard is complete

How to use the Query Builder for Google Ads

With the Query 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 Query Builder for Google Ads include creating Campaign- and Ad-specific Metrics and reports to track your Google Ads data. 

Learn more about the Query 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 Query Builder, you can create Custom Campaign Metrics and purge data to refetch the Campaign Names. If you don't have access to Query 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. 
  • The Google Ads API version that the Databox + Google Ads integration relies on does not support ''Local'' and ''Performance Max'' Campaign Types. 

    As a result, campaigns with "Local" and "Performance Max" Campaign Types will be missing in your reports for Campaign metrics. This includes metrics like ''Impressions by Campaign,'' ''CTR by Campaign,'' ''Clicks by Campaign,'' etc. You may also notice data discrepancies with metrics that represent total values, such as ''Impressions,'' ''CTR,'' ''Clicks,'' etc., due to data for campaigns with "Local" and "Performance Max" Campaign Types not being included in the reports.

    In your Google Ads reports, you can identify the campaign type by checking the ''Campaign Type'' column.

    We plan to update our Google Ads integration to sync data from the newer Google Ads API that supports ''Local'' and ''Performance Max'' Campaign Types in the future. You can upvote the development of this update here:

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
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