Latest Articles

article-img
Marketing & Commerce | November 14, 2018
Binary Sort Collation Campaign
​Today, I am writing about how different binary collations between databases affect Campaign sorting and result in an error. The 'Campaign' uses binary sort collation but this is not enough. I encountered a case where two databases (Oracle and Netezza) are using binary sort collation but still, it results in incorrect sort order. In the case, the input is taken from 1 database and this was made output to another database. ERROR Message encountered : [SORT ORDER] [THIS_CYCLE] Audience ID: Wrong sort order detected (Last ID > This ID)[SORT ORDER] [THIS_CYCLE] Audience ID: Wrong sort order detected (Last ID > This ID)Last ID: Name=FK_ROWID_ASSET, Type=8, Chars=100, Bytes=100, dbtype=17, prec=0, Value='02i0Y000001XOBiQAO'   Reason: This is because sort order of database is different from what Campaign expects. Although both databases have binary sort collation yet there is a difference between these two binary sort collations itself. One database is using ASCII format and the other one is using EBCDIC standard. In the ASCII standard, all uppercase letters appear before any lowercase letters. In the EBCDIC standard, the opposite is true: all lowercase letters appear before any uppercase letters. So, the way one database sorts are different from the way another database expects sorting to be. Hence it resorts them onto campaign server. That's why we get the wrong sort order error. If this is the case, there is no way we can avoid this error. This is as expected. Documents referred: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/nlspg/linguistic-sorting-and-matching.html#GUID-68633595-DC95-4393-A6B8-146AD05F5FDF https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/charset-binary-collations.html
article-img
Marketing & Commerce | October 23, 2018
Campaign Sort Orders
  This is Swati Rajput. I am getting started with my first blog today in which I am writing about various sort orders that a database has and what sort orders are specifically needed by Campaign. ​ If sort order of database is different than what Campaign needs, what parameters, configuration or commands need to be run on database to match those so that data sorting can be avoided on Campaign Server. Instead if appropriate sort orders are set , sorting of data would be carried on database which would be much faster. By default, Campaign Use Binary Sort order. In order to do proper sorting at campaign, set default character set as UTF-8, default character type as Unicode and sort order as Binary. Oracle Sort Orders: Default sorting order in oracle is binary. Execute this command to check various sorting techniques in Oracle: select * from v$nls_valid_values where parameter='SORT'; ​Sort order Sql Server​ More description: https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1572/html/sprocs/X46017.htm DB2 sort order collate_info - Collating Information This parameter determines the database's collating sequence. For a language-aware collation, the first 256 bytes contain the string representation of the collation name (for example, SYSTEM_819_US). This parameter can only be displayed using the db2CfgGet API. It cannot be displayed through the command line processor or the Control Center. You can specify the collating sequence at database creation time. More description: https://www.codeproject.com/Articles/71612/Controlling-Collation-Order-On-DB https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.admin.nls.doc/doc/c0007183.html Teradata sort order: The Teradata Database offers five standard collation sequences in which data can be defined as CASESPECIFIC or NOT CASESPECIFIC. This affects how the five collation sequences collate and compare data. The five collations, determined either by default or explicit use of the SET SESSION COLLATION statement, are: •  ASCII •  EBCDIC •  CHARSET_COLL •  JIS_COLL •  MULTINATIONAL CASESPECIFIC or NOT CASESPECIFIC can be chosen at table definition time, or specified...
article-img
Marketing & Commerce | October 3, 2018
Interact Coverage Analysis
  Database marketers often want to test their Interactive channel(s) whether they have enough offer coverage for each group of their customer base or for certain groups of segments. ​ NEW FEATURE IN INTERACT  In addition to the Simple and Advanced Scenario simulator features which had already been introduced, a new and very useful simulation capability has been made available in Interact version 11.0.   FUNCTIONALITY  The ‘Simulator Coverage Analysis scenario’ functionality allows marketeers to create reusable scenarios in order to test whether their offers, events, segmentation, strategy and suppression rules will work as expected.   LOCATION  The simulator functionality is accessible in the Design Time environment (this is the same environment marketers use for Campaign) and can be found in the Interactive Channel’s Simulator tab.   DETAILS  ​A set of commonly used API methods (startSession(), getOffers() and endSession() is used to build your reusable simulation scenario. Users can define against which Audience ids the coverage analysis scenario will run (All or a custom defined selection of audience ids using filter criteria in the profile data)​The scenario can be run against All of a selection of Zones. The user can choose whether to take Event pattern existing states and Offer suppression rules into account when running the scenario.   In order to create a new coverage scenario open the Scenario tab in the Marketing Suite Interactive channel definition screen. ​ You can select All or a selection of Zones: ​ You can use all Audience ids or apply a filter condition: ​ The scenario editor also allows you to add additional columns from the profile data to capture during the scenario run: ​ Indicate whether to apply existing event pattern state and offer suppression rules: ​ ​Note that depending on the size of the profile data table (and the complexity of...
article-img
Marketing & Commerce | September 27, 2018
Planning for Marketing Effectiveness
Planning for a campaign is much easier with Marketing Suite products which are designed to cater to every marketing objective or activity. Marketing Effectiveness helps in reducing the time and budget for any Campaign. The below article will help to understand the steps
article-img
Marketing & Commerce | September 6, 2018
Using Campaign Outbound Triggers
An outbound trigger is the execution of a command, batch file, or script (that is stored on the Campaign Application Server) that takes place after a flowchart or process is run. You can define triggers to perform virtually any action, such as opening an application, sending an email, or running a program.
article-img
Automation | August 27, 2018
Using Campaign Inbound Triggers
  This blog will take you through the Inbound Triggers – triggers sent from other applications to Campaign. Inbound Triggers Inbound triggers are triggers sent from other applications to Campaign.  The other applications send information to the unica_actrg executable that resides in the bin directory (<CAMPAIGN_HOME>/bin).  The application calls unica_actrg and passes parameters: ​ Usage of unica_actrg ​Possible parameters can be seen by typing ‘unica_actrg’ from the command line: Unica_actrg [-p <port.] [-s ] [-v] [ | | -n ] , , … Where items enclosed in [] brackets are optional.   The | sign indicates an ‘OR’ – campaign code can be used, or campaign name or flowchart name.   -v is used to indicate the version of the Campaign Trigger Utility.   Examples: 1)     All flowcharts waiting for ‘Go’ This would send a message to continue execution of all flowcharts (the * is a wildcard) waiting for the command ‘go’.   Tip:  In Unix, if there are spaces in the campaign name or flowchart name this will cause an error.  To avoid this put quotes around the asterisk. <CAMPAIGN_HOME>/bin/unica_actrg ‘*’ Go   2)     All flowcharts waiting for ‘Go’ specifying the port.   <CAMPAIGN_HOME>/bin/unica_actrg –p 5664 ‘*’ Go   This would call the Campaign on port 5664 (if multiple versions of Campaign are installed on the same server you may need to specify the port) and send a message to continue execution of all flowcharts (the * is a wildcard) waiting for the command ‘Go’.   3)     A specific flowchart waiting for the command ‘Go’ <CAMPAIGN_HOME>/bin/unica_actrg TestFlowchart Go   This would send a message to continue execution of the flowchart ‘TestFlowchart’ waiting for the command ‘Go’. Campaign A Triggers Execution of Campaign BIn this example Campaign A will send an outbound trigger that will then be the inbound trigger that Campaign...

Upcoming Event

No upcoming events
Close