What should look like 3.07% CTR pulls in as 304%. I tried removing _perc from CTR and playing around with formatting in sheets but can't get it to show correct CTR format.
the amount coming from Bing is correct but your current formatting in Google Sheets is doing this. Try selecting that column and changing it's formatting from here:
I have this same issue, and the solution provided above did not fix it. Not even sure what the custom number format was supposed to do since the result was identical to the percent format.
Only work around I and fellow user have found is to not import click or conversion rates, rather just create those as columns with own formula and formatting to ensure proper percent format. Custom number format didn't work for me either.