Posted on

List of placenames in New Zealand for SEO

Sometimes during my work as an online marketer I need a list of NZ placenames. Usually this is so I can scan the clients analytics account to see how much activity there is – or how much traffic they are receiving – around search traffic that contains a placename. Trouble is it is quite tricky as there can be many placenames, and it requires a strong regular expression to search the account.

List of Main Cities in New Zealand

Auckland
Birkenhead
Christchurch
Dunedin
East Coast Bays
Gisborne
Hamilton
Hastings
Invercargill
Lower Hutt
Manukau
Mt Albert
Napier
Nelson
New Plymouth
North Island
Palmerston North
Papakura
Papatoetoe
Porirua
Rotorua
South Island
Takapuna
Tamaki
Tauranga
Timaru
Upper Hutt
Waitemata
Wanganui
Wellington
Whanganui
Whangarei

Regex:

Auckland|Birkenhead|Christchurch|Dunedin|East Coast Bays|Gisborne|Hamilton|Hastings|Invercargill|Lower Hutt|Manukau|Mt Albert|Napier|Nelson|New Plymouth|North Island|Palmerston North|Papakura|Papatoetoe|Porirua|Rotorua|South Island|Takapuna|Tamaki|Tauranga|Timaru|Upper Hutt|Waitemata|Wanganui|Wellington|Whanganui|Whangarei

Full List of All Placenames in New Zealand

 

Ahaura
Ahipara
Ahititi
Ahuroa
Akaroa
Akitio
Albany
Albert Town
Albury
Alexandra
Allanton
Amberley
Anakiwa
Aramoana
Aranga
Arapohue
Arrowtown
Arundel
Ashburton
Ashhurst
Ashley
Auckland
Auroa
Awanui
Balclutha
Balfour
Barrytown
Beachlands
Beaumont
Bell Block
Benhar
Benneydale
Birkenhead
Blackball
Blenheim
Bluff
Brighton
Brightwater
Broadwood
Bulls
Bunnythorpe
Cambridge
Canterbury
Canvastown
Carterton
Cheviot
Christchurch
Clarksville
Clevedon
Clinton
Clive
Clyde
Coatesville
Collingwood
Colville
Coroglen
Coromandel
Cromwell
Culverden
Cust
Dairy Flat
Dannevirke
Darfield
Dargaville
Dobson
Drury
Dunedin
Duntroon
East Coast Bays
Eastbourne
Edendale
Edgecumbe
Egmont Village
Eketahuna
Eltham
Ettrick
Fairhall
Fairlie
Featherston
Feilding
Flaxmere
Fox Glacier
Foxton
Foxton Beach
Frankton
Franz Josef
Geraldine
Gisborne
Glenorchy
Gore
Granity
Greymouth
Greytown
Grovetown
Haast
Hakataramea
Halcombe
Hamilton
Hampden
Hanmer Springs
Hari Hari
Hastings
Haupiri
Havelock
Havelock North
Hawea
Hawera
Helensville
Henley
Herbert
Herekino
Hikuai
Hikurangi
Hikutaia
Hinuera
Hokitika
Hope
Horeke
Horowhenua
Houhora
Howick
Huapai
Huiakama
Huirangi
Hukerenui
Hunterville
Huntly
Hurleyville
Inangahua Junction
Inglewood
Invercargill
Jacobs River
Kaiapoi
Kaihu
Kaikohe
Kaikoura
Kaimata
Kaingaroa
Kaipara Flats
Kaitaia
Kaitangata
Kaiwaka
Kakanui
Kakaramea
Kaniere
Kaponga
Karamea
Karetu
Karitane
Katikati
Kaukapakapa
Kauri
Kawakawa
Kawerau
Kennedy Bay
Kerikeri
Kihikihi
Kingston
Kinloch
Kokatahi
Kokopu
Koromiko
Kumara
Kumeu
Kurow
Lawrence
Leeston
Leigh
Lepperton
Levin
Lincoln
Linkwater
Little River
Lower Hutt
Luggate
Lumsden
Lyttelton
Makahu
Manaia
Manakau
Manapouri
Mangakino
Mangamuka
Mangatoki
Mangawhai
Manukau
Manurewa
Manutahi
Mapua
Maraetai
Marco
Marlborough
Maromaku
Marsden Bay
Martinborough
Marton
Maruia
Masterton
Matakana
Matakohe
Matamata
Matapu
Matarangi
Matarau
Matata
Mataura
Matihetihe
Maungakaramea
Maungatapere
Maungaturoto
Mayfield
Meremere
Methven
Middlemarch
Midhirst
Millers Flat
Milton
Mimi
Moana
Moenui
Moeraki
Moerewa
Mokau
Mokoia
Morrinsville
Mosgiel
Mossburn
Motatau
Motueka
Mount Maunganui
Mount Somers
Mt Albert
Murchison
Murupara
Napier
Naseby
Nelson
New Brighton
New Plymouth
Ngaere
Ngamatapouri
Ngapara
Ngaruawahia
Ngataki
Ngongotaha
Ngunguru
Nightcaps
Norfolk
Normanby
North Island
Oakura
Oamaru
Oban
Ohaeawai
Ohakune
Ohangai
Ohoka
Ohope Beach
Ohura
Okaihau
Okato
Omanaia
Omarama
Omata
Omokoroa
Onewhero
Opononi
Opotiki
Opua
Opunake
Oratia
Orewa
Oromahoe
Oruaiti
Otago
Otaika
Otaki
Otakou
Otautau
Otiria
Otorohanga
Owaka
Oxford
Paekakariki
Paeroa
Pahiatua
Paihia
Pakaraka
Pakiri
Pakotai
Palmerston
Palmerston North
Pamapuria
Panguru
Papakura
Papamoa
Paparoa
Paparore
Papatoetoe
Parakai
Paraparaumu
Paremoremo
Pareora
Paroa
Parua Bay
Patea
Pauanui
Pauatahanui
Peka Peka
Pembroke
Peria
Petone
Picton
Piopio
Pipiwai
Pirongia
Pleasant Point
Plimmerton
Porirua
Poroti
Port Chalmers
Portland
Portobello
Pukekohe
Pukepoto
Pukerua Bay
Pukeuri
Purua
Putaruru
Queenstown
Raetihi
Raglan
Rahotu
Rai Valley
Ramarama
Ranfurly
Rangiora
Rapaura
Ratapiko
Raumati
Rawene
Rawhitiroa
Reefton
Renwick
Richmond
Riverhead
Riverlands
Riversdale Beach
Riverton
Riwaka
Rolleston
Ross
Rotorua
Roxburgh
Ruatoria
Ruawai
Runanga
Russell
Saint Andrews
Saint Arnaud
Saint Bathans
Sanson
Seacliff
Seddon
Seddonville
Shannon
Sheffield
Silverdale
Snells Beach
South Island
South Otago
South Taranaki
Southland
Spring Creek
Springfield
Springston
Stirling
Stratford
Taharoa
Taieri Mouth
Taihape
Taipa-Mangonui
Tairua
Takaka
Takapuna
Tamaki
Tangiteroria
Tangowahine
Tapanui
Tapawera
Tapora
Tapu
Taradale
Tauhoa
Taumarunui
Taupaki
Taupo
Tauranga
Tauraroa
Tautoro
Te Anau
Te Arai
Te Aroha
Te Awamutu
Te Hapua
Te Horo
Te Kao
Te Kopuru
Te Kuiti
Te Poi
Te Puke
Te Puru
Te Rerenga
Temuka
Thames
Tikorangi
Timaru
Tinopai
Tinwald
Tirau
Titoki
Tokanui
Tokarahi
Toko
Tokoroa
Tolaga Bay
Tomarata
Towai
Tuai
Tuakau
Tuamarina
Tuatapere
Turangi
Twizel
Umawera
Upper Hutt
Upper Moutere
Urenui
Uruti
Waddington
Waharoa
Waiharara
Waiheke Island
Waihi
Waihi Beach
Waihola
Waikanae
Waikawa
Waikouaiti
Waikuku
Waima
Waimangaroa
Waimate
Waimate North
Waimauku
Wainui
Wainuiomata
Waioneke
Waiotira
Waiouru
Waipawa
Waipukurau
Wairakei
Wairau Valley
Wairoa
Waitahuna
Waitara
Waitaria Bay
Waitati
Waitemata
Waitoa
Waitoki
Waitoriki
Waitotara
Waiuku
Waiwera
Wakefield
Wallacetown
Walton
Wanaka
Wanganui
Ward
Wardville
Warkworth
Warrington
Waverley
Wellington
Wellsford
Weston
Westport
Whakamaru
Whakatane
Whananaki
Whangamata
Whangamomona
Whanganui
Whangarei
Whangarei Heads
Whangaruru
Whataroa
Whatuwhiwhi
Whenuakite
Whenuakura
Whiritoa
Whitby
Whitford
Whitianga
Willowby
Wimbledon
Winchester
Windsor
Windwhistle
Winscombe
Winton
Woodend
Woodhill
Woodville
Wyndham

 Regex:

Ahaura|Ahipara|Ahititi|Ahuroa|Akaroa|Akitio|Albany|Albert Town|Albury|Alexandra|Allanton|Amberley|Anakiwa|Aramoana|Aranga|Arapohue|Arrowtown|Arundel|Ashburton|Ashhurst|Ashley|Auckland|Auroa|Awanui|Balclutha|Balfour|Barrytown|Beachlands|Beaumont|Bell Block|Benhar|Benneydale|Birkenhead|Blackball|Blenheim|Bluff|Brighton|Brightwater|Broadwood|Bulls|Bunnythorpe|Cambridge|Canterbury|Canvastown|Carterton|Cheviot|Christchurch|Clarksville|Clevedon|Clinton|Clive|Clyde|Coatesville|Collingwood|Colville|Coroglen|Coromandel|Cromwell|Culverden|Cust|Dairy Flat|Dannevirke|Darfield|Dargaville|Dobson|Drury|Dunedin|Duntroon|East Coast Bays|Eastbourne|Edendale|Edgecumbe|Egmont Village|Eketahuna|Eltham|Ettrick|Fairhall|Fairlie|Featherston|Feilding|Flaxmere|Fox Glacier|Foxton|Foxton Beach|Frankton|Franz Josef|Geraldine|Gisborne|Glenorchy|Gore|Granity|Greymouth|Greytown|Grovetown|Haast|Hakataramea|Halcombe|Hamilton|Hampden|Hanmer Springs|Hari Hari|Hastings|Haupiri|Havelock|Havelock North|Hawea|Hawera|Helensville|Henley|Herbert|Herekino|Hikuai|Hikurangi|Hikutaia|Hinuera|Hokitika|Hope|Horeke|Horowhenua|Houhora|Howick|Huapai|Huiakama|Huirangi|Hukerenui|Hunterville|Huntly|Hurleyville|Inangahua Junction|Inglewood|Invercargill|Jacobs River|Kaiapoi|Kaihu|Kaikohe|Kaikoura|Kaimata|Kaingaroa|Kaipara Flats|Kaitaia|Kaitangata|Kaiwaka|Kakanui|Kakaramea|Kaniere|Kaponga|Karamea|Karetu|Karitane|Katikati|Kaukapakapa|Kauri|Kawakawa|Kawerau|Kennedy Bay|Kerikeri|Kihikihi|Kingston|Kinloch|Kokatahi|Kokopu|Koromiko|Kumara|Kumeu|Kurow|Lawrence|Leeston|Leigh|Lepperton|Levin|Lincoln|Linkwater|Little River|Lower Hutt|Luggate|Lumsden|Lyttelton|Makahu|Manaia|Manakau|Manapouri|Mangakino|Mangamuka|Mangatoki|Mangawhai|Manukau|Manurewa|Manutahi|Mapua|Maraetai|Marco|Marlborough|Maromaku|Marsden Bay|Martinborough|Marton|Maruia|Masterton|Matakana|Matakohe|Matamata|Matapu|Matarangi|Matarau|Matata|Mataura|Matihetihe|Maungakaramea|Maungatapere|Maungaturoto|Mayfield|Meremere|Methven|Middlemarch|Midhirst|Millers Flat|Milton|Mimi|Moana|Moenui|Moeraki|Moerewa|Mokau|Mokoia|Morrinsville|Mosgiel|Mossburn|Motatau|Motueka|Mount Maunganui|Mount Somers|Mt Albert|Murchison|Murupara|Napier|Naseby|Nelson|New Brighton|New Plymouth|Ngaere|Ngamatapouri|Ngapara|Ngaruawahia|Ngataki|Ngongotaha|Ngunguru|Nightcaps|Norfolk|Normanby|North Island|Oakura|Oamaru|Oban|Ohaeawai|Ohakune|Ohangai|Ohoka|Ohope Beach|Ohura|Okaihau|Okato|Omanaia|Omarama|Omata|Omokoroa|Onewhero|Opononi|Opotiki|Opua|Opunake|Oratia|Orewa|Oromahoe|Oruaiti|Otago|Otaika|Otaki|Otakou|Otautau|Otiria|Otorohanga|Owaka|Oxford|Paekakariki|Paeroa|Pahiatua|Paihia|Pakaraka|Pakiri|Pakotai|Palmerston|Palmerston North|Pamapuria|Panguru|Papakura|Papamoa|Paparoa|Paparore|Papatoetoe|Parakai|Paraparaumu|Paremoremo|Pareora|Paroa|Parua Bay|Patea|Pauanui|Pauatahanui|Peka Peka|Pembroke|Peria|Petone|Picton|Piopio|Pipiwai|Pirongia|Pleasant Point|Plimmerton|Porirua|Poroti|Port Chalmers|Portland|Portobello|Pukekohe|Pukepoto|Pukerua Bay|Pukeuri|Purua|Putaruru|Queenstown|Raetihi|Raglan|Rahotu|Rai Valley|Ramarama|Ranfurly|Rangiora|Rapaura|Ratapiko|Raumati|Rawene|Rawhitiroa|Reefton|Renwick|Richmond|Riverhead|Riverlands|Riversdale Beach|Riverton|Riwaka|Rolleston|Ross|Rotorua|Roxburgh|Ruatoria|Ruawai|Runanga|Russell|Saint Andrews|Saint Arnaud|Saint Bathans|Sanson|Seacliff|Seddon|Seddonville|Shannon|Sheffield|Silverdale|Snells Beach|South Island|South Otago|South Taranaki|Southland|Spring Creek|Springfield|Springston|Stirling|Stratford|Taharoa|Taieri Mouth|Taihape|Taipa-Mangonui|Tairua|Takaka|Takapuna|Tamaki|Tangiteroria|Tangowahine|Tapanui|Tapawera|Tapora|Tapu|Taradale|Tauhoa|Taumarunui|Taupaki|Taupo|Tauranga|Tauraroa|Tautoro|Te Anau|Te Arai|Te Aroha|Te Awamutu|Te Hapua|Te Horo|Te Kao|Te Kopuru|Te Kuiti|Te Poi|Te Puke|Te Puru|Te Rerenga|Temuka|Thames|Tikorangi|Timaru|Tinopai|Tinwald|Tirau|Titoki|Tokanui|Tokarahi|Toko|Tokoroa|Tolaga Bay|Tomarata|Towai|Tuai|Tuakau|Tuamarina|Tuatapere|Turangi|Twizel|Umawera|Upper Hutt|Upper Moutere|Urenui|Uruti|Waddington|Waharoa|Waiharara|Waiheke Island|Waihi|Waihi Beach|Waihola|Waikanae|Waikawa|Waikouaiti|Waikuku|Waima|Waimangaroa|Waimate|Waimate North|Waimauku|Wainui|Wainuiomata|Waioneke|Waiotira|Waiouru|Waipawa|Waipukurau|Wairakei|Wairau Valley|Wairoa|Waitahuna|Waitara|Waitaria Bay|Waitati|Waitemata|Waitoa|Waitoki|Waitoriki|Waitotara|Waiuku|Waiwera|Wakefield|Wallacetown|Walton|Wanaka|Wanganui|Ward|Wardville|Warkworth|Warrington|Waverley|Wellington|Wellsford|Weston|Westport|Whakamaru|Whakatane|Whananaki|Whangamata|Whangamomona|Whanganui|Whangarei|Whangarei Heads|Whangaruru|Whataroa|Whatuwhiwhi|Whenuakite|Whenuakura|Whiritoa|Whitby|Whitford|Whitianga|Willowby|Wimbledon|Winchester|Windsor|Windwhistle|Winscombe|Winton|Woodend|Woodhill|Woodville|Wyndham
Posted on

Evidence of the effects of the Google Farmer Update

So there has been a fair bit of talk in the SEO community about the so called Google Farmer / Panda update and its effects.  The idea with this update was to reduce webspam in the results, specifically those shallow informational articles (shallow How To’s as so forth) that used to appear are now getting pushed down the listings thankfully.  It was also targetting content farms (hence the “Farmer” label applied to the udpate) which basically are sites more intended for search engines than actual humans, which probably sell links or banner ads to make money, rather than have an actual product.

Personally, I think I like the change. I’ve been doing some searches for informational How To subjects and have been finding some excellent articles in high positions that really do answer my question. All of the sites I look after have seen an improvement in organic traffic from Google – see the screenshots from analytics below covering the period this was supposed to have rolled out. It should be noted that most of these sites have very clean white-hat link profiles, so go figure.

Google actually makes about 200 algo changes per year so this all needs to be taken in context, however Google themselves said this affects like 11% of the resutls which is humongous.

Damnative.com
Damnative.com up +31.0%
Funk.co.nz
Funk.co.nz up +13.2%
Youthline.co.nz
Youthline.co.nz up +49.5%
Posted on

“Unavailable After” Google Meta Tag

This one’s handy for those time-specific marketing pages. So for instance, if you add this tag to a page:

< META NAME=”GOOGLEBOT” CONTENT=”unavailable_after: 31-Dec-2013 23:59:59 EST” >

Then the page in question will vanish from the Google cache on the 1st Jan 2014 EST. You’ll no longer appear in the results. Could be fairly neat for some time-critical promotions that you’d like to have appear in search results but want to save yourself the hassle of switching the current page to a version with NOINDEX tags shortly after the thing ends.

This also helps get the job done, since you never can be quite sure when the crawler will come back to your page and see the NOINDEX tags, so this is nice since you can just set it and forget and make no changes to the page when the promotion ends. Nifty.

Posted on

How to show all sites in Google Webmaster Tools

The new interface for Google Webmaster Tools is currently being rolled out. My main complaint was the loss of the ability to see all sites and get to any site with one click from a single view was removed. However, thanks to Susan Moskwa (a Googler), I now have a temporary hack that will let me see all sites:

Just add &grid.s=500 to the end of the URL:

https://www.google.com/webmasters/tools/new/home?hl=en&grid.s=500

Groovy – I can see all the sites in one hit!

Posted on

MS Excel function to convert URL into domain name

This function can be used to convert a URL such as http://www.funk.co.nz/ into just www.funk.co.nz

Here it is:

=LEFT(RIGHT(C5,(LEN(C5)-7)),(SEARCH(“/”,RIGHT(C5,(LEN(C5)-7)))-1))

Where cell C5 contains the URL, this formula should output just the domain name. If the URL is secure, you will need to increase the -7 to a -8 (http:// is 7 chars, whereas https:// is 8 chars).

Note: My blog software is converting the quotes so you will need to re-type the quote marks in the centre of the formula after pasting into Excel.

Enhanced Version that support https URLs:

=LEFT(RIGHT(A1,(LEN(A1)-if(isnumber(search(“https”, A1)), 8, 7))),(SEARCH(“/”,RIGHT(A1,(LEN(A1)-if(isnumber(search(“https”, A1)), 8, 7))))-1))