How to KickBox Email Lists

KICKBOX LOGIN:
URL: https://app.kickbox.com
UN: [email protected]

PW: TBD

HOW TO FORMAT LISTS UNDER 250:

  • Format the supplied list if needed (using text to columns to separate information, removing unnecessary data, re-naming columns, etc)
  • If applicable, replaced every “NULL” with nothing using the Find, Replace tool
  • Highlight the column of email addresses, select Data, and remove duplicates
  • Select Filter, Does not contain, and insert the @ symbol (Remove anything that does NOT contain an @ symbol and/or blank) Clear Filter
  • Use the Find & Replace tool again to replace “spaces” with nothing
  • Check birthdays/anniversaries and make sure they are valid dates
  • Save to desktop as CSV (Business Name_KB_Date)

HOW TO FORMAT LISTS OVER 250:

  • Open the newly supplied file
  • Format the supplied list if needed (using text to columns to separate information, removing unnecessary data, re-naming columns, etc)
  • If applicable, replaced every “NULL” with nothing using the Find, Replace tool
  • Select Filter, Does not contain, and insert the @ symbol (Remove anything that does NOT contain an @ symbol and/or blank) Clear Filter
  • Use the Find & Replace tool again to replace “spaces” with nothing
  • Check birthdays/anniversaries and make sure they are valid dates
  • Add a column, title it “KB” and add an asterik into all fields under that column next to the emails to identify what emails are the newly supplied emails
  • Open Emma, Go to Audience, Export entire audience, Download export, Save to desktop
  • Open the file and use the Ctrl+Shift+Down Arrow method to copy all email addresses and paste them into the newly supplied file under the new emails
  • Highlight all emails, Select Conditional Formatting, Highlight cell rules, Duplicate values, hit ok, and any email address that is a duplicate will turn red
  • Right click on any red email, select Filter, and filter by selected cell color
  • Delete everything in red and then clear the filter
  • Save to Desktop as a CSV (Business Name_KB_Date)

RUNNING THE LISTS THROUGH KICKBOX:

  • Login to Kickbox
  • Upload your formatted file
  • Once it’s done analyzing click Start List
  • If there are errors, look at them (ask Parkey/Emily for assistance if needed) then fix and re-upload
  • Once the file is done, Download the file using the Marketers Choice option
  • Save to Desktop as CSV (Rename to Business Name_KB_Date_CLEANED)

BEFORE YOU IMPORT INTO EMMA:

  • Remember to clean up your list one final time
  • Feel free to delete anything you don’t need
  • Add the appropriate acquisition, primary location, and the Welcome Email field if applicable


*SPEICAL CASES* IF SOMEONE SENDS YOU A LIST THAT THEY WANT YOU TO SEND AN EMAIL TO JUST THESE SUBSCRIBERS:

  • Go to Emma, Import the database into Emma first into its own unique group (Ie; 7/8/21 Send)
  • Create a Segment: Name it “Contacts In Last Day” and set it up as Contact Since – in the last – 1 – day AND Group – In – (select the unique group you just added the list to)
  • After you save the segment, Export the segment and Download the export to your desktop
  • Upload this file to Kickbox, when you choose to download the kickboxed file, choose the Custom option, hit Filter, Uncheck “Deliverable” and choose “UNdeliverable” and then Download
  • Import this file into Emma into a unique group you can title “REMOVE”
  • Go to the group called “Remove”, select all, and change the status of these email addresses to “Error”  

SOMETHING TO NOTE: When you are in Kickbox, please keep an eye on the Verification number in the bottom left. Once it gets down to around 5K, we need to let Sloan know so he can pay for more capacity

VIDEO TUTORIAL:

https://hchgrp-my.sharepoint.com/:v:/r/personal/parkey_phipps_clippermagazine_com/Documents/Recordings/Call%20with%20Butler,%20and%207%20others-20210708_150308-Meeting%20Recording.mp4?csf=1&web=1&e=TIoCf7

Leave a Reply

Your email address will not be published. Required fields are marked *