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.
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 email@example.com and we’d be happy to help.