{"id":8085,"date":"2023-02-08T15:03:24","date_gmt":"2023-02-08T15:03:24","guid":{"rendered":"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/"},"modified":"2023-02-08T15:03:24","modified_gmt":"2023-02-08T15:03:24","slug":"your-guide-to-ppc-budget-management-in-excel","status":"publish","type":"post","link":"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/","title":{"rendered":"Your guide to PPC budget management in Excel"},"content":{"rendered":"<p>Over the past month or so, nearly all the 2023 industry outlook articles I\u2019ve perused (as well as <a href=\"https:\/\/searchengineland.com\/ppc-marketing-trends-2023-391165\" target=\"_blank\" rel=\"noopener\">my own<\/a>) included a common theme:\u00a0<\/p>\n<p>Recessionary trends in the macroeconomy will pressure digital marketers to show the impact of their investments.\u00a0<\/p>\n<p>One of the core tenets I live by (and if my fianc\u00e9e reads this, she\u2019ll probably roll her eyes) is, \u201cFocus on what you can control.\u201d Translating this concept to PPC marketing, it is now more important than ever to put processes and tools in place to maximize control over your budgets.\u00a0<\/p>\n<p>Business objectives may change and have a ripple effect on our budgets, but we can control the funds allocated to the channel.<\/p>\n<p>In a <a href=\"https:\/\/searchengineland.com\/optimizing-account-structure-automation-383883\" target=\"_blank\" rel=\"noopener\">previous article<\/a>, I highlighted PPC account structure strategies that you should consider when looking to increase cost-effectiveness. Today, I want to focus specifically on the topic of budget management.\u00a0<\/p>\n<p>I\u2019ll start with some thoughts on my budget management philosophy and then jump into the tactical tips that can help increase your grasp on spend pacing.\u00a0<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#A_4-point_approach_to_PPC_budget_management\" >A 4-point approach to PPC budget management<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#PPC_campaigns_are_eligible_for_a_finite_amount_of_impressions\" >PPC campaigns are eligible for a finite amount of impressions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Spreading_budget_evenly_will_result_in_better_cost-efficiency_than_spending_during_a_short_concentrated_period\" >Spreading budget evenly will result in better cost-efficiency than spending during a short, concentrated period<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Plan_your_investment_strategy_before_launching_the_campaigns\" >Plan your investment strategy before launching the campaigns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Check_your_pacing_tracker_daily_even_if_its_for_a_minute\" >Check your pacing tracker daily, even if it\u2019s for a minute<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Excel_tips_and_tricks_for_your_PPC_pacing_tracker\" >Excel tips and tricks for your PPC pacing tracker<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Part_1_Raw_platform_data_30-60_minutes\" >Part 1: Raw platform data (30-60 minutes)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Part_2_The_detailed_budget_tracker_1-2_hours\" >Part 2: The detailed budget tracker (1-2 hours)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Part_3_The_delta_graph_15-60_minutes\" >Part 3: The delta graph (15-60 minutes)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Part_4_The_executivesummary_view_30-90_minutes\" >Part 4: The executive\/summary view (30-90 minutes)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/craighordlow.com\/index.php\/2023\/02\/08\/your-guide-to-ppc-budget-management-in-excel\/#Boost_your_PPC_budgeting_performance_and_reduce_the_effort_with_Excel\" >Boost your PPC budgeting performance and reduce the effort with Excel\u00a0<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"A_4-point_approach_to_PPC_budget_management\"><\/span>A 4-point approach to PPC budget management<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Four core budget management principles have helped me throughout my career. While there may be a few exceptions, the following generally hold true.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"PPC_campaigns_are_eligible_for_a_finite_amount_of_impressions\"><\/span>PPC campaigns are eligible for a finite amount of impressions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Budget management is key to success across all PPC channels. However, in search campaigns, I believe it is of heightened importance, as we do not have frequency settings at our disposal.\u00a0<\/p>\n<p>PPC campaigns are only eligible to deliver a finite number of impressions, based on the keywords and targeting settings applied.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Spreading_budget_evenly_will_result_in_better_cost-efficiency_than_spending_during_a_short_concentrated_period\"><\/span>Spreading budget evenly will result in better cost-efficiency than spending during a short, concentrated period<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you\u2019ve ever received a lump sum of incremental at the end of a reporting period, you likely know what I am talking about.\u00a0<\/p>\n<p>Unless budgets are severely constrained \u2013 meaning, there is a large volume opportunity for your campaigns \u2013 you\u2019ll likely have to enable less effective tactics, that will diminish your aggregate performance.<\/p>\n<p>In addition, think about how conversion-focused automation features are designed to work. <\/p>\n<p>They are attempting to prioritize your ad delivery toward users most likely to convert, while ultimately hitting your spend targets.\u00a0<\/p>\n<p>By spreading spend out over a longer period, you enable the algorithms to get \u201cpickier\u201d about when to show ads, increasing your efficiency.\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Plan_your_investment_strategy_before_launching_the_campaigns\"><\/span>Plan your investment strategy before launching the campaigns<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It might seem like I\u2019m stating the obvious here, but it\u2019s a critical step that can often be overlooked. <\/p>\n<p>The simplest approach is straight-line budgeting, but that often is not the optimal solution. Work with your leaders to align your spending patterns in the context of the broader business.\u00a0<\/p>\n<p>For example, if there\u2019s a promotion planned during the flight, you may want to increase spend levels during that time. <\/p>\n<p>Planning ahead allows you to understand how much you should be spending in the early days of the campaign and ensures you don\u2019t run out of funds as the campaign ends.\u00a0\u00a0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Check_your_pacing_tracker_daily_even_if_its_for_a_minute\"><\/span>Check your pacing tracker daily, even if it\u2019s for a minute<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>As the great Pam Beasley once said, \u201cPobody\u2019s nerfect.\u201d Mistakes happen when managing search accounts.\u00a0<\/p>\n<p>One of the easiest ways to catch those mistakes? You guessed it, your pacing document.\u00a0<\/p>\n<p>Fluctuations in spend that deviate from expectations highlight that an unanticipated change has occurred and can have a critical impact on performance. Jump on top of them right away by checking your pacing daily.<\/p>\n<p>If you\u2019re questioning whether the time spent updating a pacing document daily could be better used elsewhere, I encourage you to keep reading.\u00a0<\/p>\n<p>Using the tips and techniques outlined below, you can create a tracker that takes seconds to update.\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Excel_tips_and_tricks_for_your_PPC_pacing_tracker\"><\/span>Excel tips and tricks for your PPC pacing tracker<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>One of my favorite parts of search marketing is that there is rarely a one-size-fits-all solution. <\/p>\n<p>Similar to PPC account structures, the design of your spend tracker should absolutely be tailored to your business.\u00a0Take these ideas, run with them, and put aside the ones that don\u2019t make sense.<\/p>\n<p>There are four core components of every PPC budget pacing tracker that I create in Excel. You can think of each of these as separate tabs in the workbook. They are:<\/p>\n<p>Raw platform data.<\/p>\n<p>The detailed budget tracker (one per managed budget).<\/p>\n<p>The delta graph.<\/p>\n<p>The executive\/summary view.<\/p>\n<p>Each of these tabs has a different intended audience and purpose. We\u2019ll start with the most granular and work our way up to the high-level views.\u00a0<\/p>\n<p>My advice would be to tackle one step at a time. Next to each section header, I\u2019ll provide a rough estimate of how long each step may take, pending your experience in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Part_1_Raw_platform_data_30-60_minutes\"><\/span>Part 1: Raw platform data (30-60 minutes)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A key element of any pacing document is going to be the actual spend data you are importing from the platform. As for the data imported, I always advise keeping it simple, yet granular.\u00a0<\/p>\n<p>In most cases, I design a simple dataset with three columns: <strong>Date<\/strong>, <strong>Campaign<\/strong>, and <strong>Spend<\/strong>.\u00a0<\/p>\n<p>Labels can also be an effective tool for associating campaigns with budgets, depending on the complexity of your account.\u00a0<\/p>\n<p>That said, the more interesting conversation is not about <strong>what<\/strong> data you are importing, but <strong>how<\/strong> the data is getting there.\u00a0<\/p>\n<p>There are many options for how to approach data imports. Below are a couple of different flavors (though I would encourage you to reach out to your analytics team, as they may have additional ideas based on how your data is stored\/structured):<\/p>\n<p><strong>Scheduling reports in the platform: <\/strong>Most PPC platforms have a report scheduling feature available that is easy to use, ensuring the previous day\u2019s data is sitting in your inbox when you hop online. This is where I recommend starting your journey if you are new to pacing automation.<\/p>\n<p><strong>Web links: <\/strong>Some campaign management tools, such as Search Ads 360, allow you to create custom URLs for your reports. This eliminates the need to manually import data via copy and paste, as you will using the previous option.\u00a0<\/p>\n<p><strong>Query connections: <\/strong>Similar to web links, you can create connections to data tables in analytics platforms. This approach allows you to refresh and update your data in real time. However, it requires SQL proficiency, so I always advise consulting your analytics team if exploring this route. If that is not possible, circle back to the first option.\u00a0\u00a0<\/p>\n<p>Remember, it doesn\u2019t matter how your data gets to the pacing document, so long as it is comprehensive and accurate. <\/p>\n<p>The time saved using one of the automated data connections described above \u2013 instead of copying\/pasting reports \u2013 is minimal. The biggest difference is the elimination of the potential for human error.<\/p>\n<p>Once you have the data in the workbook, the only manipulation required is the creation of the join, which is simply the unique identifier you will reference to VLOOKUP the data into the detailed budget tracker (more in the next section).\u00a0<\/p>\n<p>When creating a join, there are some simple considerations to keep in mind:<\/p>\n<p>Make sure your date column is one of the elements of the concatenate, as you want to pull in spend by day.\u00a0<\/p>\n<p>The nomenclature used for budget names must be consistent throughout the document, including in the \u201cRaw data\u201d tab.<\/p>\n<p>Below is an example of what this concatenate could look like.\u00a0\u00a0\u00a0\u00a0<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p><!-- START INLINE FORM --><\/p>\n<div class=\"nl-inline-form border py-2 px-1 my-2\">\n<div class=\"row align-items-center\">\n<div class=\"col-12 col-lg-3 col-xl-4 pe-md-0 pb-2 pb-lg-0\">\n<p class=\"inline-form-text text-center mb-0\">Get the daily newsletter search marketers rely on.<\/p>\n<\/div>\n<div class=\"col-12 col-lg-7 col-xl-6  pe-lg-0\">\n<div class=\"form-nl-inline\">\n<div class=\"row g-0\">\n<div class=\"form-group col-12 col-lg-8 mb-0\"><\/div>\n<div class=\"col-12 col-lg-4 col-xl-4 mb-0\">\n<div class=\"d-none\">\n<p>Processing\u2026Please wait.<\/p>\n<\/div>\n<p>\t\t\t\t\t\t\t<button class=\"btn btn-dark inlineButton w-100 rounded-0 font-weight-bold\">SUBSCRIBE<\/button>\n\t\t\t\t\t\t<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"col-12 col-lg-2 col-xl-2 ps-1\">\n<p class=\"text-center mb-0\"><a class=\"nl-terms\" href=\"https:\/\/searchengineland.com\/termsofuse\" target=\"_blank\" rel=\"noopener noreferrer\">See terms.<\/a><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- END INLINE FORM --><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Part_2_The_detailed_budget_tracker_1-2_hours\"><\/span>Part 2: The detailed budget tracker (1-2 hours)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>These tabs are the core of the pacing document, as they marry your actual spend performance to the spending plan. You should have one detailed budget tracker per budget you are managing.\u00a0<\/p>\n<p>That might sound redundant, but here&#8217;s the trick \u2013 if you build the first one using formulas and references, it can be quickly duplicated and adjusted for your other line items!<\/p>\n<p>I&#8217;m going to start with a snapshot of the detailed budget tracker and then provide an overview of how to automate each element so that it is easily replicable.\u00a0<\/p>\n<p><strong>1. Summary table<\/strong><\/p>\n<p>A simple overview of what the total budget is and how much we&#8217;ve spent to date. Each budget should only be hardcoded in one cell in the document.\u00a0<\/p>\n<p>I tend to do the hard coding on the &#8220;Executive summary&#8221; (the final section covered in this article), but you could do it here as well. Your budget spent and remaining budget should be set up as calculations so that they update dynamically.\u00a0<\/p>\n<p><strong>2. Spend plan details<\/strong><\/p>\n<p>A critical element that needs to be customized based on the budget duration, business needs, and your understanding of consumer behavior. Here, I recommend leaning on historical data as much as you can.\u00a0<\/p>\n<p>One small tip: See that list of numerals next to the Day of Week column? That&#8217;s for the VLOOKUP we&#8217;re about to create. It enables you to use the WEEKDAY function when automating your VLOOKUP references.<\/p>\n<p><strong>3. Daily spend plan<\/strong><\/p>\n<p>Mapping out target daily spends sounds daunting, right?\u00a0<\/p>\n<p>Good news! We can use VLOOKUPs and math to make this an easy, dynamic calculation.<strong>\u00a0<\/strong><\/p>\n<p>If I were to write as an equation, it is:<\/p>\n<p>Daily Spend = [Target Spend for Week] * [Target %Spend by Day of Week]<\/p>\n<p>In Excel, I write a VLOOKUP for each component of the equation, referencing the details we compiled in the spend plan.\u00a0<\/p>\n<p>(If you want a reminder on VLOOKUP best practices, check out my previous article, <a href=\"https:\/\/searchengineland.com\/level-up-analytical-skills-excel-391940\" target=\"_blank\" rel=\"noopener\">How to level up your analytical skills with Excel<\/a>.)\u00a0<\/p>\n<p>The Total Target Spend column simply aggregates the target spends over time. The easiest way to do this is [Today&#8217;s Target Spend] + [Yesterday&#8217;s Total Target Spend]. You can see how that column adds up to $10,000, which aligns with our summary table.<\/p>\n<p><strong>4. Actual spend<\/strong><\/p>\n<p>Does that column on the far lefthand side look familiar? It should, as that&#8217;s the join from our &#8220;Raw data&#8221; tab.<\/p>\n<p>The trick I use here is concatenating the date to the Title row (shaded in Red). When thinking about duplicating the tab and creating a detailed budget tracker, all you need to update is the table&#8217;s title.<\/p>\n<p>Similar to the previous step, this is a VLOOKUP of the join, pulling in the spend from our &#8220;Raw data&#8221; tab. I then use the same exact approach as the previous step for the Total Actual Spend.<\/p>\n<p><strong>5. Calculations<\/strong><\/p>\n<p>These are calculations I build based on the Target and Actual Spends we incorporated in the previous two steps.\u00a0<\/p>\n<p>When it comes to the delta, make sure you are using the Total columns, as opposed to the Daily Target\/Actual Spends.\u00a0<\/p>\n<p><strong>Note:<\/strong> In each of the five steps listed above, we are only using formulas. I can&#8217;t stress this enough \u2013 though it may take longer to create initially, this is what allows your detailed budget tracker to be replicable for additional budgets or for new quarters.\u00a0<\/p>\n<p>You may wrestle with the formulas at first, but once you have a strong template, budget management processes will become much more efficient \u2013 as the only details you&#8217;ll need to update are the Budget Name, Budget Amount, and potentially, your Spend plan details table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Part_3_The_delta_graph_15-60_minutes\"><\/span>Part 3: The delta graph (15-60 minutes)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>The purpose of this feature is to create a simple view of how all campaigns are pacing relative to the predetermined plan. In a perfect world, all budgets would have a 0% deviation from the plan, but that is rarely the case in real life.\u00a0<\/p>\n<p>This is one of the easiest parts to set up, as you&#8217;ve already done the heavy lifting. <\/p>\n<p>As you can see in the visual below, this is a simple reference to the &#8220;Detailed budget tracker&#8221; tab you&#8217;ve already created. Set up one column for each detailed budget tracker you created in the previous step.<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>A couple of tips as it relates to this component of the pacing tracker:<\/p>\n<p>Remember that 0% is the ideal target here. The closer to 0%, the more tightly aligned spend is to your plan. If your audience isn&#8217;t very data-centric, it might be helpful to make that visually apparent. Sometimes, I&#8217;ll include a transparent green box between the -20% to 20% range to illustrate.<\/p>\n<p>Typically, I keep the vertical axis range set at -1 to 1. However, as you approach the end of the flight, you may want to &#8220;zoom in&#8221; by decreasing to -0.5 to 0.5 or even further.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Part_4_The_executivesummary_view_30-90_minutes\"><\/span>Part 4: The executive\/summary view (30-90 minutes)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>We save this one for last, as it is largely built off the work you&#8217;ve already done. <\/p>\n<p>The purpose of this view is to complement the delta graph with a bit more context and some of the basic data points leaders will be curious to know.\u00a0<\/p>\n<div class=\"wp-block-image\">\n<\/div>\n<p>Some thoughts regarding the executive summary:\u00a0<\/p>\n<p>As mentioned in the detailed budget tracker overview, this is the only tab where I hardcode any cells. The Dates table and the Engine\/Budget Name\/Budget Amount columns are the only hard-coded cells.\u00a0<\/p>\n<p>With this being an executive view, the argument could be made to further reduce the number of metrics. I like to include Yesterday and Past 7-Day Average metrics as they help contextualize whether the previous day was abnormal or in line with the recent trend. This view should be adjusted based on your audience.<\/p>\n<p>Creating the summary using formulas and references makes it easy to replicate for new campaigns or flights. The Past 7-Day Average metric looks messy and difficult to create, but it&#8217;s quite easy using a simple trick. Once you write the VLOOKUP, you just need to copy and paste. The only update to make is the date you are referencing ($C$$-X in the formula above).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Boost_your_PPC_budgeting_performance_and_reduce_the_effort_with_Excel\"><\/span>Boost your PPC budgeting performance and reduce the effort with Excel\u00a0<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Investing time to enhance your pacing processes and tools at the beginning of 2023 is a worthwhile endeavor. <\/p>\n<p>During turbulent times, maximizing available budgets is critical \u2013 and it starts with creating a spending plan and adhering to it.\u00a0<\/p>\n<p>Implementing the techniques described in this article will reduce the aggregate time spent on pacing updates, while also providing views that enable a quick response when things go awry.\u00a0<\/p>\n<p>In addition, once your template is automated, it will be easily replicable and only requires a couple of cell changes to complete updates for a new month or quarter.\u00a0<\/p>\n<p>The post <a href=\"https:\/\/searchengineland.com\/ppc-budget-management-excel-guide-392687\" target=\"_blank\" rel=\"noopener\">Your guide to PPC budget management in Excel<\/a> appeared first on <a href=\"https:\/\/searchengineland.com\/\" target=\"_blank\" rel=\"noopener\">Search Engine Land<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Over the past month or so, nearly all the 2023 industry outlook articles I\u2019ve perused (as well as my own) included a common theme:\u00a0 Recessionary trends in the macroeconomy will pressure digital marketers to show the impact of their investments.\u00a0 One of the core tenets I live by (and if my fianc\u00e9e reads this, she\u2019ll probably roll her eyes) is, \u201cFocus on what you can control.\u201d Translating this concept to PPC marketing, it is now more important than ever to put processes and tools in place [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"h5ap_radio_sources":[],"cybocfi_hide_featured_image":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-8085","post","type-post","status-publish","format-standard","hentry","category-best-seo-blogs"],"featured_image_src":null,"featured_image_src_square":null,"author_info":{"display_name":false,"author_link":"https:\/\/craighordlow.com\/author\/"},"_links":{"self":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/8085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/comments?post=8085"}],"version-history":[{"count":0,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/posts\/8085\/revisions"}],"wp:attachment":[{"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/media?parent=8085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/categories?post=8085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craighordlow.com\/index.php\/wp-json\/wp\/v2\/tags?post=8085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}