Managing PPC campaigns on Google Ads can be both challenging and tedious. However, using scripts—such as our free Google Ads Auto-SQR script—can be a game-changer, automating tasks that would otherwise take significant time and effort.
This powerful Google Ads script aims to streamline the process of targeting high-volume search queries by automatically adding them as exact match keywords based on user-defined criteria.
In this article, we’ll explain the benefits of using scripts such as our Auto-SQR script and how to set them up on your Google Ads account. We’ll also discuss the importance of targeting the right keywords in your campaign.
Google Ads Auto-SQR Script
/*
_ ___ _ _ _____ ___ _
/_\ / __| | | |_ _/ _ \ (_)___
/ _ \ (__| |_| | | || (_) || / _ \
/_/ \_\___|\___/ |_| \___(_)_\___/
*/
const config = {
DATE_RANGE: 'YOUR_DATE_RANGE', // Replace YOUR_DATE_RANGE with your desired date range. Valid pre-defined date ranges are: TODAY, YESTERDAY, LAST_7_DAYS, THIS_WEEK_SUN_TODAY, LAST_WEEK, LAST_14_DAYS, LAST_30_DAYS, LAST_BUSINESS_WEEK, LAST_WEEK_SUN_SAT, THIS_MONTH, LAST_MONTH, ALL_TIME.
MIN_SPEND: 100, // Minimum conversions threshold
MIN_CONVERSIONS: 2, // Minimum conversions threshold
MIN_REVENUE: 50, // Minimum revenue threshold
LABEL_NAME: 'your label', // A label to identify what the script has worked on
};
function main() {
const query = `
SELECT
search_term_view.search_term,
segments.keyword.info.match_type,
segments.keyword.info.text,
segments.search_term_match_type,
metrics.clicks,
metrics.conversions,
metrics.conversions_value,
metrics.cost_micros,
campaign.id,
campaign.name,
ad_group.id,
ad_group.name
FROM search_term_view
WHERE
campaign.status = 'ENABLED'
AND segments.date DURING ${config.DATE_RANGE}
AND metrics.cost_micros > ${config.MIN_SPEND * 1000000}
AND search_term_view.status IN ('NONE', 'UNKNOWN')
`;
const report = AdsApp.report(query);
const rows = report.rows();
const data = [];
while (rows.hasNext()) {
const row = rows.next();
const cost = row['metrics.cost_micros'] / 1000000;
const campaign = row['campaign.name'];
const campaignId = row['campaign.id'];
const adGroup = row['ad_group.name'];
const adGroupId = row['ad_group.id'];
const searchTermMatchType = row['segments.search_term_match_type'];
const conv = row['metrics.conversions'];
const revenue = row['metrics.conversions_value'];
if (cost > config.MIN_SPEND && conv >= config.MIN_CONVERSIONS && revenue >= config.MIN_REVENUE) {
data.push({
search_term: row['search_term_view.search_term'],
keyword: row['segments.keyword.info.text'],
campaign: campaignId,
adgroup: adGroupId,
});
/* console.log( {
search_term: row['search_term_view.search_term'],
keyword: row['segments.keyword.info.text'],
match_type:searchTermMatchType,
test:searchTermMatchType.indexOf('NEAR'),
clicks: row['metrics.clicks'],
cost: cost,
conv: row['metrics.conversions'],
rev:row['metrics.conversions_value'],
campaign: campaign,
adgroup: adGroup}) */
}
}
const labelName = config.LABEL_NAME + Utilities.formatDate(new Date(), 'GMT', 'yyyy-MM-dd');
const labelExists = AdsApp.labels().withCondition(`label.name = "${labelName}"`).get().totalNumEntities();
if (labelExists === 0) {
AdsApp.createLabel(labelName);
}
console.log(data);
data.forEach(row => {
const campaignId = row.campaign;
const adGroupId = row.adgroup;
const newKeyword = '[' + row.search_term + ']';
const keyword = row.keyword;
// console.log(adGroupId)
const adgroups = AdsApp.adGroups()
.withCondition(`campaign.id = "${campaignId}" AND ad_group.id = "${adGroupId}"`)
.get();
while (adgroups.hasNext()) {
const adgroup = adgroups.next();
const kws = adgroup.keywords().withCondition(`ad_group_criterion.keyword.text = "${keyword}"`).get().next();
const finalUrl = kws.urls().getFinalUrl();
try {
if (finalUrl && finalUrl !== null && finalUrl !== '') {
const keywordOperation = adgroup
.newKeywordBuilder()
.withText(newKeyword)
.withFinalUrl(finalUrl)
.build()
.getResult();
keywordOperation.applyLabel(labelName);
} else if (!finalUrl || finalUrl === null || finalUrl === '') {
const keywordOperation = adgroup.newKeywordBuilder().withText(newKeyword).build().getResult();
keywordOperation.applyLabel(labelName);
}
} catch (e) {
`couldn't update keyword ${newKeyword}`;
}
}
});
}
How to Use Scripts in Google Ads
Google Ad scripts can be used to automate a range of different PPC tasks.
Here’s how to set them up:
- Sign in to your Google Ads account.
- From the toolbar, select the TOOLS drop-down menu.
- Under the BULK ACTIONS list, select SCRIPTS.
- Click the blue + icon to create a new script.
- Enter a name for your script in the name bar.
- Copy & paste your script code into the editor.
- You will need to click AUTHORISE to allow the script to run on your account.
- At this point, you can SAVE & PREVIEW your script.
- Check the logs on your preview to ensure the script will run as expected.
- When you are ready, click RUN to implement the script.
What is the Google Ads Auto-SQR Script?
SQR stands for Search Query Report. This crucial feature of Google Ads provides valuable insights into the specific search terms that trigger an ad. By detailing the actual search terms users entered into Google, advertisers can better understand the relevance and effectiveness of their keyword targeting.
Acuto’s free Google Ads Auto-SQR script is a handy bit of code specifically designed to automate the process of retrieving search query data and adding optimal keywords to your search query report. This should enable a more efficient workflow and lead to more accurate results.
How Does the Google Ads Auto-SQR Script Work?
This free Google Ads auto-SQR script works by using predefined user criteria to identify potential keywords that match the campaign’s objectives.
It continuously monitors the search terms triggering ads and evaluates them against the specific search queries you want to focus on. If a search term meets this optimal criteria—indicating it has high search volume and relevance—the script will automatically add it to the SQR.
By automating this process, the Auto-SQR script saves time and ensures that valuable search queries are not missed. This can help improve the overall performance of your campaign by identifying new keywords that can generate relevant traffic and conversions.
Why Should You Use the Google Ads Auto-SQR Script?
The Google Ads auto-SQR script is sure to be a valuable tool when trying to improve your PPC campaign.
Here are three key benefits:
- Saving time: Manually identifying high-volume search queries can be a tedious task. A Google Ads script such as this automates the process, saving you and your team valuable time and effort. The script continuously monitors and adds relevant queries to the SQR, allowing you to focus on other important aspects of your campaign.
- Maximising budget: By automatically discovering high-volume search queries, the script helps you make the most of your paid ad budget. It ensures that your ads are shown to a broader audience by targeting relevant keywords that drive traffic. This optimisation can lead to improved campaign performance and a higher return on investment.
- Scalability: The Auto-SQR script can be applied across multiple Google Ads accounts. This allows you to streamline your processes and ensure consistent performance across campaigns. The script saves you from manually implementing SQR updates for each account, making it an efficient solution for large-scale advertising efforts.
When to Use the Google Ads Auto-SQR Script
The Google Ads Auto-SQR script can be utilised in various scenarios to optimise your campaign.
Here are a few situations where it might be particularly handy:
- Fluctuating search trends: If your campaigns tend to operate in a particular niche—for example, where search trends change frequently or seasonally—the Auto-SQR script can help. By automatically identifying emerging high-volume search queries, the script ensures that your campaign stays up to date.
- Managing multiple Google Ads accounts: With its inherent scalability, the script can be applied across all accounts simultaneously—saving time that would be taken up manually monitoring and updating SQRs individually.
- Budgeting: The Auto-SQR script can help to maximise your budget by automatically discovering high-volume search queries that drive traffic. This enables you to focus your budget on the optimal keywords, ultimately enhancing the overall performance of your campaigns and avoiding wasted ad spend.
- Efficiency: The Auto-SQR script also offers a simple way to save time and improve overall efficiency. Instead of manually reviewing search terms and updating the SQR, the script automates this click-intensive process. This frees you and your team to focus on other, more strategic aspects of your PPC campaign.
Custom Automation Scripts by Acuto
Are you and your team spending too much time on tedious ad-management tasks? Google Ads scripts provide a powerful solution to automate these time-consuming processes, allowing you to channel your skills into more strategic elements of your campaign.
If you’re seeking targeted ways to streamline your team’s workflow, you may want to consider Acuto’s custom automation script service.
We recognise that every business faces unique challenges. Our expertise lies in developing tailor-made scripts to address a wide range of needs for platforms such as Google Ads.
Whether your goal is to optimise ad content, expand your ad reach, or enhance the efficiency of your search query reports, our codes can be specifically designed to match your requirements.
Find out what Acuto can do for your business by booking a call with our team today.
Key Takeaways
So, to recap:
- Scripts can be used to automate various elements of ad management and are a great way to improve the efficiency of your workflow.
- SQR is a feature in Google Ads which stands for Search Query Report. It shows you the user searches that trigger your ads.
- Acuto’s free Google Ads Auto-SQR script is a clever bit of code designed to automate the process of retrieving search data & adding the most optimal keywords to your SQR.
- The script can help to save time, maximise your budget, improve overall efficiency and can be scaled across multiple accounts.
- Acuto’s bespoke script service is a convenient and powerful solution to improving various aspects of your company’s ad management.
Auto-SQR Script FAQ
#1. What does SQR mean in Google Ads?
SQR stands for ‘Search Query Report.’ It is a feature of Google Ads which shows which user search terms trigger an ad.
For example, if a keyword is “waterproof jacket”, a search term such as “best waterproof jacket under £200” might show up in your SQR as a triggered term.
#2. How do I improve keywords in Google Ads?
Here are a few things you can do to improve your keywords:
- Regularly monitor & analyse your keyword performance.
- Refine your keywords by removing underperforming or irrelevant keywords.
- Test and experiment with new keywords to expand your reach.
- Use negative keywords to exclude irrelevant search terms.
#3. What are negative keywords in Google Ads?
Negative keywords are specific words or phrases which you select to avoid your ad being triggered when a user searches for them.
You can utilise negative keywords to refine your targeting and ensure that your ads are only shown to the most relevant audience. For example, if you are selling luxury items, you may want to select “cheap” as a negative keyword.
#4. How do I use negative keywords in Google Ads?
To use negative keywords in Google Ads:
- Identify the irrelevant search terms you wish to exclude.
- Navigate to the KEYWORDS tab.
- Choose the campaign or ad group.
- Add the negative keywords.
- Specify match types if desired.
- Save changes.
- Monitor SQR for results.
If you encounter any issues while using the script, please contact us.