Google Ads Data

I am trying to bring in my CPC, Cost per conversion, Total Spend data etc. for my Google Ads. The columns coming in are way off what they are supposed to be. How do I go about getting the correct data in and then converting those amounts into $ amounts?

Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    Google represents dollar amounts as micros. $1.00 = 1,000,000 micros (or $0.01 = 10,000 micros) so if you want to convert it to cents divid your value by 10000.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • bflavin
    bflavin ⚪️
    edited August 29

    Thanks Grant. So would that be something that I would then have to ETL for each column? Take the number and divide it by 1,000,000?