The return value of cost or money fields

As documented by Google, cost or money fields are returned in micro currency units (micros). Divide micros by 1,000,000 to get the actual cost. For example, $1.23 will come back as 1230000 (1.23 x 1,000,000).

When dividing two integers (123000 and 1000000), you should multiply them by 1.00 to turn the result into a decimal number. So instead of calculating cost/1000000, you should do (cost*1.00)/1000000.

Lastly, when filtering on cost fields, provide the value in micros. For example, to return rows where AverageCpc is greater than $1, use WHERE AverageCpc > 1000000.