Paid Search Dashboard Overview - Google Data Studio

Overview

The purpose of the paid search dashboard is to provide a reporting tool that meets the needs of both executives and analysts who are involved in advertising on search networks using Google Data Studio. This report aggregates data from the following paid social platforms: Google Ads, Bing Ads and Search Ads 360. If your campaign does not have datasets for one or more of these paid search sources, or a paid search source has not been added to the OneViews, data from that source will not populate in the dashboard.

This report includes the following data sources:

  • Bing Ads
  • Google Ads
  • Google Search Ads 360
  • Yahoo! Gemini

This report includes five separate tabs:

  1. Executive Summary: The Executive Summary presents performance (spend, impressions, clicks) and conversion (conversions, conversion rate, cost per conversion) metrics from paid social platforms. The dashboard enables users to compare and filter by search network, campaign, and ChannelMix profile.
  2. Campaign Summary: The Campaign Summary breaks down paid search performance at the Campaign level. The dashboard enables users to compare and filter by search network, campaign, ad group, device, and ChannelMix profile.
  3. Ad Group Summary: The Ad Group Summary breaks down paid search performance at the Ad Group level. The dashboard enables users to compare and filter by search network, campaign, ad group, device, and ChannelMix profile.
  4. Keyword Summary: The Keyword Summary breaks down paid search performance at the keyword level. The dashboard enables users to compare and filter by match type, search network, campaign, ad group, device, and ChannelMix profile.
  5. Ad Summary: The Ad Summary breaks down paid search performance at the individual ad level. The dashboard enables users to compare and filter by search network, campaign, ad group, device, and ChannelMix profile.

This report is built on two datasets (which you will need to connect to when setting up your dashboard):

  1. CLIENT_NAME*_oneview_paid_search_ad_group_and_conversion: This dataset includes performance (impressions, clicks, spend) and conversion data (conversions, conversion value) at the ad group level. Aggregates from Google Ads, Bing Ads, Search Ads 360 and Yahoo Gemini/Oath.
  2. CLIENT_NAME*_oneview_paid_search_keyword_and_conversion: This dataset includes performance (impressions, clicks, spend) and conversion data (conversions, conversion value) at the keyword level. Aggregates from Google Ads, Bing Ads, Search Ads 360 and Yahoo Gemini/Oath.

*NOTE: "Client_Name" is the name of your client within C3. For example, if you're ABC Agency and setting up this dashboard for John Doe Company, the first dataset above would be named "John_Doe_Company_oneview_paid_search_ad_group_and_conversion"

A note on conversion datasets:

Search Ads 360 treats all conversions as saved columns. There is no delineation between conversion counts (the number of unique conversions that took place) and conversion values (the revenue associated with conversions), so by default, all saved column metrics are in the ‘conversions’ field. When configuring the dashboard, you may need to filter out conversion names from all conversion-level OneViews to avoid inflated conversion values. 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.