Connect with us


Google Ad Script to Manage Campaign Budgets



Today as advertisers utilizing Google Ads, it is a universal struggle to manage to a specific budget by campaign(s). Your options in the U.I. are singular: set a rule that excludes hourly. My question is why? Would it not be great to have a script to manage at the campaign level, via a sheet in 2019? It took some time but I figured it out, which you will see below. The ability to manage budgets in a single script with a sheet across multiple campaigns.

Before we continue onto the script, if you are set on rules not to say they are not great for budget management, here is an example of how to create a rule that has time setting limitations to pause or enable your campaigns based on a budget for campaigns. You can find additional details here with automated rules.

  1. Sign in to your Google Ads account.
  2. Go to the CampaignsAd Groups, or Keywords pages.
  3. Click the 3-dot icon above the statistics table.
  4. Select Create an automated rule.
  5. Select Pause or Enable from the “Type of rule” drop-down.
  6. Choose which Campaign Type
  7. To add a condition, click +ADD, under “Condition”.
  8. Define the frequency of your rule which is Once, Daily, Weekly or Monthly.
  9. Choose the type of email updates you’d like to receive on issues affecting your rule.
  10. Name your rule.
  11. Click Preview to ensure you’ve set up your rule to run the way you want. Previewing is just for verification and doesn’t make any permanent changes to your account.
  12. When you are done, click Save rule.

There are benefits to rules, in my mind for budget sake, not so extremely valuable. So that leaves us with paying for tools & or having a developer or engineer to build out some fancy scripts or internal platform that works with Google’s API. What if I do not have access to those resources and all I want to do is be an advertiser? I cannot, I have to learn coding and API stuff to include staying up-to-date on all of the U.I. changes and enhancements, which you can find in the PPC Hero Library.

Why you are reading and how the script works.

This script manages your budget at the campaign level by the hour via a google sheet, so you can scale. To my knowledge and I have scoured the web, this is the first for the public. I did not write the original script. Which can be found here by Google. I simply deleted a bunch of stuff with lots of trial and error over a 1 year period of time and re-worked a few things to get it to manage budgets instead of bids.

The script allows you the flexibility of setting your budgets and forgetting about them within reason. If you want to get crazy, you can do what I do and use this script with the pacing script with few custom google sheets so that you have your own budget management tool and bidder. I figured if someone can build a tool to do this stuff and make millions of dollars, there has to be a free way to do it.

I am certain, almost positive there is a better way to write this script and more than certain there is a way to do it at the MCC level to manage multiple accounts. I have not figured that out. It would be great for those that see this that are devs, and or engineers, to make adjustments to this script and share a free version at the MCC level with your own enhancements.

How to set up the script

Before you run the script here are a few things that you need to change.

  1. Make a new Google Sheet. This is where the script will know which campaigns to Pause or UnPause, once you have created a new sheet copy the URL.
  2. Ensure your Tab name is set to “Rules” if not please make sure you update this line where “Rules is changed to whatever your Tab Name is: var spreadsheetAccess = new SpreadsheetAccess(SPREADSHEET_URL, “Rules“)
  3. Still working in Google Sheets, update Row 2 with your account number “000-000-0000” replace with your own.
  4. Row 3 is the time period reference for your script to run, if you want to execute after 7 days, 1 week or a month. Reference the below table for valid inputs for this row as it relates to your goal with controlling your budgets.

Google ads script timeframe options

  • Starting in row 6, column C, you will want to add your budgets for that period
  • Lastly, in row 6, column D, you will want to list your campaigns.

I hope this helps you all in better controlling your budgets. Almost forgot, you can change the campaign.pause in the script to campaign.enable and adjust the simple formula if you want to duplicate the script and create another script to enable campaigns.


var SPREADSHEET_URL = "[]"; var spreadsheetAccess = new SpreadsheetAccess(SPREADSHEET_URL, "Rules"); var totalColumns; function main() { var columns = spreadsheetAccess.sheet.getRange(5, 2, 5, 100).getValues()[0]; for (var i = 0; i < columns.length; i ++) { if (columns[i].length == 0 || columns[i] == 'Results') { totalColumns = i; break; } } if (columns[totalColumns] != 'Results') { spreadsheetAccess.sheet.getRange(5, totalColumns + 2, 1, 1).setValue("Results"); } // clear the results column spreadsheetAccess.sheet.getRange(6, totalColumns + 2, 1000, 1).clear(); var row = spreadsheetAccess.nextRow(); while (row != null) { var budget; try { budget = parseBudget(row); } catch (ex) { logError(ex); row = spreadsheetAccess.nextRow(); continue; } var selector = AdWordsApp.campaigns(); for (var i = 2; i < totalColumns; i ++) { var header = columns[i]; var value = row[i]; if (!isNaN(parseFloat(value)) || value.length > 0) { if (header.indexOf("'") > 0) { value = value.replace(/\'/g,"\\'"); } else if (header.indexOf("\"") > 0) { value = value.replace(/"/g,"\\\""); } var condition = header.replace('?', value); selector.withCondition(condition); } } var campaigns = selector.get(); try { campaigns.hasNext(); } catch (ex) { logError(ex); row = spreadsheetAccess.nextRow(); continue; } var fetched = 0; var changed = 0; while (campaigns.hasNext()) { var campaign =; var oldCost = campaign.getStatsFor("THIS_MONTH").getCost(); var action = row[0]; var newStatus; fetched ++; if (budget <= oldCost) { campaign.pause(); changed++ } } logResult("Fetched " + fetched + "\nChanged " + changed); row = spreadsheetAccess.nextRow(); } var now = new Date(Utilities.formatDate(new Date(), AdWordsApp.currentAccount().getTimeZone(), "MMM dd,yyyy HH:mm:ss")); } function parseBudget(row) { if (row[1].length == 0) { return null; } var limit = parseFloat(row[1]); if (isNaN(limit)) { throw "Bad Argument: must be a number."; } return limit;
} function logError(error) { spreadsheetAccess.sheet.getRange(spreadsheetAccess.currentRow(), totalColumns + 2, 1, 1) .setValue(error) .setFontColor('#c00') .setFontSize(8) .setFontWeight('bold');
function logResult(result) { spreadsheetAccess.sheet.getRange(spreadsheetAccess.currentRow(), totalColumns + 2, 1, 1) .setValue(result) .setFontColor('#444') .setFontSize(8) .setFontWeight('normal');
} function SpreadsheetAccess(spreadsheetUrl, sheetName) { this.spreadsheet = SpreadsheetApp.openByUrl(spreadsheetUrl); this.sheet = this.spreadsheet.getSheetByName(sheetName); this.cells = this.sheet.getRange(6, 2, this.sheet.getMaxRows(), this.sheet.getMaxColumns()).getValues(); this.rowIndex = 0; this.nextRow = function() { for (; this.rowIndex < this.cells.length; this.rowIndex ++) { if (this.cells[this.rowIndex][0]) { return this.cells[this.rowIndex++]; } } return null; } this.currentRow = function() { return this.rowIndex + 5; }


Google to pay $391.5 million settlement over location tracking, state AGs say



Google to pay $391.5 million settlement over location tracking, state AGs say

Google has agreed to pay a $391.5 million settlement to 40 states to resolve accusations that it tracked people’s locations in violation of state laws, including snooping on consumers’ whereabouts even after they told the tech behemoth to bug off.

Louisiana Attorney General Jeff Landry said it is time for Big Tech to recognize state laws that limit data collection efforts.

“I have been ringing the alarm bell on big tech for years, and this is why,” Mr. Landry, a Republican, said in a statement Monday. “Citizens must be able to make informed decisions about what information they release to big tech.”

The attorneys general said the investigation resulted in the largest-ever multistate privacy settlement. Connecticut Attorney General William Tong, a Democrat, said Google’s penalty is a “historic win for consumers.”

“Location data is among the most sensitive and valuable personal information Google collects, and there are so many reasons why a consumer may opt out of tracking,” Mr. Tong said. “Our investigation found that Google continued to collect this personal information even after consumers told them not to. That is an unacceptable invasion of consumer privacy, and a violation of state law.”

Location tracking can help tech companies sell digital ads to marketers looking to connect with consumers within their vicinity. It’s another tool in a data-gathering toolkit that generates more than $200 billion in annual ad revenue for Google, accounting for most of the profits pouring into the coffers of its corporate parent, Alphabet, which has a market value of $1.2 trillion.

The settlement is part of a series of legal challenges to Big Tech in the U.S. and around the world, which include consumer protection and antitrust lawsuits.

Though Google, based in Mountain View, California, said it fixed the problems several years ago, the company’s critics remained skeptical. State attorneys general who also have tussled with Google have questioned whether the tech company will follow through on its commitments.

The states aren’t dialing back their scrutiny of Google’s empire.

Last month, Texas Attorney General Ken Paxton said he was filing a lawsuit over reports that Google unlawfully collected millions of Texans’ biometric data such as “voiceprints and records of face geometry.”

The states began investigating Google’s location tracking after The Associated Press reported in 2018 that Android devices and iPhones were storing location data despite the activation of privacy settings intended to prevent the company from following along.

Arizona Attorney General Mark Brnovich went after the company in May 2020. The state’s lawsuit charged that the company had defrauded its users by misleading them into believing they could keep their whereabouts private by turning off location tracking in the settings of their software.

Arizona settled its case with Google for $85 million last month. By then, attorneys general in several other states and the District of Columbia had pounced with their own lawsuits seeking to hold Google accountable.

Along with the hefty penalty, the state attorneys general said, Google must not hide key information about location tracking, must give users detailed information about the types of location tracking information Google collects, and must show additional information to people when users turn location-related account settings to “off.”

States will receive differing sums from the settlement. Mr. Landry’s office said Louisiana would receive more than $12.7 million, and Mr. Tong’s office said Connecticut would collect more than $6.5 million.

The financial penalty will not cripple Google’s business. The company raked in $69 billion in revenue for the third quarter of 2022, according to reports, yielding about $13.9 billion in profit.

Google downplayed its location-tracking tools Monday and said it changed the products at issue long ago.

“Consistent with improvements we’ve made in recent years, we have settled this investigation which was based on outdated product policies that we changed years ago,” Google spokesman Jose Castaneda said in a statement.

Google product managers Marlo McGriff and David Monsees defended their company’s Search and Maps products’ usage of location information.

“Location information lets us offer you a more helpful experience when you use our products,” the two men wrote on Google’s blog. “From Google Maps’ driving directions that show you how to avoid traffic to Google Search surfacing local restaurants and letting you know how busy they are, location information helps connect experiences across Google to what’s most relevant and useful.”

The blog post touted transparency tools and auto-delete controls that Google has developed in recent years and said the private browsing Incognito mode prevents Google Maps from saving an account’s search history.

Mr. McGriff and Mr. Monsees said Google would make changes to its products as part of the settlement. The changes include simplifying the process for deleting location data, updating the method to set up an account and revamping information hubs.

“We’ll provide a new control that allows users to easily turn off their Location History and Web & App Activity settings and delete their past data in one simple flow,” Mr. McGriff and Mr. Monsees wrote. “We’ll also continue deleting Location History data for users who have not recently contributed new Location History data to their account.”

• This article is based in part on wire service reports.

Source link

Continue Reading


5 Tips to Boost Your Holiday Search Strategy



Student writing on computer

With the global economic downturn, inflation, ongoing supply chain challenges, and uncertainty due to the Ukraine war, this year’s holiday shopping season promises to be very challenging. Will people be in the mood to spend despite the gloom? Or will they rein in their enthusiasm and save for the year ahead?

With these issues in mind, here are five considerations to support your search engine optimization strategy this holiday shopping season:

1. Start early.

Rising prices are likely to mean shoppers will start researching their holiday spending earlier than ever to nab the best bargains. Therefore, retailers must roll out their holiday product and category pages — and launch any promotions — sooner to ensure their pages get crawled and indexed by search engines in good time.

Some e-commerce stores manage to get their pages ranking early by updating and reusing the same section of the website for holiday content and promotions, rotating between content for Christmas, Mother’s Day, Valentine gifts, Fourth of July sales, etc. This approach can help you retain the momentum, links and authority you build up with Google and get your holiday pages visible and ranking quickly.

2. Make research an even bigger priority.

With all the uncertainty this year, it’s vital to use SEO research to identify the trending seasonal keywords and search phrases in your retail vertical — and then optimize content accordingly.

With tools such as Google Trends you can extract helpful insights based on the types of searches people are making. For example, with many fashion retailers now charging for product returns, will prioritizing keywords such as “free returns” get more search traction? And with money being tighter, will consumers stick with brands they trust rather than anything new — meaning brand searches might be higher?

3. Make greater use of Google Shopping.

To get the most out of their holiday spending, consumers are more likely to turn to online marketplaces such as Google Shopping as they make it easier to compare products, features and prices, as well as to identify the best deals both online and in nearby stores.

Therefore, take a combined approach which includes listing in Google Shopping and at the same time optimizing product detail pages on your e-commerce site to ensure they’re unique and provide more value than competitors’ pages. Be precise with product names on Google Shopping (e.g., do the names contain the words people are searching for?); ensure you provide all the must-have information Google requires; and set a price that’s not too far from the competition. 

4. Give other search sources the attention they deserve.

Earlier this year Google itself acknowledged that consumers — especially younger consumers — are starting to use TikTok, Instagram and other social media sites for search. In fact, research suggests 11 percent of product searches now start on TikTok and 15 percent on Instagram. Younger consumers in particular are more engaged by visual content, which may explain why they’re embracing visually focused social sites for search. So, as part of your search strategy, create and share content on popular social media sites that your target customers visit.

Similarly, with people starting their shopping searches on marketplaces such as, optimizing any listings you have on the site should be part of your strategy. And thankfully, the better optimized your product detail pages are for Amazon (with unique, useful content), the better they will rank on Google as well!

5. Hold paid budget for late opportunities.

The greater uncertainty and volatility this holiday season mean you must keep a close eye on shopper behavior and be ready to embrace opportunities that emerge later on. Getting high organic rankings for late promotions is always more challenging, so hold some paid search budget back to help drive traffic to those pages — via Google Ads, for example. Important keywords to include in late season search ad campaigns include “delivery before Christmas” and “same-day-delivery.” For locally targeted search ads, consider “pick up any time before Christmas.”

The prospect of a tough, unpredictable holiday shopping season means search teams must roll out seasonal SEO plans early, closely track shoppers’ behavior, and be ready to adapt as things change.

Marcus Pentzek is chief SEO consultant at Searchmetrics, the global provider of search data, software and consulting solutions.

Source link

Continue Reading


Google Home App Gets an Overhaul, Rolling Out Soon



Google Home app

Google refreshes its Home app with a slew of new features after launching a new Nest gear. This makes it faster and easier to pair smart devices with Matter, adds customization and personalization options, an enhanced Nest camera experience, and better intercommunication between devices.

This revamped Home app utilizes Google’s Matter smart home standard – launching later this year – especially the Fast Pair functionality. On an Android phone, it will instantly recognize a Matter device and allow you to easily set it up, bypassing the current procedure that is often slow and difficult. Google is also updating its Nest speakers, displays, and routers – to control Matter devices better.

Google Home App New Features

  • Spaces: This feature allows you to control multiple devices in different rooms. Google has listed a few things by room: kitchen, bedroom, living room, etc., although it’s pretty limited right now. Spaces let you organize devices how you see fit. For instance, you can set up a baby monitor in one room and set a different room’s camera to focus on an area the baby often plays. With Spaces, you can categorize these two devices into one Space category called ‘Baby.’

Google Home app Spaces

  • Favorites: This one is pretty self-explanatory. It allows you to make certain gears as a favorite that you frequently use. Doing so will bring those devices into the limelight within the Google Home app for easier access. 

Google Home app

  • Media: Google adds a new media widget at the bottom of your Home feed. This will automatically determine what media is playing in your home and provide you with the appropriate controls as and when needed. There will be song controls if you listen to music on your speakers. There will be television remote controls if you’re watching TV. 

Google probably won’t roll out this Home app makeover anytime soon. But you can try it for yourself in the coming week by enrolling in the public preview, available in select areas.

Source link

Continue Reading