With regard to Google, the general idea is to affect Google's relevance algorithm by incorporating the keywords being targeted in various places "on page", in particular the title tag and the body copy. Too many occurrences of the keyword, however, cause the page to look suspect to Google's spam checking algorithms.