Docs menu
Get started
What is Opus GrowthQuickstartAdd to your AIHow it worksSafety and approvalCreditsPlansFAQAI apps
All AI appsChatGPTClaudeGrokPerplexityClaude CodeCodexGemini CLIOpenClawCursorVS CodeWindsurfOther MCPConnect ad platforms
Google AdsMeta AdsLinkedIn AdsMicrosoft AdvertisingTikTok AdsChatGPT AdsAgencies and MCCConnect data sources
Search ConsoleGoogle AnalyticsYouTubeBusiness ProfileTag ManagerWebsites and SEO
AI ServerWordPressSEO IntelligenceClick fraudTool reference
All toolsGoogle AdsMeta AdsTikTok AdsLinkedIn AdsMicrosoft AdvertisingChatGPT AdsSearch ConsoleGoogle AnalyticsYouTubeBusiness ProfileTag ManagerWordPressAI ServerSEO IntelligenceClick fraudCross-channelAccount and billingLanguage
Microsoft Ads Report Query
Free-form READ of the Microsoft Advertising Reporting API (v13): any report type and column set.
- Type
- Reads only
- Credits
- 2
- Platform
- Microsoft Advertising
- Approval
- Not needed, nothing changes
What it does
Free-form READ of the Microsoft Advertising Reporting API (v13): any report type and column set. report_type: CampaignPerformance, AdGroupPerformance, AdPerformance, KeywordPerformance, SearchQueryPerformance, GeographicPerformance, AgeGenderAudience, AudiencePerformance, AssetPerformance, ShareOfVoice, ProductPartitionPerformance, … (the 'ReportRequest' suffix is added). columns: that report's column names (TimePeriod, CampaignId, CampaignName, Impressions, Clicks, Spend, Conversions, Revenue, ImpressionSharePercent, …); the valid set differs per report type and Microsoft rejects invalid ones with an explanatory error. aggregation: Summary | Hourly | Daily | Weekly | Monthly | Yearly | DayOfWeek | HourOfDay (TimePeriod gives 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`. limit controls the response page; page_token=next_page_token returns later pages without another API call or credit.
MCP: microsoft_report_query
How to use it
You don't call tools by name. Write what you want in ChatGPT, Claude or another assistant connected to Opus Growth, in your own words; it picks this tool when it fits.
Parameters
| Name | Type | Required | Default | |
|---|---|---|---|---|
| report_type | string | Optional | · | Provider-specific report type accepted by this operation. Use a supported value from the tool documentation or returned provider data. |
| columns | array | Optional | · | Columns value for microsoft report query. Follow the documented provider format and use values returned by Opus Growth discovery tools where possible. |
| account_id | string | Optional | · | Advertising account identifier to query or change. Use the exact ID returned by the relevant account-listing tool, not the display name. |
| aggregation | string | Optional | Summary | Exact aggregation value for microsoft report query. Supply text in the provider's required format; when it selects an existing resource, use the exact identifier returned by the relevant list or search operation. |
| days | integer | Optional | 30 | Number of calendar days to look back from now for this analysis or report. |
| start_date | string | Optional | · | Inclusive start date for the requested period, in the format required by this tool. |
| end_date | string | Optional | · | Inclusive end date for the requested period, in the format required by this tool. |
| customer_id | string | Optional | · | Google Ads customer account ID to query or change. Use the numeric ID returned by list_accounts; omit separators unless this tool explicitly says otherwise. |
| limit | integer | Optional | 0 | Maximum number of rows returned in this response. When the result has_more flag is true, continue with next_page_token rather than assuming the list is complete. |
| page_token | string | Optional | · | Continuation token returned as next_page_token by a previous call. Leave empty for the first page; pass it unchanged to retrieve the cached next page. |
Related tools
add_microsoft_ad_extensionsMicrosoft Ad Scheduleadd_microsoft_ad_scheduleMicrosoft Demographic Targetadd_microsoft_demographic_targetMicrosoft Device Targetadd_microsoft_device_targetAdd Microsoft Keywordsadd_microsoft_keywordsMicrosoft Location Targetadd_microsoft_location_targetAdd Microsoft Negative Keywordsadd_microsoft_negative_keywordsConnect Microsoft Advertisingconnect_microsoft_adsCreate Microsoft Ad Groupcreate_microsoft_ad_group