Online Tools

Destination URL Checker with Email Report Script

This script gets all Destination URLs from your account and creates a unique list of URLs to check. It will keep a list of 404 URLs and it will email you the results when broken links are found. Add and paste the code into your scripts then replace PutYourEmailHere@YourEmail.com with your own email address. Do a preview or schedule it to run weekly or in any time frame that you wish to check URLs.

Get the URL Checker Script For Free

Quickly Add Callout Extensions to Campaigns Script

This script creates Callout extensions on all campaign levels. You can use this to list out all of your Callout extensions and quickly add them to your account. Callout text should be identified in createCallouts() in withText(“This Is Your Callout Text.“). You can modify your campaign selection as to your preference. Logs will verify if the extensions was created

Get the Callout Script For Free

Keyword Idea Generator with Google Sheet Report Script

This script uses Google auto-complete to find phrase keyword ideas and negative keyword ideas. It generates phrase keywords ideas based on a base target keyword and it will email you the results on a Google Docs spreadsheet for easy addition to your existing campaigns or ad groups. A date range and a base keyword should be added to the script. I’ll send clear email instructions along with this script.

Get the Keyword Generator Script For Free

\ – Place it before an Existing RegEx Character to turn it into plain text. searchmarketingjoe\.com prevents . from being a RegEx
| – Means “or”. Jo|Joe will match Jo or Joe
? – Will match none and the previous character. Nitz?y matches both Nitz and Nitzy
( ) – A grouping character that should work just like they are used basic algebra equations. Jo(e|seph) will match Joe and Joseph
[ ] – Creates lists. B[oau]n will match Bun, Bon and Ban.
        [a-z] – Matches all lower case letters
        [A-Z] – Mathces all upper case letters
        [0-9] – Matches all digits
        [a-zA-Z] – Matches all letters of cases
        [a-zA-Z0-9] – Matches all letter cases and digits
{ } – Repeats the last characters of last RegEx characters. e.g. [0-9]{1,2} will match all digits from 0-99
. – Can be used to match all special characters, digits, and letters. Ni*tz will match Niitz, Ni8tz, Ni#tz, …
+ – Used to match one or more of the character before it. Nii+tzy will match Niitzy, Niiiiitzy and Niiiiiiiiiiiiiiitzy.
* – Used to match 0 or more of the character before it. Nii*tzy will match Nitzy, Niitzy, Niiiiitzy and Niiiiiiiiiiiiiiitzy.
.* – Used to match everything
^ –  Put in front of RegEx strings to match exactly with how strings are created. ^Joe matches Joe but not SEMJoe.
$ – Only matches the characters in front of it. Jo$ matches Jo but not Joseph.

Mobile Bid Adjustment Formula = (Mobile Conversion Rate / Desktop Conversion Rate) – 1

Target CPC = Conversion Rate × Target CPA

Top of the Page Impression Share = (Impression Share x Top of the Page Rate) / 100

Short Term Conversion Value = Average deal revenue x Profit Margin x %Leads that Convert to a deal

Conversion Value Gain through word-of-mouth = Conversion Value x (Percent gain from Word of Mouth +.100)

Lifetime Customer Value = (Average deal revenue + Repeat Business Revenue) x (Profit Margin)

Lifetime Value Gain through word-of-mouth =
Lifetime Value x %Leads that convert to a deal x (Word of Mouth gain +.100)

Value Per Click = Conversion Value x Conversion Rate

Lifetime Value Per Click = Lifetime Value x Conversion Rate

Target Cost Per Acquisition = Average Order Value – Wholesale Cost

Target Max CPC Bid = Conversion Rate x Target Cost Per Acquisition