In Progress

Macro script with data extraction to spreadsheet.

This project is for the creation of a macro script that will tally our previous day’s revenues across several ad networks, and output it into a spreadsheet. The output could be in a Google Apps’ spreadsheet if you are using browser-based macros (ie. iMacro), which we can then copy/paste into Microsoft Excel daily. That’s not a problem.

- The macro needs to be flexible and easy to change, so we can easily add/remove ad networks.

- Several networks may use the same platform (for example Appnexus). So in this case, we shouldn’t need to re-record the steps for the macro again. In the spreadsheet, we should be able to specify the platform, and the macro script should load the appropriate script accordingly.

- Ideally, the macro should rely on the login credentials stored in Firefox to login so that the spreadsheet does not contain any privilege information. This is easy to implement since when the username provided for each network is input into the login screen, Firefox can automatically populate the password from the locally stored credentials.

- The macro should “wait” for the revenue to load. For example, after running yesterday’s report, the reporting interface may say something like “Loading…” while the revenue is being calculated. Only after the revenue is displayed would the macro copy/paste that information into an Excel. If the revenue is not displayed as expected after X minutes (ie. 1 minute), it would timeout, write “ERROR” where it would usually paste the revenue information, and move on to the next network.

Project Summary:

- Here is what the sample spreadsheet will look like: [url removed, login to view]

- The “revenue” information is to be extracted from each ad network and populated into the spreadsheet daily (could be a Google Apps spreadsheet or Microsoft Excel)

- In this example, there is a custom macro script for Adsense, Vibrant and ValueClick (“MacroScript” column)

- For Adconion, Burst and CPX – who are using Appnexus, there is a single macro script (although the domains may be different)

- When the username is entered into Firefox, since the login credentials are saved in the browser, it will populate the password automatically. Where Firefox struggles to populate the password, the spreadsheet would list it and the macro should be able to copy/paste it into the website (as in the ValueClick example)

- After logging into each ad network’s website, and selecting the fields to load yesterday’s revenues, it will wait for the revenue figure to be loaded before copying/pasting it into the spreadsheet (ignoring things like “Loading…”) < [this is what I struggled with; the rest of the project should be easy!]

- If the revenue figure is not loaded after X minutes (ie. 1 minute), the appropriate revenue column for the network would be populated with “ERROR” for manual review

- After each revenue figure is populated or timed out, the macro continues to the next network in the spreadsheet (ie. Adsense, then Vibrant, then ValueClick) – until it hits the end of the spreadsheet and then finishes

- The revenue column should be a standard format – so ignore things like the “$” sign, have 2 decimal places, etc.

For anyone familiar with macros, this should be a relatively easy project. I’m not too experienced with macros, and I can achieve most of the above myself. The part I struggle with is getting the macro to ignore the “Loading…” part before extracting yesterday’s revenue figure after it loads.

Please post your bid, and if you feel the project should be below/above the stated range, feel free to bid accordingly. Also note that part of the project is explaining to me how I can record new macros for additional networks and have it input the previous day’s revenue into the spreadsheet.

Thank you.

Skills: Anything Goes, Data Entry, Excel, Visual Basic, Visual Basic for Apps

See more: write report to me, what is manual data entry, what is an apps script, using google spreadsheet, use script in google spreadsheet, use case creation, steps to write a report, spreadsheet script google, spreadsheet script, script google spreadsheet, sample google apps, problem with error, need of tally, microsoft excel spreadsheet free, microsoft ad network, how to write report format, how to write a thank you note, how to write a summary report, how to write ad copy, google spreadsheet example, google login script, google apps spreadsheet, google apps script spreadsheet, getting hits on your website, getting hits on website

About the Employer:
( 19 reviews ) Toronto, Canada

Project ID: #4654768

Awarded to:

muthumuni

Hi, It is just another VBA script for me. feel much simple job so. please see INBOX for more details --- >>>

$250 USD in 3 days
(12 Reviews)
3.8

17 freelancers are bidding on average $478 for this job

sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$400 USD in 7 days
(205 Reviews)
6.7
srinichal

I can deliver the script as per the requirement

$526 USD in 6 days
(40 Reviews)
5.8
Viqtor

Hi, can help.

$388 USD in 2 days
(3 Reviews)
3.4
rajkavikumar

I have created many web based tools in VBA, Please check PMB for details.

$388 USD in 10 days
(3 Reviews)
3.1
sudewa

Hi, Seems like your requirements are too complex for a macro. How about a C# standalone application to cater for your requirements. If you are not happy with that approach we can go with the excel macro. Thank More

$755 USD in 20 days
(2 Reviews)
2.9
MaxwellZone

Hello, Please see the PM. Thanks

$388 USD in 3 days
(3 Reviews)
2.4
JFCosta

I read your project requirements and i'm able to do it.

$250 USD in 7 days
(0 Reviews)
0.0
zkutch

Hello. More 20 years programming experience.

$444 USD in 7 days
(0 Reviews)
0.0
mattlong447

I have several years of experience writing excel macros as a mechanical engineer, and would like the opportunity to kickstart my freelancer career with your project.

$500 USD in 5 days
(0 Reviews)
0.0
Boostercoder

sir i am too much excited for this... i think i will do this.

$555 USD in 10 days
(0 Reviews)
0.0
albanirneves

I really can do your job. I have extense experience with this time job. Waiting your contact. Albanir

$388 USD in 3 days
(0 Reviews)
0.0
expertzsol

Hi, i have gone through your requirements in detail and already have worked on a similar project and can deliver this as u have mentioned we have studied all the requirements and can deliver the same to u . we hav More

$578 USD in 21 days
(0 Reviews)
0.0
nova05

I will do my very best.

$555 USD in 3 days
(0 Reviews)
0.0
bharatbhatia9

I am the expert of excel vba and can easily finish this tasks.

$444 USD in 3 days
(0 Reviews)
0.0
RCKK

This is regular work for me I do this with excel and google

$555 USD in 3 days
(0 Reviews)
0.0
vkiranbtech

Hi cencina, i have 2+ years experience in working on VBA,EXCEL in one of the major telecom company , i can deliver u r project in time. consider my request

$777 USD in 3 days
(0 Reviews)
0.0
chandubmore

Hi, I am a MCM (Master of Computer Management) post graduate having 3+2 years of degree. I have total 9 years of experience. I have done my certification in Microsoft Office Specialist (MOS) in Microsoft Office vers More

$555 USD in 3 days
(0 Reviews)
0.0