eCommerceCircle

I found this script on webupd8.org that will help you jump-start your Twitter campaigns. You can run it on any PHP server as a standalone file. What it does is search for anyone who mentions a relevant term. Just copy and paste the code below and change the following:

enter_your_twitter_username_here // Example: eCommerceCircle
enter_your_twitter_password_here // Example: imnottellingyou
enter_the_search_term_to_follow_here // Example: iPod Touch

You can upload to your server and just load the page from time to time or set up a cron job to do it automatically. Keep in mind that Twitter has follower/following ratios in place and that at most you cannot follow more than 1.5 times the amount of people following you as well as a 1,000 follower a day limit.

<?php
// Twitter Auto-follow Script by Dave Stevens - http://davestevens.co.uk
$user = "enter_your_twitter_username_here";
$pass = "enter_your_twitter_password_here";
$term = "enter_the_search_term_to_follow_here";
$userApiUrl = "http://twitter.com/statuses/friends.json";
$ch = curl_init($userApiUrl);
curl_setopt($ch, CURLOPT_USERPWD, $user.":".$pass);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$apiresponse = curl_exec($ch);
curl_close($ch);
$followed = array();
if ($apiresponse) {
 $json = json_decode($apiresponse);
 if ($json != null) {
  foreach ($json as $u) {
   $followed[] = $u->name;
  }
 }
}
$userApiUrl = "http://search.twitter.com/search.json?q=" . $term . "&rpp=100";
$ch = curl_init($userApiUrl);
curl_setopt($ch, CURLOPT_USERPWD, $user.":".$pass);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$apiresponse = curl_exec($ch);
curl_close($ch);
if ($apiresponse) {
 $results = json_decode($apiresponse);
 $count = 20;
 if ($results != null) {
  $resultsArr = $results->results;
  if (is_array($resultsArr)) {
   foreach ($resultsArr as $result) {
    $from_user = $result->from_user;
    if (!in_array($from_user,$followed)) {
     $ch = curl_init("http://twitter.com/friendships/create/" . $from_user . ".json");
     curl_setopt($ch, CURLOPT_USERPWD, $user.":".$pass);
     curl_setopt($ch, CURLOPT_POST, 1);
     curl_setopt($ch, CURLOPT_POSTFIELDS,"follow=true");
     curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
     $apiresponse = curl_exec($ch);
     if ($apiresponse) {
      $response = json_decode($apiresponse);
      if ($response != null) {
       if (property_exists($response,"following")) {
        if ($response->following === true) {
         echo "Now following " . $response->screen_name . "\n";
        } else {
         echo "Couldn't follow " . $response->screen_name . "\n";
        }
       } else {
        echo "Follow limit exceeded, skipped " . $from_user . "\n";
       }
      }
     }
     curl_close($ch);
    } else {
     echo "Already following " . $from_user . "\n";
    }
   }
  }
 }
}
?>

4 comments »

Posted in Social Media

Tags: Auto-Follow Script Social Media Twitter

Tips & Tricks On How To Use Twitter For eCommerce Marketing

October 27th, 2009

Twitter is growing by leaps and bounds every day. By the last count Twitter.com had 58 million visitors worldwide during the last month. In addition, they just signed major deals with Microsoft and Google to supply them with a firehose of all Twittering Tweets.

Twitter Tools

You are only as good as the Twitter tools you have. Here is a brief rundown of the best Twitter tools for keeping track of your brand and interacting with your customers.

Brizzly

Brizzly allows you to control multiple Twitter accounts from the same interface without having to constantly log in and out. Some of the great features it offers that are helpful with managing an eCommerce site’s Twitter account are Groups and Saved Searches. Although Twitter.com offers the ability to save searches, it is much easier to skim through the results and answer them inline on Brizzly. The Groups feature can help you segment your follow list by category so that you can more clearly see what’s happening in your Twitter world.

Brizzly is in private beta, and can be accessed by invitation only. I have a few invites to give away, please leave your email in the comments for a free invite.

Screenshot: @Remiel

CoTweet

CoTweet is the Twitter tool of choice for many large corporations such as Pepsi, Starbucks, Microsoft and many more. CoTweet has some unique features that cater to companies with multiple people posting from a single Twitter account. Their core features are multiple Twitter accounts, multiple users managing a Twitter account, CoTags, saved searches, and scheduled Tweets.

From within CoTweet you can give access to multiple users to manage your Twitter account, the best part is that you can set up CoTags which CoTweet will append the initials of the person Tweeting to the Tweet. They generally add CoTags in this format “^MK”. This helps avoid confusion and helps your followers identify who said what.

CoTweet also allows you to schedule Tweets for a specific time, this is ideal for when you are unable to post manually but would like to keep your followers updated.

Screenshot: vincentgallegos

HootSuite

HootSuite has pretty much the same major features as the others, however it sports a more desktop like client interface with multiple tabs and columns for follower updates, saved searches etc…

A unique feature that HootSuite offers is the ability to auto post Tweets from an RSS feed. This is great if you have a company blog that you would like to automatically post the updates to Twitter.

Screenshot: cambodia4kidsorg

TweetDeck

All the above Twitter tools are web-based, TweetDeck is a desktop application that works on the Adobe AIR platform. Like HootSuite, it has a multiple column interface for easy following. The good thing about TweetDeck being a desktop application is that it has notifications built into it. It can pop up a message when your company is mentioned on Twitter.

Screenshot: merilyn_j

What To Post

Having a great tool is only half the battle. How you use it, can impact your results in a major way. The best use of Twitter is to update with a mix of Marketing/Promotional tips, helpful tips, and interact with other Twitterers.

Marketing

Post Tweets with special coupons, promotional content and deals exclusively for your Twitter followers. Give people a reason to follow you. Try not to post only promotional content and links to your site, make sure to include a healthy mix of other content as well.

Transparency

Let your customer base see the human side of your company. Post small updates that may make someone smile. Talk about your brand and what it stands for. Post helpful tips relevant to your industry.

Customer Service

Interact with your followers and potential customers. Say good morning and help fellow Tweeple with their problems. Providing help to someone who is not a customer, may turn them into one. Become an authority in your industry.

Usage Examples

Here are examples of companies using Twitter. Learn what you can should and shouldn’t do from them.

Woot

Woot posts links to their ‘daily sale’ every and blog posts on their company blog. They currently have over 1.4 million followers and they use this channel as a natural extension to reach their already loyal following.

Comcast

Comcast says they care, and it seems that they really do try to help anyone who voices their frustrations with the cable provider on Twitter. They scan Twitter for anyone who mentions ‘Comcast’ and will reply and help you out pretty much instantaneously. There are the naysayers (that may be correct) who say that you shouldn’t have to go to Twitter to get customer service.

Zappos

No post about Twitter and eCommerce would be complete without Zappos. When Zappos CEO, Tony Hsieh breathes on Twitter 1.45 million people hear him. Aside from that, it is ingrained in the Zappos corporate culture to Twitter, they even host a mashup site where you can see all Tweets from Zappos employees.

Bottom Line

A dollar spent keeping an existing customer happy is the best dollar spent on marketing your brand. Use Twitter to interact with customers to provide a satisfying shopping experience as well as to promote your latest deals.

4 comments »

Posted in Social Media

Tags: Brizzly Comcast CoTweet Dell eCommerce HootSuite Marketing Social Media TweetDeck Twitter

10 More Essential Magento Extensions For Your Store

October 15th, 2009

In a previous post we featured 10 really cool and useful Magento extensions for your store. Here is another selection of 10 more great extensions.

1 – Layered Navigation Pro

Layered Navigation Pro allows you to customize the look and functionality of the layered navigation/search filters on your Magento store. You can use sliders, images, multiple check boxes etc… In addition this extension uses AJAX to load the new search results in real-time and you change your selection.

Extension Page | Demo | Price: $99.00

2 – Google Maps Store Locator

Great for eCommerce sites with multiple brick and mortar locations. Very easy to set up, just enter all store locations and Google Maps latitude and longitude coordinates and your done.

Extension Page | Price: FREE

3 – Visualize Your Attributes

Adds the ability to display attributes with icons instead of drop down lists, radio buttons and check boxes.

Extension Page | Price: $49.00

4 – IDEALIAGroup LightBox

This extension will install a wonderful and ready-to-use LightBox widget in your Magento store.

Extension Page | Price: FREE

5 – FreshBooks Integration

This extension allows you to import your Magento Orders in real time into your FreshBooks account.

Extension Page | Price: $19.00 per Month

6 – Shop By Manufacturer

This is an alternative the the Shop By Brand extension we featured in our original Magento extensions post. It has all the basic features need to shop by brand but is not as feature rich as the other one.

Extension Page | Price: $29.99

7 – Order Editor

This extension enables you to edit order information in-line without canceling and creating a new order. Does not allow editing of any fields that would affect order total.

Extension Page | Demo | Price: $69.00

8 – Facebook Connect Social Shopping

This extension adds the ability for your site visitors to connect with their Facebook friends without leaving your ecommerce store. They can recommend items to their friends or ask advice about specific items on your site.

Extension Page | Price: FREE

9 – Twit Your Products

Take advantage of Social Media and add the ability for your customers to send products to Twitter with a customized Tweet.

Extension Page | Price: FREE

10 – Vertical Navigation

Don’t like the default horizontal menu? This extension switches your store layout to use a vertical menu bar.