Find Jobs
Hire Freelancers

Merge Two Excel Files & Recompile Data

$100-300 USD

In Progress
Posted about 7 years ago

$100-300 USD

Paid on delivery
Hello, I have two excel files that are attached to this project. One is basically the stats from an ad network and one is the stats from my ad tracker. I want to match up the data and update the fields to accurately find which advertising spots are profitable or not. I am looking for someone to build me a script or an app where I can select these two files and it will merge the data, perform some basic math calculations and provide me with and output file. I plan on doing this on a daily basis instead of a one time task which is why I want something that can be easily repeated. The two files are [login to view URL] & [login to view URL] Steps > 1) Take the "Source ID" stats from [login to view URL] and merge them with the matching field labeled "Custom Variable 1" in [login to view URL] and simply name it "Source" and I want to take the Cost from [login to view URL] and use that to replace the cost listed on Voluum.csv. We now have one master file. >> Note that both files are NOT in matching order so you must be careful to match up the correct data. For example A5 on [login to view URL] matches up with A2 on [login to view URL] 2) Now the "Impr." field is the amount of impressions we were sent and the Visits field is the amount of impressions we actually received. I want to determine the difference between these two and add a column marked "Bad Hits" to list the difference and "Bad Hits %" to list the difference in a percentage. >> For example if were looking at 46554773 we see 21042 Impr. and 5479 for Visits so the Bad Hits field would show 15,563 and the Bad Hits % field would show 73.9%. Basically I now can easily see how many hits are blocked for each source and what % of traffic is actually received. 3) Now I want to update the profit, CPV and ROI fields now that we have updated data. So Profit is obviously the Revenue minus Cost. CPV (Cost Per View) we will take the cost divided by the visits. and ROI (Return On Investment) is cost divided by revenue expressed as a percentage. 4) Final step is the output CSV file. I only want to export certain fields.. Source, Impr, Bad Hits, Bad Hits %, Visits, Cost, Revenue, Profit, ROI. >> I select users that take the time to write me a short bid instead of copy & paste a standard bid to lots of projects. Also I favor users that can get this done quickly <<<
Project ID: 12977060

About the project

21 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Riverside, United States
4.9
248
Payment method verified
Member since Jan 13, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.