Traffic Acquisition Costs (.csv) to MySQL

Closed

Description

Hi All,

We want to understand our Traffic Acquisition Costs (TAC) on a real time (as close as we can get) basis. We purchase SEM from 6 sources. Of the 6 sources, 2 of 6 have reporting APIs and the other 4 only have reporting dashboards.

We need someone to to the following:

1. Write a script to consume the (2) Reporting APIs, which come in a .csv output and then convert/export in a MySQL database.

2. Setup a cron job that the Reporting API script will pull and update the database every 15 minutes.

3. Write a script that will login to the (4) reporting GUI dashboards. Export to .csv and convert/export to a MySQL database.

4. Setup a cron job that will login to the reporting dashboards every 15 minutes and update the database.

5. Create the MySQL database with the corresponding tables and rows that will have the variables of the traffic acquisition reports.

Variables of the Traffic Acquisition to MySQL with include the following:

Date

Traffic Source

Campaign

Ad

Cost per Click

Total Cost

Country

(a few more variables could be added once we dig in)

Due to Ad networks forcing us to change passwords every 3 months, selected programmer will have to show us how to change the passwords to the accounts in the python scripts.

Also, we'd like to have documentation on how these scripts work so we can easily add new traffic sources in the future.

Must have excellent communication skill. Profit & Loss dashboard experience is a plus and if you do have this experience, please show screenshots.

We will be using [url removed, login to view] to interface the data that is in the MySQL database.

The Freelancer selected must agree to sign a Mutual Non-Disclosure Agreement.

Happy Bidding!

Skills: Database Administration, Engineering, MySQL, Python, Software Architecture

See more: mysql acquisition csv, which country need programmer, want to login freelancer, want to add in freelancer com, using python freelancer, traffic freelancer com, to to freelancer, reporting freelancer, python script freelancer, python programmer freelancer, python freelancer job, purchase skill, need python programmer, mysql job freelancer, mysql documentation, mutual disclosure, job sem freelancer, job as a freelancer programmer, how we can get work on freelancer, how to write reports, how to write on freelancer, how to write as a freelancer, how to work as freelancer, how to work as a python programmer, how to work as a freelancer programmer

Project ID: #4467646

Awarded to:

norberto108vw

Hi, i want to work on this project. I can use some PHP scripts already done. Regards, Norberto

$525 USD in 3 days
(24 Reviews)
5.2

12 freelancers are bidding on average $469 for this job

OutsourceMan

Hello We would like to get opportunity to work with you and offer you the best. Thank you

$360 USD in 25 days
(22 Reviews)
6.2
RRStoyanov

Please check your PMB

$367 USD in 2 days
(23 Reviews)
5.3
suriyant

With my Python experience, I can do it.

$367 USD in 7 days
(30 Reviews)
4.9
eghlima

Hi, We can help.

$750 USD in 14 days
(20 Reviews)
4.9
expcoderxrrg

I can do the work using python, I have many years of experience using python. See PM 4 details

$440 USD in 7 days
(12 Reviews)
4.1
mxicoders

Traffic Acquisition Costs (TAC) , we study website from where you get it, we are very interested

$525 USD in 20 days
(3 Reviews)
4.0
tparis00ap

Does it have to be in Python? Once the database is imported to the database, you can read it in any language you like. I can do all of the requirements in PHP and set up a cron job for that. I'd need to look at the More

$550 USD in 30 days
(4 Reviews)
3.1
rezabakhshandeh

I can handle this.

$275 USD in 4 days
(4 Reviews)
2.6
alethes

Hello, I'm really interested in your project.

$515 USD in 3 days
(2 Reviews)
2.1
JavierV

I can do it in Java, fully automated. Let me help you!

$440 USD in 7 days
(2 Reviews)
1.8
SunnyDev

I have done similar works, please select me. More detail please see PM.

$420 USD in 14 days
(0 Reviews)
0.0
shopnopoka

I have done similar work for a Vehicle Inventory system. http://inventorypro.crawlerwebsolutions.com.

$330 USD in 3 days
(0 Reviews)
0.0
opencvcoder

I can handle this task.

$275 USD in 2 days
(0 Reviews)
0.0
sujanon2it

Kia ora! On2itonline.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional ex More

$1030 USD in 21 days
(0 Reviews)
0.0