updated site_view to get aggregates for the last 30 days.