randomhacksuk/aircall-reporting

A reporting tool to help analysis your Aircall call data.

Aircall Report

A reporting tool to help analysis your Aircall call data and understand when calls come and what happens to them. It uses the Aircall API (https://developer.aircall.io/). The data is retreived the AirCall API and stored in a MySQL database. You can see the analysis of the calls from the reporting screen.

Get Started

You will need to install mysql, PHP and composer. You install everything from terminal.

Clone the project to your server.

$ git clone https://github.com/randomhacksuk/aircall-reporting.git

Install all the php dependencies for the project.

$ composer install

$ php artisan key:generate

Once database is created, run the following command to generate databse tables. You will need to set the database name in the .env file within root of the project.

$ php artisan migrate

To set app id and app key of your aircall account change it from .env file.

The are several scheduled tasks, which will update database if you configure it clear.

The crontab file can be reached by running this command in Terminal

$ crontab -e

This line need to be added to crontab file:

* * * * * php /path/to/your/project/artisan schedule:run >> /dev/null 2>&1

Visit {domain name/ip address}/get-old-data to store old data from aircall to our database.

After that database will be automatically updated according to aircall account users activity by frequency, which set in crontab file.