Microsoft Invest - Creative spreadsheet conventions
We support the use of spreadsheet templates for uploading multiple creatives simultaneously.
Feel free to leverage the following spreadsheet templates:
- Microsoft Advertising Third-Party Creative Template
- Microsoft Advertising Hosted Creative Template
- Microsoft Advertising Native Creative Template
Note
Only XLS and XLSX file formats are supported with a file size limit of 8 MB.
Third-Party creatives
When you prepare your Excel files for upload, the following information must be included in your file: creative name, content tag, and secure content tag. For automatic column mappings, follow these column name mapping conventions when creating your Excel file:
| Mapping Option | Column Name |
|---|---|
| External Identifier (optional) | For automatic External Identifier mappings, use one of the following column names in your Excel file: - Placement ID - External Identifier |
| Name | For automatic Name mappings, use one of the following column names in your Excel file: - Name - File Name - Placement Name |
| Secure Content | For automatic Secure Content mappings, use one of the following column names in your Excel file: - Tag Content Secure - Tag Content - JavaScript Tag - Legacy JavaScript Tag - URL - Secure URL |
| Size (optional) | For automatic Size mappings, use one of the following column names in your Excel file: - Dimensions - Size |
| (optional) | For automatic Tracker mappings, use one of the following column names in your Excel file: - Tracker - Pixel Pixel URL - Third-Party Pixel |
Hosted creatives
When preparing your Excel files for upload, the creative type and name must be included in your file. For automatic column mappings, follow these column name mapping conventions when creating your Excel file:
| Mapping Option | Column Name |
|---|---|
| Creative Type | For automatic Creative Type mappings, use one of the following column names in your Excel file: - Creative Type - Type |
| External Identifier (optional) | For automatic External Identifier mappings, use one of the following column names in your Excel file: - Placement ID - External Identifier |
| Landing Page URL (optional) | For automatic Landing Page URL mappings, use one of the following column names in your Excel file: - Landing Page - Landing Page URL - Click URL |
| Name | For automatic Name mappings, use one of the following column names in your Excel file: - Name - File Name - Placement Name |
| Tracker (optional) | For automatic Tracker mappings, use one of the following column names in your Excel file: - Tracker - Pixel - Pixel URL - Third-Party Pixel |
Native creatives
When preparing your Excel files for upload, the creative name and image file name must be included in your file. For automatic column mappings, follow these column name mapping conventions when creating your Excel file:
| Mapping Option | Column Name |
|---|---|
| Body Text (optional) | For automatic Body Text mappings, use one of the following column names in your Excel file: - Body Text - Description |
| Call to Action (optional) | For automatic Call to Action mappings, use one of the following column names in your Excel file: - Call-to-Action - Call to Action |
| External Identifier (optional) | For automatic External Identifier mappings, use one of the following column names in your Excel file: - Placement ID - External Identifier |
| Icon (optional) | For automatic Icon mappings, use one of the following column names in your Excel file: - Icon - Icon Name - Icon Image - File Name (Icon) - Logo |
| Image | For automatic Image mappings, use one of the following column names in your Excel file: - Image - Main Image - File Name (Image) |
| Landing Page URL (optional) | For automatic Landing Page URL mappings, use one of the following column names in your Excel file: - Landing Page - Landing Page URL - URL |
| Name | For automatic Name mappings, use one of the following column names in your Excel file: - Name - Creative Name - File Name - Placement Name |
| Sponsored By (optional) | For automatic Sponsored By mappings, use Sponsored By as your column name in your Excel file. |
| Title (optional) | For automatic Title mappings, use Title as your column name in your Excel file. |
| Tracker (optional) | For automatic Tracker mappings, use one of the following column names in your Excel file: - Tracker - Pixel - Pixel URL - Third-Party Pixel |
| Video (optional) | For automatic Video mappings, use one of the following column names in your Excel file: - Video - Video Name - File Name (Video) |