Create a Facebook ads report dashboard with Google sheets

Offered By
Coursera Project Network
In this Guided Project, you will:

Access Google spreadsheets and apply important basics.

Build dashboard tables and add calculated formulas.

Add charts, drop down menus and color scaling.

Clock1 Hour
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will create a Facebook ads report using Google sheets. You will be able to track all your campaigns at the beginning and end of the year. Whether you need to track your ads, measure the money spent, calculate the number of impressions and create a link between them all to better allocate your resources. This project will provide you with the basic steps to do so. Since reports allow you to create a plan for your future and set goals, it ensures that you will always have enough money for the campaigns that are important for you. Following a Facebook report will also keep you out of confusion or help you work your way out of spending money on a failing campaign. Throughout the project you will be able to acquire the basic Google Sheets skills that are needed to organize all your campaigns. Along the way, you will be applying and practicing the basic features of spreadsheets such as formatting and calculations, as well as creating tables to use in your dashboard that are efficient and resourceful. This Facebook ads report will help you increase the productivity of your campaigns and better allocate your resources in your job. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop


Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Access Google spreadsheets and apply important basics.

  2. Build dashboard tables and add calculated formulas.

  3. Add spark lines, averages and total as well as add charts. 

  4. Apply color scaling using conditional formatting.

  5. Add a drop down menu to filter your campaigns using data validation.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.