---
title: How do I manually update the EOS Sheet for Dental Marketing?
description: This SOP provides instructions on how to effectively modify and maintain the EOS (Entrepreneurial Operating System) Sheet for DentalMarketing.com.
---

[Skip to content](https://grow.dentalmarketing.com/university/how-do-i-update-the-eos-sheet-for-dentalmarketing.com#main-content)

English

Show submenu for translations

[Customer portal](https://grow.dentalmarketing.com/tickets-view?hsLang=en)

![DentalMarketing-Logo2-White copy-1.png\]](https://grow.dentalmarketing.com/hs-fs/hubfs/DentalMarketing-Logo2-White%20copy-1.png?height=40&name=DentalMarketing-Logo2-White%20copy-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://grow.dentalmarketing.com/tickets-view)
- [Don't see the SOP you're looking for? Submit your suggestion here.](https://share.hsforms.com/1Fk5_GHeGTTqeJyg4BwR0CAdihez)

[Don't see the SOP you're looking for? Submit your suggestion here.](https://share.hsforms.com/1Fk5_GHeGTTqeJyg4BwR0CAdihez)

 Welcome! What article can we help you find?

- There are no suggestions because the search field is empty.

1. [Internal](https://grow.dentalmarketing.com/university?hsLang=en)
2. [Paid Media SOPs](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en)
3. [Account Management & Updates](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#account-management-updates)

# How do I manually update the EOS Sheet for Dental Marketing?

## This SOP provides instructions on how to effectively modify and maintain the EOS (Entrepreneurial Operating System) Sheet for DentalMarketing.com.

 

**Google Sheet:** 

https://docs.google.com/spreadsheets/d/1aiOrmiFIBp197fV9aClmiSNIsmixgRA8Sny4pM6\_0Ow/edit?gid=1903798466#gid=1903798466

 

**Note: The EOS Sheet should be updated every Tuesday**

- Open up the EOS sheet and add a column for the new date range (Mon-Sun)
- In Google Ads, open the Dental Marketing MCC overview \> Select ‘Accounts’ \> ‘Performance’ 
    - Add a filter to include accounts that have a Cost \> $0
    - Adjust your date range to match the EOS sheet
    - Pull the total Cost per Lead (i.e. Cost/Conv), Conversion Rate, and Conversions and update in the EOS sheet accordingly
    - Pull the ‘Filtered Total’ of accounts and update the EOS sheet accordingly
- Open up the Dental Marketing business manager in FB, then go to Ads Reporting \> MCC Report - Leah (<https://fb.me/2Hh3fBjzxZuuUT4>[https://fb.me/2Hh3fBjzxZuuUT4](https://fb.me/2Hh3fBjzxZuuUT4)) 
    - Adjust your date range to match the EOS sheet
    - Pull the number of accounts active from the ‘Total Results’ row and update the EOS sheet accordingly
- In the[Launch Tracker](https://docs.google.com/spreadsheets/d/1XV7d51WhaikvqFgaGHH6w2ucxwIEA5auVI5V6sAGn_Q/edit#gid=1438610148) Spreadsheet 
    - Count any ‘Dental Marketing’ accounts listed in the Launch Tracker that match the EOS date range and update the EOS sheet accordingly
- In the [Cancellation tracker](https://docs.google.com/spreadsheets/d/1CQ6wClVrBq0-V-rnmOgJohsaHOk0q5uuzQx4HUJ4MDk/edit?usp=sharing)Spreadsheet,  
    - Count any ‘Dental Marketing’ accounts listed in the Launch Tracker that match the EOS date range and update the EOS sheet accordingly

- [Paid Media SOPs](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#main-content)

    - [Account Management & Updates](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#account-management-updates)
    - [Facebook Ads](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#facebook-ads)
    - [Google Ads](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#google-ads)
    - [Microsoft Ads](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#microsoft-ads)
    - [GMB](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#gmb)
    - [SEO](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#seo)
    - [Optmyzr](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#optmyzr)
    - [Google Analytics](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#google-analytics)
    - [Google Tag Manager](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#google-tag-manager)
    - [Google Ads Editor](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#google-ads-editor)
- [Creative Team SOPs](https://grow.dentalmarketing.com/university/creative-team-sops?hsLang=en#main-content)

    - [Mail LP](https://grow.dentalmarketing.com/university/creative-team-sops?hsLang=en#mail-lp)
    - [Lost Client](https://grow.dentalmarketing.com/university/creative-team-sops?hsLang=en#lost-client)
- [Client Success SOPs](https://grow.dentalmarketing.com/university/client-success-sops?hsLang=en#main-content)

    - [Photoshoot](https://grow.dentalmarketing.com/university/client-success-sops?hsLang=en#photoshoot)
    - [Claude Design Landing Pages](https://grow.dentalmarketing.com/university/client-success-sops?hsLang=en#claude-design-landing-pages)
- [Technology SOPs](https://grow.dentalmarketing.com/university/technology-sops?hsLang=en#main-content)

    - [Dashboard](https://grow.dentalmarketing.com/university/technology-sops?hsLang=en#dashboard)
    - [ChatGPT](https://grow.dentalmarketing.com/university/technology-sops?hsLang=en#chatgpt)
    - [HubSpot](https://grow.dentalmarketing.com/university/technology-sops?hsLang=en#hubspot)
    - [Other](https://grow.dentalmarketing.com/university/technology-sops?hsLang=en#other)
- [Company Information SOPs](https://grow.dentalmarketing.com/university/company-information-sops?hsLang=en)
- [Direct Mail SOPs](https://grow.dentalmarketing.com/university/direct-mail-sops?hsLang=en)
- [Organic Social Media SOPs](https://grow.dentalmarketing.com/university/organic-social-media-sops?hsLang=en#main-content)

    - [Content Creation](https://grow.dentalmarketing.com/university/organic-social-media-sops?hsLang=en#content-creation)
    - [OB Process](https://grow.dentalmarketing.com/university/organic-social-media-sops?hsLang=en#ob-process)
- [Compliance Team SOPs](https://grow.dentalmarketing.com/university/compliance-team-sops?hsLang=en#main-content)

    - [WhatConverts](https://grow.dentalmarketing.com/university/compliance-team-sops?hsLang=en#whatconverts)
    - [Tickets](https://grow.dentalmarketing.com/university/compliance-team-sops?hsLang=en#tickets)
    - [Edits](https://grow.dentalmarketing.com/university/compliance-team-sops?hsLang=en#edits)
    - [Websites](https://grow.dentalmarketing.com/university/compliance-team-sops?hsLang=en#websites)
- [Onboarding SOPs](https://grow.dentalmarketing.com/university/onboarding-sops?hsLang=en)
- [Content Creation SOPs](https://grow.dentalmarketing.com/university/content-creation-sops?hsLang=en)
- [Creative Support](https://grow.dentalmarketing.com/university/creative-support?hsLang=en#main-content)

    - [Ticket Creation](https://grow.dentalmarketing.com/university/creative-support?hsLang=en#ticket-creation)

# Dentalmarketing.com

dentalmarketing.com Help Center

Copyright © 2026, Dentalmarketing.com