[Partner Block] DoubleClick Analytics by Google (DBM/DCA)

  • 25 October 2016
  • 4 replies

Userlevel 4

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


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.

4 replies

Is it possible to get access to this block? If so, where is it located? thanks.

Userlevel 4

@Alice_Ching you caught me in the middle of writing this 🙂 I’ll post instructions in just a few minutes here! Thanks for the interest

Userlevel 4

@Alice_Ching you’re good to go! Please feel free to reach out with any questions that come up.

🙂 awesome thank you very much!!