Man On A Street

If you often work on AdWords text ads, you'll like this little spreadsheet that will make the keyword matching tags automatically for you. As you know, the matching convention for keywords is: Exact Match Phrase Match Modified Broad Match [this is a keyword] "this is a keyword" +this +is +a +keyword Imagine how tiresome doing this would be, for every word, if you have hundreds of keywords (or search terms). Here's a Google spreadsheet that will do this for you: Keyword Match Tagger . You just paste your search terms (one search term per line) on the "Keyword" column, and the other columns will populate with the keyword matching tags which you can then copy to your own spreadsheet. If you pasted in keywords with duplicates, those will be highlighted in red. Since modified broad match does not consider the order of the words in a search term, the "MMB Duplicate Detector" column will rearrange the words alphabetically in a search term and highl...

Last week I needed to compile a list of several hundred fake customer names with fake (but verifiable) email addresses and passwords to test a client's eCommerce site. Fake data generators At that time, I knew of only two online identity generators: Fake Identity Generator  (FIG) and GenerateData.com  (GD). By accepting three user-specified parameters (country, gender, age range) FIG outputs a lot of nice fake data, including disposable (but accessible) YopMail email addresses and relatively easy-to-remember passwords. However FIG doesn't provide free bulk identity generation so I had to generate and copy-paste identities one at a time – a very slow process – along with manually creating accounts using these fake identities at the client site (I had no access to the client content management system so I couldn't bulk register the fake identities). On the other hand, GD allows bulk generation of identities (up to 100 at a time) for free (and with more paramete...