How to fetch campaigns with metrics using REST API (Python)

Hi Microsoft Ads Support Team,

I’m integrating the Microsoft Advertising API using REST + Python, and I need to fetch campaigns along with their performance metrics (like impressions, clicks, CTR, spend, conversions, and currency code) — similar to what we see in the Microsoft Ads UI or via the Google Ads API.

Here’s what I’ve done so far:

• Successfully called the CampaignManagement/v13/GetCampaignsByAccountId endpoint using REST to retrieve campaign names and IDs.

I also tried using the Reporting/v13/SubmitGenerateReport endpoint to fetch performance data, but it only returns CSV data, not JSON.

My questions are:

Is there a REST endpoint that directly returns campaigns with metrics in a single API response?

If not, what is the recommended Python + REST workflow to combine campaign data with metrics (for example, which report type to use, and how to correlate results by CampaignId)?

Could you please share a working REST + Python example to fetch campaign metrics, ideally in JSON format?

I want to achieve functionality similar to the Microsoft Ads UI’s “Campaigns” table — showing campaign name, ID, spend, impressions, clicks, CTR, conversions, and currency.

Thank you for your help! Santosh SakreHi Microsoft Ads Support Team,

I’m integrating the Microsoft Advertising API using REST + Python, and I need to fetch campaigns along with their performance metrics (like impressions, clicks, CTR, spend, conversions, and currency code) — similar to what we see in the Microsoft Ads UI or via the Google Ads API.

Here’s what I’ve done so far:

Successfully called the CampaignManagement/v13/GetCampaignsByAccountId endpoint using REST to retrieve campaign names and IDs.

I also tried using the Reporting/v13/SubmitGenerateReport endpoint to fetch performance data, but it only returns CSV data, not JSON.

My questions are:

Is there a REST endpoint that directly returns campaigns with metrics in a single API response?

If not, what is the recommended Python + REST workflow to combine campaign data with metrics (for example, which report type to use, and how to correlate results by CampaignId)?

Could you please share a working REST + Python example to fetch campaign metrics, ideally in JSON format?

I want to achieve functionality similar to the Microsoft Ads UI’s “Campaigns” table — showing campaign name, ID, spend, impressions, clicks, CTR, conversions, and currency.

Thank you for your help!
Santosh Sakre