Like Through Rate (LTR) for Facebook Advertisement

I’ve been going through many results for the keyword Like Through Rate (LTR) in Google, but did not find any good article that could explain a bit. Though many people have claimed to have invented it, so I’m not really the first. But, trying to give more lights to it.

Click Through Rate (CTR)

Before we go to LTR, those of you who don’t know what CTR or Click Through Rate is, here is the formula:

CTR = (Number of Clicks / Number of Impressions) X 100

This denotes the percentage of impressions that generated clicks. Impressions are the number of times the ad is shown. So, CTR is a percentage value that can show you how effective your ad was, in terms of the number of impressions shown. This is a quality factor for ads. Because, a high CTR e.g. 70% means your ad was so good that 70% of the ads shown, encouraged people to click; and a low CTR e.g. 30% means you ad was so bad that 70% of the ads shown, were never clicked.

What Happens Beyond Clicks?

But, what happens beyond Clicks in social media advertisement? Clicks are not the major factor when your main goal is to get more likes as possible. And doing it for least cost is also a concern.

The effectiveness of the ads ends, when someone clicks your ad. So, CTR is not responsible for what happens afterwards. People come through clicks and if they like your posts, then they like your page and if your post are crappy, they bounce away from the page. Like is a next level of call to action after clicks. So, what’s the quality factor here?

image

Like Through Rate (LTR)

It’s the Like Through Rate that indicates how good are your Page’s posts. LTR is the quality factor in work after clicks are generated. If you have very interesting posts for your target audience, then the most number of clicks will turn into likes. And the way to measure it is by LTR. So, here goes the formula:

LTR = (Number of Likes / Number of Clicks) X 100

Like CTR, Like Through Rate or LTR is a percentage of Clicks that turned into likes. If you have a high LTR e.g. 70%, it means that you page was so likebale that 70% of the people that clicked, liked your page. Likewise, a low LTR e.g. 30% means that your page’s post are so bad that 70% of the people that clicked on you ad did not find your page interesting.

How Like Through or LTR Can Be Helpful?

  • LTR tells you how good your page’s posts are. If you have a high LTR, then you have a very interesting page for your target audience. You might have very bad CTR, but a high LTR is surely a winner.
  • Increasing your LTR can also decrease your cost of advertising in Facebook and other social media. Beause, a high LTR means you are getting more likes for the same cost for clicks.
  • Ater hosting an ad campaign, if you find that your LTR is low (Usually below 60%), it can be a sign that your page is not ready either for public or for your taget audience.
  • Sometimes the LTR depends on your target audience. You might see different LTR for different audiences. So, you can tell which audience to target and which not to.
  • Well, if you are optimistic about the audience that generate low LTR, then you can take measures to tailor posts that can encourage the low LTR audience to generate better LTR.
  • With that in mind, if you run a campaign for specific niche audience and still see low LTR, it clearly tells you that your campiagn is not working. You need change. And vice versa.

Most of the Social Media Marketing (SMM) strategies evolve around increasing LTR for your page. Starting from increasing likes to increasing engagements, all are related to LTR. And how to increase your Like Through Rate (LTR) is another topic and I might put light on that later as well. But, the definition needed to be cleared out.

©  of SEOPPCSMM.COM - Source: Like Through Rate (LTR) for Facebook Advertisement

25 May 2013 ·

Facebook Auto Pokes with iMacro

When you have a lot of friends and followers on Facebook, the number of pokes can be high. Most of the time you hesitate to return a poke. Moreover, responding to each poke is time consuming. That’s why your Poke Page in Facebook steadily gets compiled with many pokes. But, not returning is also a bad idea. It is a silent piece of communication to many, which can help you stay silently in touch with friends and peers.

Auto Pokes for Facebook with iMacro

Facebook Auto Pokes with iMacro

To save you time, I have created an Automated Facebook Poking Script that can auto-poke your pokers automatically. It is made from iMacros Scripts. iMacros is a macro tool for browsers that can help you do repetitive boring jobs automatically, just like the Macros in MS Office. To know more about iMacros, please visit this link

To make the Facebook Auto Poke work for you, here’s what you have to do:

Get iMacros

If you are using Firefox, then get iMacros Addon from here.

If you are using Chrome, then get iMacros Extension from here.

Install the Addon/Extension on your browser.

Optimize  iMacros

After getting it installed, open iMacros and below the windows, press “Preferences” to get the path where the Macros saved. It’s usually located at: My Documents\iMacros\Macros

image

Download my Facebook Autopoke iMacros Script file from this location and save the file in the location where all the macro files are located. After you make the script file available in the location, close iMacros and reopen. You should be able to see “500 Auto Pokes.iim” file like the snapshot above.

Make the Autopoke Work

Once you have the script in place, log into Facebook and then open iMacros from your browser. Select the “500 Auto Pokes.iim” file on iMacros and click the “Play” button.

image

That should do the trick.

Warning: 

  • Please don’t move away to other windows while the pokes are being done. It might pause the auto poking process.
  • This is based on 500 pokes at a time. If you have less than 500 pokes in the Pokes page, then it might stop working after all are finished.
  • This ensures that all “Poke Back” links are clicked. But, most of the time, you may see that some pokes are not returned. If you play the script again, it’ll start working.
  • Facebook keeps on changing every now and then. This might not work if anything in Facebook is changed. Please comment below, if things are not working.

©  of SEOPPCSMM.COM - Source: Auto Pokes for Facebook with iMacro

18 May 2013 ·

How to Remove Facebook Page Like Count or Fans and Rename Page

Aminul Islam Jewel asks in BIMPA: I really need to rename my Facebook Page name. But, Facebook is not allowing me to rename my page for having more than 200 fans. 275 to be exact. How can I rename the page?

+++++++++++++++++++++++++++++++

Renaming your Facebook Page

If you have 275 fans, then it is easy to remove 75 fans. Remove 75 fans from your Facebook page and then rename it. It works. Just be choosy in who to remove. See below for the thought process to remove.

How to Remove Facebook Page Like or Fans

How to Remove Facebook Page Like or Fans

Go to your Facebook Page and if you are an admin of the page, you should see the Dashboard at the top of your page. Please don’t go directly to the Like Tab in your page. Because, you can not remove fans from there. Instead:

  1. Click the “See All” link beside “New Likes”. It’ll pop-in with a new dialog box showing people and pages that liked your page.
  2. At the top of the pop-in dialog box, you’ll see a drop-down option that says “People who like this”. If it says something else, then select ”People who like this” from the drop-down menu.
  3. At the right side of the list. there are remove or “X” buttons. Click to remove the fans you don’t want.

Thought Process for Removing Page Fans

But, as I mentioned earlier, you should apply some thought process in removing the fans. And they are: 

Fake accounts

They never help you in engagement. Engagement is more important than likes. Good Engagement helps to spread your posts like virus. Rather, having fake accounts pollutes your Engagement Ratio (i.e. the % of fans engaged to your page). Not sure if Facebook uses it as a signal. But what if they do? Then your efforts in Facebook Page Marketing will be useless.

Many businesses are using the numbers and selling or boasting high number with fake likes. But, just like Google Algorithm update, please also expect EdgeRank Update from Facebook. So, it’s always smart to keep your fan-base clean.

Brand Accounts

Brand accounts are the accounts that do not represent a person, but a company. You should remove them for the same reason of fake accounts. They really don’t ensure much engagement and most of them are interested in spamming. Moreover, they are breaking Facebook terms.

However, many businesses can like other pages “as page”. This is done by logging as page and then hitting the like button on another page. If you come across Fans that does not have “Add Friend” button, instead have “Like” button  then that fan liked your page as a page. It’s advised not to remove them. However, you need to be sure that they are not your competitors or 2nd level competitors like 2nd level cousins :-)

Geographically Irrelevant Fans

You can remove fans that are not geographically relevant for your page. e.g. a US fan for a local Bangladeshi page. Again it also depends on the language as well. If your posts are mostly in a specific language and you see fans from other countries without any engagement, it might have been a mistake. So, you should help the fan. Since such fans may report your page, when they realize that they did not like your page and you somehow hacked their account. Which can hurt you more than to have just one fan. 

Demographically Irrelevant Fans

Facebook has very strict advertising guideline for Dating Sites. But, for page like, they are not much strict. But, Facebook might impose strictness in future. Therefore, you should remove fans that are not demographically relevant for your page. e.g.

  • A female fan for a male-oriented product or vice versa (though, large number of male fans in Lingerie page is not a bad thing).
  • 18+ product like Durex with a under 18 fan
  • Married fan, while the Product is intended for single people, etc.

Competitor Fans

Yes, competitors also follow you to understand your Facebook Marketing strategies and you might not notice. BTW, you also can do the same and not let them know. But, if you can spot them, remove them.

You may also look after second level competitors. e.g. many companies hire Internet Marketing Agencies to do their Facebook Page Marketing. And to understand the playing field, the first thing they do is, follow some competitors.

F&F Fans

You can remove your friends and family from the fan list. You always can request them later to like the page. In fact, you can use the invite tool to invite them again. So, you don’t need to worry much about removing them.

©  of SEOPPCSMM.COM - Source: How to Remove Facebook Page Like Count or Fans and Rename Page

3 April 2013 ·

Find Professional References through Facebook

So, you have a dream company you want to work in? You are constantly looking for people to connect with from your dream company. But, I hear a lot of people complaining that “I don’t have references to get a job there”. Well, if it was 5 years ago, that would be a fate you had to accept. But, at the age of Social Media, there is no reason in admitting it. So, if you don’t have any references or don’t know who you can connect to, then it is your fault.

Find Professional References through Facebook

You really can use social media like Facebook find professionals references for:

  • Job or career,
  • Business opportunity,
  • Joint venture opportunity,
  • B2B Networking,
  • B2B Lead Sourcing, etc.

Last time, I gave the idea (that I am also going to give you) to someone, he found that his sister-in-law (bother’s wife) had her brother-in-law (sister’s husband) working in the company he was seeking references for.

You are probably wondering how this is possible. To tickle your brain, here are some ideas:

  • You probably saw the “Find Friends” feature where Facebook suggests you to add more people that might be your friend
  • On each un-connected Facebook user’s profile you can see how much mutual friends you have
  • Each mutual friend has some kind of a relation with that specific user
  • You know that Facebook also suggest you to add colleagues working in same company
  • Now, what would happen if you could find people by company and also could see their mutual friends?

So, I think you got the idea.

Professional References from “Find Friends” with Other Tools Links

Getting your feet wet to find a professional reference is not quite easy. You have to apply certain tricks. You might have seen the find friend feature in Facebook. If not, then go to the URL mentioned in the image below:

Find Friends Link in Facebook

If you go to the page, you will see some list of other ways to find your some friend suggestions:

Find Friends Page in Facebook

If you click Other Tools, you also can see the options to search people by the companies you work in:

Other Tools Options on Find Friends Facebook Page

If you click on the link of the company, e.g. marked red in the picture (http://www.facebook.com/find-friends/browser/?type=work&id=102777693132451&ref=ff), notice that the URL has specific number (in bold). Now, if I take this number and use it after Facebook.com like this: http://www.facebook.com/102777693132451, it takes you to the Facebook Community or Fan Page of Grameen Solutions. But, the URL of the page looks like this https://www.facebook.com/pages/Grameen-Solutions/102777693132451. Now that you know the number trick, you can go on searching for people that are working in a specific company using http://www.facebook.com/find-friends/browser/?type=work&id=THE_PAGE_NUMBER.

This is not always so straight forward. First, you need to find all possible pages that are available in Facebook belonging to that company. The phenomenon of having many pages for the same company (in the image below) happen because, many people do not use the exact match spelling for the same company.

Grameen Solutions Facebook Pages Search

When you click the community pages (the page with briefcase icon), you will find the number of the page that you can use to search for professionals working in your desired company. But, some pages uses vanity URLs like: http://www.facebook.com/grameenphone. In that case, finding the number of the page becomes hard. But there is a trick. Go to the vanity URL page and right click and get the URL of any image on the page:

Right Click to Get Facebook Page Number from Page with Vanity URLs

e.g. from http://www.facebook.com/grameenphone if you right click and copy the location of the image, you’ll see that the location is https://fbcdn-profile-a.akamaihd.net/hprofile-ak-snc4/373042_135237519825044_132091699_n.jpg. The bold numbers you see in the middle of the image file name is the page number, which you can use to find other people from the same company. If you need to confirm if the number is real, then try to see if http://www.facebook.com/135237519825044 takes you to http://www.facebook.com/grameenphone.

Professional References from Find Friends Browser

Now, I might have made this a bit complicated, but the trick I mentioned above is the best way to find all possible people or connections that belong to your dream company.

However, there is also a shortcut way. Just go to http://www.facebook.com/find-friends/browser/ and in the employer section, search for the name of the company in all alternative spelling that people used. If the page is popular, after typing some text, Facebook will suggest you some name of the pages or companies. But, in cases where there are too less people in a company, you might not find that listed in the employer search suggestion. In that case, go back and use the previous trick again.

Find Friends Browser

Now, you have the list that shows you people that are working in a specific company. Even though, you still have a problem. Because, they are not your friends in Facebook. But, the mutual friends suggest that they are friends of any one or more of your friends. So, use the mutual friends to learn more about the person working in the company and use them to get introduced. If you have a healthy number of Facebook friends, then I am sure that you will find at least one distant relative in a large company. It was actually not much possible even 5 years ago. But, in the new age of social media, use the strategy to benefit you, your career, and your business.

Professional References from Existing Friend List

Oh sorry, one thing missed. What if you already had friends from desired company and want to see which friends are from that company? Then the best way to do it is by going to your profile and then to Friends from Facebook. At the top, like the image below, you can search friend by Workplace. Select that and start typing the name of your desired company. You will find friends that are connected to the company. 

Find Friends Working in Specific Company

One last thing, when you see the list of friend suggestions or the list of friends from a specific company, don’t guess that all of them are currently working there. Facebook tries to show all past and current workers in your suggestions. So, try to see their profile individually. Another thing is, you can get the maximum benefit from this trick, if you have a large number of friends in Facebook. So, be more open and helpful to others to make more friends in Facebook as well as in real life.

©  of SEOPPCSMM.COM - Source: Find Professional References through Facebook

30 March 2012 ·

LinkedIn Wishlist - Part I: User Generated Search Tags to Create Narrow Searching, Keyword Channels for Profiles, & Virtual Directory of Interest Groups

This post is actually posted in February 04, 2008. Reposting the article here as a reference for my new upcoming article: LinkedIn Wishlist - Part II: LinkedIn Profile and Page Features.

LinkedIn Wishlist - Part I: User Generated Search Tags to Create Narrow Searching, Keyword Channels for Profiles, & Virtual Directory of Interest Groups

Dear LinkedIn,

Being an open networker, I always try to help my connection by forwarding relevant news, articles, resources, etc. in my network. To do so, I forward mails to the appropriate members in my network by searching them and adding them one by one. 

But, I think Other Filtering Option should be used to make the forwarding mails more useful by sending them to appropriate people. Currently, you can only filter by location and industry. But, there are many custom searches we can make in our contacts and group them as per our need.

Therefore, I would like to suggest User Generated Search Tags. Search Tag is similar to Blog Tags and Interest Group Tags in Blogger Profile. However this can be used to tag people with appropriate keywords. XING is already using this type of tags. You can actually use this tag for various purposes:

Search Tags for Narrow Searching

Use the tags for creating narrow search of LinkedIn connection. You can provide the tag option as narrow search for forwarding any mail. To create the tags, the users will do a people search and tick/check the appropriate people and write a tag for them. e.g. If someone searches for “SAP Developers” in people search, he will be able to choose by clicking on the check box on the basis of his judgment on the summary and then grossly mark the checked profiles with a generic tag, like “SAP Developers”. And when s/he wants to send mails to people within this search tag, s/he will be able to send it by choosing the tags defined by the user. Again, if anyone joins the network with similar People Search Attribute, then s/he will be automatically tagged.

Profile Tags for Keyword Channeling

You can use this User Generated Search Tags like XING, i.e. show it in their public profile. This will also automatically create Keyword Channels for the Profiles. This will enhance the Search Engine Rankings for each profile, since Google & other Search Engines like Keyword Channels (or simply Anchor Texts). You can also use Tag Cloud Option to show most popular tags in bold and least popular tags in plain text. I believe that Tags from people will actually represent what people are saying about you. And this will also allow members to top the Rank in People Search and establish them to stay ahead of the industry or Keyword Channel. If anyone is ranked 1st, 2nd or 3rd for the Profile Keyword Tag, then he can be rewarded with a badge. I believe that this will encourage people to promote their profile instead of their personal sites.

Tags for Virtual Directory of Interest Groups

If the tags are clickable tags, then you can virtually have Directories of Professionals channeled with Keyword Tags. Besides groups in LinkedIn, this will also create Virtual Interest Groups within LinkedIn, rather than an actual group. These tags can be further utilized for User Profile-based PPC Campaign like Facebook.

Update: This tags are more like the Google Plus Friend Circles that allows you to send updates to a specific types of people. When some one sends a Job notification for SEO Manager, it is pretty hard to find the right people and forward them the notification. If tags could be created through search, then people could have sent relevant message to the right people.

© of SEOPPCSMM.COM - Source: LinkedIn Wishlist - Part I: User Generated Search Tags to Create Narrow Searching, Keyword Channels for Profiles, & Virtual Directory of Interest Groups

7 September 2011 ·

Expandable Video Ads on YouTube and Vimeo - Innovative Web Advertisement

Google has been experimenting Expandable Ads for a while. But, flash based Expandable ads is not something new. Back in 2005, I have seen many expandable ads in Yahoo homepage. In recent years, the peel off expandable ads at top right corner is currently quite popular. You can find similar expandable ad in Marketing Pilgrim site at the top-right corner.

Google Adwords also introduced Expandible ads back in 2009. Adsense users may have seen such ads. But with Youtube, the Expandable Video Ad is something new and quite innovative. 

Have a look at these videos by clicking the images (it might take time if you have slower connection):

Expandables (The Movie) Ad on YouTube

Expandables (The Movie) Ad

This video is an example of typical Expandable YouTube ad. The name of the movie is co-incidental :-)

A Hunter Shoots a Bear - Tipp-Ex Ad on YouTube

A Hunter Shoots a Bear

This is more interactive and connected with many other videos. The bear and the hunter also started their page in Facebook, which already gained many fans. 

The Desperados Experience

Youtube Expandable Video Ad - The Desperados experience

Like the hunter shoots a bear, this video also has many versions, which you can choose at the beginning. You actually can play around with the playbar in the video and make various actions suggested in the video. Moreover, the video is loaded with many social media call-to-actions in their flash interface.

Tostitos Lady - And Then There was Salsa Ad on Vimeo

Tostitos Restaurant Style Salsa

This is one of the cool and colorful Expandable Video Ad I have seen. But, this is not from Youtube, rather from Vimeo.

Expandable Video Ads are relatively new trend, but there are here to stay for long. In near future, we might also see expandable video ads in adwords.

© of SEOPPCSMM.COM - Source: Expandable Video Ads on YouTube and Vimeo - Innovative Web Advertisement

30 December 2010 ·

View You and Your Friend’s Activity Page - A New Facebook Feature

Update: This feature has been embedded into the feature of new Facebook Timeline. You can now find the link to your friendship between a person and you below the cover photo of your timeline. Look out for the link that says “See Friendship”. However, the fetures mentioned here remains the same.

A few years back, when you landed on your friend’s profile on Facebook, you could see only the mutual friends you have. Then in recent change, Facebook also introduced the common “Likes” you have with your friend.

But, at the day of Halloween, Facebook brought in a new feature that highlights almost all the mutual activities, events, and interaction with your friend in a nice looking separate Facebook Friendship page. Just visit any friend in Facebook and you will find the link saying View You and Your-Friend’s-Name.

You and Your Friend's Activity Link in Facebook

After you click the “View You and Your Friend” link, you end up in a separate friendship page that includes the recent interaction you had with your friend.

Here is a list of information available in the page:

Duo Profile Image

If you and your friend were tagged in any photo in Facebook, then one of them will end up as the page picture or profile picture of the You-and-Your-Friend-Activity Page or Facebook Friendship Page.

Feed Filters

In the middle of the page you will see many feed updates that involves you and your friend. You will also find links to filter these updates just below the Duo Profile Image for seeing the feeds that are only Wall Posts, Photos, Events or Likes.

Mutual Friends

This is probably the oldest piece of information that was already available for your when you went to your friend’s profile. In the activity page, this eats up most of the space at left.

News Feed Updates

The mid-portion of the page is occupied with news feed updates that involves you and your friend. They are also categorized into Wall Posts, Photos, Events, and Likes.

Browse Friendship

In 3rd column at top-right, you will find links to other friends that are also mutual friends. From there you can see what are your friend’s interaction with other mutual friends.

Custom Friend Activity View

But, this is not all, Facebook is not only allowing you to see activities on You vs. Your Friend. They are also allowing you to see the activity of Your Friend vs. Another Friend. The interface to view the activity of two friends is available just below the Browse Friendship links.

Private Activity in Facebook with Your Friend

Currently, this new feature shows all the public feeds or the feeds that can be shared in custom settings (e.g. friends of friends or network can see). Facebook is not showing the private communication like messages, chats, or any private sharing with your friend at this moment. However, if this is introduced, then this new Facebook Friendship Page can have full functionality.

Enjoy the new feature and Facebooking!!

© of SEOPPCSMM.COM - Source: View You and Your Friend’s Activity Page - A New Facebook Feature

1 November 2010 ·

Generate QR Code with Google Chart API in Bulk from Excel Worksheet

This article is about generating QR Codes automatically in bulk from Google Chart API. If you know how it works, then you can skip all the descriptions in the article and go straight below and download the spreadsheet that can help you print QR Codes in bulk.

But, if you are interested to learn about how it was done, then please start reading  from here. Before that, I think a lot of people want to have more introduction about some terms. So here they go:

What is QR Code?

QR Code is 2-dimensional or 2D barcode (unlike the traditional 1D barcode) that looks like the black pixilated image below:

QR Code for Asif Anwar of Blueliner Marketing, LLC.

Came from some innovative Japanese mind, who invented the code to make contents decoded at high speed. This 2D Barcode now readable by QR scanners, smartphones or mobile phones attached with cameras.

For iPhone (Semacode), Android Phones (QuickMark), Blackberry (ScanLife), and Symbian Phones or Nokia (UpCode) there are many competing apps that can read QR Codes from any printed media.

The utility of QR Code is simple, transfer a whole chunk of text or information from any printed media to your mobile phone (through QR reader) or computer  (through QR scanner). So, this is the best way for you to make people go directly to your site from the printed QR Code or have people save your business card in their mobile phone in a snap.

What Does QR Codes Have to do with Web Marketing?

QR Codes are fastest way to transfer text and information from print to mobile phones. Therefore, it has good implications on increasing your site traffic from alternative media by referring the URL to your site. e.g. if you sell a specific product; by using mobile phone, the printed QR Code on your product can make the friends or colleagues of the buyer go to the page where he/she can also buy it.

For any type of contact request, a visitor can save your contact information from web, product, brochure, coupons, etc. and might convert later.

QR Code Bilboard Ad by Calvin Klein

Calvin Klein recently made an innovative adult advertisement on billboard with QR codes, without even showing the nude models. The title of the advertisement was “Get It Uncensored”. This triggered many people to go to their website and watch the uncensored video. Please read more about this news here.

Even though QR Code is thought to be a mobile marketing strategy, combined with the web technology, it can be a great strategy for web marketing.

What is Google Chart API?

According to the Google chart API site:

The Google Chart API lets you dynamically generate charts with a URL string. You can embed these charts on your web page, or download the image for local or offline use.

Interesting fact is that Google Chart API is also currently the most reliable and free source for generating 2D QR Codes.

How can you Generate QR Codes with Google Chart API?

If you look at the URL of the above image, you’ll see that there are many information avalable in the URL:

http://chart.apis.google.com/chart?cht=qr&chs=350x350&chl=MECARD:N:Asif%20Anwar;ORG:Blueliner%20Marketing,%20LLC.;TEL:008801712181761;EMAIL:anwar%40bluelinerbangla.com;ADR:55%20Broad%20Street,%2017th%20Floor,%20New%20York,%20NY%2010004,%20USA.;URL:http://asifanwar.tumblr.com;NOTE:Company%20site:%20http://www.bluelinerny.com;;

So, by just inputting the information in the right place in the right format, you also can generate the desired QR codes.

Interpreting the Google Chart API URL

From the URL, you will find several parameters that can be customized. Here is the list of the parameters and their description:

cht=qr

If you go to the Google Chat API site, then you can see that Google arranges many types of charts. So, by using cht=qr, you are telling Google that the chart type should be QR.

chs=350x350

This is where you mention what would be the chart size.

chl=MECARD

CHL is the Chart Label parameter. This actually states what type of content you have and based on that, your device will create certain action. You can have content as vCard (make an Phonebook Entry), URL (go to the referred site), Text (read the contents of the QR), Phone (call the referred number), SMS (Get info saved on your mobile), etc.

Usually, MECARD is used to tell that, the content is for Mobile vCard. According to ServletSuite.com, the definition of 

MECARD is a text format lets you present address information for phonebook registration.

It is then followed by other heads with your custom values, like:

N: Full Name
ORG: Company Name
TEL: The Telephone Number
EMAIL: The Email Address
ADR: The Address
URL: The URL
NOTE: Any note or comment.

Each of the heads should be separated with semicolon. If you are using the Chart API for generating URL only, then the custom URL is the label. You don’t need separate label for that.

More information on Google Chat API Parameters are on: http://code.google.com/apis/chart/docs/gallery/qr_codes.html

How to Generate QR Codes in Bulk from Excel Worksheet?

Well, this is what this article is about. In excel worksheet or any other sort of database, you might have information or record like this:

A2. Name: Asif Anwar
B2. Company: Blueliner Marketing, LLC.
C2. Phone Number: 008801712181761
D2. Email: ɯoɔ˙ןıɐɯb@ʇuɐʇןnsuoɔǝpɐɹʇ (upside-down text)
E2. Address: 55 Broad Street, 17th Floor, New York, NY 10004, USA. 
F2. Website: http://asifanwar.tumblr.com 
G2. Note: Company site: http://www.bluelinerny.com

[A2 to G2 are cell reference]

In terms of QR Code generation, these information is best for website/URL reference or business card transfer from print to mobile. And with all these information, you get this URL again:

http://chart.apis.google.com/chart?cht=qr&chs=350x350&chl=MECARD:N:Asif%20Anwar;ORG:Blueliner%20Marketing,%20LLC.;TEL:008801712181761;EMAIL:anwar%40bluelinerbangla.com;ADR:55%20Broad%20Street,%2017th%20Floor,%20New%20York,%20NY%2010004,%20USA.;URL:http://asifanwar.tumblr.com;NOTE:Company%20site:%20http://www.bluelinerny.com;;

Now, if you look at the URL that generates the QR Codes, you will find a pattern. e.g.:

http://chart.apis.google.com/chart?cht=qr&chs=[THE-CHART-SIZE-YOU-WANT]&chl=MECARD:N:[FIRST-NAME]%20[LAST-NAME];ORG:[COMPANY%20NAME];TEL:[YOUR-TELEPHONE-NUMBER];EMAIL:[YOUR-EMAIL-ADDRESS];ADR:[YOUR-ADDRESS];URL:[YOUR-URL];NOTE:[YOUR-NOTE]; ;
In other analogy with cell reference:http://chart.apis.google.com/chart?cht=qr&chs=[THE-CHART-SIZE-YOU-WANT]&chl=MECARD:N:[A2];ORG:[B2];TEL:[C2];EMAIL:[D2];ADR:[E2];URL:[F2];NOTE:[G2]; ;

So, it is possible the join these information from excel worsheet to generate the URL and finally generate the QR Codes. But, there is one problem, the information you have, has spaces and @ sign that are not allowed in the URL. So, you have to replace them with “%20” and “%40” respectively.

In Excel Worksheet, you can use the following formulas to replace the spaces and @ signs and create a new text that can be easily joined:

H2. =SUBSTITUTE(TRIM(A2),” “,”%20”)
I2. =SUBSTITUTE(TRIM(B2),” “,”%20”)
J2. =SUBSTITUTE(TRIM(C2),” “,”%20”)
K2. =SUBSTITUTE(TRIM(D2),”@”,”%40”)
L2. =SUBSTITUTE(TRIM(E2),” “,”%20”)
M2. =SUBSTITUTE(TRIM(F2),” “,”%20”)
N2. =SUBSTITUTE(TRIM(G2),” “,”%20”)

[Assuming that you are placing the replaced texts in single row that starts after G column]

Since you have all the spaces and @ replaced, you now can join the texts with =CONCATENATE() formula. e.g.

=CONCATENATE(“http://chart.apis.google.com/chart?cht=qr&chs=350x350&chl=MECARD:N:”,H2,”;ORG:”,I2,”;TEL:”,J2,”;EMAIL:”,K2,”;ADR:”,L2,”;URL:”,M2,”;NOTE:”,N2,”;;”)

The strategy for generating the URLs for QR Codes using Google Chart API may vary in case if you are using separate form of database. Once you have created the URLs, you can easily embed them in the site or print them by visiting the file on browser.

Now I can go a long way to discuss on how you can embed them. For your convenience, I have done all the trouble in the embeded spreadsheet below. You can download and use it to generate QR Codes and also embed in in a printable format.

Download this Spreadsheet

The Embed Code in the spreadsheet some times come with double (2) double quotation marks in HTML when you try to paste the embed codes in other HTML Editors. Please find and replace double (2) double quotation marks with single double quotation marks, before finally using them for print. You might also see that there are starting and ending double quotation marks in the embed codes, delete them as well to make it work for you. Feel free to change the codes into the design you like best.

If, I have saved your time, feel free to comment below, like, and share the article with your friends. And if you feel it’s too geeky for you, then consider this Gig for $5 in Fiverr: I will create Custom Designed Qr Code Badges from CSV Database for Events for $5

Some of my other articles on QR Codes:

QR Code Marketing and Advertising Ideas and Strategies for Internet Marketing

How to Turn Your Billboard into an Interactive Marketing Campaign and Measure ROI

© of SEOPPCSMM.COM - Source: Generate QR Code with Google Chart API in Bulk from Excel Worksheet

19 October 2010 ·

Archive RSS

About Me

Blogger Bio

Professionally, Asif Anwar is working as National Consultant (Web Optimization) of Access to Information (A2I) program of UNDP for various Web Marketing Solutions for the Bangladesh Government, small companies as well as large brands.

Search Engine Marketing (SEM) and Social Media Marketing (SMM) consultant and specialist for various high PR sites and large brands.

Professional Internet Marketing Blogger and occasional guest blogger for Search Engine Journal, Social Media Today, and Marketing Pilgrim.

SEO Trainer, Mentor, Moderator, and Co-founder of Bangladesh Internet Marketing Professional Association (BIMPA).

My Tumblr Timeline

Networked Blog Accreditation

Top 3 SEO Blog

Top 3 Internet Marketing Blog

Top Most Social Media Marketing Blog

Asif Anwar - Find me on Bloggers.com