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

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

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

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

How to build a Databoard

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

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:
  • ''Local Campaign metrics''
  • ''Performance Max Campaign metrics''

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.