---
title: How do I create a Google Ads budget recommendation?
description: This article provides a step-by-step guide on how to create a Google Ads budget recommendation using both Looker Studio automation and manual input in the Budget Recommendation Google Sheet.
---

[Skip to content](https://grow.dentalmarketing.com/university/how-do-i-create-a-google-ads-budget-recommendation-for-dental-marketing-using-automation#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. [Google Ads](https://grow.dentalmarketing.com/university/paid-media-sops?hsLang=en#google-ads)

# How do I create a Google Ads budget recommendation?

## This article provides a step-by-step guide on how to create a Google Ads budget recommendation using both Looker Studio automation and manual input in the Budget Recommendation Google Sheet.

**Note**: This process will create a custom budget recommendation using the last 30 days of the data in the Google Ads account.

- Open the [**Budget Recommendation Report**](https://lookerstudio.google.com/u/0/reporting/9004bcae-fc25-46dd-9a51-f65bc99dc121/page/wWwwD) in **Looker Studio**.
- Click **Edit → Resource → Manage added data sources**.  
  Locate the **Google Ads** data source row, then click **Edit → Edit Connection**.
- Select the correct **Google Ads account** for the client you’re preparing the budget recommendation for.
- Click **Reconnect → Apply → Done** to refresh the report with the most recent **30-day data**.
- Once the connection is updated, close the window. Your Looker Studio report now reflects the latest account data.
- Make a copy of the official [**Budget Recommendation Template**](https://docs.google.com/spreadsheets/d/1P5B8AOKyyrHpflYca17ETtZpCHSJtlt3/edit?gid=1622732435#gid=1622732435):
- Rename the file using this format: **Client Name – Budget Recommendation – MMDDYY**
- In Looker Studio, locate the **Target Area** section of the report. Use the geographic targeting data (states, cities, or service areas) from this section. Enter those same locations under **Target Area** in the Budget Recommendation Report. 
    - **Note:** There’s no need to pull targeting data manually from Google Ads. The Looker Studio data is already current.
- In Looker Studio, find the section titled **“Search Impression Share Breakdown.”**

- - Take a **screenshot** of the graph showing: 
          - Search Impression Share
          - Search Lost IS (Budget)
          - Search Lost IS (Rank)

- - Paste that image into the **Impression section** of the Budget Recommendation Report.
    - Enter the **% values** shown in Looker Studio into the grey boxes below the image.
- After this step, delete the **“Location Targeting”** rows that appear below this section — they are not used.
- In the **Current Metrics Analysis** section of the Budget Recommendation Report, update only the **grey boxes**:

- - **Current Avg. CPC** 
          - Open Google Ads.
          - Select the account and date range (Last 30 Days).
          - Copy the **overall Average CPC** value and enter it into the grey box.
    - **Current Budget** 
          - Pull this value from either: 
                  - The **Companies** section in **HubSpot**, or
                  - **Optmyzr**, under the client account.
          - Enter it into the grey box labeled **Current Budget**.
    - **Note:** All other fields calculate automatically — only these two grey boxes need manual updates.

- In the **Budget Recommendation** tab: 
    - **Maximum Recommended Budget:**  
      Add the **Current Budget** + **Amount Needed to Cover Loss Due to Budget (with buffer)**. 
          - Max Budget = Current Budget + Amount Needed to Cover Loss Due to Budget (with buffer)

- - **Minimum Recommended Budget:**  
      Average the **Current Budget** and the **Max Recommended Budget**. 
          - Min Budget = (Current Budget + Max Budget) / 2
    - **Tip:** Keep your recommendations realistic and aligned with the client’s budget history.
    - Enter both numbers in the grey boxes for *Minimum* and *Maximum Recommended Budget*.
- In the **‘TD’ sheet** of the Budget Recommendation Report: 
    - Update only the **grey boxes** — the rest will calculate automatically.
    - Get the following from **Optmyzr** (Last 30 Days): 
          - **CPA (Cost per Conversion):**  
            Copy the value from the **Cost/Conv** column and paste it into the grey box for CPA.
          - **Conversions:**  
            Copy the number from the **Conversions** column and paste it into the grey box for Conversions.
    - Once entered, the sheet will automatically estimate new conversion volumes based on your budget ranges.
- Next, fill in the **two grey boxes** below with new conversion projections for the **Low** and **High** ranges. 
    - **Example:**  
      If the client currently has 10 conversions, you can recommend: 
          - **Low:** 15
          - **High:** 20
    - **Note:** Review the “Amount Needed to Cover Loss Due to Budget (with buffer)” in the *Budget Recommendation* tab. Ensure your recommended budget range covers or comes close to that amount — this guarantees your recommendation positively impacts **Impression Share**.
- **Hide the ‘TD’ tab** since it’s not client-facing.
- **Edit the Summary section** to include: 
    - The **new budget recommendation range** (Min–Max)
    - The **% increase range** compared to the current budget
- **In Google Sheets, click File → Download → PDF Document (.pdf).** 
    - Check that the file name follows this format: **Client Name – Budget Recommendation – MMDDYY**
- **Upload the PDF to [Google Drive.](https://drive.google.com/drive/folders/1E8Kasl1q1pwBM7i_GvOGB7nevn7h5YUS)** 
    - Set the file's sharing settings to **Public.**
    - Copy the **public link.**
- Return to Hubspot task and mention the SA in a comment on the task with the PDF link 
    - **Example:** Please see full budget recommendation for \[Client Name\] attached: PDF link.

- [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