0
The easiest way to get the result would be to use an aggregate function along with a CASE expression to convert the rows of data into columns, but you could also apply the PIVOT function.
select date,
placementname,
campaignid,
impressions,
clicks,
sum(case when activity = 'Mobile Book...