run_report
Generates custom Microsoft Ads reports with any report type, columns, and date range for campaign, keyword, or account performance analysis.
Instructions
Build-your-own report: any Microsoft Ads report type, any columns, any date range. Use describe_report to look up valid report types and column names.
Common recipes (report_type: useful columns beyond Impressions/Clicks/Spend):
Totals for a period: any type with aggregation="Summary" and NO TimePeriod column.
Conversions split by goal: CampaignPerformanceReportRequest with Goal, GoalType, Conversions, Revenue (also valid on ad group / keyword / search-term reports).
Revenue and return: CampaignPerformanceReportRequest with Revenue, ReturnOnAdSpend.
Impression share and why it was lost: CampaignPerformanceReportRequest with ImpressionSharePercent, ImpressionLostToBudgetPercent, ImpressionLostToRankAggPercent.
Device split: add DeviceType to a campaign / ad group / keyword report.
Whole account: AccountPerformanceReportRequest with AccountName, CurrencyCode.
Performance Max asset groups: AssetGroupPerformanceReportRequest.
Age and gender: AgeGenderAudienceReportRequest with AgeGroup, Gender. Goal / GoalType cannot share a report with impression-share columns (the API faults RestrictedColumnCombinations, 2064) — run those as two reports. Recipes live-verified 2026-11-17.
aggregation: "Daily" (default) works with any column set; Weekly / Monthly / DayOfWeek / HourOfDay also need the TimePeriod column. "Summary" is only valid when columns exclude TimePeriod — the live API raises InvalidTimePeriodColumnForSummaryReport otherwise.
Dates: days must be 7, 14, or 30. Or pass start_date/end_date (YYYY-MM-DD, both or neither) for an explicit range of any length. Live-verified 2026-08-14 (106-day AccountPerformance custom-range pull).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"report_type": "<report_type>",
"columns": "<columns>"
},
"name": "run_report"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | ||
| columns | Yes | ||
| end_date | No | ||
| start_date | No | ||
| aggregation | No | Daily | |
| report_type | Yes |