Flash in the pan

When something was rather promising in the beginning but appeared to be a failure

Examples

The advertising campaign appeared to be a flash in the pan. We’ve spent thousands of dollars but earned less than a half of this sum.