Popular Use Cases: Google Ads

HOW TO REPORT ON

How to report on Campaign Performance

You may want to report on Campaign performance from your Google Ads Account. This includes viewing data on "Impressions," "Cost per Conversion," "Avg CPC," etc. for a specific Campaign or list of Campaigns. 

IN THIS SECTION

Campaign Performance Metrics

You can use Basic or Custom Metrics to report on the performance of a specific Campaign or list of Campaigns. 

The Basic Metrics that are available all have "by Campaign" in the Metric name. These include "Cost by Campaign," "Clicks by Campaign," and "Conversion Rate by Campaign."

To view a list of these Metrics, navigate to  Data Manager > Metrics in Databox and select Google Ads from the Data Source drop-down. Type "by Campaign" in the Search bar to filter out all "by Campaign" Metrics. 

In order to view the performance of a single Campaign from your Account, you'll need to set your Datablock up in a way that prompts you to select a specific Dimension (Campaign). Learn how to select a specific Campaign on a Datablock here

Custom Metrics can also be created to report on the performance of a single Campaign using the Query Builder for Google Ads. In order to access Campaign-specific data, you will need to choose the Campaign Performance Report from the Report drop-down. 

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following these steps.
If you want to report on the performance of a single Campaign, it's recommended you use the Dimension "Campaign" in the Filter. This will allow you to specify the individual Campaign you want to sync data for. 
Pro Tip : If you don't know which Filter to put in place, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Ads Account for each field. Learn more here.
If you want to report on Impressions for your Campaign called "Product Launch," you can build the following Custom Metric:

If you want to report on the performance of all Campaigns, it's recommended that you use the Dimension "Campaign" in the Dimension field rather than the Filter.

If you want to report on Impressions for all of your Campaigns, you can build the following Custom Metric:

Campaign Performance Templates

Here is a Campaign Performance Template to help you get started: 

How to report on Ad Group Performance

You may want to report on Ad Group performance from your Google Ads Account. This includes viewing data on "Impressions," "Cost per Conversion," "CTR," etc. for a specific Ad Group or list of Ad Groups. 

You can use Basic or Custom Metrics to report on the performance of a specific Ad Group or list of Ad Groups. 

The Basic Metrics that are available all have "by Ad Group" in the Metric name. These include "Cost by Ad Group," "Clicks by Ad Group," and "Conversion Rate by Ad Group."

To view a list of these Metrics, navigate to  Data Manager > Metrics in Databox and select Google Ads from the Data Source drop-down. Type "by Ad Group" in the Search bar to filter out all "by Ad Group" Metrics. 

In order to view the performance of a single Ad Group from your Account, you'll need to set your Datablock up in a way that prompts you to select a specific Dimension (Ad Group). Learn how to select a specific Ad Group on a Datablock here

Custom Metrics can also be created to report on the performance of a single Ad Group or list of Ad Groups using the Query Builder for Google Ads. In order to access Ad Group-specific data, you will need to choose the Ad Group Performance Report from the Report drop-down.

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following these steps.
If you want to report on the performance of a single Ad Group, it's recommended that you use the Dimension "Ad Group" in the Filter. This will allow you to specify the individual Ad Group you want to sync data for. 
Pro Tip : If you don't know which Filter to put in place, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Ads Account for each field. Learn more here.
 If you want to report on Impressions for your Ad Group called "Sneakers," you can build the following Custom Metric:

If you want to report on the performance of all Ad Groups, it's recommended that you use the Dimension "Ad Group" in the Dimension field rather than the Filter.

If you want to report on Impressions for all of your Ad Groups, you can build the following Custom Metric:

How to report on Ad Performance

You may want to report on Ad performance from your Google Ads Account. This includes viewing data on "Impressions," "Cost per Conversion," "Avg CPC," etc. for a specific Ad or list of Ads. 

You can use Basic or Custom Metrics to report on the performance of a specific Ad or list of. 

The Basic Metrics that are available all have "by Ad" in the Metric name. These include "Cost by Ad," "Clicks by Ad," and "Conversion Rate by Ad."

To view a list of these Metrics, navigate to  Data Manager > Metrics in Databox and select Google Ads from the Data Source drop-down. Type "by Ad" in the Search bar to filter out all "by Ad" Metrics. 

In order to view the performance of a single Ad from your Account, you'll need to set your Datablock up in a way that prompts you to select a specific Dimension (Ad). Learn how to select a specific Ad on a Datablock here

Custom Metrics can also be created to report on the performance of a single Ad or list of Ads using the Query Builder for Google Ads. In order to access Ad-specific data, you will need to choose the Ad Performance Report from the Report drop-down. 

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following these steps.
If you want to report on the performance of a single Ad, it's recommended you use the Dimension "Ad" in the Filter. This will allow you to specify the individual Ad you want to sync data for. 
Pro Tip : If you don't know which Filter to put in place, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Ads Account for each field. Learn more here.
If you want to report on Impressions for your Ad called "Sandals," you can build the following Custom Metric:

If you want to report on the performance of all Ads, it's recommended that you use the Dimension "Ad" in the Dimension field rather than the Filter.

If you want to report on Impressions for all of your Ads, you can build the following Custom Metric:

How to report on Keyword Performance

You may want to report on keyword performance from your Google Ads Account. This includes viewing data on "Impressions," "Cost per Conversion," "Avg CPC," etc. for a specific Keyword or list of Keywords. 

You can use Basic or Custom Metrics to report on the performance of a specific Keyword or list of Keywords. 

The Basic Metrics that are available all have "by Keyword" in the Metric name. These include "Cost by Keyword," "Clicks by Keyword," and "Conversion Rate by Keyword."

To view a list of these Metrics, navigate to  Data Manager > Metrics in Databox and select Google Ads from the Data Source drop-down. Type "by Keyword" in the Search bar to filter out all "by Keyword" Metrics. 

In order to view the performance of a single Keyword from your Account, you'll need to set your Datablock up in a way that prompts you to select a specific Dimension (Keyword). Learn how to select a specific Keyword on a Datablock here

Custom Metrics can also be created to report on the performance of a single Keyword or list of Keywords using the Query Builder for Google Ads. In order to access Keyword-specific data, you will need to choose the Keyword Performance Report from the Report drop-down. 

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following these steps.
If you want to report on the performance of a single Keyword, it's recommended that you use the Dimension "Criteria" in the Filter. Since the "Keyword Performance Report" is selected, the "Criteria" refers to "Keywords."
Pro Tip : If you don't know which Filter to put in place, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Ads Account for each field. Learn more here.
If you want to report on Impressions for your Keyword "Slippers," you can build the following Custom Metric:

If you want to report on the performance of all Keywords, it's recommended that you use the Dimension "Criteria" in the Dimension field. Since "Keyword Performance Report" is selected, the "Criteria" refers to "Keywords."

If you want to report on Impressions for all of your Keywords, you can build the following Custom Metric:

How to report on Gender Performance

You may want to report on gender performance data from your Google Ads Account. This includes viewing data on "Impressions," "Cost per Conversion," "Avg CPC," etc. split up by Gender. 

Custom Metrics can be created to report on this data using the Query Builder for Google Ads. In order to access Gender-specific data, you will need to choose the Gender Performance Report from the Report drop-down. 

    Query Builder is available in Plus and Business Accounts. Agency Basic Accounts have access to Query Builder in the Agency Account only. Request a trial of Query Builder by following these steps.
In order to split up results based on gender, it's recommended that you select "Criteria" in the Dimension field. Since the "Gender Performance Report" is selected, the "Criteria" refers to "Gender."
Pro Tip : If you don't know which Filter to put in place, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Ads Account for each field. Learn more here.

If you want to report on Impressions split up by gender, you can build the following Custom Metric:

If you want to view data for a single Gender, you'll need to set your Datablock up in a way that prompts you to select a specific Dimension (Gender). Learn how to select a specific Gender on a Datablock here

How to report on Total Ad Spend

You may want to report on the aggregated spend from multiple Data Sources, like Google Ads, Facebook Ads, and LinkedIn Ads. 

This can be accomplished using Data Calculations

    Data Calculations is available in Plus and Business Accounts. Agency Basic Accounts have access to Data Calculations in the Agency Account only. Request a trial of Data Calculations by following these steps.

To start, identify the Metric from each Data Source that's tracking your spend. For Google Ads, this Metric is called "Cost." For Facebook Ads, this Metric is called "Amount Spent." For LinkedIn Ads, this Metric is called "Total Spent." 

You can identify the appropriate ad spend Metrics for your Data Sources using the Metrics page

Using Data Calculations, create a new Calculated Metric that adds these all together. Be sure to select the "Unit" to ensure your Metrics are summed together to produce 1 aggregated value. 

Pro Tip: If the "Unit" selection is not consistent for all Metrics, they will not be added together. As a result, your Calculated Metric will have different aggregated values stored for each Unit. 

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