When pulling in the Cost field from Google Ads, you’ll see that the cost data comes through as a longer string of numbers than you would expect.

Google Ads's API data gives monetary amounts in micro cents. This means that for any money values, it will need to be divided by 1 million to get the value in dollars and cents. 

There are two ways to solve this issue.

Divide by 1 million

Grow adds a new column and automatically divides by 1 million to automatically convert to standard currency amounts for you.

SQL Solution

You can also divide by 1 million using SQL.

To do this, add a SQL transform to your metric. In the box that pulls up for your SQL, enter the following:

SELECT cost/1000000
FROM report
GROUP BY 1

Hit connect, and you will see the Google Ads cost in a dollar figure.

Questions? Chat in on the site and we'll be happy to help!

Did this answer your question?