I need someone to develop a spreadsheet to be used for digital marketing planning for an agency.
You need to have worked in an agency to understand what I need here. A strong understanding on online media planning, budgeting and buying is crucial.
The said document should have all the formulas functioning and a note should be attached detailing how the spreadsheet works.
This application breaks it all out very well - http://ift.tt/1FoDl78
This excel sheet should cover all forms of digital media advertising all properly laid out into sections - Social, search, display, tenancies, custom websites, mobile, cpc,cpm, cpv,cpa ...the full thing . All formulas must be included.
I should be able to define things like impressions, CTRs, Views e.t.c and the sheet will work it's magic.
I should be able to take a client's budget and input it into a field and share it in percentages into the various elements and the whole system populates with the right figures
Make provision for every element to be marked up so, I should be able to see profitability of each element and total profitability in another excel sheet.
The excel sheet must look great as this is what will be going directly to client. A second excel sheet with the exact same entries should also show profitability.
Must have space for client credentials and you know what..... :-)
Everything should be dynamic to reduce chances of human error but the I should be able to manually make edits when I have to without messing up the formula.
If you work in a media planning agency you probably already have what I want, simplify it, make it easy to send to client and to explain and make sure it's automated.
The experience digital media buying will notice that I have missed out a thing or two, you should be able to add this and other value to project.
There should be a provision for a percentage of total cost as a management fee
Goodluck
Posted On: March 22, 2015 11:02 UTC
ID: 205303736
Category: >
Skills: Array, Array, Array, Array, Array, Array, Array
Country: Nigeria
click to apply
from Online Job Search
You need to have worked in an agency to understand what I need here. A strong understanding on online media planning, budgeting and buying is crucial.
The said document should have all the formulas functioning and a note should be attached detailing how the spreadsheet works.
This application breaks it all out very well - http://ift.tt/1FoDl78
This excel sheet should cover all forms of digital media advertising all properly laid out into sections - Social, search, display, tenancies, custom websites, mobile, cpc,cpm, cpv,cpa ...the full thing . All formulas must be included.
I should be able to define things like impressions, CTRs, Views e.t.c and the sheet will work it's magic.
I should be able to take a client's budget and input it into a field and share it in percentages into the various elements and the whole system populates with the right figures
Make provision for every element to be marked up so, I should be able to see profitability of each element and total profitability in another excel sheet.
The excel sheet must look great as this is what will be going directly to client. A second excel sheet with the exact same entries should also show profitability.
Must have space for client credentials and you know what..... :-)
Everything should be dynamic to reduce chances of human error but the I should be able to manually make edits when I have to without messing up the formula.
If you work in a media planning agency you probably already have what I want, simplify it, make it easy to send to client and to explain and make sure it's automated.
The experience digital media buying will notice that I have missed out a thing or two, you should be able to add this and other value to project.
There should be a provision for a percentage of total cost as a management fee
Goodluck
Posted On: March 22, 2015 11:02 UTC
ID: 205303736
Category: >
Skills: Array, Array, Array, Array, Array, Array, Array
Country: Nigeria
click to apply
from Online Job Search
No comments:
Post a Comment