Skip to main content

Posts

Quick AdWords keyword match formatting in Google Docs and Excel

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...

Logo for a quilting business (Inkscape)

A friend requested a logo for her home quilting business named QuiltDat! (The spelling, I was told, is a Louisiana thing.) No color specified, no style specified. I like this kind of design challenge – you're basically free to come up with your take on the business name and no pressure for perfection (no time limits, although I think they wanted this quick). The risk, though, is that those who requested it may not like your design. Collaboration is still the best way to design a logo since the ones who will end up using the logo know their business and usually know what they want (or, at least, will have no one else to blame if the design turns out bad since they were in on it). Here's the logo (no color decisions yet – they like the yellow one over gray, although I meant for this to be like Japanese family crests or kamon/mon , where it's usually white or light colored over a darker colored background): It represents a "sunrise" letter 'Q' using q...

Heron Crest Tutorial (Inkscape)

I have been reading the medieval Japanese-inspired novel series by Lian Hearn, the Tales of the Otori on Calibre eBook viewer. But I don't care much for the existing covers I can find on Google. They're too ... elaborate for my tastes: I needed to make my own eBook cover for Across The Nightingale Floor . My idea was to have a single emblem—​the heron kamon (family crest) of the Otori as the main decoration on the book cover and graphic accents on the virtual "spine" (changeable to other crests and color motifs relevant to the story for the remaining books). But first, I had to find a heron kamon. The Japanese word for "heron" is "sagi" . I googled for "heron crest" or "heron kamon" or "sagi kamon", hoping to find a suitable and authentic emblem to include in the cover. I found one , a triple-heron done in the paulownia (kiri) leaf style: I wanted the round look of the crane crests like the one seen on Jap...

Create 'Fake Identity Generator'-style email addresses and passwords in Excel

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...

Inkscape Tutorial: 'Maayo'

[Note: This was originally posted as a Facebook Note on  December 24, 2014 at 12:44pm . I lost several images on old tutorials in the Facebook Note format – maybe because images get moved around. I'm recreating them here. Although the software examples are outdated, the principles used can still apply with newer software.] “Maayo” is the first half of the Cebuano Bisaya greeting of “Maayo’ng Pasko”, literally “Good Christmas” but some of you might prefer Happy Hanukkah, Diwali, Eid al-Adha or a simple well-wishing so I kept it open-ended. “Maayo” – good, happy, best, something something – as long as it makes you well. The “birds” are the Baybayin syllable characters for Ma+A+Yo. The Baybayin was supposed to be generic calligraphic pen writing (I think I’ll get a cheap graphics tablet next year) but then I noticed they look like birds so I ended up with bird forms. Step 1: Set up page When you fire up Inkscape , the default document size is US Letter Size. I decided to go ...