Other: Coalesce null event date values with requested_report_date values
Not plannedThis is for the Apple sales_subscriber_detailed table. Apple can return events with null event dates. When this happens, it would be ideal if we can use requested_report_date as the event_date along with a flag indicating that the event_date is using requested_report_date as the value.
Something like
when event_date from Apple is null
event_date = requested_report_date
using_requested_report_date_for_event_date = true
-
Official comment
Hi Spike,
Closing this request out as resync has helped fix the missing data issue. If there are continued issues with the source not providing data please open a support request.
Thanks,
Frank -
Hi Spike,
Thank you for submitting this request. I've asked our team to investigate this further and we will get back to you with updates when we have them.
Thanks,
Frank
Please sign in to leave a comment.
Comments
2 comments