Getting count(column) as well as a specific row in each group
For the (column2 where column2 contains 'page1') expression, try something like:

MAX(CASE WHEN Column2 LIKE '%page1%' THEN Column2 END)


...but I'm not sure what you expect if you have multiple rows with "page1" per column1.