Sending Email Campaigns

Send Email campaigns to your members using the Data Warehouse tables.

This requires that an .XML file be placed in the ZIP file. The system looks for an XML file with the campaign details in the ZIP file, reads the XML file and automatically associates a campaign using the subscriber data.

You may repeat the campaign nodes in order to create multiple campaigns using uploaded data.

On this page:

Example XML

Campaign Reports

Example XML File for EMAIL Campaigns

<euro.message>
<NOTIFICATION_EMAIL>youremailaddress@euromsg.com</NOTIFICATION_EMAIL> 
<CAMPAIGN type="EMAIL">
<CAMP_ID>AAA05D262017BD26BD17DBBBADCCADBA</CAMP_ID>
<CAMP_NAME>your campaign name</CAMP_NAME>
<FROM_NAME>your from name</FROM_NAME>
<FROM_ADDRESS>prodtest@euromsg.net</FROM_ADDRESS>
<REPLY_ADDRESS>euro.message@euromsg.net</REPLY_ADDRESS>
<SUBJECT>This is a test e-mail!</SUBJECT>
 <!--===============================================================================
   =======S U B J E C T   O P T I M I Z A T I O N   N O D E S=======================
   =================================================================================-->
  <!-- If you want to use "subject optimization (subject A/B testing)" in this campaign, you can use subjects more than one and these nodes
 <SUBJECT>subject 1</SUBJECT>
		<SUBJECT>subject 2</SUBJECT>
		<SUBJECT>subject 3</SUBJECT>
		<SUBJECT_OPT enabled="true">
			<TARGET_PERCENTAGE>10</TARGET_PERCENTAGE>
			<WAIT_HOUR>1</WAIT_HOUR>
 </SUBJECT_OPT>  -->
 
<DELIVERY_DATE>2017-03-15 10:00:00</DELIVERY_DATE>
<DEMOGRAFIC_FILTER>SEGMENT='GOLD'</DEMOGRAFIC_FILTER>  <!-- if you want to use a demografic filter in this mail, you can use this node-->
<DAILY_LIMIT>2</DAILY_LIMIT>  <!-- if you want to use dailt limit for a member in this mail, you can use this node-->
<CT_FLAG>Y</CT_FLAG>
<READ_FLAG>Y</READ_FLAG>
 
 <!--================================================================================
	============C A M P A I G N   A P P R O V A L   N O D E S========================
    =================================================================================-->
 <!-- If you want to use "campaign appproval module" in this campaign, you can use these nodes in xml 
<APPROVAL enabled="true">
                    <MIN_APPROVAL_COUNT>1</MIN_APPROVAL_COUNT>
                    <EMAIL lang="TR">omer.yilmaz@euromsg.com</EMAIL>
                    <EMAIL lang="TR">oguz.olgun@euromsg.com</EMAIL>
</APPROVAL> -->

<EXPIRE_DATE>2017-03-16 10:00:00</EXPIRE_DATE>

  <!--===============================================================================
	  =============G O O G L E   A N A L Y T I C S   N O D E S=======================
      =================================================================================-->
 <!-- If you want to use "Google Analytics utm parameters" in this campaign, you can use these nodes
<GOOGLE_ANALYTICS enabled="true">
	<UTM_SOURCE>test_source</UTM_SOURCE>
	<UTM_MEDIUM>test_medium</UTM_MEDIUM>
	<UTM_CAMPAIGN>test_campaign</UTM_CAMPAIGN>
	<UTM_TERM>test_term</UTM_TERM>
	<UTM_CONTENT>test_content</UTM_CONTENT>
</GOOGLE_ANALYTICS> -->
<MESSAGE><![CDATA[<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
Hello <##FIRSTNAME##>, This is a test e-mail.
</body>
</html>
]]></MESSAGE>
  <!--=================================================================================
	  =============C R A W L E R   F O R   E M A I L   C O N T E N T===================
      =================================================================================-->
<!--If you want to use crawler for email content, you can use these nodes instead of HTML Body
		<MESSAGE>
		<![CDATA[http://euromsg.net/bulten]]>
		</MESSAGE> -->
		
<REPORT_ADMINS>youraddress@euromsg.com</REPORT_ADMINS>
	<REPORT_ADMINS>youraddress@euromsg.com</REPORT_ADMINS>
	<PDF_REPORT enabled="true">
	<FIRST_REPORT enabled="true">
	<EMAILS>youraddress@euromsg.com</EMAILS>
	<DAY_AFTER>1</DAY_AFTER> <!-- in hour type -->
	<LANG_ID>TR</LANG_ID>
	</FIRST_REPORT>
	<SECOND_REPORT enabled="true">
	<EMAILS>youraddress@euromsg.com</EMAILS>
	<DAY_AFTER>6</DAY_AFTER><!-- in hour type  -->
	<LANG_ID>TR</LANG_ID>
	</SECOND_REPORT>
	</PDF_REPORT>
	</CAMPAIGN>

  <!--=================================================================================
	  =============O F F E R   I D S   N O D E S===================
      =================================================================================-->
  <!--If you want to use OFFER structure in this email, you can use these nodes;
<OFFERS>
	<OFFER>
		<OFFER_ID>1</OFFER_ID>
		<OFFER_HTML><![CDATA[<tr><td><a href="http://euromsg.com/<##KEY_ID##>">offer 1<##FIRSTNAME##></a></td></tr>]]></OFFER_HTML>
	</OFFER>
	<OFFER>
		<OFFER_ID>2</OFFER_ID>
		<OFFER_HTML><![CDATA[<tr><td><a href="http://euromsg.com/<##KEY_ID##>">offer 2<##FIRSTNAME##><</a></td></tr>]]></OFFER_HTML>
	</OFFER>
	<OFFER>
		<OFFER_ID>3</OFFER_ID>
		<OFFER_HTML><![CDATA[<tr><td><a href="http://euromsg.com/<##KEY_ID##>">offer 3<##FIRSTNAME##><</a></td></tr>]]></OFFER_HTML>
	</OFFER>
</OFFERS>-->
</euro.message>

Parameter	Description
NOTIFICATION_EMAIL	Notification Email Address.
CAMP_ID	32 bytes unique GUID. Must be 32 bytes and must be 0-F.
CAMP_NAME	Campaign Name must be no longer than 100 characters.
FROM_NAME	From Name must be defined in your account by the RMC Technical Support Team.
FROM_ADDRESS	From Address must be defined in your account by the RMC Technical Support Team.
REPLY_ADDRESS	Reply-to Address.
SUBJECT	Email Subject Line must be no longer than 300 characters. If you plan to use Subject Optimisation, then SUBJECT node should be repeated.
SUBJECT_OPT	if you want use "Subject Optimisation”, ENABLED="TRUE" should be added to SUBJECT_OPT.
TARGET_PERCENTAGE	Target Percentage means the percentage of the targeted members used for optimisation.
WAIT_HOUR	Waiting time for optimisation.
DELIVERY_DATE	Campaign delivery date. 2011-01-03 12:56:08
DEMOGRAFIC_FILTER	To target a specific group in a data file. Example: send the campaign to people in data file in segment = A
CT_FLAG	Click through flag for analysing number of clicks. Should be Y.
READ_FLAG	Read (Open) flag to get the number of opens. Should be Y.
EXPIRE_DATE	Campaign expiration date. Sending will stop after expiration date. 2011-01-03 12:56:08
MESSAGE	HTML message in CDATA tag.
REPORT_ADMINS	When campaign starts and finishes, all of the related reports are sent to this email address.
PDF_REPORT	Automatic Campaign Report PDF's for executives. Max 2 reports can be defined.
ACTIVE_EMAIL_READERS	Set Y if you would like to send your campaigns to active members only

If Active Email Readers ACTIVE_EMAIL_READERS segment is not defined by the RMC support team, the campaign data will be sent to all subscribers in the Data Warehouse table.

Campaign Reports

RMC Data Warehouse module sends the campaign reports to SFTP every night. This report includes the following data:

Report Type	Description
Delivery Report	Open, Hard Bounce, Soft Bonuce and Spam complaint report
Unsubscribe Report	List of members who have unsubscribed
Campaign Links Report	Sent only once per each campaign. Reports the links used in the campaign.
Member Link Report	Members who clicked on links.

In these files, data are in .CSV files separated by a semicolon (;) and provided as ZIP. The details and the columns of this file are listed below. These files are sent to your SFTP address.

SFTP credentials should be shared with the RMC Technical Support Team.

Delivery Report

CAMP_ID;EMAIL_ADDRESS;MARKED_SPAM;DELIVERY_STATUS;LAST_CHANGE_TIME;CLICK_STATUS;ACCOUNT_KEY_ID;ACTIVITY_ID

Parameters

Parameter	Description
CAMP_ID	Campaign ID in the XML File.
EMAIL_ADDRESS	Recipient's email address.
MARKED_SPAM	Y/N: If campaign is marked as Spam, Spam = Y.
DELIVERY_STATUS	RD (Read/Opened) / HU (Hard Bounced) / SU (Soft Bounced) (can be left empty if Spam = Y).
LAST_CHANGE_TIME	Last changed time of the delivery status.
CLICK_STATUS	Y/N (If click to link in Campaign = Y).
ACCOUNT_KEY_ID	If KEY_ID is used as unique column, then the KEY_ID column is returned back.
ACTIVITY_ID	If ACTIVITY_ID is not used, then this column does not appear .

Unsubscribe Report

CAMP_ID;EMAIL_ADDRESS;UNSUBCRIBE_TIME;ACCOUNT_KEY_ID;ACTIVITY_ID;UNSUBCRIBE_TYPE

Parameters

Parameter	Description
CAMP_ID	Campaign ID in the XML File.
EMAIL_ADDRESS	Recipient's email address.
UNSUBCRIBE_TIME	Time the user has unsubscribed.
ACCOUNT_KEY_ID	If KEY_ID is used as the unique column, then the KEY_ID column is returned back.
ACTIVITY_ID	If ACTIVITY_ID is not used, then this column does not appear .
UNSUBCRIBE_TYPE	E, S, M for unsubscribe from links; empty for unsubscribes from user form.

Campaign Links Report

CAMP_ID;LINK_ID;LINK;LINK_NAME;LINK_TYPE;UNIQUE_REFERENCE_COUNT;TOTAL_REFERENCE_COUNT

Parameters

Parameter	Description
CAMP_ID	Campaign ID in the XML File.
LINK_ID	32 bytes GUID Link ID of Link in Campaign.
LINK	Link URL.
LINK_NAME	Name of the Link provided in the Campaign.
LINK_TYPE	T: Text, I: Image, M: Map.
UNIQUE_REFERENCE_COUNT	Unique Click Count.
TOTAL_REFERENCE_COUNT	Total Click Count.

Member Click Report

LINK_ID;LINK_URL;LINK_NAME;CAMP_ID;CLICK_COUNT;FIRST_CLICK_TIME;LAST_CLICK_TIME;ACCOUNT_KEY_ID;ACTIVITY_ID

Parameters

Parameter	Description
CAMP_ID	Campaign ID in the XML File.
LINK_ID	32 byteS GUID Link ID of Link in Campaign.
CLICK_COUNT	Total number of Clicks for the Link.
FIRST_CLICK_TIME	First Click Time on the Campaign Link.
LAST_CLICK_TIME	Last Click Time on the Campaign Link.
ACCOUNT_KEY_ID	If KEY_ID is used as unique column, then the KEY_ID column is returned back.
ACTIVITY_ID	If ACTIVITY_ID is not used, then this column does not appear.

Parent Topic: Data Warehouse SFTP Integration