Issue with Ad Schedule Dates: Empty values for TikTok & Missing fields for Snapchat

Hello
I am currently setting up reports for my ad campaigns, but I am facing issues retrieving the “Start” and “End” dates for both the TikTok and Snapchat connectors.

1. TikTok Ads Issue:
I have selected the schedule_start_time and schedule_end_time fields in my query. However, the report returns empty values for these columns.

  • I have tested this across different accounts and tried various date ranges, but the columns remain empty.

2. Snapchat Ads Issue:
I am unable to find the correct fields in the schema that represent the Campaign/Ad Start Date and End Date.

  • Could you please clarify which specific field names I should select to see when a Snapchat campaign starts and ends?

Thank you.

Hi dear user,
Sorry for the delay here.

Windsor.ai’s Snapchat connector does not automatically provide scheduled start/end dates from the Snapchat API, it only shows activity data.

Here are all the available fields for Snapchat: Snapchat Ads Field Reference.

As a workaround, you can use MIN(date) and MAX(date) per campaign. But for exact scheduled start/end dates, it won’t always be accurate.

Regards,

Mary from Windsor.ai