What Is the Currency of the spend_in_micro_dollar Metric, and How Do I Convert It From INT8?

Question

What is the currency of the spend_in_micro_dollar metric, and how do I convert it to a standard amount?

Environment

Connector: Pinterest Ads

Answer

The spend_in_micro_dollar value is reported in your Pinterest Ads account's currency. Despite the name, it is not always in US dollars, and we do not convert it.

We receive this data directly from the Pinterest API in INT8 format. To convert this value to a standard amount, use a SQL transformation to divide the total by 1,000,000. For example:

spend_in_micro_dollar/1000000