DoubleClick by Google helps businesses connect with the right people in the right moments and drive higher ROI by making digital advertising efforts more effective. Here are some things you can expect from the DoubleClick/Grow integration.

Related Articles and Links:

WHAT TO EXPECT

  • DoubleClick Publisher and Advertising support: The DoubleClick/Grow integration is currently designed to pull DoubleClick Search reports. It does not offer a connection to Publisher or Advertising reports.
  • Choosing Columns: For a full list of the precise column names available from DoubleClick, visit their API reference page here. Select “Types of Reports” in the left sidebar and click the report that you want to pull. In Grow, you should list the desired columns one after the other, separated by a comma with no additional spaces. Bear in mind that any metrics or attributes you want to pull on a level more specific than "Account" will require the ID or IDs for all levels above that.
  • Segmenting by Date: In order to segment by date, you’ll include the date column in the “Columns” bar. “monthStart” and “monthEnd” will summarize the metric columns requested on that level, while “date” will include all activities for each date included in the date range selected from the Grow drop down date picker at the bottom of the data connection sidebar.
  • Finding IDs: The individual IDs for each level of granularity above that where segmentation is desired (agency, campaign, ad group, etc.) are required to pull a report for that level. These IDs can be found easily in grow by requesting the ID and name columns for each level in a separate report in the metric builder. 
  • Segments, Attributes, & Metrics: The data you pull in from DoubleClick will be one of three types. Segments will group and sum any metrics pulled in on a certain level, whether by date, activity, group, or another level of summation. Attributes are account-specific data, such as IDs and names of entities, and are typically used to filter data in Grow. Metrics are measurements, and most often come in integers— percentages, dollars, counts, etc. 

REPORTS

There are a large number of reports that can be generated from DoubleClick, and most can be filtered as broadly as by agency, advertiser, engine account, and campaign, or as specifically as ad group, keyword, and ad. Below is a list of the reports you can pull from DoubleClick, along with a description of the fields available with each report.

  • Account: Reporting data for engine accounts, including performance metrics across all of an account’s campaigns (cost-per-click, conversions, impressions, revenue, etc.) and configuration attributes for an account (IDs, names, currency codes, time zone, created and modified dates, etc.)
  • Ad: All performance metrics and configuration attributes for ads, including ad ID, ad headline, ad description, landing page, type, promotion line, labels, actions, revenue, transactions, weighted actions, avg cpc, avg cpm, avg position, cost, ctr, impressions, conversions, etc.
  • Advertiser: Reporting data for advertisers, including performance metrics across all of an advertiser’s engine accounts and campaigns (cost-per-click, conversions, impressions, revenue, etc.) and configuration attributes for an advertiser (IDs, names, currency codes, time zone, created and modified dates, devices, other segmentation data, etc.)
  • Ad Group: All performance metrics and configuration attributes for ad groups, including ad group ID, status, start date, end date, max cpc, mobile bid adjustment, group type, distributions, group labels, device targets, actions, revenue, transactions, cpc, cpm, position, cost, ctr, impressions, conversions, etc.
  • adGroupTarget (DynamicSearchAds and RemarketingList): Performance metrics for ad group level location targets and remarketing list targets. Some targets are available only in specific types of engine accounts. Includes revenue, transactions, cpc, cpm, clicks, cost, ctr, impressions, conversions, visits, etc.
  • bidStrategy: Performance metrics and configuration attributes for bid strategies, including agency, advertiser, bid strategy ID, goal, targets, min bid, max bid, actions, revenue, transactions, cpc, cpm, position, clicks, cost, ctr, impressions, conversions, visits, etc.
  • Campaign: All performance metrics and configuration attributes for campaigns, including campaign ID, start date, end date, budgets, ad rotation, campaign type, targets, excluded targets, actions, revenue, transactions, cpc, cpm, position, clicks, cost, ctr, impressions, conversions, visits, search impression share, etc.
  • campaignLocationTarget: Performance metrics for campaign location targets (geo-location, proximity, and location extension). Some targets are available only in specific types of engine accounts.
  • Conversion: All raw event data about conversions, including status, device segment, floodlight group and activity data, ad, ad group, campaign, conversion ID, type, revenue, quantity, date, visit ID, search term, referrer, order ID, feed ID, feed type, etc.
  • feedItem: Performance metrics and configuration attributes for feed items (for example, sitelink, location, call or app extensions).
  • floodlightActivity: Configuration attributes for Floodlight activities, including status, created timestamp, last modified timestamp, group, group conversion type, group ID group tag, configuration ID, activity, activity tag, agency, advertiser, etc.
  • Keyword: All performance metrics and configuration attributes for keywords, including status, created date, agency, advertiser, account, campaign, ad group, ad, quality score current, dfa actions, revenue, transactions, cpc, cpm, position, clicks, cost, ctr, impressions, conversions, visits, date, month start, month end, etc.
  • negativeAdGroupDynamicSearchAdsTarget: Configuration attributes for negative dynamic ads targets at the ad group level, including status, agency, advertiser, account, account type, campaign, campaign status, target conditions, etc.
  • negativeAdGroupKeyword: Configuration attributes for negative keywords that have been created at the ad group level.
  • negativeAdGroupRemarketingListTarget: Configuration attributes for negative remarketing list targets at the ad group level.
  • negativeCampaignDynamicSearchAdsTarget: Configuration attributes for negative dynamic ads targets at the campaign level.
  • negativeCampaignKeyword: Configuration attributes for negative keywords that have been created at the campaign level.
  • negativeCampaignRemarketingListTarget: Configuration attributes for negative remarketing list targets at the campaign level.
  • paidAndOrganic: Search terms that either triggered your ads to appear on Google, triggered Google to display unpaid (organic) search results for your site, or both. 
  • productAdvertised: Performance metrics, configuration attributes, and inventory attributes for products defined in an inventory feed and advertised in a shopping campaign.
  • productGroup: Performance metrics and configuration attributes for product groups. Learn more about how product groups differ from keyword reports here
  • productLeadAndCrossSell: Performance metrics, configuration attributes, and inventory attributes for products defined in an inventory feed and sold as a result of paid search advertising.
  • productTarget: Performance metrics and configuration attributes for product targets. Learn more about product targets in DoubleClick here.

More questions about the DoubleClick/Grow integration? Email us at support@grow.com or chat in on the site.

Did this answer your question?