Hi Roee,
Unfortunately, we don't have any endpoints for generating reports via the API yet and I don't think the feature will be available anytime soon.
I don't think there's no other place you can find CPM metrics other than the "stats" endpoints. The "campaign_stats" can only give basic stats as well.
You might need to head into the UI and generate reports per campaign to get the stats you desire.