What is this block and what does it tell me?
DoubleClick is Google’s ad technology foundation aimed at helping customers create, transact, and manage digital advertising for the world’s buyers, creators, and sellers. For Publishers, DoubleClick offers a complete ad revenue engine, helping publishers streamline operations and capture the most value for every impression. For advertisers and agencies, DoubleClick strengthens and simplifies complex online campaigns using a robust digital ad management platform. DoubleClick also offers an Ad Exchange - a real-time digital ad marketplace that connects publishers with agencies, ad networks and third-party technology providers.
Data type and technical info
DoubleClick DBM/DCA customers can pull DoubleClick data out of the application to conduct deep, granular analysis to determine which ads are the most performant across all outlets. This data is useful for advertisers and agencies to understand how to optimize campaigns and future advertising plans. DoubleClick data contains several key tables:
Impressions - contains data for each advertising view, segregated by target market, campaigns, and any other audience attributes
Clicks - contains information around all audience clicks, which can be combined with impressions to determine conversion rates
Activity - contains revenue and metadata information about each advertising campaign
Examples
Reach Overview
Reach Detail
Campaign Overview
##How do I Implement this Block?
The LookML for this block can be found in this Github repo. You can either download the entire block into your Looker application by following the directions outlined here, or selectively migrate pieces of the block by simply copying + pasting the block LookML into your Looker instance.
If you don’t have a Github account, we encourage you to create one for easy access to this block. If you don’t have access to the repo, or cannot make a Github account, please contact a Looker Analyst or email blocks@looker.com and we’d be happy to help.