spend_in_micro_dollar Displayed in INT8 Formatlink
Updated 12 days ago
In Pinterest, values for the metric,
spend_in_micro_dollar, are displayed in a DECIMAL format. However, in the destination, values are displayed in INT8 format.
For example, a value of 2089.27 appears as 2089265952 in the destination.
Connector: Pinterest Ads
After loading data to the destination, use an SQL transformation to divide the total by 1000000. For example,
Fivetran syncs raw data from Pinterest and uses minimal preprocessing. When data is pulled from API, it is received in