For performance reasons all selections used in Marketing Efforts must be static.  To change the selection from dynamic to static:
  1. Go to Analysis, Query
  2. Find the Ad-hoc query with the same name as the selection
  3. Select Edit Defintion
  4. Select File>Properties
  5. Select the General Tab
  6. Change the selection option from Dynamic to Static
  7. Save the Query