database design for capturing trending keyword -

I need some help on capturing the keyword transging and creating a database design for scoring. What I have so far:

keyword_id int auto_increment
Keywords varchar
Description tinytext
date_trade_started date time
mention_count int
ranking int
< Strong> day_a_tap from day to day
day_a_top int

and what needs to be considered

I do not think this design can take data on loyalty you want Are.

Note (keyword ID, referrer source, date time)

This will be more beneficial to keep the data historically

You can use it to compile summary summaries for the query, such as ranking per day, where there is a record per day and presents the summation of calculation, ranking, movement from the previous day.

  Date | Keyword ID | Rank | Movement "25/6/08" | 576426 | 17 | -3 "26/6/08" | 576426 | 15 | 2  

This gives you enough to calculate other things, as if the trend starts or between any two time period, the day at the top

None of the above is comprehensive - just the examples of showing you that you should think about your data in many dimensions.