Values for spend_in_micro_dollar Displayed in INT8 Formatlink

Updated 12 days ago

Issuelink

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.

Environmentlink

Connector: Pinterest Ads

Resolutionlink

After loading data to the destination, use an SQL transformation to divide the total by 1000000. For example, spend_in_micro_dollar/1000000.

Causelink

Fivetran syncs raw data from Pinterest and uses minimal preprocessing. When data is pulled from API, it is received in INT8 format.