Have been dealing with Snapchat API for the past few days, and boy is that a terrible API to work with…
When querying the Campaign stats endpoint and want to get stats on a day level, you need to specify start_date and end_date. That makes sense. It also specifies date format should follow ISO 8601. That is the only sane date format in the world, so great!
I could take you through my frustrating journey of trial and error, talk about how stupid the date handling is, but let’s skip that part and get straight to the solution.
Use ISO 8601 date/time format INCLUDING time zone information (and url encode your values)
That format looks like this, with date, time and timezone.
You need to URL encode it though, or else…
The time zone information HAS TO MATCH the time zone of the ad account, NOT the zone you are in!
How do you find that information?
SnapcHAt Business Interface
Using the Snapchat business interface, go to:
Settings > Ad Accounts > Select Ad Account
List all organizations for an account:
List all ad accounts for an organization:
Convert that timezone value to a UTC offset.
Whether you get it from API or interface, you need to take that timezone string and look it up somewhere to get the UTC offset (-08:00 in this case).
Also be aware that Daylight Saving Time (needs to die in a fire, but that’s for another day) might affect the current timezone! So if you use the right timezone and STILL run into problems, try considering DST.