OurBigBook Web analytics

OurBigBook Web supports the following types of analytics:

Google Analytics. TODO: the Google Analytics ID is currently hardcoded under web/front/config.js googleAnalyticsId: 'G-R721ZZTW7L', we should instead take it from an environment variable
our simple built-in analytics to better view referrers. At some point Google Analytics stopped showing clear referrer paths, and so we started storing out own real quick. There is currently no UI for it, you just have to query the database e.g. with:
```
printf '\\a\nSELECT referrer,path,ip,"createdAt" FROM "Request" ORDER BY "createdAt" DESC LIMIT 1000' | ./heroku psql DATABASE_URL
```
You can also blacklist domains to reduce referrer spam with web/bin/blacklist-referrer-domain:
```
./heroku web/bin/blacklist-referrer-domain binance.com
```
You can list the blacklisted domains with:
```
./heroku psql -c 'SELECT domain FROM "ReferrerDomainBlacklist" ORDER BY domain ASC'
```
Here's a small open database that might help: github.com/matomo-org/referrer-spam-list.
Local testing can be done on PostgreSQL with the help of:
```
curl -H 'Referrer:http://exmaple.com' http://localhost:3000/qwer &>/dev/null && web/bin/psql 'select * from "Request"'
```
We later learned that this feature is completely useless because browsers are actually not sending paths anymore. But it's fun.

 Ancestors (5)