This is for online google adwords campaign manager software.
The intent is for registered subscribers to my Joomla site to be able to add, update, and derive statistics from Adwords campaigns. User flow is as follows:
1. Add Campaign page-Allow user to add data to a campaign SQL table. This table would display campaigns for only the currently logged in joomla user.
2. Update/Delete Campaigns page-Allow user to view and update their campaign data.
3. Add keywords page- Allow user to import a .csv file with keywords and related data to a kewyword SQL table. This file would contain multiple fields including the keyword and related data. These keywords would be assigned to a previously created campaign.
4. Assign Themes page-Allow user to assign "themes" to the keywords. Each keyword would have one theme. Multiple keywords would have the same theme.
5. Ad groups page-Allow user to create two ads for each theme. These ads would be assigned to a single ad group.
6. Export page-Export data into a CSV format for upload into google adwords editor.
7. The SQL tables I envision for this project are: Campaign, Keywords, Ads, Ad Groups, Themes. I will assign what fields need to be in which table and what should be displayed.
I envision this being a flex application with PHP backend. But maybe it would be better to just do in PHP. It needs to be integrated into Joomla as a wrapper or component. (whichever makes most sense)
As a follow-on I will be wanting to integrate importing of clickbank data and statistical reporting as well. This will involve importing csv files from both clickbank and google adwords and updating current table data to display highest performing keywords, ads, etc. I would also like the developer to consider that google adwords API may be used in the future for direct upload/download of data.
I would like your bid on what it would cost to create steps 1-7. Also, would you prefer the interface in flex or php only?
Please respond as soon as possible.