1

Snap Ads - can't pull timeseries data into google sheets


T
Tyler Barnett

Getting an error when using the 'Day' Field in Dataslayer+Google Sheets for Snap Ads - Even simple queries fail
Error with timeseries_stats
{'request_status': 'ERROR', 'request_id': '6231370900ff076a6648f9223c0001737e616473617069736300016275696c642d65306139643464612d312d3532342d3000010117', 'debug_message': 'Unsupported Stats Query: End time should be after start time.', 'display_message': 'Request cannot be processed due to validation error', 'error_code': 'E1008'}

A

Activity Newest / Oldest

Avatar

Adela Delso

Hi Tyler, yes the error was the yesterday date range because we put end date as yesterday as well and the Snapchat API didn't allow that. IT is already fix and uploaded. Can you please try again and let us know how it goes?
Thanks!


T

Tyler Barnett

Hey Adela,

I'm trying to pull just for Yesterday as a test of the system. Right now, Dataslayer only has a 'Day' field for timeseries data - I think that might be causing the issue since Snap Ads reporting only has 'Start Time' & 'End Time' as timestamps. (Daily reports have start time at midnight of the current day & end time at midnight of the next day)

Let me know if that makes sense, or if you have any additional questions


Avatar

Adela Delso

Hello Tyler, can you tell us what dates where you trying to pull? The message says "Unsupported Stats Query: End time should be after start time", is it possible you selected an end date that's earlier in time than the start date?
Thanks


Avatar

Adela Delso

Thanks Tyler, the IT team will look at it as soon as possible and we will let you know when there is an update.