Not everyone has this feature. See this article for more information.
If you manage multiple Microsoft Advertising accounts, you can download campaign data -- across accounts and customers -- and edit it offline in a spreadsheet. This is the first step in the bulk upload process. You can set up a query for a bulk download on your Accounts Summary page by clicking Bulk Operations and then Downloads.
Setting up a query for a bulk download is a four-step process:
Define spreadsheet scope: Here you select whether to query by customers or by accounts. Enter the appropriate customer IDs or account numbers and then click Continue to go to the next step.
Filter spreadsheet data: Here you tell us exactly how to filter your data. Filters are grouped by Microsoft Advertising entity (campaign, ad group, ad, keyword, etc.).
You can have as many filters as you want, but keep in mind that multiple filters will be additive. This means that only data that meets all the filters’ criteria will be included in your spreadsheet. For example, if you filter on campaign names containing "holiday" and keywords containing "new year", your spreadsheet will only return data from "holiday" campaigns that also have at least one keyword containing "new year". It will not return data for a "new year" keyword that is not in a "holiday" campaign, or for a "holiday" campaign that does not have a "new year" keyword.
When you have finished defining your filters, click Continue to go to the next step.
Specify spreadsheet output: Here you select exactly what data to appear in your spreadsheet. We preselect the data you filtered on by default, but you can add or remove information to appear by selecting or deselecting their checkboxes. For example, you may have filtered on campaigns, but also want to see the campaigns' ad groups or ads in the resulting spreadsheet.
When you have finished selecting the information to appear in your spreadsheet, click Continue to go to the next step.
All ID columns are enclosed in brackets for Excel and CSV files, to ensure that no data is lost when opened in Excel.
Schedule spreadsheet download: Here you tell us when you want to download your spreadsheet. If you want to run the download immediately, select Download now. If you want the download to run sometime (or multiple times) in the future, select Schedule download for a later time.
You can also set the Data date range to query data only from a specific time period. For example, you may want to run it on data from just the past week. Note: Setting a data date range will only return meaningful results if the data you’ve filtered on is time-related (for example, ad performance data, but not ad name).
When you have set your download's schedule, click Done. If you selected Download now, the query will start running immediately and you will be taken to the Downloads page.
Here you’ll see all of the downloads you’ve run in the last 180 days and all of your completed and pending scheduled downloads.
Downloads table: In the Actions column of each download, you can:
Scheduled downloads table: From this table you can:
This will create a new download -- it will not change the scheduled download you based it on. If you want to change the settings of an existing scheduled download, you will need to use Create similar to make the changes, and then pause or delete the existing scheduled download.