reportUserClicked UserGuide

reportUserClicked User guide

This page serves as a quick install guide of reportUserClicked. To send personalized message, refer this page.

(1) User registration.

You have to SIGN UP(Free) and you will recieve your user ID and password .
Choose [File|Preference..] from menu bar of base messege window, select [reportUserClicked] tab from tab list. Next, enter your userID and password to fields.

(2) Creating a message.

Create base message using adToOne. user guide shows how to create a base message.
To insert URL in your message, choose [reportUserClicked | insert URL for tracking...] from menu bar.

[[reportUserClicked = target URL , RUC_fieldName]]

target URL: URL you want to insert in your message.
RUC_fieldName: This must starts with "RUC_".

To insert URL for unsubscripition, choose [reportUserClicked | insert URL for unsubscription...] from menu bar.

[[reportUserClicked_unsubscribe= targetURL, RUC_UNSUBSCRIBE

target URL: Web page in your site after unsubscribed.
e.g.) sample

Please refer the following page to purchase this product.
[[reportUserClicked = http://www.foo.com/producta.html , RUC_PRODUCT_A]]
If you wish to be removed please click.
[[reportUserClicked = http://www.foo.com/unsubscribe.html , RUC_UNSUBSCRIBE]]

(3)Send e-mail to your recipient

Send e-mail using adToOne. In sending phase, adToOne uploads URL in the message to server of zaisoft automatically. And URL in a base message will be converted as follows.
e.g) sample

Please refer the following page to purchase this product.
http://www.zaisoft.com/cgi-bin/r2.cgi?5f534b475774474
If you wish to be removed please click.
http://www.zaisoft.com/cgi-bin/remove.cgi?4df5ba54cc

(4)Recipient clicks the URL in a email.

Recipient will click URL in a email and web browser will display the web page which you specified in (2). In this process, server of zaisoft records the clicks.

(5)Download click data from zaisoft.com to your client.

(A) If your recipient list is CSV or tab delimited text,
Choose [reortUserClicked| RucDownload] from menubar. You need to specify (a)the recipient list to be merged, (b)field name represents e-mail address of recipient and (c)your password for reportUserClicked.
(a) recipient list: click history and analyzed data will be merged to this list.
(b) field name: represents e-mail address of reicipient.
(c) your password for reportUserClicked.
(B)In ODBC connection
In ODBC database connection, you have to append columns to your table for storing analyzed data.

Column name to append Column type

RUC_MAILTYPE String

RUC_UNSUBSCRIBE String unsubscription info

RUC_fieldName String URL used in base message of (2)

Next, you have to create new table contains click list. Set permission which you can insert and update table.
Table name: RUC_CLICKLIST

Column name Column type

EMAIL String email address of the recipient

SN String serial number of e-mail

CLICKTIME String date and time when click occurs

URL String url which recipient clicks

FIELD String field name of clicked url

MAILTYPE String mail type of recipient clicks

Choose [reortUserClicked| RucDownload] from menubar. You need to specify (a)the recipient list to be merged, (b)field name represents e-mail address of recipient and (c)your password for reportUserClicked.

(6)Update your recipient list.

After the download, click history and analyzed data will be merged into your recipient list automatically.

RUC_DATA: Click list, log.
RUC_FieldName: Evaluation value of recipient's interest based on click history.

RUC_FieldName Evaluation Description

4(Strong interest) click almost always Click this field twice or more and click this field almost always(over 80%).

3(New interest) click recently Click this field of the mail which delivered the last or second last.

2(interested) there was a click There was a click in this field.

1(not interested) no click There is no click.

RUC_MAILTYPE: Mail type which recipient opens.

RUC_MAILTYPE Description

Plain text A recipient clicks the URL in plain text message. You sent plain text mail or recipient's mail client does not support HTML mail.

HTML mail A recipient clicks the URL in HTML mail. You send HTML mail and recipient's mail client supports it.

Mobile mail You sent mobile mail and recipient click the URL in it.

Unknwon Unknown. Because recipient haven't been to click any URL.

Column name to append	Column type
RUC_MAILTYPE	String
RUC_UNSUBSCRIBE	String	unsubscription info
RUC_fieldName	String	URL used in base message of (2)

Column name	Column type
EMAIL	String	email address of the recipient
SN	String	serial number of e-mail
CLICKTIME	String	date and time when click occurs
URL	String	url which recipient clicks
FIELD	String	field name of clicked url
MAILTYPE	String	mail type of recipient clicks

RUC_FieldName	Evaluation	Description
4(Strong interest)	click almost always	Click this field twice or more and click this field almost always(over 80%).
3(New interest)	click recently	Click this field of the mail which delivered the last or second last.
2(interested)	there was a click	There was a click in this field.
1(not interested)	no click	There is no click.

RUC_MAILTYPE	Description
Plain text	A recipient clicks the URL in plain text message. You sent plain text mail or recipient's mail client does not support HTML mail.
HTML mail	A recipient clicks the URL in HTML mail. You send HTML mail and recipient's mail client supports it.
Mobile mail	You sent mobile mail and recipient click the URL in it.
Unknwon	Unknown. Because recipient haven't been to click any URL.