Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.


Warning

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





Anchor
example
example


Code Block
languagexml
titleExample XML File for EMAIL Campaigns
linenumberstrue
<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>






ParameterDescription
NOTIFICATION_EMAILNotification Email Address.
CAMP_ID32 byte bytes unique guidGUID. Must be 32 byte bytes and must be 0-F.
CAMP_NAMECampaign Name - Must must be no longer than 100 characters.
FROM_NAMEFrom Name must be defined in your account by the RMC Technical Support Team.
FROM_ADDRESSFrom Address must be defined in your account by the RMC Technical Support Team.
REPLY_ADDRESSReply-to Address.
SUBJECT

Email Subject Line - Must must be no longer than 300 characters. If you plan to do subject optimisationuse Subject Optimisation, then

Status
subtletrue
colourRed
titlesubject
 node should be repeated.

SUBJECT_OPT

if you want use “Subject "Subject Optimisation”, 

Status
subtletrue
colourRed
titleenabled="true"
should be added to
Status
subtletrue
colourRed
titleSUBJECT_OPT
.

TARGET_PERCENTAGETarget Percentage means the percentage of the bulk targeted members used for optimisation.
WAIT_HOURWaiting time for optimizationoptimisation.
DELIVERY_DATECampaign delivery date. 2011-01-03 12:56:08
DEMOGRAFIC_FILTERTo 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 

Status
subtletrue
colourRed
titleY
.

READ_FLAG

Read flag for analysing (Open) flag to get the number of opens. Should be 

Status
subtletrue
colourRed
titleY
.

EXPIRE_DATECampaign expiration date. Sending will stop after expiration date. 2011-01-03 12:56:08
MESSAGE

HTML message in 

Status
subtletrue
colourRed
titleCDATA
 tag.

REPORT_ADMINSWhen campaign starts and finishes, all of the related reports are sent to this email address.
PDF_REPORTAutomatic Campaign Report PDF's for executives. Max 2 reports can be defined.
ACTIVE_EMAIL_READERS

Set 

Status
subtletrue
colourRed
titleY
 if you would like to send your campaigns to active members only



Warning
If Active Email Readers
Status
subtletrue
colourRed
titleACTIVE_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 
Anchor
reports
reports

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



Report TypeDescription
Delivery ReportOpen, Hard Bounce, Soft Bonuce and Spam complaint report
Unsubscribe ReportList of members who have unsubscribed
Campaign Links ReportSent only once per each campaign. Reports the links used in the campaign.
Member Link ReportMembers who clicked on links.



Info

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.

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



Delivery Report 
Anchor
delivery
delivery

Status
subtletrue
colourRed
titleCAMP_ID;EMAIL_ADDRESS;MARKED_SPAM;DELIVERY_STATUS;LAST_CHANGE_TIME;CLICK_STATUS;ACCOUNT_KEY_ID;ACTIVITY_ID

Parameters

ParameterDescription
CAMP_IDCampaign ID in the XML File.
EMAIL_ADDRESSRecipient's
Email Address
email address.
MARKED_SPAMY/N: If campaign is marked as
spam
Spam,
spam
Spam = Y.
DELIVERY_STATUSRD (
read
Read/Opened) / HU (
hard bounced
Hard Bounced) / SU (
soft bounced
Soft Bounced) (can be left empty if
spam
Spam = Y).
LAST_CHANGE_TIMELast changed time of the delivery status.
CLICK_STATUSY/N (If click to link in
campaign
Campaign = Y).
ACCOUNT_KEY_IDIf KEY_ID is used as unique column, then the KEY_ID column is returned back.
ACTIVITY_IDIf ACTIVITY_ID is not used, then this column does not appear .



Unsubscribe Report 
Anchor
unsubscibe
unsubscibe

Status
subtletrue
colourRed
titleCAMP_ID;EMAIL_ADDRESS;UNSUBCRIBE_TIME;ACCOUNT_KEY_ID;ACTIVITY_ID;UNSUBCRIBE_TYPE

Parameters

ParameterDescription
CAMP_IDCampaign ID in the XML File.
EMAIL_ADDRESSRecipient's
Email Address
email address.
UNSUBCRIBE_TIMETime the user has unsubscribed.
ACCOUNT_KEY_IDIf KEY_ID is used as the unique column, then the KEY_ID column is returned back.
ACTIVITY_IDIf ACTIVITY_ID is not used, then this column does not appear .
UNSUBCRIBE_TYPEE, S, M for unsubscribe from links; empty for unsubscribes from user form.



Status
subtletrue
colourRed
titleCAMP_ID;LINK_ID;LINK;LINK_NAME;LINK_TYPE;UNIQUE_REFERENCE_COUNT;TOTAL_REFERENCE_COUNT

Parameters

ParameterDescription
CAMP_IDCampaign ID in the XML File.
LINK_ID32 byte bytes GUID Link ID of Link in Campaign.
LINKLink URL.
LINK_NAMEName of the Link provided in the Campaign.
LINK_TYPET: textText, I: imageImage, M: mapMap.
UNIQUE_REFERENCE_COUNTUnique Click Count.
TOTAL_REFERENCE_COUNTTotal Click Count.



Member Click Report 
Anchor
member
member

Status
subtletrue
colourRed
titleLINK_ID;LINK_URL;LINK_NAME;CAMP_ID;CLICK_COUNT;FIRST_CLICK_TIME;LAST_CLICK_TIME;ACCOUNT_KEY_ID;ACTIVITY_ID

Parameters

ParameterDescription
CAMP_IDCampaign ID in the XML File.
LINK_ID32
byte
byteS GUID Link ID of Link in Campaign.
CLICK_COUNTTotal
Click Count
number of Clicks for the Link.
FIRST_CLICK_TIMEFirst Click Time on the Campaign Link.
LAST_CLICK_TIMELast Click Time on the Campaign Link.
ACCOUNT_KEY_IDIf KEY_ID is used as unique column, then the KEY_ID column is returned back.
ACTIVITY_IDIf ACTIVITY_ID is not used, then this column does not appear.