Build Digital Marketing Dashboard Using Spreadsheets

Job ID: 31987597

Budget: $250 – $750 USD

Hello, I am in need of a talented freelancer to both design and build out a project for me that marries the standardized data of several spreadsheets each representing a separate campaign to create a Dashboard that allows my clients to look at all of the data across the sheets at once. We will need the ability to update with new spreadsheets monthly. I was thinking Google Sheet and Google Data Studio would be the best route to build the project but am open to hear other ideas. I have attached the campaigns of one of my clients as example data. If interested please let me know the estimated ETA for the project as well as your cost. Thanks in advance.

Elements Dashboard Must Have

Boxed KPIs -
Spend (listed as Adv. Spend in sample data)
CPM (listed as Adv. Spend eCPM in sample data)
Impressions Won (listed as Imps. Won in sample data)
Win Rate (listed as Win Rate in sample data)
Video Plays Started ( Listed as Audio Video Starts in sample data and with graph showing 25%, 50%, 75% and 100% complete rates)

Lists -
Channel / App / Domain Names (will show sortable list of placements with KPIs listed exactly as seen in sample data rtb-Domains (8).csv)

Top Performing Ads (Will show sortable list of ads with KPIs listed exactly as seen in sample data rtb-Ads (1).csv)