Issue

The spend data does not match between the source (Snapchat) and destination (warehouse).

Environment

Connector: Snapchat Ads

Resolution

There are two possible reasons you may notice a spend mismatch:

1. The Snapchat API contains the spend in micro-currency and you haven't yet done the conversion.

   From Snapchat's API documentation:

   Micro-currency conversion: 1.00 local currency unit = 1000000 Micro-currency

2. You may need need to account for the timezone difference in your date field:

Example: You are looking at spend data between '2021-04-01' and '2021-04-26' and you have a timezone in Snapchat of UTC + 7.

The correct way to query for these dates:

select sum(spend) from <schema>.<table>
where date between '2021-04-01 07:00:00' and '2021-04-27 06:01:00';