{"id":758,"date":"2017-02-10T11:37:59","date_gmt":"2017-02-10T07:37:59","guid":{"rendered":"https:\/\/optimizationup.com\/?p=758"},"modified":"2021-03-03T17:20:03","modified_gmt":"2021-03-03T13:20:03","slug":"facebook-bing-link-checker-script","status":"publish","type":"post","link":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/","title":{"rendered":"Facebook & Microsoft Ads Link Checker Script"},"content":{"rendered":"

Google has its own link checker script to monitor broken URLs for Google\u00a0Ads. However, when it comes to Facebook Ads<\/a> and other channels, it could be a bit challenging to find out broken links, essentially, that websites evolve, new pages get added, old pages are taken down, and links get broken and fixed. Keeping your campaigns in sync with the website is an ongoing battle for many advertisers, especially\u00a0if you are working on large accounts.<\/p>\n

To solve this issue for our clients, we’ve written a script that iterates\u00a0through all of your ads URLs and\u00a0notifies you through an email if any of your ads has any broken URLs. The script returns the status code for the fetched URLs, it considers only 200 a valid response code<\/a>\u00a0and the rest of the response codes get highlighted in red.<\/p>\n

404 shouldn’t be the only invalid response\u00a0code that you are looking at. 301 and 302 redirects usually lead to drop\u00a0the UTMs that you use to track FB campaigns performance on Google Analytics<\/a>. If the links UTMs are getting dropped, Facebook traffic will be attributed to the Direct source on GA. This is critical if you want to make sure you are basing your decisions on accurate data.<\/p>\n

You can use the script to scan any kind of URLs; Facebook<\/a>, Bing, Twitter, LinkedIn or Yahoo ads. So, let’s get down to business and discover how to use the script:<\/p>\n

How to use the script?<\/h5>\n

1- Fetch The Ads URLs into a Google Sheet<\/p>\n

You can do this manually, but this is not recommended. What’s highly recommend is you use an add-on that can connect to the ads platform (Facebook, Twitter, .. etc) and you can schedule it on a regular basis to fetch all of the URLs into a Google Sheet.
You can use Supermetrics<\/a>, it’s a\u00a0really powerful add-on that every marketer must have, it saves so much time, especially when it comes to reporting. You can schedule\u00a0a URL performance report that refreshes every day at a certain\u00a0time. In parallel, we will be scheduling the script to scan the refreshed URLs and sends an email if any errors found.<\/p>\n

2- Connect Google App Scrips to your Google Sheet<\/p>\n

Click Tools then \u201cScript Editor\u201d:-<\/p>\n

Now, the script editor is open:-<\/p>\n

\u00a0<\/p>\n

Delete any code in the script editor and paste the code below and don’t forget to name and save your project.<\/p>\n

\/***************************************************\n* Facebook Link Checker Script\n* Version 1.0\n* Created By: Ahmed Ali\n*https:\/\/optimizationup.com\/\n****************************************************\/\n\nfunction myFunction() {\n\nvar email = \"Add your Email Here\";\nvar urlColumn = \"A\";\/\/ Change if you want to change the URL column\nvar resultsColumn = \"E\"; \/\/ Change if you want to change the result column\n\nvar ss = SpreadsheetApp.getActiveSpreadsheet();\nvar sheet = ss.getActiveSheet();\nvar sheetURL = ss.getUrl();\nvar lastRow = sheet.getLastRow();\nvar data = sheet.getRange( urlColumn + 1 + \":\" + urlColumn + lastRow).getValues();\n\nsheet.getRange(resultsColumn + 1 + \":\" + resultsColumn + lastRow).clearContent().clearFormat();\nsheet.getRange(resultsColumn + 1 ).setValue(\"Status Code\");\n\nvar results = [];\nvar infected = [];\n\nfor (i in data) {\n\n var [urls] = data[i];\n\nif (i == 0) {\n continue;\n }\n\nif (urls == \"\") {\n break;\n}\n\n else {\n\n results.push(statuscode(urls));\n }\n}\n\n\nfor ( var i = 0; i < results.length; i++) {\n\nvar r = i + 2;\n\nsheet.getRange(resultsColumn + r).setValue(results[i]);\n\n if (results[i] != 200) {\n \n sheet.getRange(resultsColumn + r).setBackground(\"red\");\n \n infected.push(results[i]);\n\n }\n}\n\nvar numOfErrors = infected.length; \n\n if(infected.length > 0){\n\n MailApp.sendEmail( email , \"Facebook URLs Checker Script! \", \"Your Ads have \" + numOfErrors + \" URLs with errors. Please visit the spreadsheet below for more details: \" + sheetURL);\n\n } \n}\n\nfunction statuscode(url) {\n try {\n var response = UrlFetchApp.fetch(url, {\n muteHttpExceptions: true,\n followRedirects: false,\n\n });\n return response.getResponseCode();\n } catch (error) {\n\n return \"Error\";\n }\n}\n<\/pre>\n
3- Configure the Script<\/p>\n
You need to configure the script based on your needs to determine which column has the URLs and which column to write the results to.<\/p>\n
\"\"<\/p>\n
In the screenshot above, the URLs that we want to check are present in column A, that’s why we set the urlColumn equal to A<\/p>\n
var urlColumn = \"A\";<\/pre>\n
We also want to return the results to column \u00a0“E”, so we assigned the value E\u00a0to the resultsColumn variable<\/p>\n
var resultsColumn = \"E\";<\/pre>\n
Finally, you can add your email:-<\/p>\n
var email = \"Add your Email Here\";<\/pre>\n
4- Schedule the Script<\/p>\n
Schedule the script hourly or daily to iterate through the ads URLs. Please make sure that the script only runs after the add-on schedule that you will be used to fetch new URLs every time.\u00a0<\/p>\n
Each time the script runs, it automatically sends an email with the number of errors and the spreadsheet URL as see below:-<\/p>\n
Feel free to leave any comments below or contact me, if you have any questions.<\/p>\n
\u00a0<\/p>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Google has its own link checker script to monitor broken URLs for Google\u00a0Ads. However, when it comes to Facebook Ads and other channels, it could be a bit challenging to find out broken links, essentially, that websites evolve, new pages get added, old pages are taken down, and links get broken and fixed. Keeping your…<\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":1419,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[42],"tags":[36,38,35],"class_list":["post-758","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analyze","tag-facebook-ads","tag-paid-social","tag-search"],"yoast_head":"\nFacebook & Microsoft Ads Link Checker Script | Optimization Up<\/title>\n<meta name=\"description\" content=\"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Facebook & Microsoft Ads Link Checker Script | Optimization Up\" \/>\n<meta property=\"og:description\" content=\"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched\" \/>\n<meta property=\"og:url\" content=\"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/\" \/>\n<meta property=\"og:site_name\" content=\"Optimization Up\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/A7med.3lii\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-10T07:37:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-03T13:20:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Ahmed Ali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@A7med_3ly\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ahmed Ali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/\"},\"author\":{\"name\":\"Ahmed Ali\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"headline\":\"Facebook & Microsoft Ads Link Checker Script\",\"datePublished\":\"2017-02-10T07:37:59+00:00\",\"dateModified\":\"2021-03-03T13:20:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/\"},\"wordCount\":572,\"commentCount\":5,\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/MIcrosoft-Facebook.jpg\",\"keywords\":[\"Facebook Ads\",\"Paid Social\",\"Search Engine Marketing\"],\"articleSection\":[\"Analyze\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/\",\"name\":\"Facebook & Microsoft Ads Link Checker Script | Optimization Up\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/MIcrosoft-Facebook.jpg\",\"datePublished\":\"2017-02-10T07:37:59+00:00\",\"dateModified\":\"2021-03-03T13:20:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\"},\"description\":\"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#primaryimage\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/MIcrosoft-Facebook.jpg\",\"contentUrl\":\"https:\\\/\\\/optimizationup.com\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/MIcrosoft-Facebook.jpg\",\"width\":1000,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/facebook-bing-link-checker-script\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/optimizationup.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Facebook & Microsoft Ads Link Checker Script\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#website\",\"url\":\"https:\\\/\\\/optimizationup.com\\\/\",\"name\":\"Optimization Up\",\"description\":\"Advanced Optimization & Analytics Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/optimizationup.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/optimizationup.com\\\/#\\\/schema\\\/person\\\/75b8aaa058bc4d0630cc7e138840f768\",\"name\":\"Ahmed Ali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g\",\"caption\":\"Ahmed Ali\"},\"description\":\"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.\",\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/A7med.3lii\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/a7med-ali\\\/\",\"https:\\\/\\\/x.com\\\/A7med_3ly\"],\"url\":\"https:\\\/\\\/optimizationup.com\\\/author\\\/a7med\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Facebook & Microsoft Ads Link Checker Script | Optimization Up","description":"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/","og_locale":"en_US","og_type":"article","og_title":"Facebook & Microsoft Ads Link Checker Script | Optimization Up","og_description":"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched","og_url":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/","og_site_name":"Optimization Up","article_author":"https:\/\/www.facebook.com\/A7med.3lii","article_published_time":"2017-02-10T07:37:59+00:00","article_modified_time":"2021-03-03T13:20:03+00:00","og_image":[{"width":1000,"height":500,"url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg","type":"image\/jpeg"}],"author":"Ahmed Ali","twitter_card":"summary_large_image","twitter_creator":"@A7med_3ly","twitter_misc":{"Written by":"Ahmed Ali","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#article","isPartOf":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/"},"author":{"name":"Ahmed Ali","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"headline":"Facebook & Microsoft Ads Link Checker Script","datePublished":"2017-02-10T07:37:59+00:00","dateModified":"2021-03-03T13:20:03+00:00","mainEntityOfPage":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/"},"wordCount":572,"commentCount":5,"image":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg","keywords":["Facebook Ads","Paid Social","Search Engine Marketing"],"articleSection":["Analyze"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/","url":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/","name":"Facebook & Microsoft Ads Link Checker Script | Optimization Up","isPartOf":{"@id":"https:\/\/optimizationup.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#primaryimage"},"image":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#primaryimage"},"thumbnailUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg","datePublished":"2017-02-10T07:37:59+00:00","dateModified":"2021-03-03T13:20:03+00:00","author":{"@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768"},"description":"Learn how to find out broken links of your Facebook Ads or Bing campaigns using the Link Checker Script. The script returns the status code for the fetched","breadcrumb":{"@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#primaryimage","url":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg","contentUrl":"https:\/\/optimizationup.com\/wp-content\/uploads\/2017\/02\/MIcrosoft-Facebook.jpg","width":1000,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/optimizationup.com\/facebook-bing-link-checker-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/optimizationup.com\/"},{"@type":"ListItem","position":2,"name":"Facebook & Microsoft Ads Link Checker Script"}]},{"@type":"WebSite","@id":"https:\/\/optimizationup.com\/#website","url":"https:\/\/optimizationup.com\/","name":"Optimization Up","description":"Advanced Optimization & Analytics Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/optimizationup.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/optimizationup.com\/#\/schema\/person\/75b8aaa058bc4d0630cc7e138840f768","name":"Ahmed Ali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/68727300a58d1891a3dda2e17e66e7ebd42c80226d3006db77b4814bc14d4d43?s=96&d=mm&r=g","caption":"Ahmed Ali"},"description":"Entrepreneur focused on building MarTech products that bridge the gap between marketing and technology. Check out my latest products Markifact,\u00a0 Marketing Auditor & GA4 Auditor - discover all my products here.","sameAs":["https:\/\/www.facebook.com\/A7med.3lii","https:\/\/www.linkedin.com\/in\/a7med-ali\/","https:\/\/x.com\/A7med_3ly"],"url":"https:\/\/optimizationup.com\/author\/a7med\/"}]}},"_links":{"self":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/758","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/comments?post=758"}],"version-history":[{"count":1,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/758\/revisions"}],"predecessor-version":[{"id":1420,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/posts\/758\/revisions\/1420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media\/1419"}],"wp:attachment":[{"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/media?parent=758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/categories?post=758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimizationup.com\/wp-json\/wp\/v2\/tags?post=758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}