How to track, after clicking on which request the call was made?

Question

MySQL

The site has a phone number. The client comes to the site by clicking on an ad on a search in Yandex.Direct, explores the site, manually dials the number and calls. How to automatically track, after clicking on which request a call occurs? Thank you.

Answer 1

Everything depends on the amount of data. If the expected number of records will not be in the millions or even tens of millions, then it is better to stick to normalization. There will be less chaos. Otherwise yes, denormalization or any solutions like nosql.
The client also contributes.
For example, you need to display summary data for certain reporting periods. From a programming point of view, it is better to calculate dynamically based on a properly normalized base. A line was added to the period - the total result for this period was recalculated. But, from the point of view of accounting, customers often require that if the period is closed, then the results for it are not recalculated, even if more lines were pushed back into this period. We have to add another table in spite of normalization.

Answer 2

You need call tracking. This system replaces the phone number on the site depending on utm-tags, incl. and request. The best known are Callibri, Comagic, ROIStat, etc.
Alternatively, you can assign a unique code to each site visitor (for example, like this ) and ask the client to name him on a call. In complex voice systems, you can ask the client to dial this number during a call, or ask them to dictate

Answer 3

No call tracking. At all. You are changing the digital channel to analog in fact.