- May 22, 2023
- May 18, 2023
- April 25, 2023
- April 17, 2023
- April 10, 2023
- April 3, 2023
- March 23, 2023
- March 16, 2023
- March 9, 2023
- January 30, 2023
- January 26, 2023
- January 19, 2023
- January 6, 2023
May 22, 2023
Running percentage delta
You can apply a running percentage of delta calculation to metrics in a chart. This calculation applies the following formula:
(current value - previous value) / ABS(previous value)
To apply a running calculation to your chart, follow these steps:
- Edit your report.
- Select a chart.
- On the right, in the properties panel, select the SETUP tab.
- Add a metric to the chart, and then click its edit pencil .
- Click the Running calculation menu, and select the desired function.
For example, the following table shows the percentage change in class attendance for 1 week. Day 1 attendance is 95 , while day 2 attendance is 101. The running percentage delta calculation for day 2 is:
(101 - 95) / ABS(95)= 6.32%.
Learn more about running calculations.
May 18, 2023
Pause report updates
You can pause updates to minimize the number of data requests made while building and editing your report. While the report is paused, changes made to the report's data settings are placed on hold until you resume updates. Pausing report updates can potentially save on query costs because Looker Studio only requests the data needed to meet the report configuration as of the time you resumed updates.Learn more.
April 25, 2023
We fixed an issue that prevented users from connecting to PostgreSQL version 14.
Public issue tracker.
Updated PostgreSQL connection information. If you wish to enable client authentication, note that Looker Studio expects the key to be in PKCS-8 format.
April 17, 2023
Scorecard visualizations include the following options:
- Sparklines show historical trends for a scorecard value over time.
- Progress visuals show the progress of a scorecard value towards a goal.
- You can compare the scorecard metric to a time period, target value, or metric.
Updated pivot table limit
Pivot tables can render up to 500,000 cells of data, however, depending on the data set and dimensions and metrics involved in the table, performance may degrade. You can apply a filter to the pivot table to reduce the amount of data being rendered.
(Previously, the limit was incorrectly stated as 50,000 rows.)
April 10, 2023
Scheduled delivery improvements
We've launched these new features for scheduled delivery of your reports:
Pro feature: multiple delivery schedules
Looker Studio Pro customers can add up to 20 email delivery schedules to a report. Each schedule can go to different recipients and have different settings. Learn more.
Filters in scheduled delivery
You can customize the filters and date ranges applied to scheduled reports. Learn more.
You can send a report via email immediately with the Send now feature. Learn more.
New chart type: sankey visualization
Sankey charts display a flow from one set of values to another and are effective for analyzing movements of information over time. Learn more.
Add buttons to your reports
Buttons let you customize and streamline the way your customers interact with chart filters, actions, and navigation.
Zoom and pan on charts
Zooming and panning can help you focus on specific areas of a data-dense visualization, such as when you want to highlight a portion of your data or review more granular details. Learn more.
April 3, 2023
PostgreSQL 13 & 14 support
You can now connect Looker Studio to PostgreSQL versions 13 and 14. Learn more about connecting to PostgreSQL.
YouTube connector bug fix
We fixed a bug that could cause you to see different data from the YouTube connector than what you'd see in YouTube Analytics. Now the data should be the same in both places. Learn more about connecting to YouTube analytics.
March 23, 2023
Align both axes to 0 option in Cartesian charts
You can align left and right axes to zero in Cartesian line, bar, and combo charts that have left and right Y-axes. This option is useful when you want to compare sets of data that contain a mix of positive and negative numbers.
Here's an example: the chart on the left is not aligned to 0, while the chart on the right is aligned to 0.
Google Ad Manager: Deprecation of the Verified categories dimension
The Verified categories dimension is deprecated in the Historical report. We've replaced Verified categories with the equivalent dimension, Advertiser vertical, in saved reports.
March 16, 2023
More improvements to field search in the data panel
Searching for a field in the report editor's data panel is contextual:
- When no components are selected, you can search for fields in any data source that is added to the report.
- When a component is selected, the search results are restricted to that component's data source.
- When a group of components is selected, the search results are restricted to the grouped component's data sources.
When you search for a field, the data panel provides additional information about the results:
- The number of matches for each data source on the report appears on the right.
- The text matching your search appears in bold.
- If a data source doesn't contain your search term, a message appears below that data source.
Updated database connector articles
Added the note that custom queries in Looker Studio may timeout after 3 to 5 minutes to all database connectors that support custom queries.
Updated PostgreSQL connector article
Added a note that the PostgreSQL connector doesn't use the Cloud SQL proxy when connecting to Cloud SQL PostgreSQL instances. If you're connecting to a Cloud SQL PostgreSQL instance, you'll need to add the listed IPs to the authorized networks list.
March 9, 2023
New / renamed fields in the Google Analytics 4 connector
The following fields are available in the GA4 connector:
- Items added to cart
- Items checked out
- Items clicked in list
- Items clicked in promotion
- Items viewed
- Items viewed in list
- Items viewed in promotion
The following fields have been renamed:
|Old name||New name|
|Add-to-carts||Add to carts|
|Item purchase quantity||Items purchased|
|Item list clicks||Item-list click events|
|Item list views||Item-list view events|
|Item promotion clicks||Promotion clicks|
|Item promotion views||Item view events|
|Item views||Item view events|
To see these fields in your reports, refresh the data source.
Updated: Connect to BigQuery
Added a note that custom queries in Looker Studio may timeout after 3 to 5 minutes.
Deleted: Connect to Google Surveys
Google Surveys and Surveys 360 were turned down in November 1, 2022. Creating new data sources based on Google Surveys has not been possible since that time.
Learn more about why Surveys was turned down.
January 30, 2023
Identify Looker Studio queries with BigQuery job labels
All queries sent by Looker Studio to BigQuery have the BigQuery job label requestor:looker_studio.
You can use this job label to identify BigQuery queries related to Looker Studio. See viewing job labels for instructions.
Article: Set up organizational ownership of Looker Studio Pro assets
Clarified that Looker Studio Pro assets are protected from accidental deletion by applying a Google Cloud lien.
January 26, 2023
Looker connector generally available
The Looker connector allows you to access Looker data within Looker Studio by adding an Explore as a data source to a Looker Studio report.
Learn more about Connecting to Looker Studio from Looker.
January 19, 2023
Improved field search in the report editor
Searching for a field in the data panel only searches the currently selected component's data source. When no components are selected, search looks for fields in any data source that is added to the report.
January 6, 2023
Connect to Cloud SQL for MySQL instances that use private IP connectivity
The Cloud SQL for MySQL connector now supports connections to Cloud SQL for MySQL instances with private IP connectivity.
To allow Looker Studio to access data in Cloud SQL and make queries against this data over a private connection, select the Enable private path option under Google Cloud services authorization in your Cloud SQL for MySQL instance settings.