When building Looker Stuio dashboards, sometimes metrics such as CTR, CPC, CPM, CPA, ROAS, and Frequency don't show correctly.
These metrics have something in common: they're calculated metrics based on other metrics.
CTR: clicks/impressions
CPC: ad spend/clicks
CPM: Ad spend/impressions (*1000)
CPA: ad spend/conversions
ROAS: Revenue/ad spend
Sometimes, Looker Studio "aggregates these data incorrectly, ending up in larger values than expected.
As you can s
To fix them, create custom metrics inside your Google Looker Studio reports by using the function SUM () to aggregate your data correctly.
To avoid creating custom fields for every chart, you can consider creating custom fields at a data source level.
If you created custom fields from the data source, they'll show by default in all your charts, as the default fields from the connector.
