Microsoft Ads Report Query
microsoft_report_queryFree-form READ of the Microsoft Advertising Reporting API (v13) — any report type and column set. report_type: e.g. CampaignPerformance, AdGroupPerformance, AdPerformance, KeywordPerformance, SearchQueryPerformance, GeographicPerformance, AgeGenderAudience, AudiencePerformance, AssetPerformance, ShareOfVoice, ProductPartitionPerformance (the 'ReportRequest' suffix is added). columns: that report's column names, e.g. ['TimePeriod','CampaignId','CampaignName','Impressions','Clicks','Spend','Conversions','Revenue','ImpressionSharePercent'] — the valid set differs per report type; Microsoft rejects invalid ones with an explanatory error. aggregation: Summary | Hourly | Daily | Weekly | Monthly | Yearly | DayOfWeek | HourOfDay (include TimePeriod for time rows). days = last N full days excluding today, or start_date/end_date (YYYY-MM-DD). Reference: https://learn.microsoft.com/en-us/advertising/reporting-service/reporting-service-reference. Read-only; reply carries the exact period.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | No | ||
| limit | No | ||
| columns | Yes | ||
| end_date | No | ||
| account_id | No | ||
| start_date | No | ||
| aggregation | No | Summary | |
| customer_id | No | ||
| report_type | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||