Hi all, We have recently joined the wonderful AdWords to BigQuery datatransfer beta. Please forgive me, if my question is trivial to you. I'm not an experienced data scientist :).
I've used the table: *AccountStats* to visualise our *Cost, Conversion Value* *and ROI* in DataStudio. I am using *Date* as dimension and offer the possibility to filter on *AdNetworkType1*. I visualised this in Datastudio and checked the total cost for the 8th of May with the AdWords UI and that matches perfectly. Great! The next thing that I would like to do: is show the same visualisation but offer the dimension *CountryCriteriaId* as filter. I've checked the AdWords Transformation reference guide <https://cloud.google.com/bigquery/docs/adwords-transformation> and concluded that *Geo Performance Report: GeoStats table* would be best suitable. I've duplicated the table in DataStudio and replaced the *AccountStats *from BQ with *GeoStats.* Unfortunately the result shows highly inflated values. For example: the 8th of May 2018 shows a cost of almost x5 higher than our actual cost that day. I've checked the raw data in BQ and that shows the same results (although not corrected yet with /1000000). My question is: how does it come that the summed value based on group by date is over 5x higher in table *GeoStats *compared to table *AccountStats* ? Any help is highly appreciated. Kind regards, Pim Coffeng -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/72c915c7-00a0-499f-acf7-33607a6f320a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
