Looker

Marketplace

Develop for Marketplace

Blocks

Google Ads - BQ Transfer

By Google
Expand your insights by joining in external datasets, simplifying complex account hierarchies and streamlining currency data with the Looker Block for Google Ads.
Expand your insights by joining in external datasets, simplifying complex account hierarchies and streamlining currency data with the Looker Block for Google Ads.

Version

v3.0.0

Release Notes

Category

Blocks

ETL Providers

BQ Transfer

SQL Dialects

Google BigQuery

Overview

Install this block for free by importing the project(s) from the GitHub repository linked at the top of the listing.

This is not an officially supported Google product.

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

Related Content

Amazon Redshift Administration

GoogleFine-tune your Redshift deployment with a comprehensive view of performance and query analysis.Blocks

BigQuery Information Schema Performance Monitoring

GoogleMonitor and Explore your BigQuery Usage and PerformanceBlocks

© 2025 Looker Data Sciences, Inc.
Privacy | Terms | Cookies