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`

.

## Comments

0 comments

Please sign in to leave a comment.