--- title: "Data Source - Microsoft Advertising" slug: "data-source-microsoft-advertising" updated: 2024-09-10T11:32:44Z published: 2024-09-10T11:32:44Z canonical: "documents.trocco.io/data-source-microsoft-advertising" --- > ## Documentation Index > Fetch the complete documentation index at: https://documents.trocco.io/llms.txt > Use this file to discover all available pages before exploring further. # Data Source - Microsoft Advertising This is the Help Page for ETL Configuration of Data Setting from Microsoft Advertising. ## constraints - none in particular ## Setting items ### STEP1 Basic settings | item name | indispensable | Contents | | --- | --- | --- | | Microsoft Advertising Connection Configuration | ✓ | Select the preregistered [Microsoft Advertising Connection Configuration](/docs/connection-configuration-microsoft-advertising) that has the necessary permissions for this ETL Configuration. | | account ID | ✓ | Enter the account ID from which you want to retrieve the report. For more information, please refer to [How to Verify Account ID](/docs/en/data-source-microsoft-advertising#%E3%82%A2%E3%82%AB%E3%82%A6%E3%83%B3%E3%83%88id%E3%81%AE%E7%A2%BA%E8%AA%8D%E6%96%B9%E6%B3%95). Note that **Custom Variables** can be embedded in the Account ID. If you wish to transfer Data Settings for multiple Ad Account IDs in a single ETL Configuration, please use [Custom Variable Loop Execution](/docs/loop-using-custom-variables). | | Report Type | ✓ | Select a report type from the following[`Account`](https://learn.microsoft.com/advertising/reporting-service/accountperformancereportcolumn?view=bingads-13)[`Campaign`](https://learn.microsoft.com/advertising/reporting-service/campaignperformancereportcolumn?view=bingads-13)[`Ad group`](https://learn.microsoft.com/advertising/reporting-service/adgroupperformancereportcolumn?view=bingads-13)[`Ad`](https://learn.microsoft.com/advertising/reporting-service/adperformancereportcolumn?view=bingads-13)[`Keyword`](https://learn.microsoft.com/advertising/reporting-service/keywordperformancereportcolumn?view=bingads-13) | | particle size | ✓ | Select the granularity of the report (time unit in division) from the following`Hourly``Daily``Weekly``Monthly``Yearly` | | Data acquisition period | ✓ | Specify the start date, end date, and time zone for the data you wish to transfer. Please enter start and end dates in `YYYYY-MM-DD` format. Note that depending on the combination of granularity and data acquisition period, data outside the range of the data acquisition period may also be acquired. For more information, please refer to the [relationship between granularity and data acquisition period](/docs/en/data-source-microsoft-advertising#%E7%B2%92%E5%BA%A6%E3%81%A8%E3%83%87%E3%83%BC%E3%82%BF%E5%8F%96%E5%BE%97%E6%9C%9F%E9%96%93%E3%81%AE%E9%96%A2%E4%BF%82). | Time zone of data acquisition period The [time zone that can be](https://learn.microsoft.com/advertising/guides/time-zones?view=bingads-13) selected on TROCCO and the [time zone that can be specified in Microsoft Advertising](https://learn.microsoft.com/advertising/guides/time-zones?view=bingads-13) may differ. Here is an example - TROCCO side: `Asia/Tokyo` - Microsoft Advertising side: `OsakaSapporoTokyo` Note that even if you select a time zone with a different notation, the time zone will be properly converted to "the time zone that can be specified in Microsoft Advertising" when the job is executed. Report retention period Microsoft Advertising data is aggregated into respective reports, divided by each time unit ( **granularity)**. The retention period for each report depends on the unit of division of the report. Reports that are past their retention period cannot be retrieved. Please note For more information on report retention periods, please refer to [the official Microsoft documentation - Reporting Data Retention Time Periods.](https://learn.microsoft.com/advertising/guides/report-data-retention-time-periods) #### STEP1 Detailed settings Click on **Advanced Settings** to display the configuration items. | item name | default value | Contents | | --- | --- | --- | | `Impression Share Performance Statistics` | OFF | When turned ON, columns `related to Impression Share Performance Statistics` are retrieved. However, since this data has a mutually exclusive relationship with other data, some columns will not be retrieved when turned ON. For more information, please refer to [the official Microsoft documentation - Column Restrictions.](https://learn.microsoft.com/advertising/guides/reports?view=bingads-13#columnrestrictions) | | `Additional Impression Share Performance Statistics` | OFF | When turned ON, the following columns are also retrieved.`AudienceImpressionLostToBudgetPercent``AudienceImpressionLostToRankPercent``AudienceImpressionSharePercent``RelativeCtr`However, since this data has a mutually exclusive relationship with other data, the following columns will also not be retrieved when turned ON.`CustomerId``CustomerName``DeliveredMatchType`For more information, please refer to [Microsoft Official Documentation -](https://learn.microsoft.com/advertising/guides/reports?view=bingads-13#columnrestrictions)**Note on**[Column Restrictions](https://learn.microsoft.com/advertising/guides/reports?view=bingads-13#columnrestrictions). | ## supplementary information ### How to verify your account ID You can check it from the Microsoft Advertising administration page. 1. Log in to [Microsoft Advertising](https://ads.microsoft.com/). 2. Click on **Tools>Preferences.** ![data-source-microsoft-advertising_001.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-microsoft-advertising-2024-08-29-12-13-0.png) The Account settings page will appear and you can check your account ID. ![data-source-microsoft-advertising_003.png](https://cdn.document360.io/3a3bae1e-f157-487f-8798-01e9d820e760/Images/Documentation/data-source-microsoft-advertising-2024-08-29-12-13-1.png) ### Relationship between granularity and data acquisition period For more information on each granularity, please refer to [the official Microsoft documentation - ReportAggregation Value Set - Reporting](https://learn.microsoft.com/advertising/reporting-service/reportaggregation?view=bingads-13#values). #### Relationship between granularity and record Each record of data to be retrieved is organized by granularity (time unit in the division). For example, if `Monthly is` selected `as the` granularity, data for one month will be aggregated into one record. #### Records to be acquired **If the range of the data acquisition period overlaps the "granularity start to end range" even partially, the records of that granularity will be acquired.** For example, suppose you select `Monthly as` the granularity and specify the data acquisition period `from 2023-07-28``to 2023-08-27`. In this case, **two months' records will be retrieved, one for July 2023 and the other for August 2023.** To prevent unintended retrieval of records, make sure that the start and end dates of the data retrieval period match the start and end points of the granularity. #### Starting and ending points for each granularity | particle size | starting point | terminus | | --- | --- | --- | | `Hourly` | `00:00` | `59:59` | | `Daily` | `00:00:00` | `23:59:59` | | `Weekly` | Sunday `00:00:00` | Saturday `23:59:59` | | `Monthly` | `00:00:00 on the` first day of the month | `23:59:59 on the` last day of the month | | `Yearly` | `00:00:00 on the` first day of the year | `23:59:59 on the` year-end date |