You need to use the Position, Rotation and Scale controls provided within the effect rather than the Inspector's built-in Transform controls which won't activate the trail effect.
To install the effect unzip the attachment and copy the entire folder to your User/Movies/Motion Templates/Effects folder.