The thing you need is dependent upon millions of things, not to mention just what your definition of "successful" is. For many people, an effective
radio promotion campaign is getting one spin on one college radio station. For other people, it's getting 60 spins/week on each and every Urban station within the top 100 markets, thus charting #1 in Billboard & R&R, which in turn creates a major label deal, which in turn scans 10,000 units each week in the U.S., which results in a 300-date U.S. stadium tour, not forgetting all major publications and Tv covering the artist. So rather than searching for a "successful" radio marketing campaign, look at precisely what you have got to spend on radio, and then decide what you are going to do using these radio results. This is exactly where the "success" comes from.
Below are a few starting points where you can use your radio results:
Traditional (NON-WEB) Syndication: Start by getting consignment in select outlets. One does this through informing the consignment management that "you are presently spinning on WXYZ station " After that you aim to get a basic distribution deal via a small independently owned distributor, which will require more airplay results than "just one radio station." Lastly, you try to get a good-sized P&D distro agreement, that is"successful". To make an impression on those distro people, you will need substantial airplay results. And also keep in mind that no matter how good the radio results are that your promoter gives you, you should take them and employ them properly in making your distribution "successful". Of course , if retail Product sales are the ultimate way of measuring success, then it will be up to your sales rep (who is visiting/calling the shops) to create the sales.
GIGS: Start with showing your bookers the airplay report. Regardless of whether a radio station isn't near the clubs, the simple fact you've got a few spins occurring in other places can help you get booked. On the next phase, start speaking with booking agents... they are going to need larger airplay results to work with... however they have the opportunity to book you into 300-600 seat clubs (with larger bands) which you may never get yourself. Lastly, with commercial regular rotation, you'll be able to work with large agents for getting 1000 to 5000 seat venues, with or even without other acts.
IMPRESSING Others: You need to use your airplay results to attract or/and impress others who may help your own career. Music labels, newspaper publishers, publications, TV/film producers, managers, lawyers, as well as investors are all aware and fully grasp the fundamental value of airplay, and they will see from the airplay results that

1) Your own material is worthwhile; (2) There now could be an audience anticipating your next release; (3) You understand how the radio system works; (4) You agree to work with this product; and most important, (5) You have already purchased a certain level of radio, and therefore anyone who would be supporting you would have to contribute less in order to get you to the next step.