Seasonality Adjustment Record - Bulk

Article
08/22/2024

Defines the Seasonality Adjustment fields that can be uploaded and downloaded in a bulk file.

You can download all Seasonality Adjustment records in the account by including the DownloadEntity value of SeasonalityAdjustments in the DownloadCampaignsByAccountIds or DownloadCampaignsByCampaignIds service request. Additionally the download request must include the EntityData scope. For more details about the Bulk service including best practices, see Bulk Download and Upload.

The following Bulk CSV example would add a new Seasonality Adjustment.

Type,AccountId,Id,Campaign Type,Start Date,End Date,Name,Description,Adjustment Value,Seasonality Adjustment,Device Type,Campaign Associations
Format Version,,,,,,6.0,,,,,
Seasonality Adjustment,,,Search,3/15/2024 3:00,3/16/2024 3:00,,Description,100,TestSA,Tablets,

If you are using the Bing Ads SDKs for .NET, Java, or Python, you can save time using the BulkServiceManager to upload and download the BulkAdGroupSeasonalityAdjustment object, instead of calling the service operations directly and writing custom code to parse each field in the bulk file.

var uploadEntities = new List<BulkEntity>();

// Map properties in the Bulk file to the BulkSeasonalityAdjustment
var bulkSeasonalityAdjustment = new BulkSeasonalityAdjustment
{
    // Map properties in the Bulk file to the 
    // SeasonalityAdjustment object of the Campaign Management service.
    SeasonalityAdjustment = new SeasonalityAdjustment
    {
        // 'Adjustment Value' column header in the Bulk file
        AdjustmentPercentage = 100,
        // 'Campaign Associations' column header in the Bulk file
        CampaignAssociations = new List<CampaignAssociation>(),
        // 'Campaign Type' column header in the Bulk file
        CampaignTypeFilter = CampaignType.Search,
        // 'Description' column header in the Bulk file
        Description = "Description",
        // 'Device Type' column header in the Bulk file
        DeviceTypeFilter = DeviceType.Computers,
        // 'Id' column header in the Bulk file
        Id = null,
        // 'Start Date' column header in the Bulk file
        StartDate = DateTime.UtcNow,
        // 'End Date' column header in the Bulk file
        EndDate = DateTime.UtcNow.AddDays(7),
        // 'Seasonality Adjustment' column header in the Bulk file
        Name = "Seasonality Adjustment",
    },
};

uploadEntities.Add(bulkSeasonalityAdjustment);

var entityUploadParameters = new EntityUploadParameters
{
    Entities = uploadEntities,
    ResponseMode = ResponseMode.ErrorsAndResults,
    ResultFileDirectory = FileDirectory,
    ResultFileName = DownloadFileName,
    OverwriteResultFile = true,
};

var uploadResultEntities = (await BulkServiceManager.UploadEntitiesAsync(entityUploadParameters)).ToList();

For an Seasonality Adjustment record, the following attribute fields are available in the Bulk File Schema.

Adjustment Value
Campaign Associations
Campaign Type
Description
Device Type
End Date
Id
Seasonality Adjustment
Start Date

Adjustment Value

The percentage of the conversion rate adjustment.

Add: Required
Update: Optional
Delete: Read-only

Campaign Associations

Make the seasonality adjustment to these campaigns.

Add: Optional
Update: Optional
Delete: Optional. Only one of "Campaign Associations" and "Campaign Type" can be specified. If you set "Campaign Type," this will be null.

Campaign Type

Make the seasonality adjustment to these campaign types.

Add: Optional
Update: Optional
Delete: Optional. Only one of "Campaign Associations" and "Campaign Type" can be specified. If you set "Campaign Associations," this will be null.

Description

A description for the seasonality adjustment.

Add: Required
Update: Optional
Delete: Read-only

Device Type

Make the seasonality adjustment to these device types.

Add: Required
Update: Optional
Delete: Read-only

End Date

The end date.

Important: The value must be in your account time zone. This differs from the time zone options when you upload offline conversions in the Microsoft Advertising web application. For information about the format of the date and time, see the dateTime entry in Primitive XML Data Types.

Add: Required
Update: Optional
Delete: Read-only

Id

The system-generated identifier for the seasonality adjustment.

Add: None
Update: Required
Delete: Read-only