Paid Search Dashboard Overview

Overview  

The Paid Search Dashboard brings together all paid search marketing efforts into one workbook with multiple dashboards. 

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.

Intended Audience

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. 

Dashboards  

  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.

Supported BI Tools

The Paid Search Dashboard is available in Tableau, Power BI and Google Data Studio. 

Data

This report includes the following data sources:

*Not all data sources are needed for the OneView

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

This report is built on these datasets:

Tableau and PowerBI

  1. v_oneview_paid_search_ad_group_and_conversion
  2. v_oneview_paid_search_keyword_and_conversion
  3. v_oneview_paid_search_ad_and_conversion

Google Data Studio

  1. CLIENT_NAME*_oneview_paid_search_ad_group_and_conversion
  2. CLIENT_NAME*_oneview_paid_search_keyword_and_conversion
  3. CLIENT_NAME*_oneview_paid_search_ad_and_conversion

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