Write a SQL query using window functions to rank campaigns by performance within each channel for Snagajob.
