[Partner Block] AdWords Analytics by Google


(Dillon Morrison) #1

What is this Block and what does it tell me?

Adwords offers the most powerful tool on the web for search-based marketing, used by thousands of industry-leading companies across all industries. Adwords lets you be seen by customers at the very moment that they’re searching on Google for the things you offer. And only pay when they click to visit your website or call.

Give users the ability to easily run any report that can be found in AdWord’s native reporting platform, and analyze your full Adwords data set, all within Looker’s snappy, intuitive interface. Explore data across campaigns, line items, display and keyword ads, audience segments, and much more, with full flexibility and consistency. Use this Block to understand where and how to allocate budget effectively, and to monitor your entire Adwords initiative, including workflows and alerting, with a rich suite of prebuilt analysis.

Data types and technical info

This Block was modeled around data from AdWords as exported using Google’s BigQuery Transfer Services. It models around many of the core entities in AdWords. Additional analysis, modeling logic, and custom objects should be added to help this Block meet your business needs.

Examples

Please note that Partner Blocks are only available to current and prospective customers. Please reach out to your assigned Looker Analyst for questions and/or assistance implementing this Block. Included below are some sample screenshots of a few out of the many dashboards that can be created with this Block:

Ad Performance Overview - understand display performance across all outlets to understand which platforms, formats, text, etc., reach your intended audience most effectively

Campaign Performance Overview - compare audience cohorts, conversions and cost, period-over-period analysis, and all other signs of campaign success

Keyword Performance Overview - control budget and optimize keyword success using custom cohorting and trend analysis over time

How to implement this Block

You can either download the entire block from this Github repo, directly 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.


#2

Have there been any updates to these blocks since this post last year? If so, where to find them? Thanks.


#3

Hey drogalski,

Do you mean this specific Adwords Analytics block? If so, here is a link to its github repo, and it looks like the last commits were about 9 months ago. You can also submit feedback as an issue for this block here.

If you’d like information about all Looker blocks in general, you can find all Looker blocks as well as the more recently built ones on our blocks directory.

Have a great day!