Go to Bottom

Bronto Contact Export

In this Topic: Show

Overview

Bronto is an email marketing tool that provides the user with the ability to execute sophisticated email marketing campaigns throughout the customer life cycle, thereby increasing contact engagement and driving repeat purchases by sending the right message to the right contacts at the right time.

Support for Bronto integration is available in the Standard, Plus and Enterprise Editions of the Order Manager. The user must have a Bronto Professional account. At this time, integration with Bronto's Agency Edition is not supported.

Order Manager customers should contact Bronto support at 919-595-2500 extension 2, for technical assistance.

Configuring the Order Manager to integrate with Bronto Email Marketing Software

Contact Bronto to obtain Site, SiteID, Token and UserID values that need to be entered into the appropriate Order Manager System Parameters listed below. For instructions on entering values into Order Manager System Parameters, see the Knowledge Base article, Set System Parameters.

Enter Bronto Information into Order Manager System Parameters

   When entering Bronto-provided values into the system parameters, be sure to use the appropriate case for all letters.

There are no Special Parameters (cart-based) for this service. Customer records can be limited to those associated with a specific shopping cart by using the Source of Initial Order drop-down on the Bronto Export Filter screen, as seen later in this article.

Map the Order Manager Fields to Bronto Fields

  1. Log in to the Bronto application.

  2. Click the [Contacts] tab and select the [Fields] link.

Figure 1: Bronto Contacts tab

  1. Click on the [Create New Field] link in the upper right-hand corner of the screen.

Figure 2: Bronto Create New Field screen

  1. The chart below shows the fields that can be exported from the Order Manager to Bronto. Create a field definition in Bronto for each Stone Edge Field in the chart. Use the value in the Bronto Field column of the chart as the Name field, seen in the figure above. While the Label field in the screen pictured above is an arbitrary value, it might be helpful to use the Stone Edge Field name as the label.

      When entering fields names into the Create A Field screen pictured above, be sure to enter the field names using lower case letters.

Stone Edge Field

Bronto Field

Field

Details

Field Description

Prefix

prefix

text

Contact’s prefix

First Name

firstname

text

Contact’s first name

Middle Name

middlename

text

Contact’s middle name

Last Name

lastname

text

Contact’s last name

Suffix

suffix

text

Contact’s suffix

Company

company

text

Contact’s company name

City

city

text

Contact’s address city

State

state

text

Contact’s address state

Zip

zip

text

Contact’s address zip

Country

country

text

Contact’s address country

Phone

phone

text

Contact’s address phone

Original Order Date

originalorderdate

date

The date of the first order ever placed by this contact.

Recency

recency

date

The date of the most recent order placed by this contact.

3 Month Frequency

3mofrequency

number

The number of orders placed by this contact in the last three months.

3 Month Monetary Value

3momonetaryvalue

currency

The total amount of orders placed by this contact in the last three months.

6 Month Frequency

6mofrequency

number

The number of orders placed by this contact in the last six months.

6 Month Monetary Value

6momonetaryvalue

currency

The total amount of orders placed by this contact in the last six months.

12 Month Frequency

12mofrequency

number

The number of orders placed by this contact in the last twelve months.

12 Month Monetary Value

12momonetaryvalue

currency

The total amount of orders placed by this contact in the last twelve months.

Previous Order Date 1

previousorderdate1

date

The date of the most recent order placed by this contact.

Previous Order Source 1

previousordersource1

text

The source of the most recent order placed by this contact.

Previous Order Amount 1

previousorderamount1

currency

The amount of the most recent order placed by this contact.

Previous Order Date 2

previousorderdate2

date

The date of the second most recent order placed by this contact.

Previous Order Source 2

previousordersource2

text

The source of the second most recent order placed by this contact.

Previous Order Amount 2

previousorderamount2

currency

The amount of the second most recent order placed by this contact.

Previous Order Date 3

previousorderdate3

date

The date of the third most recent order placed by this contact.

Previous Order Source 3

previousordersource3

text

The source of the third most recent order placed by this contact.

Previous Order Amount 3

previousorderamount3

currency

The amount of the third most recent order placed by this contact.

  1. In the Type: drop-down list on the Create a Field screen, select the appropriate field type from the Field Details column of the chart shown above.

  2. In the Visibility: field, choose whether the field should be Public or Private from the drop-down list. Public fields are visible to you and can be made visible to your contacts. Private fields are visible only to you.

  3. Check the box labeled [Contact List:] to have the field shown in the contact list.

 

Exporting Customer Data from Order Manager to Bronto

  1. Go to the Main Menu > Maintenance Menu > Import/Export  tab > Bronto Contact Export > Go. The Bronto Contact Export screen opens:

  1. Select an Action from the drop-down list. The possible choices are:

    1. Add - to add a new list

    2. Update - to update an existing list

    3. Add and Update - add and update a new list (this is the default action, if no action is selected from the drop-down list)

  2. (Optional) In the List Name field, enter the name of the contact list (at Bronto) that is to be created or modified. The default is the All Contacts list.

  3. (Optional) In the Notify field, enter an email address that will receive a notice when the update process is completed. There is no default for this field.

  4. Click the [Apply Filter] button to launch the Bronto Export Filter screen:

 

  1. Specify the customer selection criteria to be used to produce a list of customer records that will be sent to Bronto by entering one or a combination of the following:

      1. In the top section of the form, there are numerous options for filtering customer records. Filter by:

        1. Ranges of order numbers, web order numbers, order dates, or customer ids.

        2. Payment status. Select Any Status, Credit Due, Balance Due, or Paid in Full.

        3. Customers where their most recent order was on or before or after a given date.

        4. Address. Enter a City, State, Zip, or Country.

      2. Further limit the list of customer records by using the Items Purchased tab to include customers who have bought a single SKU, multiple SKUs or ranges of SKUs.

          1. In the Orders that include the following items section, click the [All SKUs] check box or enter characters in the SKU’s that start with text field.

          2. You can also click the [Any SKU in list below] check box and then build a list of SKUs using the options in the Select items here to build the list section.

            • To display your products sorted by SKU:

              1. Click the [SKU] radio button plus the [All] button to see all SKUs in alphanumeric order.

              2. Click [SKU] plus the [#] button to see SKUs that begin with a symbol followed by SKUs that begin with a number in alphanumeric order.

              3. Click [SKU] plus a letter button to see SKUs that begin with that letter, in alphanumeric order.

            • To display your products sorted by product name:

              1. Click the [Name] radio button plus [All] to see all product names in alphanumeric order.

              2. Click [Name] plus # to see product names that begin with a symbol followed by product names that begin with a number in alphanumeric order.

              3. Click [Name] plus a letter button to see product names that begin with that letter in alphanumeric order.

          1. Click on an item once and click [Add to List].

          2. The item appears in the Any of the following list of items list box to the right.

          3. Delete an item from the list by clicking on it and clicking the [Delete] button.

          4. Ignore the Add to Email List button, which will not be active and does not relate to this feature.

    1. Select customer records based on data that is contained in custom fields on the Custom Fields tab. (If you have not set up any custom fields, the Custom Fields tab will not be visible. See Configuring Custom Fields document to learn how to add custom fields.)

    2. To filter customers based on range of order frequency and/or value of orders within a selected date range, go to the Frequency & Value tab. (For more information about RFM [Recency, Frequency, Monetary Value] data and how to view RFM data about a specific customer, see the RFM Data & Order History section of the View Customers Knowledge Base topic.)

  2. Click the [Apply] button in the upper right hand corner of the Bronto Export Filter screen when all customer selection criteria has been entered.

  3. Click the [Export] button to send the selected customer records to Bronto. A confirmation box will be displayed, indicating the success of the data transfer.

 

Created: 2/14/11

Go to Top