One of the main categorisation about motivation is the difference between intrinsic and extrinsic motivation.
Some types of motivation are more effective than others depending on the context. Therefore it is useful to understand hat are the difference between them.
Motivation is intrinsic when what drives us comes from within the individual. For example doing things only for the joy and the interest of doing them.
Intrinsic motivation have greater effect on the performance when the task to be done is complex, is not a routine task and requires creativity.