De-duplication and dealing with updates over a long time horizon
As a result of updated records for 5/19, a new 5/19 row for the Sponsored Brand campaign came in… Lastly, if you are not comfortable doing this in a BI tool, another option is creating a custom view… A view looks like a table but runs custom SQL behind the scenes