Showing posts with label tips. Show all posts
Showing posts with label tips. Show all posts

Thursday, December 4, 2008

Blogger Tip: How to add "Email Subscription Form"

Looking for a way to collect emails from blogger site visitors? Here are some good source I found:
  • Feedblitz.com: This is a free (ad supported) service that enables publishers to collect subscribers and send emails for free.
  • Feedburner.com (now part of Google): Primarily used to send new articles with a very light 'delivered by' footer, ability to export subscriber email addresses.
Here are a couple of nice posts on this subject: "how to add Email Subscription Form using Feedburner" and "Add RSS/Email subscription in Blogger".

Separately, Google added the "Subscribe to" feature which is different, it currently only supports 3 RSS readers: Google, Bloglinks, and Netvibes, and there is no email support.

Wednesday, November 26, 2008

eMarketer: 54% of Retailer still do not test email subject line

Personally, I am now getting about 2 emails a week from Amazon, more than one per week from Costco and Target. This is probably two to three times the normal frequency, it's probably the combination or final holiday push and desperation during tough economic condition. They are definitely trying harder, unfortunately, I don't think many of them are hitting the sweet spots yet, at least for me. What about for you?

Obviously, the sender's FROM address (both email and display name parts) is crucial in determining the open and response rates. Recipients needs to trust and feel they have a relationship to even consider opening the email.

After that, the subject line is the key. Much more important than time of day or day of week in most of the emails I have tried. Changing a couple of key words can have huge impact on open rate AND response rate. Subject lines set the expectation of what's inside the email. You can have a very provocative subject line to get people open the email, but if people feel they are cheated or if the email did not meet people's expectation, the click-to-open ratio could be much worse. This would hurt the long term relationship with the user.

Different subject lines can have huge swing in different age groups and achieve plus/minus 50% in overall response. Is it too much work for 54% of the retailers to do?

Sources:
eMarketer: E-Mail Marketers Get in the Spirit (11/26/2008)

Tuesday, June 24, 2008

Tips: Calculate hours between two dates in Excel

Here is a handy function to calculate the difference between two dates:
  • =DATEDIF(Date1, Date2, Interval) where:
  • interval="m" for number of months
  • interval="d" for number of days
  • interval="y" for number of years
  • For example:
  • =(DATEDIF(today(),A1, "d")-1) *24 is approximately number of hours between today and the date value stored in cell A1.

Reference:

Tips: Add Outlook Mail Box

Add additional mail boxes for Outlook 2003
1) go to Start; Setting; Control Panel
2) Double click on the Mail icon
3) Choose Email accounts
4) view or Change email accounts
5) Click on Microsoft Exchange Server and choose Change
6) Click on More Setting..
7) Goto the Advanced tab and click the Add ... button
8) Enter "Robert.Demo" and click OK
9) Continue clicking OK buttons to close up the Mail control panel