2020-3Q: Lorex MarketBroadband Integration / Inside Info Marketing

Feb 2023: Note that  much of the below logic also applies when the "Inside Info Marketing" report is being generated. 

A new feature has been added to enable Lorex MarketBroadband integration. MarketBroadband is a 3rd party service which allows Operators to automatically notify "neighbours" of newly installed customers, that they are now offering service in their neighborhood. The marketing is typically done by traditional "snail mail", based on address information. 

Operators will first need to contact Lorex in order for them to set up an FTP server. Lorex will send through FTP credentials which will then allow this integration.

To make use of this feature:

    1. Go to    => Settings

                    => External File Storage

        Add Blank Row

        Change the Name to “SFTP” and select a Label, in this example - Lorex.

        Enter:   Directory 

                    Host (Server IP address)


                    Port, which must be 22


        *These details will be provided by Lorex

                    => Update Table

        Go back to External File Storage and make a note of the ID, in this example - 1

Fig 1 External File Storage

    2. Next create a custom field

        Hover over “Settings”

                => Custom Fields

                => Add Row and under “Label” type “No. to Mail”

                => Update


        Go back to Custom Field and make note of the ID and name, in this example it is 17 – No. to Mail


Fig 2 Custom Field

     3. Next create a cronjob

                => Settings

                => Cronjobs

                => Add Blank Row

        From the scroll list select “Auto Reports” and select report “Lorex Marketing”

        Change the day it runs to once a week on a Wednesday morning

        Enter:   Email address where the report should be sent

                    select skip email

                    select external storage from the newly created entry which was noted number in step 1, eg. 1

                    add in the operator's WISP name under “Lorex ISP Account Number”

                    Select the custom field from the newly created entry from step 2, eg. No. to Mail 

                => Update Cronjobs

Fig 3 Lorex Cronjob

     4. This report can also manually be accessed

         Hover over “Tools”

            => Reports

        Select “Lorex Marketing”

        Ensure that the correct Custom Field from the DropDown list is selected i.e. "No. to Mail" to ensure that the Report picks up
the correct value from the subscribers record. This determines the number of neighbours, to whom, marketing information
will be sent.   

            => Generate

        Then Export to XLS which displays more information

        The XLS report will contain the following worksheets e.g. where Days Back is set to 7.

            "Activation Addresses" - addresses of customers activated in the last 7 days

            "Suppression File" - all addresses of current customers activated older than 7 days

            "Inactive Disconnects" - addresses of customers who went to post in the last 7 days

Fig 4 Download Lorex Report

Published Date: [17-July-2020]

Contact Azotel Support:

Need more help? Save time by creating a maintenance ticket to Azotel through your instance.