Google Ads - BQ Transfer
What does this Block do for me?
Combine Multiple Data Sources - Combine your Google Ads data with data from GA, DoubleClick, Facebook Ads, Salesforce, and more to get a holistic view of all your customer data in one central view (see bottom of this page for instructions).
Work with Complex Account Hierarchies - Provides possibilities for custom permissions structures and singular views when you have MCC codes with thousands of accounts or perhaps multiple Data Transfer Service accounts going into multiple BigQuery projects.
Unbounded Custom Metrics - With Looker's modeling language (LookML) there are no limitations to the kinds of complex custom metrics that can be created including filtered measures, measures that require advanced mathematical functions, custom groupings. Anything is possible.
Utilize Machine Learning (ML) - Through the power of BQML, unleash advanced use cases like click fraud prevention.
Take Advantage of Blocks Ecosystem - Want to add powerful machine learning with BQML? Add the BQML block, there are 100s of blocks in the blocks directory.
Enterprise Data Platform - Take advantage of Looker's data platform functionality, including data actions, scheduling, permissions, alerting, parameterization (each user can only see their own data), and more. Get immediate alerts when budgets are exceeded, ads are underperforming, or any other business criteria.
Usable / Shareable Dashboards - create centralized dashboards for the entire team, and departmental or individual dashboards for each user, and rest easy knowing everyone is looking at the same information at all times. Then schedule the dashboard for emails or alerts, period-end reporting, anomaly detection, or whatever else serves your use-case.
NOTE: This block is for use with datasets ETL'd via Google's BigQuery Data Transfer Service