Building a custom Piwik plugin to show Amazon affiliate stats

***Summary*** My client (I'm just his PM since I have a dev background) is looking to get insight into how well his 100+ Amazon affiliate sites are generating affiliate commissions. Right now, Piwik shows him data about what's happening on each site, and Amazon shows how many clicks and sales came through from the site. But these are 2 totally separate interfaces. What he wants is one UI to see the most important stats for each site. Creating that is what this project is about. To do that, we want to create a Piwik plugin with a simple UI like Google Adwords’ main screen (see attached screenshot), pulling data from Piwik and his Amazon Associates accounts. When you apply, please let me know your experience with Piwik plugin development and with Amazon APIs. If you don't have any experience with either or both, let me know why you think you'd still be a good fit for the project. ***Features*** Part 1 - Administering List of Sites and Piwik / Amazon accounts 1. List all sites in a table -- Add sites manually with related Amazon affiliate ID (each site can be in 1 of various Amazon Associates accounts) -- Amazon Data import by API once nightly (the exact time doesn't matter, but say 3am Pacific time) -- Piwik data import per API once nightly (the exact time doesn't matter, but say 3am Pacific time) Use a MySQL database to store all the data. The Piwik plugin need only show data for sites in the Piwik instance it's running in. 2. Be able to sort sites in table by different columns Part 2 - Show Analytics (see attached screenshot) 1. In the UI (unlike the screenshot), there should be a dropdown box to select which site's stats to view. That can be in the top right, maybe above the date range selector dropdown. 2. Have a graph to compare website stats visually (compare 2 values to each other) See top graph in attached screenshot. 3. Compare 2 time frames if data available This will work just like in Google Adwords. See top right dropdown box in attached screenshot. 4. Stats to show in Table See bottom part in attached screenshot. Each of these metrics has its own column. From left to right... Stats from Piwik -- Unique visitors -- Visitors Stats from Amazon -- Clicks -- Number of sales -- Conversion rate (Clicks to sales) -- Income Calculate Conversions -- Unique visitors to Clicks -- Unique visitors to Sales -- Unique visitors to Income -- Visits to Clicks -- Visits to Sales -- Visits to Income Any questions? Let me know!