Data Types
Every entry in column_metadata carries a type, which tells you how to read the matching value in each row. There are five.
String#
A sequence of text characters, such as an ad unit name, a campaign name, or a device type.
Numeric#
A number. Counting columns such as impressions, conversions, and referrals use this type.
Date#
Date is a string in ISO-8601 or yyyy-mm-dd format. For example, "2023-09-12" represents September 12, 2023.
Money#
Money is a number in USD dollars. It is a decimal number with precision of 2 digits after the decimal point. For example, 5.85 represents $5.85.
Percent#
Percent is a number between 0 and 1 that represents a percentage. For example, .14 represents 14%. Percent columns such as fill_rate and rtr carry the raw ratio; multiply by 100 to display it as a percentage.