Question
While configuring, the Facebook Ad Insights connector only allows daily, weekly, and monthly aggregation. How can I choose hourly aggregation?
Environment
Connector: Facebook Ad Insights Setup Form
Answer
Facebook does not support aggregation by the hour. As a result, hourly aggregation of data is not possible.
Cause
Facebook API's time_range
field uses a timestamp format that does not include hours in it.