Reddit Ads Spend Data Appears Incorrect in Destination

Issue

Reddit Ads campaign spend data in the destination doesn't match the amount shown in Reddit Ads. For example, the platform displays £10.24, while the destination displays 10,504,894.

Environment

Connector: Reddit Ads

Resolution

To resolve this issue, convert the raw API value to the standard currency format:

1. Divide the value by 1,000,000. For example, 10,504,894 micros equals £10.50 when rounded.
2. If a minor discrepancy remains, such as £10.50 instead of £10.24, compare the time zones used by your destination and the Reddit Ads platform. The Reddit Ads API reports data in UTC/GMT. A different platform time zone may cause discrepancies when data crosses day boundaries.
3. Adjust your queries and platform settings so that they use the same time zone.

For more information, see the Reddit Ads setup guide and the Reddit Ads data model.

Cause

This issue occurs because the Reddit Ads API returns financial values in micros, or millionths of a currency unit. Minor discrepancies after conversion may result from time zone differences between the API and the Reddit Ads platform.