Search Data Library

Usage

Querying a clients search views is as simple

SELECT * FROM gap_core.{search_view}

Standard Views

• search_account

  • Account level performance statistics from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of account, date, device, and ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_campaign

  • Campaign level performance statistics from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of campaign, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_adgroup

  • Ad group level performance statistics from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of adgroup, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_ad

  • Ad level performance statistics from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of ad, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_keyword

  • Keyword level performance statistics from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of keyword, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_pla (product listing ad)

  • Shopping campaign statistics at the product partition level from all Search platforms on which the client serves media. The view is segmented so that there will be 1 row per unique combination of ad group, criteria, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_sqr (search query)

  • Data aggregated at the search terms level, one row per unique combination of search terms, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_audience

  • Audience level performance data from interests and remarketing lists for Display Network and YouTube Network ads, and remarketing lists for search ads (RLSA). The view is segmented so that there will be 1 row per unique combination of audience, date, device, ad_network_type with all metrics and statistics for a given date divided between those possibilities.
    

    

• search_geo (Google Ads only)

  • Campaign level performance statistics from Google Ads segmented by geo targets (country, region, and city). The view is segmented so that there will be 1 row per unique combination of campaign, date, device, ad_network_type, country, region, and city with all metrics and statistics for a given date divided between those possibilities.
    

    

Column Mapping

https://docs.google.com/spreadsheets/d/1psEt00-EHMiPGlO-5EtdAWlYOl0N95vwVtc9suQ-Rug/edit?usp=sharing