MKT510 – List Creation Process

This batch process report will load a list from a predefined query and specifies how many records there should be in a list.

MKT510 will fail if the custom SQL query used contains comments in the (--) format. Instead, use comments in the format (/* */).

The query can fetch “N” number of records but user might want to select only the first 500 records in a particular list. If “0” is selected it creates a list with all the records.

If the report tries to load a list from a predefined Data Analyzer query, and the query returns zero results, MKT510 will fail.

Parameters

Parameter

Description

Required?

Organization

The Organization ID for which you want to run the report.

Read-only

Organization Unit

The Organization Unit ID for which you want to run the report.

Read-only

List Code

List Code is a uniquely assigned number for each time the list is used.

If you want to use a Data Analyzer query list, you need to create a DA query with only 2 columns - Master_Customer_ID and Sub_Customer_ID in Select if the query has a UNION clause.

Yes

Total Number of Records

This parameter specifies how many records should be there in a list. The query can fetch 'n' number of records but user might want to select only first 500 record in a particular list. If this is 0, then it is assumed to create a list with all the records.

Yes

Regenerate Flag

If this flag is checked then existing members in the list will be deleted before loading the list with new criteria. If this flag is not checked then existing members in the list will be kept and new members will get added in list upload process.

Yes

Sample Report

List Creation Statistics Report

List Creation Rejection Report