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)
Password
Port, which must be 22
Username
*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.