We are looking for an app or web application to send short messages to our clients with information of items that are placed for sale on an auction website.
What we already have:
We have a database of 70.000 clients. We have created groups. We check the profile of each client and based upon that we add him to 1 or several groups.
What we need:
1. The interface to send (eventually with a picture) from a desktop a message to the smartphone of those clients. The clients who use the app will receive the message on the app. The clients who have the app but do not have an internet connection or wifi at that moment, receive an SMS (always without eventual picture). The clients who do not have the app receive an SMS.
The message uses a template with information, coming directly from the auction site. We, as admin, just have a table where we see all recently launched auction items. We select an item to start a message. The template appears, as well as a description of the item, coming from an HTML delivered by the auction site. This allows us to choose the groups and/or individual contacts to who we will send a message. We select the groups and/or individual contacts and click on "send message". The clients are warned by means of a signal in the header of their smartphone, like with facebook messenger.
It might be possible that on 1 day we will have to send 1000 messages. Of course, only to a selection of those 70.000.
2. The app (iOS/Android) where the clients receive the message. It even may be with added pictures.
They can ONLY receive messages. Not send. In the message we integrate a link that leads to the item on the auction site.
To make it easier for us it would be nice if a algorithm or Query could do the job and make the selection of destinies in our place, based upon approximately 5 criteria (make, age,...). At that moment the system could tell us that for example 20.000 of the 70.000 clients might be interested in a certain item. We can limit the number by saying: select only 1.000 of those 20.000 at random so that each client has enough offer and not always the same receive a message.
Please, do a proposition as follows:
- Required time.