A mask removes a portion of the layer you add it to. So if you want your effect to appear to be behind the footage, you need to remove a portion of the effect, correct? So you need to add a mask to the effect layer, not to the footage. This knowledgebase article
explains in a bit more detail, with illustrations.