posted by admin on April 12, 2009 11:26 PM

The past two weeks TrackVia has been promoting the new MediaOnTwitter database in partnership with @melissahourigan, @PRSarahEvans, @skydiver and @briansolis. Later today, we will announce the winner of the Kindle 2.

Today’s post describes in four steps how TrackVia’s online database is powering MediaOnTwitter.

1. To begin with, a custom database was created with fields for twitter ID, Media Outlet, beat, etc. A calculated URL field was also created to make a hyperlink so individuals viewing the list only have to click on the follow me field to follow desired media contacts.

2. Next, a website form was easily created within TrackVia to collect submissions from the media based on the custom database created. Required fields and a custom confirmation page were created to ensure all information was collected and submitters were notified that their submissions had been received.

3. Web form submissions automatically populate in the database making it easy for the editorial team to review and approve submissions for posting. The ability to edit multiple database records at once within TrackVia makes it easy to make edits to multiple records at a time.

4. Through the use of TrackVia’s powerful filtering capabilities, views (a comprehensive list and reports by country) have been created that display the Media contacts and their twitter IDs on a published website report. These reports are dynamically updated when new submissions are approved.

TrackVia is donating the use of its online database to continue powering MediaOnTwitter at the conclusion of this contest. Between now and April 20th, you can view the submissions at the following MediaOnTwitter page. After April 20, 2009, MediaOnTwitter’s new submissions can be submitted and the media contacts lists can be viewed at prsarahevans and mediaontwitter.com.

Contact me if you’d like to hear more about how TrackVia can help power your data tracking needs.