importxls

The hack imports leads from an Excel file into the system.

Hack setup interface

After installing and activating the hack, an import form will appear in its settings. It contains three fields:

  • Excel file. Select the file you want to upload. Please review the requirements listed below first.
  • Offer. Select the offer for the imported leads. If you leave the default value, the offer will be determined by the offer column in the uploaded file.
  • User . Select the webmaster to whom the imported leads will belong. If you leave the default value, the webmaster will be determined by the wm column in the uploaded file.

After filling in the fields, click Import leads to start uploading them into the system. When finished, the result will be displayed: the number of successfully added leads and the number of errors.

Excel file requirements

  • Extension .xlsx, .xls, .xlsm or .xlsb.
  • The list of leads to upload must be on the first sheet of the file.
  • Leads must be placed one per row.
  • The first row of the file must contain column names (headers). Supported values:
    • name, firstname, first_name, fio — customer first name.
    • last, lastname, last_name, surname — customer last name.
    • phone, tel, telephone — customer phone number. Required.
    • email — customer email address.
    • offer — offer ID (if not selected in the hack settings form). Required.
    • wm — webmaster ID (if not selected in the hack settings form).
    • flow — flow ID.
    • site — landing page ID.
    • space — prelanding page ID.
    • country, geo, countryiso2 — country code in ISO2 format (for example ua, ru, pl).
    • city — city.
    • area, region — region or district.
    • addr, address — delivery address.
    • index — postal code.
    • comm, comment — order comment.
    • count, quantity — quantity of product.
    • ip, client_ip — customer IP-address.
    • utm_source, utms — utm_source tag (traffic source).
    • utm_campaign, utmc — utm_campaign tag (campaign).
    • utm_content, utmn — utm_content tag (ad content).
    • utm_term, utmt — utm_term tag (keyword).
    • utm_medium, utmm — utm_medium tag (traffic type).
    • customer, utm_customer — customer tag (customer identifier).
    • domain, utm_domain — domain tag (traffic domain).
    • subid, sub, sub_id — subid tag (click identifier).
    • uuid — uuid tag (unique click identifier).
    • sub1–sub5 — arbitrary sub1–sub5.

Important! Rows without a phone number and/or offer ID are skipped.

Note. The hack does not have its own duplicate checking. During upload, the offer-level or system-level anti-duplicate setting is used.