Mailchimp percent data error

I am having issues when pulling in Mailchimp data that should be listed as a percent. When changing the column field to percent it just screws up the numbers even worse.

Any ideas? It imports into google data studio even worse.