Campaign Importer

Owned by PeterF (Deactivated)
Last updated: Sept 06, 2016 by Pete (Deactivated)
2 min read

Noojee Campaigner provides a number of methods to automate the import of campaign lists from an external system such as a Customer Relationship Management System (CRM).

SQL

Importing a campaign list using SQL is probably the easiest method of integrating NJC with your CRM.

To implement SQL Importing from your CRM into NJC we need the following:

  • Type of SQL Server (e.g. MySQL, Microsoft SQL, Web Service).
  • IP address/hostname of the SQL server
  • Database Schema to to be used
  • Username for access to the SQL server which has appropriate rights to execute the supplied SQL queries
  • Password for the above username

When a Campaign Manager goes to import a campaign the system will first run the 'getnjcampaigns' stored procedure and display the results in a drop list.

The Campaign Manager will then select one of the campaigns from the list and click the import button. The system will then run the second query passing the unique id of the select campaign.

The two queries might look similar to the following:

select name, id from tblCampaign;
select phone, firstname, surname, street, suburb, postcode from tblLeads where campaignid = <id>

At run time the system will substitute <id> with the 'id' from the campaign selected by the user.

Campaign query - 'getnjcampaigns'

The campaign query MUST return two fields.

  • The first field MUST be a unique name for the campaign.
  • The second field MUST be a unique id for the campaign.

The Campaign name will be displayed to the user in a drop list. The id will be used in a filter (where) clause on the list query.

Ideally the query should be wrapped in a stored procedure as this will isolate NJC from any schema changes that may occur within your CRM.

List query - 'getnjleads'

The second query would then return a row for each lead in the list. The 'lead' must return at least one field which must have a field name of 'phone' which MUST contain the phone number to be dialed. The phone field must be a full 10 digit phone number. The query may return any number of additional fields. Each field MUST have a unique field name.

For repeated imports, the set of fields returned by the query MUST match the full set of fields defined in for the Campaign Type.

Ideally the query should be wrapped in a stored procedure as this will isolate NJC from any schema changes that may occur within your CRM.