Level 3QUERYPractice, 4 min

QUERY another tab, with or and parentheses

The task

The data lives on the Campaigns tab. On Summary, in A1, list the paid campaigns (Paid Search or Paid Social) that brought in more than $5,000, biggest first: =QUERY(Campaigns!A1:E13, "select A, B, E where (B = 'Paid Search' or B = 'Paid Social') and E > 5000 order by E desc")

The data, 2 tabs

The starting sheet. Cells outlined in green are where your formulas go.

Summary tab
	A
1
2
3
4
5
6
7
8
9
10

Campaigns tab
	A	B	C	D	E
1	Campaign	Channel	Spend	Leads	Revenue
2	Brand terms	Paid Search	$2,400	96	$14,400
3	Competitor terms	Paid Search	$3,100	41	$2,950
4	Product terms	Paid Search	$5,200	88	$17,600
5	Prospecting video	Paid Social	$4,600	52	$3,980
6	Lookalike 1%	Paid Social	$3,800	61	$9,120
7	Retargeting	Paid Social	$1,900	47	$8,550
8	Webinar promo	Email	$600	73	$4,380
9	Newsletter	Email	$250	22	$1,750
10	Win-back	Email	$400	18	$3,240
11	Display remarketing	Display	$1,700	23	$2,890
12	Contextual	Display	$2,200	14	$1,430
13	YouTube	Display	$3,300	19	$2,310