Magento + Google Analytics : change product's position based on GA

CLOSED
Bids
35
Avg Bid (USD)
$765
Project Budget (USD)
$250 - $750

Project Description:
Hello, I need someone with good experience in Magento to develop a service to change the sort order in which the products are listed in the category , based on access recorded by Google Analytics and sales of that product .

GOOGLE ANALYTICS
When managing a category in Magento , I can set for each product which position he will appear in that category ( 1st , 2nd ... 50th , etc. ) , but setting it manually is not the best way , the idea is to place the more interesting products first , and so the demand is to create a service to once a week connect to the base of Google Analytics (via API ) , and order the products according to the amount of access they had in the past X days ( configurable parameter ) .

That is, given the initial scenario:
Product A = 0 position
Product B = 0 position
Product C = 0 position

Situation A :
Product B = position 1 ( 150 views)
Product C = position 2 ( 100 views)
Product A = position 3 ( 50 views)

SALES
Sales should also influence this position , then we must consider that each sale (use Magento’s own database) counts as X visits (configurable parameter) to that product also. The sales period to be considered should be a different parameter than the one from Google Analytics, so I may be able to set for instance 90 days of visits and 180 days of sales.

Situation B ( 1 sale = 100 visits ) :
Product C = position 1 ( 100 views + 1 sale)
Product B = position 2 ( 150 views)
Product A = position 3 ( 50 views)

MANUAL INFLUENCE
One last way to influence the position is via manual manipulation . You must create a new attribute for the products , where I may be able to insert positive or negative value , which will serve as an accounting more visits. The idea is to promote or demote products.

Situation C ( 1 sales = 100 visits ) :
Product A = position 1 ( 50 + 500 visits manually )
Product C = position 2 ( 100 views + 1 sale)
Product B = position 3 ( 150 views)


REMARKS
1 - Cancelled sales should not be counted
2 - Should NOT be created a new field for position , should use the existing field of Magento, the service should only change the value of this field.
3 - Every time service runs, must be generated a log file saying that everything ran ok or if there was an error, and which error. And in case of error send an email too.
4 - The service must be scheduled via cron job , but there should also be a manual way to execute it, can be either by an specific URL or a button in the Admin .
5 - The developer should implement it in the test server , and once validated , apply on the production server.

Skills required:
Google Analytics, Magento, MySQL, PHP
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 670
in 12 days
$ 750
in 18 days
$ 680
in 20 days
$ 740
in 10 days
$ 1263
in 21 days
$ 618
in 10 days
$ 515
in 10 days
$ 3789
in 30 days
$ 840
in 21 days
$ 789
in 12 days