Unable to aggregate ratio metrics in the request. Please select another metric.
這項錯誤表示您要求 Looker Studio 對已匯總的比例指標執行某項操作，但 Looker Studio 無法執行這項操作。舉例來說，您已將以計算欄位為依據的篩選器套用至包含比例指標的圖表。
解決方法是在圖表中選取非比率欄位 (例如使用「曝光次數」而非「點閱率」)，或是移除或變更篩選條件。
深入探討
比率指標會顯示兩個或更多值的相對大小。舉例來說，Google Ads 指標「點閱率」(CTR) 是指將廣告獲得的點擊次數除以廣告顯示次數後所得出的比率。在 Google Analytics 中，「參與度」是指網站或行動應用程式中互動工作階段的百分比，而「跳出率」則是參與度的相反詞。「跳出率」是指非互動工作階段的工作階段百分比。
在 Looker Studio 中，如果篩選包含比率指標的圖表，而該圖表需要產品重新計算比率，就會出現上述錯誤。
以下 3 點說明可協助你瞭解這個問題：
從 Google Analytics、Google Ads、YouTube 和 Google Marketing Platform 產品等資料集匯入 Looker Studio 時，資料就會匯總完成。舉例來說，當 Looker Studio 要求 Google Ads 評估指標 (例如點閱率) 時，系統會將資料處理成適當的匯總類型。
由於前述原因，系統會在匯總資料後套用計算欄位函式。您無法 (也沒有必要) 查看原始資料，瞭解該指標的每個不重複值。舉例來說，如果您嘗試在 Google Ads 資料來源中使用公式 SUM( Impressions ) 建立計算欄位，就會收到以下錯誤訊息：
Re-aggregating metrics is not supported。
這是因為「曝光次數」已匯總 (且其匯總類型「自動」無法變更)。
為求一致性，Looker Studio 中的所有計算欄位函式皆可搭配所有資料來源類型使用，即使底層系統不支援該函式也一樣。舉例來說，即使基礎系統沒有自己的 CONCAT 函式，您還是可以使用 CONCAT 函式，在任何資料來源中彙整多個值。Looker Studio 會要求資料並自行執行連結作業，而非將 CONCAT 函式「推送」至底層系統。
匯總失敗範例
那麼，這些與 Unable to aggregate ratio metrics 錯誤有什麼關係？這個範例會深入說明 CONCAT 的用法，協助您找出答案。
假設您使用下列公式，在 Google Ads 資料來源中建立名為「Campaign : Click Type」的計算欄位：
CONCAT(Campaign, " : ", Click Type)
Looker Studio 會分別針對「Campaign」和「Click Type」發出查詢，然後執行連結作業。結果會分組，因此不會有重複的記錄。
這項篩選器會要求 Looker Studio 納入「Campaign : Click Type」傳回的每個記錄，如果這些記錄包含字串 Headline。這個欄位是兩個維度的串連結果。為了滿足這項要求，Looker Studio 必須重新擷取這些維度，然後套用篩選器。問題是表格中包含比率指標 CTR。Looker Studio 要求前，系統會先計算 Google Ads 比率指標。Looker Studio 無法存取原始資料，也無法針對在連結欄位中只包含字串 Headline 的記錄重新計算新比率。
[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間：2025-09-05 (世界標準時間)。"],[],[],null,["# What does the "Unable to aggregate ratio metrics" error mean?\n\nAt a glance\n-----------\n\nHave you seen this error message?\n\n`Unable to aggregate ratio metrics in the request. Please select another metric.`\n\nThis error means that you've asked Looker Studio to do something with an already [aggregated](/looker/docs/studio/aggregation) ratio metric that it can't do. For example, you've applied a filter based on a calculated field to a chart that contains a ratio metric.\n\nThe solution is to select a non-ratio field in the chart (for example, use **Impressions** instead of **CTR**), or remove or change the filter.\n\nIn depth\n--------\n\nRatio metrics show the relative sizes of two or more values. For example, the Google Ads metric, **Clickthrough rate** ([CTR](https://support.google.com/google-ads/answer/2615875)), is the number of clicks that your ad receives divided by the number of times your ad is shown. In Google Analytics, [**Engagement rate**](https://support.google.com/analytics/answer/12195621) is the percentage of engaged sessions on your website or mobile app, while [**Bounce rate**](https://support.google.com/analytics/answer/12195621) is the opposite of the engagement rate. The bounce rate is the percentage of sessions that were not engaged.\n\nIn Looker Studio, you get the prior error when you filter a chart that includes ratio metrics in a way that requires the product to recalculate the ratios.\n\n### Here are 3 things to help you understand this issue:\n\n1. Data from data sets such as Google Analytics, Google Ads, YouTube, and Google Marketing Platforms products is already aggregated by the time it gets to Looker Studio. For example, when Looker Studio requests a Google Ads metric such as **CTR** (click-through rate), the data is already processed into the appropriate aggregation type.\n\n2. Because of the previous point, calculated field functions are applied to your data post-aggregation. It's not possible (nor would it generally make sense) to go back into the raw data and look at every unique instance of that metric. For example, if you try to create a calculated field with the formula `SUM( `\u003cvar translate=\"no\"\u003eImpressions\u003c/var\u003e` )` in a Google Ads data source, you'll get the following error:\n\n `Re-aggregating metrics is not supported`.\n\n That's because **Impressions** is already aggregated (and its aggregation type, **Auto**, can't be changed).\n | **Note:** This isn't necessarily the case with data sources such as Google Sheets, MySQL, or BigQuery, where you are able to send non-aggregated data to Looker Studio. For example, if you had raw impression data in a Sheet, you could use functions like the SUM function to add it all up and the AVG function to generate the average.\n3. For consistency, all calculated field functions in Looker Studio are available for use with all data source types, even if the underlying system doesn't natively support that function. For example, you can use the CONCAT function to join multiple values in any data source, even if the underlying system doesn't have a CONCAT function of its own. Instead of \"pushing down\" the CONCAT function to the underlying system, Looker Studio requests the data and performs the concatenation itself.\n\nAggregation failure example\n---------------------------\n\nSo what does all that have to do with the `Unable to aggregate ratio metrics` error? This example goes a little deeper with the CONCAT example to help you find out.\n\nSuppose you create a calculated field called **Campaign : Click Type** in a Google Ads data source, using the following formula:\n\n`CONCAT(Campaign, \" : \", Click Type)`\n\nLooker Studio issues queries for **Campaign** and **Click Type** individually, and then performs the concatenation. The results are grouped, so there is no duplication of records.\n\nYou can now use that concatenated field in your charts, and the metrics you include are aggregated properly. For example, we could use **Campaign : Click Type** as the dimension and **CTR** as the ratio metric in a table:\n\nBut now, suppose you apply a filter to show only those records where the value of **Click Type** is `Headline`:\n\nThis will break the chart:\n\nWhy it breaks\n-------------\n\nThe filter asks Looker Studio to include each record returned by the **Campaign : Click Type** if it contains the string `Headline`. That field is a concatenation of two dimensions; to fulfill this request, Looker Studio has to refetch those dimensions, and then apply the filter. The problem is the presence in the table of the ratio metric, **CTR** . Google Ads ratio metrics are computed before Looker Studio requests them. Looker Studio has no way to access the raw data and recompute the new ratios for the records that contain only the string `Headline` in the concatenated field.\n\nThe solution\n------------\n\nThe solution in cases like this depends on the data you are trying to show. In this example, you could either replace the **CTR** metric with a non-ratio metric, such as **Impressions** . Or, instead of filtering on the concatenated **Campaign : Click Type** field, put the filter on the standard **Click Type** field, which would achieve the same result.\n\nThe chart now works:\n\nRelated resources\n-----------------\n\n- [Google Analytics Dimensions \\& Metrics Explorer](https://developers.google.com/analytics/devguides/reporting/core/dimsmets)\n- [Google Ads Glossary](/google-ads/topic/3121777)"]]
