What is the Best Way to pull Conversion Numbers and Conversion Values from an AdWords Account?
My goal is to report ROAS numbers in Data Studio -- on an account level. I have about 400 Google Adwords accounts to monitor via Data Studio connectors to Analytics and AdWords. In addition, I need to report the conversion value/conversion cost for the entire web site - including organic and other sources.
Is there a way to parse out the conversion value from Analytics with case statements and a custom metric for each source/medium?
thanks in advance.