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.