I want to convert API Feed into a real time sheet for creating queries

We use a till system that has a loyalty card feature. This collects data which relates to buying behaviour and products etc. But the data is not easily collected and segmented to make better marketing campaigns. We are looking for an API developer to help us receive this feed and create a number or segmented queries to ensure that when we send marketing emails they are more relevant to the customer's interests.

The project is linked to Epos Now.

API Output tool does not require a user interface as we will ask for the rules to be hardcoded from the outset.

ttached is a proposal from another developer.

To automatically add customers to the specified mailing lists in MailChimp when they

meet the specified criteria

○ E.g. bought product X in the last Y months

● Data will be synced from EposNow into the new web app

○ Transactions

○ Customers

○ Products, Categories, Brands

● We will develop a web app that will allow the admin to easily add new rules

○ Admin can create and manage the rules

○ When the user/manager is logged in, they will be able to see a table showing the customers that have

been added into MailChimp and into which list

○ This front end for the user/manager can be developed further in the future, but this gives a good base

○ Can do a version without a user interface at lower initial cost, but developers required to add new rules

● The web app will pull data from EposNow periodically, process it, and then update

MailChimp as required

In order to minimize the number of the calls to the EposNow API, the data will be

synced from EposNow and stored in the new web app

○ On every sync, only incremental data will be synced

○ Sync will be carried out automatically once a day

■ Manual sync option will be available on the interface

● Once the data is in the web app, we can then use our search criteria to identify

customers who match the rules and then add them to the MailChimp lists

A MailChimp account will be provided to us by the client (API access required)

● The client will setup the email campaigns and lists

○ Any automated triggers for when a user is added to the list is to be setup by the client and is not costed

for in this proposal (we can help with this if required at additional cost)

● Each rule in the web app will be linked to specific lists(s) in MailChimp

○ If the user is already in the list, then they will not be re-added

○ If the user has unsubscribed or is suppressed in MailChimp, then they will not be added to the list

Skills: API, Frontend Development, Software Architecture, Test Automation

See more: real time currency rates api, real time forex data api, real time feed yahoo amibroker, google sheet link, import api into google sheets, google sheets 2018, google sheets 105m, google sheets api example, google sheets u, google sheets query, google sheets api, real time stock api, upload video real time convert flv joomla, excel sheet real time stock bloomberg, javascript mysql real time page feed, read real time data currently opened excel sheet, real time data feed linux api, parsing advertising xml feed real time, api excel real time, api php real time forex quotes

About the Employer:
( 6 reviews ) TORONTO, Canada

Project ID: #19769420

7 freelancers are bidding on average $341 for this job


I read your requirements. I can create a number or segmented queries. I have 8+ years of experience. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please r More

$750 USD in 7 days
(75 Reviews)

Hello Sir/Mam, MAKSOF is a team of highly qualified professionals who is dedicated in providing creative solutions and innovative ideas for your business with our skills in technologies and strategies. We have r More

$555 USD in 3 days
(35 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$180 USD in 7 days
(39 Reviews)

Hi, Hope you are doing well. I can develop this. Can you share sample output you are getting via API ? I have experience of working with API and with database etc. Waiting for your response to discuss it More

$250 USD in 10 days
(39 Reviews)

My greetings. I believe you are doing fine. I have read all your requirements for 'I want to convert API Feed into a real time sheet for creating queries' and I fully understood it. I am confident and I am sure that I More

$155 USD in 1 day
(6 Reviews)

Greetings, I have gone through your project in detail, and to better understand your project lets discuss over chat so that we are on the same page and let's start working together. Please have a look to our Portfoli More

$150 USD in 7 days
(0 Reviews)

Let me introduce WordPress Monsters, we aim at building the best development products and often succeed in doing that. We build all kinds of web applications: blogs, eCommerce and even custom solutions. We create tho More

$350 USD in 3 days
(0 Reviews)