Data Studio: How to Get Correct ROAS Using Google Sheets

Why is ROAS calculated as the SUM rather than Revenue/Spend? You'll need to use a modified calculated field to get this calculation right! ► Catch the entire Data Studio for Paid Search playlist here: https://www.youtube.com/playlist?list=PLFKQFU6BH6wL-V8a0Xipu3PsMHm_vf76g ► Subscribe to our channel here: https://www.youtube.com/channel/UC9uS9ihdfz1rgKEu_93vJoQ?sub_confirmation=1 ----- Paid Search Magic is a paid media agency run by Amy Hebdon and James Hebdon (yes, we’re married, and we work together). We get amazing returns for our clients, and we teach other digital marketers how to run ads for better results. Follow Paid Search Magic online here: Website: http://paidsearchmagic.com/ Twitter (Amy): https://twitter.com/amyppc Twitter (James): https://twitter.com/jphebdon Free Facebook group for marketers: https://www.facebook.com/groups/googleadsdigitalmarketers/ Podcast: http://paidsearchmagic.com/category/podcast/ LinkedIn (Amy): https://www.linkedin.com/in/amyhebdon/ LinkedIn (James): https://www.linkedin.com/in/jameshebdon/ Facebook: https://www.facebook.com/paidsearchmagic