Skip to content

    • Charting

    Charting

    Google Ads Data

    Member
    in Charting

    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

    • Coach

      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!**
    • Member
      edited August 2022

      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?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories