# YouTube Facts Asset

YouTube Facts flow checks if required staging tables have been populated by 
[youtube_bulk_reports_facts_asset](../youtube_bulk_reports_facts_asset/Readme.md) 
and [youtube_bulk_reports_facts_video](../youtube_bulk_reports_facts_video/Readme.md) flows and 
populates youtube fact tables. **These tables power Insights**.

There are 4 table - a combination of asset/video and analytics/demographics data. 

It's been done this way because otherwise it's impossible to join the data without fanning out. 
More about this flow and reasoning why it's been done could be found here: 
[Tech Design for YouTube Fact Table](https://docs.google.com/document/d/1YwGr0U1xUqr30Q9R3gy1ICwv3wAeM93wuq28qY4LTCE/edit#heading=h.3cxfogq8xpsi)


**Important!**: YT updates reports during one month after publishing them. So the flow configured to not 
only load the most recent date available, but also to reload days from a week ago ± a few days and a month 
ago ± a few days. This way we can have fresh data and minimize discrepancy between YT Studio and Insights.