Decimal point and CTR

For importing my Adwords data into Google Sheets, I can't get the CTR column to work well with the decimal place. 

Example: What should look like 4.22% ends up showing 422.00% or if I haven't styled the columns yet, 4.22. 

Is there a way to have the decimal be in the right place?

  • Hi Ryan,

    it seems that your Google Sheet is formatted in different way than Supermetrics pulls the data in. Try changing the format between , and . in the row / cells.


    -Supermetrics Team

Login to post a comment