spend data does not match between the source (Snapchat) and destination (warehouse).
Connector: Snapchat Ads
There are two possible reasons you may notice a
The Snapchat API contains the
spendin micro-currency and you haven't yet done the conversion.
Micro-currency conversion: 1.00 local currency unit = 1000000 Micro-currency
- 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';