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
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.