SELECT campaign.id, metrics.video_quartile_100_rate, metrics.video_quartile_75_rate, metrics.video_quartile_50_rate, segments.date FROM campaign WHERE segments.date BETWEEN '2018-01-01' AND '2019-07-01' AND campaign.resource_name = 'xxxx'