Correct ROAS calculation in Google Sheets pivot tables | Looke Studio by Gaille Reports
When you already have a pivot table in Google Sheets but need to add some calculated metric as CTR, CPC, ROAS, and so on. The best way to do it - use calculated formulas inside the pivot table.
In this video, I explain how it works.
Important moment. When you don't have spaces in your title, you can type just your field name directly. If you have a space symbol, you should add single quotes around your column title. Like this: 'Daily sales'.
For the video I use the document - https://docs.google.com/spreadsheets/...
----------------
Video prepared by Gaille Reports - https://gaillereports.com/
Marketing dashboards template store - https://gaillereports.com/looker-stud...
Looker Studio Online Course - https://gaillereports.com/google-look...
Blog about Looker Studio and Google Sheets - https://gaillereports.com/blog/
Our Telegram group - https://t.me/gaillereports