Other: Reddit Ads - Report timeezone/ Add in a datetime field
Completed
Currently the campaign data from Reddit Ads is setup to use the report from the timezone the account is associated with. There doesn't seem to be a direct way in updating the data to a different timezone.
The campaign_report table (ingested through Fivetran) has a date column. If Fivetran could update the date column to a timestamp then we can easily transform the data to a different timezone.
This request is to have Fivetran ingest a timestamp column for campaigns.
-
Official comment
Hi,
Luke from the Product team here. Thank you for submitting the request!
We support setting the timezone for custom reports. So, to accomplish what you're looking for, you could create a new custom report that includes the same fields available in our prebuilt reports. When creating the report, you can specify whatever timezone you need.
I think this solution is better than representing date as a timestamp because the data in our campaign reports are metrics aggregated by the day. It isn't possible to get the correct aggregation for a day in a different timezone without specifying the timezone in the original request.Hope this helps.
Cheers,
Luke
Please sign in to leave a comment.
Comments
1 comment