How to Optimized Sponsored Brand Campaign using Amazon Bulksheet (Practical)

Hold onto your spreadsheets, folks! Part 5 of the Bulksheet series is here, and we're about to send your Sponsored Brands into overdrive! Buckle up as we unlock mind-blowing optimization techniques and expand your brand's reach beyond your wildest dreams.

Remember how we dominated those Sponsored Products campaigns? Get ready to repeat that success with Sponsored Brands!

So without wasting time let's get started -?

Login to your amazon ads account and by clicking on the bulksheet link you have direct reach to the Bulk operations section, than refers to below steps :?

Select Date Range : Select date range for the data (last 7,14 or 30 days) as per your requirement.

Select product : Brand assets data, Sponsored Products data, Sponsored Brands data, Sponsored Display data & Sponsored Products Search term data

at Last click on Create spreadsheet for download

When you are open the bulksheet, what you saw, there are few sheet with name of Portfolios, Sponsored Products Campaigns, Sponsored Brands Campaigns, SB Multi Ad Group Campaigns, Sponsored Display Campaigns and There are few other columns in each sheet,?

Now we have to work only on Sponsored Brand Campaigns and focus only on columns in it.

We already discussed the columns in the Sponsored Brand Campaigns sheet on our previous blog on How to Create Sponsored Brand Campaigns.?

So now we only discuss the case and how we can optimise our campaign.

Note :?

• I will only update the data within the columns deemed essential for optimization based on our case requirements. All other columns will remain untouched, preserving their current state.
• Whenever you download any bulksheet you found that in each row operation column is blank always (refers to my template)?

• Optimised Campaign Level entry -??Note : We are changing in below campaign?Campaign id : Campaign12345 (refer to my template)Operation : Update, When you update particular row?

• Case 1: Campaign Name Change -? From Old SB campaign namen to New SB campaign nameCampaign Name : New SB campaign name

• Case 2: Campaign End Date add -End Date : 20240222

• Case 3: Campaign Daily Budget Change -? From 100 to 200Daily Budget : 200

• Case 4: Campaign Status Change - enabled? to? pausedState : paused

• Case 5: Campaign Creative Headline Change - My Headline 1 to? My Headline 2Creative Headline : My Headline 2

• Case 6: Campaign Achieve???Operation : Archive

• Optimised Targeting Level - Keyword entry - -??Note : We are changing in below campaign?Campaign Id : Campaign12345 (refer to my template)Keyword ID : Keyword12345Operation : Update, When you update particular row?

• Case 1: Change Bid Change -? From 1 to .075Bid : 0.75

• Case 2 : Status Change - enabled? to? pausedState : Paused

• Case 3 : New Keyword Targeting Create in existing Campaign -?Product : Sponsored BrandsEntity : KeywordOperation : CreateCampaign ID : Campaign12345State : enabledBid : 0.72Keyword Text : Keyword EMatch Type : exact

• Case 4: Keyword Achieve???Operation : Archive

• Optimised Targeting Level - Product entry - -??Note : We are changing in below campaign?Campaign Id : Campaign12345 (refer to my template)Product Targeting ID : Product Targeting12345Operation : Update, When you update particular row?

• Case 1: Change Bid Change -? From 1 to .075Bid : 0.75

• Case 2 : Status Change - enabled? to? pausedState : Paused

• Case 3 : New Product Targeting Create in existing Campaign -?Product : Sponsored BrandsEntity : Product targetingOperation : CreateCampaign ID : Campaign12345State : enabledBid : 0.72Product Targeting Expression : asin="A000000000000"

• Case 4: Product Achieve???Operation : Archive

• Optimised Negative Targeting? entry -?

I know if you read the blog to this section, I believe that you get an idea of how you can optimise the campaign for the Negative targeting optimization. I would like you to visit my template sheet to get ideas.

After filling all of your entries our next work is Upload our bulksheets file to update the campaigns.

Upload your file to update your campaigns,” click Choose file to upload the sheet you just created

After uploading your file check the upload section and look at how many errors are coming and how many rows are proceeding.

Rectify the errors

I have mentioned some of the errors which may be coming after uploading your file. My suggestion is visit my Sample Bulksheet Template where you get a sheet of errors.

My Other Article :?

• How to create Sponsored Product Campaign
• How to create Sponsored Display Campaign

Subscribe my newsletter for more knowledge.