Geeky

Mailchimp Bulk User Delete

I have found many times where I’ve wanted to mass delete users from a Mailchimp list – and this isn’t something mailchimp provide, so I’ve written a script that uses Mailchimp’s very good API to delete email addresses in bulk.

I’ve put this online for general use: Mailchimp bulk user delete
Somebody pointed out – how can can they trust this form? So I have put the code here – https://github.com/sprthompson/mailchimp-bulk-user-delete

Just create a text file of email addresses, find your API key (how to do that) and list Unique ID (how to do that), and then you’re off.

I’ll create a few other simple but useful tools in the next few days.

NB – use sensibly.

Linking multiple adwords accounts to analytics

Just posting this because so many other articles online seem out of date when I was searching for this issue.

With the ‘old’ version of Google Analytics, you could only have a 1:1 relationship between Adwords and Analytics accounts, so if you maintained multiple analytics accounts you would need to set up multiple adwords accounts, or manually create tracking URLs and deal with the lack of auto-tagging data.

The new version of Analytics allows you to link multiple adwords accounts to Google analytics, and this blog post tells you how!

how to get a google+ account

If you want a google plus account it’s easy to get…
  1. Get a gmail account.
  2. Get somebody in google+ to tag you (using your gmail address) in a photo.
  3. Done.

iPads in the cockpit…

Kind of scary?

Google Ads Under Review for longer than ever!

Anybody else experiencing really long waiting times while Google review their adwords image and flash ads?
My banners have been under review by Google for nearly 2 weeks now, this is the second time in as many months that new ads have been on hold for ages!

Adding AdSense to my site increased visibility on Google.

I should firstly explain a little about myself, I am a real internet evangelist. Since creating my first ever website on Geocities, many many years ago, I’ve been hooked.

I like to run ‘experiments’ online, just trying out ideas, so I have a couple of domains I put stuff on, either trying new tools, mucking around with code, that kind of thing – I’m certainly no real web developer but I dream of turning some of my great ideas into real web products some day (and then using the cash to fund my addiction to flying!).

Getting to the point…

I added AdSense to one of my domains, to see what effect this had (on both revenue and generally Auto Pilot SEO aspects). I had wondered if adding AdSense would have a negative effect on SEO by making my content less appealing to users – I admit I don’t think my content is that great anyway.

I didn’t realise AdSense would increase my visibility on google by 100x!

Here is the evidence…

Firstly these are my impressions in Google AdSense – note I added ads to my site onĀ 14th March.

Impressions on Google AdSense

Impressions on Google AdSense (click to enlarge)

And here are my impressions on Google for the same period, according to Webmaster tools.

Impressions on Google Webmaster tools

Impressions on Google (click to enlarge)

You might have noticed from the above – I get 100x more impressions on Google! Great news? Well not if you look at the traffic.

Traffic to the website

Traffic according to Analytics (click to enlarge)

So what are my conclusions?

  • Adding Google AdSense to my site increased my impressions on Google. POSITIVE!
  • However the greater impressions did not lead to more traffic.

This is very interesting, it means with a greater visibility on Google I have an opportunity to turn those impressions into clicks. With the webmaster tools reports I can find out what keywords I am more visible for and make sure my content will appeal and get clicks.

If I don’t do this, not only is it a missed opportunity – but potentially it is worse. My effective click-through rate on Google is less than half of what it was before, so if Google optimise organic positions as they do with Google Adwords, this might result in worsening my overall site performance on Google.

So if anybody reads this, I hope you will give this a try and let me know what you find, or let me know if you know any more about this subject!

New Google Analytics

Got it, don’t like it.

Power + Attitude = Performance

Anybody who’s undergone flight training will hopefully recognise the phrase…

“Power + Attitude = Performance”

But I’ve always through the phrase spans beyond simply being a way of understanding aircraft performance, infact, I think it could be a life coaching mantra. It sounds almost like a simple equation to success, balancing power and attitude (to maintain a ‘assertive equilibirum’ – to achive performance … to go places.

One of the things I love about learning to fly is the amount of inherited wisdom that exist in the aviation world. There are lots of phrases like:

  • Its better to be down here wishing you were up there, than up there wishing you were down here.
  • Runway behind you, altitude above you and fuel in the truck – are all useless.

These are simple facts eloquently stated and, if you’re a bit over enthusiatic like me, you can apply then to general life situations.

Learning WordPress

About 3 weeks ago I offered to help with a site which is powered partialy by WordPress. I thought I would install it myself and give it a go to get a basic understanding, and was so impressed I’ve not rolled out 2 main site installations and one micro-site! I’m also thinking of rolling our wordpress installations on 3 other sites to replace jaws installations.

It’s a fantastic tool, and tonight I learnt even more tricks that show how powerful it is!

The main reason I’m loving it is the very clever Atuhualpa theme under which I am building my Heathrow site. It’s enabled to me to do a lot, and the guy at the forum – http://forum.bytesforall.com/ – really help out with nifty tricks.

But in general the strength of WordPress is so great I look forward to continuing learning how to make and do more and more with it!