I would like to have the PPC Tracking software finished up. This includes:
Update the AdWords API
Improve the MySQL so it is more scalable
Integrate with the AdCenter API
Additional Fields in the clicks table:
1. Add a few more tracking codes from the URL to the clicks table. (all of our URLs are tagged as you requested before. We won't need any changes to the tool that you built to retag all of the URLs). This is what I would want added:
From URL - ad_tid, ad_grp, trk_place, trk_target
2. Allow us to pass another tracking variable into the clicks table. We want to pass a variable from the landing page so we know which version of it the visitor saw.
From Page - lp_id
I would also like some additional documentation so I can use and maintain this.