Add a campaign dropdown filter

As the dashboard is almost complete, the marketing director at your agency reminds you that the initial request asked for the data to be filtered by both the Source and the Campaign Name. You know that all you need to do is modify the current formula to filter for both dropdown menus.

As the formula is already quite complex at this stage, we have formatted it within the cell so that you can see the different elements of the two IF() functions. If you are struggling with the formula, you can review the relevant slide in the Slide Reference tab!

This exercise is part of the course

Marketing Analytics in Google Sheets

View Course

Exercise instructions

In cell H19, add another FILTER() function as an 'else' statement to the inner IF() function in the existing formula (replacing #insert your else statement here!)`.

This FILTER() function should filter the range A1:F29.
Add a REGEXMATCH() function as the first condition, which will filter B1:B29 based on the campaign dropdown H3.
Add another REGEXMATCH() function as the second condition to the FILTER() function in cell H19 to filter A1:A29 based on the source dropdown H2.

Note: Don't change the dropdown values in cells H2 and H3!

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise