linked up sales analytics, do purchase revised and much more efficient
and added a query to precomp tables