VIDOOMY REPORTS SERVER (LEGACY)

• Endpoint to advertisers reports: http://local.reports.vidoomy.com:8080/reports_/adv/repo.php
• Endpoint to publishers reports: http://local.reports.vidoomy.com:8080/reports/repo.php

NOTE: local.reports.vidoomy.com is the hostname defined in your .hosts file

The port by default is set to 8080 but it can also be modified in docker-composer.yml

PREREQUISITES

• docker
• docker-compose
• run: sudo apt install build-essential

INSTALLATION INSTRUCTIONS

1. git clone https://github.com/vidoomymedia/report-server.git
2. cd report-server
3. make init
4. make php-shell
5. composer install
6. ask for .env file
7. ask for DB dumps

   tables required for DB advertisers: (vidoomy_adv)

   • advertiser
   • agency
   • campaign
   • country
   • dsp
   • reports
   • ssp
   • user

   tables required for DB publishers: (vidoomy_login)

   • accounts
   • reports202106
   • reports_country_names
   • reports_domain_names
   • reports_resume202106
   • supplytag
   • users
8. add to your hosts file: 127.0.0.1 local.reports.vidoomy.com

9. update your panels .env.local file with:

   ### Vidoomy reports server ### REPORTS_ENDPOINT='http://local.reports.vidoomy.com:8080/reports/repo.php'
10. browse: local.reports.vidoomy.com:8080 you should see this installation instructions

NOTES

report-server/reports_/libs/common.php holds the dimensions SQL code for advertisers

report-server/reports_/libs/common5.php holds the dimensions SQL code for publishers