Belardi Wong

Rockerbox has an existing integration with Belardi Wong where we receive user-level log files. More detail on how these log files are used to track Direct Mail touchpoints can be found here.

Log File Instructions

All files must align with the requirements listed here.
  1. Enable the integration here in your Rockerbox account. You may be prompted to contact Rockerbox support if this is a net-new launch, or if your current plan does not include tracking for this channel.
  2. Reach out to Belardi Wong to request that they schedule automated reporting to Rockerbox that follows the below requirements.
    1. Files should be sent before each drop as soon as they are ready.
    2. Log files should include all mail recipients, and should not include holdouts
    3. Files should be sent to the designated endpoints. Endpoint details can be found under Data > Advertising Platforms. Navigate to the Belardi Wong tile and select "Instructions". Note that there are two separate required reports, each with separate endpoints.
      1. Log Files: Belardi Wong will send to an SFTP endpoint
      2. Spend Files: Belardi Wong will send to an email endpoint
  3. Reports must contain the columns exactly as noted below, including capitalization & spacing.
Required Columns - Log File (Address File)

STREET_1
STREET_2
CITY
STATE
ZIP
COUNTRY
MAIL_DATE
IN_HOME_DATE
CAMPAIGN
CREATIVE
AUDIENCE
GENDER
Required Columns - Spend File

CLIENT
YEAR
SEASON
DROP
IN-HOME
KEYCODE
CIRC QTY
TOTAL CATALOG COST PER PIECE
TOTAL CATALOG COST

How did we do?