I beleive the only way to get actual cpc data is via the adwords api. If you are using google analytics then you'll have an option in the settings that automates the process. The parameters that adwords can process are described very well here:
I beleive the only way to get actual cpc data is via the adwords api.
That is correct.
And...you have to wait a few days to get accurate information. About 1 day after a click occurs Google is pretty accurate as to the pricing and such but I have seen changes to click information several days after the click. Sometimes changes happen on the cpc but the click itself can go away several days later if Google decides it was fraud. It's not easy to sync up with Google and you will drive yourself crazy trying to sync up an external app in real time :-/