Best way to create click report (PHP Mysql)

Asked

Viewed 371 times

0

I’m putting together a real estate market system where developers can see the land available for construction. Then I want to record the clicks that each developer gives in any terrain and then I pull reports from the most clicked, which lands the developer is interested in, etc.

I thought about inserting the information in a mysql table:

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

But I think it can end up being a very big table, because we have hundreds of plots and hundreds of developers.

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

php mysql report log

1 answer

1

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

What criterion of analysis you will need in the end, how analytical and synthetic this information has to be in order for it to happen.

You need to question as much as possible:

What is the use of knowing how many times in the day, or in the week, the date and time !?

If none, fine, then I’ll do it every month to get a sense if they’ve got their eye on the ground !?

Oh not either... so it only does by amount of clicks in total... and so it goes...

For example: if I were to do this, I would make an accumulated month x terrain instead of click per click, so I would meet my criteria neither synthetic nor analytical.

No, I want really analytical.

There the focus is on performance in the bank, mainly for writing, since he put that will be great the movement.

Or even use Google Analytics, or other tools like.

has to be very analytical, because we want for example: Developer A clicked 20 times on X, and 15 times on Y. And the other way around also, the land X was clicked by the developer A, B and C... - Leandro Teraoka

By embed yes... but you need to get to the level of knowing what day and time of each click ? or if you had a weekly summary, would it serve ? A summary of developer x land x clicks, understood ?

For example, weekly:

You would determine when the week starts (ex Sunday) then from Sunday to Saturday, you will accumulate clicks separating embed x land x qtd_clicks... so if you have 20 addressees, 100 terrains, at most would be 2,000 registrations, if all the developers click on all the land. But if they click on all the 5x plots, it would still be the 2,000, already being click per click, went up to 10,000.

  • has to be very analytical, because we want for example: Developer A clicked 20 times on the X, and 15 times on the Y. And the other way around, the X was clicked by the developer A, B and C...

  • I edited the answer because it got too big to put in the comments.

  • Actually per hour was an exaggeration...rs, but accurate per day, you gave me a light already, would make for example 20/02/2018 X embed, 10 clicks, this ne?

  • Exactly.. but lacking the land ! rs DATA | INCORPORADORA | TERRENO | CLIQUES... Of course, this will make it difficult in the system, because now the method that only made inclusion, now needs to do research, and from it, include or change (Insert or update).

Browser other questions tagged php mysql report log

You are not signed in. Login or sign up in order to post.