Select your language
Keep track of your Quality Score in Bing Ads / Microsoft Advertising. Without reporting to a Google sheet.
Start Now!
A lot of PPC marketers use the Google Ads script for Quality Score tracking. And we agree, it's a great script to keep focussing on the quality in your accounts. So of course, you want to do this as well in your Microsoft Advertising accounts. But that's a bit trickier. Because Bing Ads scripts don't have a connection to Google Sheets.
Frederick Vallaeys published a script for Bing Ads to keep track of the quality score in your account. Because the output can't be synced with Google Sheets, the results will be logged in the script history. You have to check this history every once in a while to keep an eye on your QS in Microsoft Advertising.
To get started with this script, all you have to do is copy-paste. And then just check the log every day, to keep track of you Quality Score in Bing Ads.
function main() {
var time = "LAST_30_DAYS";
var totalImpressions = 0;
var totalQs = 0;
var iterator = BingAdsApp.campaigns().forDateRange(time).withCondition("Impressions > 0").get();
while(iterator.hasNext()) {
var campaign = iterator.next();
var impressions = campaign.getStats().getImpressions();
totalImpressions += impressions;
}
Logger.log("The account had " + totalImpressions + " impressions (" + time + ")");
var kwIter = BingAdsApp.keywords().forDateRange(time).withCondition("Impressions > 0").get();
while(kwIter.hasNext()) {
var keyword = kwIter.next();
var kwText = keyword.getText();
var impressions = keyword.getStats().getImpressions();
var qs = keyword.getQualityScore();
var qsContribution = qs / totalImpressions * 100;
Logger.log(kwText + " " + impressions + " " + qs + " " + qsContribution);
totalQs += qsContribution;
}
Logger.log("Account QS: " + totalQs);
}
Adsscripts.com is all about sharing knowledge. In the current market, PPC specialists like to keep their knowledge and experience to themselves. We're convinced that sharing knowledge can ensure that everyone gets better at their work. We want to change this by sharing our knowledge about scripts with everyone.
Do you also want to contribute? We are open to new ideas and feedback on everything you find on Adsscripts.com.
