Building a custom Piwik plugin to show Amazon affiliate stats

Cerrado Publicado Jun 30, 2014 Pagado a la entrega
Cerrado Pagado a la entrega

***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!

Amazon Web Services Analytics MySQL PHP Arquitectura de software

Nº del proyecto: #6131762

Sobre el proyecto

11 propuestas Proyecto remoto Activo Aug 6, 2014

11 freelancers están ofertando un promedio de $1407 por este trabajo

mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$1030 USD en 30 días
(373 comentarios)
8.1
prashushinde9

Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu Más

$1546 USD en 40 días
(54 comentarios)
7.0
techwelfare

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..

$1184 USD en 20 días
(140 comentarios)
6.9
bistanil98

have gone through with the requirement and we can start this project now. I want to introduce our self, we are a group of freelancers we have 11 year of experience in web application development and design, we w Más

$1000 USD en 20 días
(38 comentarios)
6.8