Pages

Monday, August 17, 2015

New bike stunt: Bangladeshi new bike stunt 2015

Wednesday, June 17, 2015

Freelancing success tips

Freelancing success tips: Juwel


In this post, I'll talk about some vital issues for online freelance. Ideally, You will get a clearer thought for a percentage of the things that are vital for internet outsourcing.
Regular numerous individuals are coming to do online freelance. Since it is a free occupation. It's a vocation, where you have the opportunity to work. On the off chance that you wish, you can do, If you don't need, then you can't work. Additionally, you can win very much a respectable salary on independent. On the off chance that you are exceptionally appropriate, then you can procure a ton more. Which you would not have any official job. Along these lines, everyday individuals are getting into the online independent. However, in the event that they wished you can't do internet outsourcing. Since, on the off chance that you don't think about the different sorts of assignment, things being what they are, the way do you do? In this way, in the event that you need to do web outsourcing, at first you ought to be qualified. At that point you need to begin outsourcing on the web.
We should simply attempt to bode well, what capabilities you have to accomplish for internet outsourcing? Which errors are made novices? For qualifying, what would it be advisable for you to do? What English prerequisites for Online outsourcing?

What is critical to fit the bill for the online freelance?

 Two focuses are imperative for online freelance. Firstly proficiency and also tolerance. In the event that you have enough effectiveness, however you don't have persistence, then your realization chance is low. Then again, you have a considerable measure of persistence, however you don't have effectiveness, then your fulfillment chance is low as well. In this way, when there have a mix of effectiveness and tolerance, then achievement will come. Along these lines, who have no effectiveness, they will need to accomplish productivity. Furthermore, who has no persistence; it is beneficial for them to not come in freelance. 

Since, It might be for a long time or weeks you're attempting, however you don't land any position. It is normally a great many people get to be eager and get to be disappointed. At long last, they lose enthusiasm for web outsourcing. Along these lines, you ought to accomplish abilities and should be tolerant and



Beginner’s mistake for online freelance:

Numerous individuals need to do online independent. That is the reason somebody conceded into a preparation focus without speculation anything. Subsequent to increasing some preparation from the preparation focus, they needed to begin outsourcing. At that point a couple of days after the fact, without landing any position they lost their understanding, and considered independent is a fake thing. So for the individuals who are keen on outsourcing needed to let them know, at first accomplish the aptitudes, keep persistence, be sure about yourself and continue attempting. At that point achievement will accompany your hands.

To qualify for the online freelance what should do?

To pick up aptitude, you must get proficient preparing over related points. Attempt to gain from a talented individual or specialist. You can likewise take in a considerable measure by means of hunt in Google, viewing the feature instructional exercises from YouTube and from a few web journals. You need to ability on English with specialized item. On the off chance that you don't have aptitudes in English, then you discover snag at each stride.

The requirements of English for online freelance:

There are numerous individuals in our nation who are a lot of actually gifted, however don't have the English abilities. This is the reason they can't succeed in independent or don't get the adequate achievement. This is the reason to get abilities in English you need to study English a great deal and need to learn in English. You need to learn and take after the English web journals with websites are composed in your mom dialect. Websites of our sites are composed in simple and effortless English. Take after and studies the sites on our site. Ideally you may get advantage from this

Like us on Facebook

Friday, May 29, 2015

Data Entry Tutorial for new Online Freelancer

In this post I'll talk about information section for internet outsourcing. Initially, we have to recognize what is data entry:
Data Entry is a blend of two words. Information mean data and Enter mean Insert. That is to say, Data and Entry is information inserting.

Data entry tips : Juwel Rana
In other words, information inserting into any data store is to say Data Entry. It might be Online or Offline. For instance: Information embedding into an internet shopping store or writing into a page or structure to see a filtered document is a sort of Data Entry undertaking.

The first and most important is: Fast typing speed and fast mouse handling skill.
Second is: Learn tasks to selecting the platform.
We can mention two types of Data Entry platform: 1) Online Freelancing Data Entry. 2) Official Data Entry Job.

If you want to do the data entry task for “Official Data Entry Job “, you can’t get nothing in this post. I’ll discuss about “Online Freelancing Data Entry” here. If you start an official job as a data entry operator, the office representative will teach you how to work or use on their software or application.
But If you want to do the data entry task for online freelancing, you should learn some programs and task, for example: Microsoft Word, Microsoft Excel, PDF Form Entry, Magento, WordPress, Volusion, Drupal, Joomla, OpenCart, Bigcommerce, eBey, Alibaba, Amazon, Craigslist etc.

You should know which programs works for which task. So, let’s start details for all programs and task:

Basic programs for Data Entry:
Microsoft Word: You should learn Microsoft Word, because it needs for any type of typing task, writing from scanned images, proposal letter, press release, application etc.
Microsoft Excel: You should learn Microsoft Excel, because it needs for any type of data collection task, calculation task, conditional task etc.
PDF Form Entry: You should learn about PDF reader and PDF writer. A lot of task you can find in the online freelancing marketplace for online data entry into PDF form.
Listing data entry:
Listing is a one kind of data entry. So, you should know, how to post articles, uploading content, product listings, business Listings in various types of CMS or Open Source based websites.

CMS – Content Management System Data Entry:
WordPress: Present age WordPress is the most popular CMS to build a website or blogs. So, you need to know, how to post articles, uploading content, product listings, business Listings in WordPress sites.
Joomla: Present age Joomla is also a popular CMS to build a website or blogs. So, you need to know, how to post articles, uploading content, product listings, business Listings in Joomla sites also.
Magento: Magento is the most popular CMS to build e-commerce based website. So, you should learn, how to product listings in Magento CMS based websites.
Volusion: Volusion is also a popular CMS to build e-commerce based website. So, you should also learn, how to list or upload products in Volusion based websites.
Drupal: Drupal is a CMS like Magento or Volusion which is for e-commerce based websites. So, you should also learn, how to list or upload products in Drupal based websites.
OpenCart: OpenCart is also same CMS like as Magento, Volusion or Drupal, which is used for e-commerce based websites. So, you should also learn, how to upload or listing products in OpenCart based websites.
Open Source E-Commerce Platform Data Entry:
BigCommerce: BigCommerce is an open source e-commerce platform. It is used for e-commerce web service. So, you should also learn, how to upload or listing products in BigCommerce based websites.

C-to-C, B-to-C and B-to-B Website Products Listings Data Entry:
C-to-C: C-to-C mean Consumer-to-Consumer
B-to-C: B-to-C mean Business-to-Consumer
B-to-B: B-to-B mean Business-to-Business

eBey: eBey is a Consumer-to-Consumer & Business-to-Consumer sales services via Internet. You can get a lot of tasks in freelancing marketplace, to list products in an eBay store. So, you should know, how to ebay listing.
Alibaba: Alibaba is a Consumer-to-Consumer, Business-to-Consumer and Business-to-Business sales services via Internet. You can get a lot of Alibaba store products listing tasks in freelancing marketplace. So, you should know, how to list products in Alibaba store.
Amazon: Amazon is an Internet based retailer website. A lot of product listing project you can get in freelancing marketplace. So, if you want to do more work you should know how to list products in Amazon store.
Classified Website Products Listings Data Entry:
In the freelancing you can get a lot of data entry projects to list products on classified website. Craigslist is one most popular world wide classified site. So, you should learn how to listing craigslist.

Other ----->>>

Facebook Page

Juwel Media

Sunday, May 3, 2015

অডেস্ক এ যারা একদম নতুন

______________________________
নতুন অডেস্কারদের জন্য এই পোস্টটা দিলাম । যারা এপ্লাই করতে করতে হতাশ তাদের কাজে আসবে আশা করি, , , , একটুদেখেন,
ধরে নিলাম আপনি ভাল SEO এর কাজ পারেন। ওকে গুড। এখন অডেস্ক এ সাইন আপ করেই কি আপনে ফুল কনফিডেন্ট এ এপ্লাই করাশুরু করে দিবেন প্রথম দিনই??
অডেস্ক মানেই আপনি পুরো একটা নতুন জগতে প্রবেশ করেছেন। তাই ঘড়ি ধরে ঠিক এক সাপ্তাহ মানে ৭ দিন আপনি কোন এপ্লাই করবেন না। ৭ দিন আপনি পুরো অডেস্ক এর খুটি নাটি দেখবেন,
নিয়ম কানুন পরবেন। লাগলে নেট থেকে বাংলা কিছু পরবেন
অডেস্কনিয়ে। সেই সাথে দেখবেন আপনার অভিজ্ঞতাটা আস্তে আস্তে বারবে অডেস্ক এ। আর আগে যদি কোন বড় ভাই থেকে
টিপস নিয়েথাকেন, তাহলেও এপ্লাই করতে পারবেন না। প্রবলেম
পরবেন সিউর। তাই নিজেই কিছু জানার চেষ্টা করুন।
oDesk Help
কি করতে পারেন এই ৭ দিন, অন্তত ৫০ জন মানুষের প্রোফাইল ঘাটবেন। তাদের রিভিউ গুলি পড়বেন। মানে আপনি যে কাজ করবেন
সেইরকম মানুষের প্রোফাইল , , ,
, তারা কি কি টেস্ট দিয়েছেন তা দেখবেন। মোট কথা মনে করবেন এটাই আপনার প্রোফাইল,
কি করেএটা এতো সুন্দর হলো এবং আরো কি করা জায় তা ভাব্বেন।
এবার আপনি অডেস্ক এর প্রতিটা মেনুতে ক্লিক করে দেখবেন অন্দর মহলে কি আছে। ভাই, এমন কিছু লোক দেখছি যারা প্রায় ৬ মাসঅডেস্ক এ থাকার পর আমাকে বলে যে, ভাই পেমেন্ট মেথড এ সাইন করবো কিভাবে। মানে কিছু টাকা পাইছে হয়তো, তাই উঠাবেআরকি। বলেন দেখি কেমন অবস্থা।
আর জরুরি কাজ হল, বায়ারদের জব পোস্টিং এর দিকে খেয়াল
করুন ভাল ভাবে। সে কি বলতে চায় তা বোঝার চেষ্টা করুন।
তারপর মনে মনে সেই জব অনুজাই কভার লেটার বানান। সো,
কখনো কপি পেস্ট কভার লেটার দিবেন না। এমনকি আপনার
লেখা কভারলেটারো কখনো কপি পেস্ট করবেন না। তাতে কাজে দেবে না। সব সময় ইন্সট্যান্টলি কভার লেটার লেখবেন। তাতে সেটা জত বড়ইহোক না কেনো।
সবার শেষে, ৭ দিন পর এপ্লাই শুরু করুন। এখন আপনি অনেক ভাল কিছু জানেন জেটা হয়তো ৭ দিন আগে এপ্লাই করা শুরু করলেএক মাসেও জানতেন না। দেখবেন আস্তে আস্তে আপনি প্রায় প্রতিদিনই দুই একটা করি ইন্টারভিউ পাবেন। সো গো অন, , , ,
অনেক ভাল কাজ জানার পরও দেখা যায় হুটহাট করে অনেকের একাউন্ট সাসপেন্ড হয়ে থাকে। এ সংক্রান্ত অনেক জিজ্ঞাসা এ গ্রুপেএমনকি আমার ব্যক্তিগত মেসেজেও আসে। ব্যস্ততার কারণে অধিকাংশ মেসেজেরই উত্তর দিতে দেরী হয় অনেক মেসেজের জবাব দেয়াওহয় না। আমার জানামতে ওডেস্ক কয়েকটি বিষয় খুব গুরুত্বের সাথে দেখে সেগুলো হচ্ছে-
• প্রোফাইল : অনেকেই দেখা যায় নতুন সাইনআপ করে আরেকজনের প্রোফাইলের লেখাগুলো কপিপেস্ট মেরে দিলেন। তারাসাবধান। ওডেস্কের কিছু কর্মী আছে যারা নিয়মিত প্রোফাইল পরীক্ষা করে। কারো আগে কারো পরে। ধরা পড়লে নোটিশে বা বিনানোটিশে সাসপেন্ড হবার সম্ভাবনা আছে।
• পোর্টফোলিও : এক্ষেত্রেও উপরের কথাটিই প্রযোজ্য।
• ছবি : আপনার একাউন্টটি যদি ব্যক্তিগত একাউন্ট হয়ে থাকে তাহলে আপনার নিজের সাম্প্রতিক ছবি দিতে হবে। কোন লোগো আঅন্য কিছু না। আর টিমের ক্ষেত্রে টিমের লোগো দিতে পারবেন।
• কভার লেটার : ওডেস্কের নীতিমালা অনুসারে কোন কাজে বিড করার আগে জব পোস্টটি ভালভাবে পড়ে বুঝে সেই জব পোস্টঅনুসারে কভার লেটার লিখতে হবে। একটা কভার লেটার লিখে রেখে সবখানে ওটা পেস্ট করতে থাকলে স্পামার হিসেবে সাসপেন্ডহতে পারেন।
• বাইরে যোগাযোগ : কভার লেটার বা প্রোফাইলে কখনো ঠিকানা, ফোন নম্বর, ইমেইল, মেসেঞ্জার আইডি ইত্যাদি দেবেন না।এগুলো শুধুমাত্র তখনই দিতে পারবেন (অন্তত ইন্টারভিউ লেভেলে) যদি আপনার এমপ্লয়ার আপনার কাছে কাজের স্বার্থে চেয়েথাকেন।
• বাইরে লেনদেন :
আপনার কোন এমপ্লয়ার যদি আপনাকে ওডেস্কের বাইরে পেমেন্ট নেবার প্রস্তাব করে, সরাসরি প্রত্যাখ্যানকরুন। কোনভাবেই ওডেস্কের বাইরে লেনদেন করা যাবে না।

Thursday, April 23, 2015

Data entry jobs profile for oDesk

I expect that all of you are in a relax mode. I would like to start today’s oDesk serial by welcoming everyone. In today’s episode I like to show you how to make a Data entry jobs profile in oDesk. Not only for Data entry jobs, but also you can make any other job’s oDesk profile by following this rule. Only you have to modify a little bit. By the by lets start.
At first login with your created ID and Password. After login, please click “Complete Your Profile” page what you see on the screen.
data-entry-jobs-complete-your-profile
After clicking “Complete Your Profile” page than “Create your freelancer profile”page would come. This page mainly divided into two parts, such as
a. Profile Overview.
b. Location Information.

Complete Your Data entry jobs Profile:

There are some sections Profile in Overview part. Description about these sections and how to do that are shown below.
Portrait: Here have to attach your photo. This is not mandatory. That means if there is no attachment of photography, it will also do. Attachment of photography is better. Because, if there is an attachment photography client would easily recognize. To add a photo, click “Add a photo now”.
data-entry-jobs-add-photo
Now select your choice picture what you preserve in your computer and click ‘Open’. Then click Save Image. After for a while the picture will be added normally. Mind it there will not be attached any types of Logos, clip-art, group pictures or editing picture.
data-entry-jobs-add-photo-2
Title: This section is for the title of a Freelancer. That means what type of Freelancer you are? You may be a Data entry jobs Specialist, Web Research Specialist, Graphics Designer or any other specialist. If you are an expert in more than two topics, than you can write two or more topics at a time. Here I have made a Data entry jobs profile who is expert in various topics. That is why, I write here Data Entry, Web Research, Social Media Marketing and SEO Specialist as a title. Note that this title must in maximum word limit seventy with a space.
data-entry-jobs-title
Overview: You are an expert in Data entry jobs or any other jobs. In this section you have to write down about your professional aim, relevant work experience, your capability and scope of work. Also write in a short article in 4625 words, why an employer choice you. So that, the employer may get a simple idea about you. You must try to write correct English spelling and proper grammar. Because if there is a wrong client may think that you do not know or understand proper English. Mind it do not copy or paste this article from anywhere. Try to follow better profile, but not to do direct copy or paste.
data-entry-jobs-overview
Hourly Rate: In this section you have to mention your profile rate. That means what is your proposed payment per hour from your client. But it is not always correct that client give your payment what you demand (Client gives your payment what you demand from the application’s time, if the client likes). You can mention a rate as consideration of your capability and work experience. But mind it, this rate is not crossing the limit also not far from expected rate. Hence, you are not shown in your work experience first in oDesk. On the other hand, the payment of Data entry jobs is poor and easy that is why try to submit a bit low rate. Because the client always try to hire low rated contractor for Data entry jobs. I demand here $2.00 as a profile rate.
data-entry-jobs-hourly-rate
English Level: You have to mention what the extents of English do you know and also mention your reading English, writing English and level of speaking English in this section. 1 is worst here and 5 is best. The good English level is necessary if it is Data entry jobs or any other jobs. I have mentioned here best “5 – Fluent in both written and verbal skills”.
data-entry-jobs-english-level
Job Categories of Interest: What type of work you like to interest have to mention in this section. To select a categories, click “Add job categories that apply to you”. Then a new page will come. Then select some categories as you wish. As the profile is for Data entry jobs that is why I have selected two Data Entry and Web Research from administrative support, SMM – Social Media Marketing and SEO – Search Engine Optimization from Sales & Marketing. After select category then click save category to save.
data-entry-jobs-save-categories
After select category then it will be shown below.
data-entry-jobs-save-categories-view
Profile Visibility: Who can eligible to see your profile it would be selected here. If it is not selected By Default it would be selected ‘Everyone’. You can select “oDesk Users only” or ‘Hidden’. If you select “oDesk Users only” than oDesk users see your profile. And if you select ‘Hidden’ nobody can see your profile. As you like that every client hire you then you have to select everyone.
data-entry-jobs-profile-visibility
Location Information:
Click “Save Profile and Continue” after filling up your Address, City, Country, ZIP Code(Post office code) and Valid Phone Number.
data-entry-jobs-location-information
Now you will see a new page like below.
data-entry-jobs-5steps
Your profile is initially ready for Data entry jobs. But you cannot apply now for the post of Data entry jobs. If you like to apply for jobs, you have to verify Phone and ID first. Phone verify and ID verify will be discussed in the next article. If you like to know more details you can follow the posts below. Hope that you will be benefited.

Monday, April 20, 2015

What is Data Entry Jobs?

Data Entry Job Tips by Juwel Rana

Introduction
:

what is Data Entry ?? the answer is when a person or typist enter some data into a database by using keyboards that  called data entry. For more realization use some increase to this data like use color and bold options for a word which strike most significant.

At normal knowledge data entry job is one where a man or typist type any into a database may be used text or numerical codes.



Online data entry jobs are now a top of topics over internet .There are so many websites have been display many ads as for data entry jobs such as online jobs, data entry jobs, free data entry work, email reading job ,  captcha  filling job,  article writing job,  freelance and data entry etc etc. normally  the users seek data entry job for money making online so they become interest with this site to give some information where email address is one of them.Many of this website mainly give this registration program looking for mules to operate online accounts for them such as  adsense account, eBay account, bank account, Paypal account, email account.They are only spammers not give any chance to earn.So you should make sure about fraud website information's and go ahead.



Data Entry Jobs:


Some freelancer give data entry job when they get a lots of project.The Bangladeshis, you should at first know about the websites you want to join seriously.The students who are now study to Universities in Bangladesh are more crucial to seek a online data entry job.But at most case they become fail.So be composure and see only internet as daily work.

Thanks.

Sunday, April 19, 2015

Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate

Data Entry-Excel tiutorial


Online Data Entry Tips

Introduction:
Data Entry tips

You know how Many businesses need some help in creating and building their mailing list? Once the structure of your list has been thoughtfully designed, the next step is to place your information into it - the industry term is data entry. While service bureaus offer experienced data entry, in some cases, it may make sense for you to do a large part of your data entry in-house. Your service bureau can help you make this decision. The necessity for clean and consistent data input cannot be emphasized enough. The cost of running your mailing list - in both effort and money - will stay reasonable and remain stable if some consideration is given to how your data should be entered into the system right from the beginning. If it becomes necessary to reinvent the wheel (high level corporate talk for clean up data entry errors) whenever it comes time to add ZIP+4's, remove duplicates, presort labels, etc. the cost will continually be going up -- not down.
This situation is by no means unique in the business world, or the computer services industry - we see it all the time. Hopefully, the following standards will prove to be of as much value to you as other businesses that have asked Northwest Database Services to suggest some ways your in-house list efforts might be improved.
Topics: 

Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

It's more important to your customer than you know

The information entered into your computer is used to maintain contact with your customer. This ongoing contact not only tells you about this person, but more important, tells the customer a lot about you and your company. Normally this is done through mailing, although phone numbers are also used for telemarketing and follow-up survey purposes. The advertising messages you send to customers and prospects (AKA: future customers) are only a small part of what you tell them about yourself and your business. The way in which these communications are handled often tells your audience far more about your feelings towards them than the marketing messages themselves.
All of this effort is for one thing only: to keep in touch with your customer and make sure that he, she or they feel recognized and valued for their contribution to your success. It is for this reason customers continue to do business with your company. It's really that simple, which is why the way that you handle their information is so very important.
Anyone who gets more that one piece of mail from an organization, in the same mailing, can come to only two conclusions. The first is that this company doesn't really care enough about their customers, as individuals (i.e. as real people), to make sure that only one letter or card is sent to them. This feeling of disregard is tremendously compounded when the mailing piece projects personal recognition of the recipient. All of your company's credibility is instantly destroyed and the "personal" message dismissed as more junk mail. A person who receives two or more of these "sincere" mailing pieces feels irritated that you have wasted his or her valuable time only to convey the fact that he or she is on yet one more mailing list. Be honest, don't you feel that way when this happens to you?
The other conclusion that one comes to is this: your company apparently isn't skillful enough at handling its own records to have them listed only once in your mailing list. Nobody really wants to do business with a company that isn't capable and efficient at keeping track of their own customers.
There is no surer way of projecting indifference or incompetence than sending several mailing pieces to the same person - unless it's misspelling their name (or their company, etc.). Again, remember when this has happened to you... and how you felt. 
Topics: 

Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

It's not that difficult

Computers process information literally, they have no discretionary intelligence. A computer can't tell that you meant "John" when you entered "Jhon"; it will simply interpret these as two different names.
For any database (a computer "file" containing names, addresses, phone numbers, etc.) to function properly it must be consistent (Street is always written "St" - Floor is always "Fl", etc.) and it must be accurate (free from typos and "creative" data entry). When everything is done the same way, by everyone involved, your information systems run smoothly (and less expensively).
Carefully data entry, solid data management, and the increased good will that results is actually quite easy. In fact, most people prefer to have some set of standards that make this all possible. While it's true that some of these conventions can be accomplished in more than one equally acceptable way, (such as using "Apt" or "Ste" rather than "#", etc.), for the sake of simplicity the following data guidelines will keep your list on track: 
Topics: 

Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

Names

Peoples' names are made up of five basic parts. The first is the Prefix (Mr, Mrs, Dr, Rev, etc.). After the Prefix comes the First Name. This is followed by the Middle Name (or Middle Initial), the Last Name and finally the Suffix (Jr., III, DDS, MD, PhD, etc.). Normally, most files have separate fields for these name components (at least, they should have). But even when the name is entered into one large field, the same basic data entry rules apply:
  • Do not follow Suffixes, First Initials or Middle Initials with periods (or commas). Never use "and" in combination Prefixes like Mr & Mrs or Dr & Mrs Always use an ampersand (&), with a space on either side.
  • First Names are relatively straightforward. If there are only Initials given, enter those as "J B"; (no periods), with only one space between them. If a First Name is given, for instance, as "C Thomas," (an Initial preceding the "First" - or Middle Name, enter it as "C Thomas"). Dual First Names, such as "John & Mary," are entered accordingly, using an ampersand - not the word "and." 
  • Normally, don't enter Middle Initials, especially if there is a full First Name. Only enter them if an Initial is given for the First Name along with a Middle Initial, i.e. "J J Smith."
  • Last Names are relatively direct. If there is any doubt, always verify the spelling. Keep an eye out for hyphenated Last Names. If a customer says their name is "Jane Cooper Smith," they are likely to spell it, "Jane Cooper-Smith." At any rate, ask if you have the chance; it's important to them.
  • Suffixes are typically things like "MD, DDS, Jr, PhD, III and so on. Enter those after the Last Name separated by a single space. Do not enter a period following, or a comma preceding the Suffix.
  • Every segment of the name should be separated by single spaces. The sequence of the name's data components should be: Prefix, First Name (or First and Middle Initials, or First Initial and Middle Name), Last Name and Suffix - not Last Name comma First Name. The only valid punctuation used is: a hyphen (used in hyphenated last names), and an apostrophe (used occasionally in names like D'Angelo).
    Topics: 

    Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

Companies

Company names have simple rules.
  • The only punctuation allowed is: the pound sign (#) for number ("American Legion Post # 1"), an apostrophe ("Jake's Place" or "Tail 'O the Cock"), a hyphen ("Two-For-One Pizza") or a slash (/) used to denote fractions ("1/2" - this is rare).
  • If a company includes initials as part of its name, separate them with a single space ("IBM Corp" becomes "I B M Corp" - "TNT Productions" becomes "T N T Productions"). The reason that this is done is to keep the company name accurate when "casing" is performed. Casing is a process where information is converted to all upper case letters from upper and lower case, or the other way around. Casing up to all capital letters is simple, but when the operation is reversed (often called "Proper Casing"), the computer will make "IBM" into "Ibm" and "AT&T" into "At&t" or "At&T." Putting a space between these letters, while not the most elegant solution, is usually the most practical and consistent. If a company simply has a weird industrial name, like "Gelco" or "Unetco," enter it as one word. Again, if there is any doubt, ask.
  • Use the same business abbreviations throughout the database ("Inc" for "Incorporated", "Corp" for "Corporation", "Ltd" for "Limited", etc.). If there is any question about what the proper abbreviation is, refer to the table of business abbreviations in USPS Postal Publication # 28, "Postal Addressing Standards." The USPS distributes this publication free of charge.
  • Again, use no commas or periods. "Savinni & Sons, Inc." is wrong; "Savinni & Sons Inc" is correct.
  • Spell out business designations only when they are part of the business's proper name. Sometimes this can be unclear, and your best guess will have to do. There should be, however, an obvious difference between "A-1 Carpet Cleaning Svcs" and "Super Service Steam Cleaning Inc."
  • Use only a proper name in this field. It's OK to enter, "Dr. John Mayfield" and then "Mayfield Dental Care Clinic" (if that's the name of the company); don't enter "Dental Clinic" just because that's what Dr. Mayfield's business happens to be.
    Topics: 

    Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

Addresses

Addresses are probably the most important part of the data entry process. Fortunately, the conventions and abbreviations for address formats are clearly defined by the US Postal Service. If there is any question, again, refer to "Postal Addressing Standards and the address abbreviation standards and tables contained therein.
  • Never, never, never use periods or commas in an address. Acceptable punctuation includes only: the pound sign (#) denoting number (used for apartments or suites), hyphen (occasional - "1234-A Johnson St"), and the slash (/) (for fractions - "234 1/2 Williams Ave"). Do Not Use: double spaces, asterisks (*), commas, periods, parentheses(), quotation marks(""), colons(:), semi-colons(;), apostrophes('). Only use hyphens in the ZIP+4 code (if there is one) or in the primary number used in the delivery address ("2345-C Washington Blvd").
  • There is basically only one address to which mail is delivered for each business or residence, although many businesses may list two. Typically this is a PO Box number and a street address. This is usually done when a business prefers to receive it's mail at its PO Box but must also list it's street address on letterhead, business cards and invoices so that people will know where to send UPS, Fed-X and Airborne packages which don't deliver packages with PO Box addresses). When taking information from a customer, ask what his or her mailing address is, and then enter that address only. Don't enter both lines just because you have two address fields (there are different ZIP Codes for each address, and because you will usually have only one of them, Postal Coding, duplication checking and even delivery will get fouled up. If there is no opportunity to verify the correct mailing address, the PO Box is probably the right one. If you must put both addresses in, make the PO Box line the primary (first) address line - always. If your file has a lot of entities that require separate mailing and shipping addresses, it’s much more professional to simply add a second and distinct set of address fields that to try and mix the data in only one.
  • Even though there are fields allowing for two line addresses, place the address into the first line only. With proper abbreviation, it will fit. If there is an apartment or suite number enter it this way: "2345 W Havenhurst Rd Apt 435" for residential addresses or "2345 W Havenhurst Rd Ste 435" for business addresses. Even though the USPS prefers either "Apt " or " te ", but they also sanction "#" as a secondary substitute for either. Always include a single space after the pound sign.
  • For additional or unusual abbreviations, check the tables in Postal Pub. 28 ("Building 3B" becomes "Bldg 3B", "Floor 3" or "3rd Floor" becomes "Fl 3", etc.).
  • Always ask for and enter the street suffix (i.e. Avenue, Street, Boulevard, Road, Drive, Way, Trail, Lane, Circle, Loop, etc.). "123 Smith" is not an address; "123 Smith Rd" is. This is the most commonly occurring addressing error; one which will seriously impair just about every one of your subsequent mailing list operations. There can be a 123 Smith Rd, a 123 Smith Dr, a 123 Smith Ave, a 123 Smith Cir, etc. all coexisting in the same ZIP Code. If it is unknown which one was meant, not only does the address become uncodable, but the mailing piece may not be deliverable at all.
  • Things like "The Kon Tiki Apartments" or "Parkwood Village Shopping Center" are not true address components; don't include them in the address areas. 90% of the correct addresses you encounter will have a street number, street name and a suffix. There may also be a pre-directional ("123 N Main St") or, occasionally a post-directional ("123 Main St NE) as well. "El Torito Mall" or "The Skyler Building" aren't parts of a functional address.
  • Never arbitrarily put an apartment number or letter between the street number and the street name unless you are sure that that is how it’s properly written. Always add it at the end of the address with an “Apt”, “Ste”, or "#". "1234 B Miller Dr" is bad. "1234 Miller Dr # B" is good. Sometimes an address is legitimately written "1234-C Dennis Rd" (always with a hyphen), but if you are at all unsure, opt for "1234 Dennis Rd # C".
  • Stay with one street number whenever possible. Try to avoid addresses with ranges that look like, "205-13 Trammel Way" unless you are fairly sure that it’s a legitimate address (e.g. it appears on that company’s invoice accompanied by a ZIP with a +4 extension). Although a company's building(s) may occupy all of those street numbers, but its mail is usually delivered to only one of them. As with all addressing, some actually are written as above, but...
  • Don't put hyphens or spaces between numbers and letters when entering an apartment or suite number. "# 3 A" or "# 3-A" should be "# 3A."
    Topics: 

    Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

City, State and Zip

City, State and ZIP should be entered into three separate fields:
  • When it comes to City, always enter the full city name. Don't abbreviate city names - use "Saint Louis", not "St Louis" - " os Angeles" is a city, "L A" is not. State abbreviations are always two characters (in upper case). The ZIP Code should be in one of the following formats (where "N" = a single digit): "NNNNN", or "NNNNN-NNNN". If you don't know the correct ZIP+4 extension, don't guess. Just leave it out, CASS coding will pick it up later.
  • If you must enter all three items into one field, follow the city with a single space, the state abbreviation (always two characters - this is also true for Canadian provinces), a single space and the ZIP or ZIP+4. That's it.
  • If you are entering a Canadian address, you will still enter the city, a single space, the two character provincial abbreviation and then the Canadian ZIP. Canadian ZIP Codes are quite different from US ZIPS and are written in this format: "LNL NLN", where "L" is a letter and "N" is a number. There is a single space between the first three characters and the last three characters (i.e. "W4N 5T7" or "F8M 6H5"). Putting Canada in this field is unnecessary; the ZIP itself is a dead give away. The Country name will be placed into a special Country field, implanted in the mailing file later. If you are entering a lot of foreign addresses, English, Australian and Canadian addresses can look the same -- including similar ZIP formats. If foreign addressing is a large a part of your data entry, create and use a country field to differentiate these at the time of entry. The Post Office requires the Country Name to be in upper case, by itself, on the last line of the mailing label.
    Topics: 

    Data Scrubbing   Data Cleaning   Mailing List Cleanup   Data Cleansing  

Be direct

These simple rules will insure that your mailing list will work and your labor and cost intensive efforts won't be wasted. If names, companies and addresses are entered carefully and consistently, your information can be conditioned and processed electronically (incurring less cost -- much less). Name splitting, salutation creation and letter personalization, USPS CASS certified postal encoding (which will significantly lower your postage costs), duplication removal, etc. will all run accurately, smoothly, and efficiently. The formula is straightforward. Good Data Entry + Skilled Processing = Less Production Money Spent + More Response Money In. That's why it's called direct mail.

About Admin

Hi I am Juwel. Full name Juwel Rana. Now I am studying in Higher secondary in college. But I Mostly Interested in Online Job. I am practicing online work with 2 years. Now I am working as a freelancer on oDesk. And I pretty much Enjoying This. You can Find me on Odesk  Now I am Data entry, Email marketing Expert. I have been working in the Internet Marketing industry for a wide assortment of niches.I truly love challenges and I am seeking opportunities to continue growing my experience to work with you.
Juwel Rana