Dello Russo Laser Vision - dellorusso.com

Advertising Summary in Google Sheets - Urgent

Assigned to
Jonnamae Jumawan, Medstar Jonnamae J.
Notes
Hi J - we need to prepare a summary report for the Google Ads, Facebook and BING reports for Dello Russo. They are asking for it prior to Monday. Some of the months have been done already. The sheet is here> Only some months we had Bing and Facebook runnings so you will not need to include those in some of the months

See if you can make the reports look prettier than they are. Erase unused cells, etc.

It looks like you will need to do the following months:
2018 -2019 Summary (Chris Handled This)
July 2019
May 2019
June 2018 (there will only a few days on this report)
July 2018
August 2018
Sep 2018
Dec 2018

We only ran Bing from Dec 2018 to Early Feb 2019
We only Ran Facebook ads (Joseph Dello Russo) in 2018


I also would like to download all the monthly reports Shane sends to my mediapong@gmail.com and chris@medstarmedia.com and upload them to a Google Drive file you create at Mediapong@gmail.com - and if you have time upload the weekly reports in a separate file. I have created the area to upload here. This way I can share it with the client.

You can access Google Ads through my account, Facebook ads through my account and Bing Access Below:

https://bingads.microsoft.com/ | dellorussoweb@gmail.com | Eye2018#$


Here is a video with some instructions.

https://drive.google.com/file/d/1l7DuOOGtfrZUaVIWRE4sp0KHUrzth4UO/view

Sorry I go back and forth on the video and change my mind. You are super smart you will see what I am trying to do. 

Comments & Events

Chris Zelig, Medstar
I took care of the 2018 - 2019 Summary I am still working. 
Chris Zelig, Medstar
on some of the other tabs as well
Chris Zelig, Medstar
I will do July 2019 as well - just do the following and and also make the reports look pretty, same font size, delete unused cells, etc. So it looks professional 

May 2019
June 2018 (there will only a few days on this report)
July 2018
August 2018
Sep 2018 
Dec 2018
Jonnamae Jumawan, Medstar
OK Sir. I will do this now Sir.
Chris Zelig, Medstar
Can you access both mediapong and medstar so you can download the monthly reports shane sends their is a google ads and Facebook report once a month he sends. most will be in mediapong the other more recent ones will be in medstar
Jonnamae Jumawan, Medstar
I only have access for medstar Sir. Is it different report from this Sir?
Jonnamae Jumawan, Medstar
I'm already logged in Sir. OK Sir, I will check out the other reports.

Thank you Sir.
Jonnamae Jumawan, Medstar
Sir, where exactly will I put the FB and Bing ads data?

is it next to Notes?
Jonnamae Jumawan, Medstar
Sir, can I ask for bing's confirmation code?

and

here is what I did for Dec. 2018 Sir:
Chris Zelig, Medstar
J - sorry I went to bed. You can see from other reports I placed the Bing Info and the Facebook into in a similar table below the google ads table and then added them all up. Did you find the pdf reports in my email? Do you want to try to login to bing again and get it to work. 
Jonnamae Jumawan, Medstar
Its Ok Sir. Yes, I'm still waiting for the code Sir. I checked the pdf but it didn't say if its a Bing or not so I'm not sure where exactly is Sir.
Chris Zelig, Medstar
Jonnamae Jumawan, Medstar Jonnamae - Your dec report looks good. I updated it so it has the correct format. I just noticed Facebook ads started in August so you will need to do Facebook breakdown in August 2018, 
June 2018 - no ads were running so I deleted that tab
July 2018 - is complete very little traffic
Aug 2018 - need to add Facebook and summary at top
Sep 2018 - add facebook and complete summary at top
Oct 2018 - complete summary at top 
Nov - 2018 - complete. just clean up look
Dec 2018 - I will handle Bing, Please add Facebook and top summary, I had to redo your version so it was uniform
Jan 2019 - complete
Feb 2019 - Complete
Chris Zelig, Medstar
The PDF's are in my emails can you find them they are from shane.quast@gmail.com or shane@wearesqdm.com - finish the report first and then upload the monthly reports. Do not worry about the weekly reports. 
Chris Zelig, Medstar
I do actually want you to complete the bing reports I just sent you the code 
Chris Zelig, Medstar
If you need me to resned it let me know on whats app
Chris Zelig, Medstar
A few months still need the Bing info updated 
Dec 2018 needs bing info and summary updated
Feb 2018 - needs bing info and summary updated
Jan 2018 looks good but double check, 

Please double-check the totals of all months to make sure I did not screw up.