Best way to create a click report (PHP MySQL)

0

I am setting up a real estate market system where real estate developers can see the land available for construction. Then I want to record the clicks that each developer gives on any land so I can pull reports of the most clicked, which land the developer is interested in, etc.

I thought of inserting the information into a mysql table:

id|id-incorporadora|id-terreno|hora-do-clique
1 |   276          |   501    |2018-02-02 15:12:10

But I think it could end up being a very large table, as we have hundreds of land and hundreds of developers.

Is there any other way to do this, without it getting so heavy?

    
asked by anonymous 21.03.2018 / 19:08

1 answer

1

You need to think about the level of detail you want, how useful and quality the information is for you.

What analysis criteria you will need in the end, how much this information has to be analytical and synthetic for this to happen.

Need to question as much as possible:

How useful to know how many times in the day, or week, the date and time!?

If no beauty, then do I do a month to have notion if they are eyeing the ground!

Oh no either ... so it only does the amount of total clicks ... and so it goes ...

For example, if I were to do this, I would do a cumulative month x terrain instead of click-through, so I would meet my criteria neither synthetic nor analytical.

No, I really want very analytical.

There, the focus is on performance in the bank, especially for writing, since it has put a lot of emphasis on moving.

Or even use Google Analytics, or other such tools.

  

It has to be very analytical, because we want for example:   A clicked 20 times on terrain X, and 15 times on terrain Y. And the opposite   also, terrain X was clicked by the incorporator A, B and C ... -   Leandro Teraoka

By incorporator yes ... but you need to get to the level of knowing the day and time of each click? or if I had a weekly summary, would it? A summary of incorporator x terrain x clicks, get it?

For example, weekly:

You would determine when the week starts (Sunday) then from Sunday to Saturday, you will accumulate clicks separating developer x terrain x qtd_cliques ... so if you have 20 developers, 100 lands, a maximum of 2,000 registrations, if all developers will click on all terrains. But if they click on all 5x land, it would still be 2,000, being click-through-click, going to 10,000.

    
21.03.2018 / 19:18