Delivering Measurable Online Success

Archive for September, 2009

Keyword Traffic Estimator

Sunday, September 27th, 2009

I wanted to make you all familiar with one of the PPC tools, using this blog. Use the Traffic Estimator tool to find out how the keywords you are suggesting, going to perform. This tool helps to estimate the Max CPC of the keywords we select, the estimated ad position for those particular keywords, estimated clicks & cost per day. The estimates are based on the bid amounts and geographical targeting selections. We can also download the file in a .csv format and share it with the clients. It is an external tool and easily available when you search for it on Google.

I am attaching a screenshot of the tool for your convenience. I have used the keyword ‘fresh flower’ as an example. You can change the keywords and try. Please let me know if you have any questions about the tool or it’s usage.

screenshot1.JPGscreenshot.JPG




Making a difference in someone’s life..

Friday, September 25th, 2009

As an organization, our endeavor always remain to involve us and our staff members in activities wherein we can proudly say, we made a difference in someone’s life. Do not measure how big or small your contribution is. Important is at least you have started thinking in the right direction..

Ms. Supreet, a Chandigarh Adventure Treks & Sports (CATS) member and supporter of many social activities shared something which we want to share with the masses through our blog. Read on in her own words…

“There is an NGO in our City Beautiful, Chandigarh (India) called Theatre Age, which was formed in 1992 by Dept of Indian Theatre graduate from Panjab University, Zulfiqar Khan. Theatre age focuses on the upliftment of slum children. Till date, approximately 51 rag pickers, boot-polishers and labourers are in the process of discovering themselves and carving their niche in the world. Theatre Age rehabilitates the children from the above identified categories and introduces them to school education and offer a new perspective through theatre and dance workshops. Recently 15 children associated with Theatre Age have passed 8th and 9th grade examination with flying colours. Not toppers, but winners for sure.

A boot-polisher, VeerPal learnt new skills at Theatre Age and has now joined a reputed television channel as a trained make-up artist.
Vicky Raja transformed himself from a street urchin to Border Security Force soldier.
Sahil joined Theatre Age at the age of 4 as a rag-picker and now at the age of 13, he had passed 8th grade exams with flying colours.

Funds for their evening school run in sec.24 are generated via collection and sale of old newspapers or ‘raddi’ as is generally called. Theatre Age will arrange to collect your ‘raddi’ from your home, office, department at a time.day convenient to you. All you have to do is make up your mind that instead of putting your old newspapers in the gargabe bin or selling it for a few bucks to the ‘kabaari’, you will rather let the old newspapers spell a new world of education for an underprivileged child.

Would you like to be the reason for someone’s path to dignified financial and vocational independence?

Can we offer a ray of hope to a tender soul, a hope to look towards a better future?

All it will take is one phone call from you, when you want your old newspapers/raddi to be collected, absolutely free of charge.

Contact Person- Mr. Kanwar

Contact Number- 9877442675″

PicturePicturePicture

Reference Link for pictures:http://catseduCATe.blogspot.com/



MySql Delete Duplicates

Thursday, September 10th, 2009

We all must have faced to delete the duplicate entries in a table.
Here’s the simple solution to that. :)

The scenario is:
The table has 3 columns, A, B, and C. Column A is unique for all rows
but the columns B and C can be duplicated across rows. Now if you need
to remove the rows where B and C are duplicated.

DELETE
FROM daTable
WHERE a NOT IN
( SELECT MIN(a)
FROM daTable
GROUP
BY b,c )



Moment of Pride and Celebrations for RedAlkemi

Friday, September 4th, 2009

It gives us immense pleasure to share with you all that our Co-Founder and COO of RedAlkemi, Ms. Anuja Lath has been honored with the Award of Excellence as the “Woman Entrepreneur of the Year” for the year 2008-2009 by Software Technology Parks of India (STPI).

Dr. S.S. Channy, Principal Secretary, Industries and Commerce, Government of Punjab, distributed the STPI Software Exports Awards for 2008-09 at the awards night held as part of the e-Revolution 2009.

Award FunctionAward Function