3.5. Google Connectors in Looker Studio
Notable Built-In Connectors
Google offers several built-in connectors for Looker Studio. When selecting a Google connector, you'll be presented with various options. Some of the most notable connectors include:
- Universal Analytics and GA4: These connectors can access all data or a specific segment. For Universal Analytics, data sampling is applied, and the sample rate is shown.
- Google Ads: This connector can connect to a single customer account or an MCC account, supporting up to 50 accounts simultaneously.
- Google Search Console: With this connector, you can extract site impressions or URL impressions. It supports four different types of API requests: web data, image data, video data, and news data. You can create multiple data sources with different settings using the same connector.
- Google Sheets: A versatile connector that allows you to import data from other tools or even manual entries. It's quick and can connect to the entire sheet or a specific range.
- BigQuery: A fast and scalable petabyte-scale data warehouse managed by Google. You can connect to a single table or write a custom query to access multiple tables. It also features the BI Engine, which is only available for Looker Studio connections and enables sub-second queries and filtering.
- YouTube and Extract Data: YouTube allows you to access video data, while Extract Data is a special type of connector that can increase speed, security, and even de-aggregate pre-aggregated data.
More details on Extract Data will be provided in future sessions.
Google offers a variety of connectors to help you access and visualize data in Looker Studio. From Google Analytics to BigQuery, these connectors enable you to connect to different data sources and create versatile and comprehensive reports.
We will discuss the functions, features, and limitations of these notable Google Connectors in detail.