SELECT 
date,
demand_revenue,
demand_revenue_marketplace,
demand_revenue_direct,
auctions_chocolate_logs,
auctions_chocolate_materialised,
impressions_chocolate_logs,
impressions_chocolate_materialised,
auctions_vdopia_logs,
auctions_vdopia_materialised,
impressions_vdopia_logs,
impressions_vdopia_materialised,

FROM [reporting_consistency_check.stats_daily_<PREV_DATE..%Y%m%d>] 

