Excel Macros to convert a list of keywords into specific format output.
Budget: $30 – $250 USD
I'm looking for an excel expert,
I want to input lists of keywords and a few other data, and output a tab with all the keywords formatted in a specific way so it can be uploaded as a bulk operations file to Amazon Seller Central.
I want to have the following fields on the input:
SKU: We will input the SKU which will be used to to name campaigns.
ASIN: We will input the ASIN which will be used to to name campaigns as well.
Exact Keywords List: All the keywords that we want to create exact campaigns with.
Phrase Keywords List: All the keywords that we want to create phrase campaigns with.
Broad Keywords List: All the keywords that we want to create phrase campaigns with.
Negative Exact Keyword List: All the negative keywords that will be applied to Phrase campaigns.
Negative Phrase Keyword List: All the negative keywords that will be applied to Broad campaigns.
Groups of: Default value of 10. Which means it will create 1 campaign for every 10 keywords, so if the list has 1000 keywords, it would create 100 campaigns with 10 keywords each (in the same order).
Bid: Default value of 2.5 - It will apply Bid of 2.5 to each one of the campaigns.
Budget: Default value of 100 - It will apply default budget of 100 to each one of the campaigns.
Strategy: There are 3 types of strategy, Fixed bids, Dynamyc bid down, and Dynamic bid up and down. It will apply the strategy to all campaigns.
The output will show up the header for each campaign, (2 rows) defining the values we input above.
And then the # of keywords (exact, broad and phrase) on groups of whatever number we have in the input "Groups of". As well as the negative keywords corresponding to each campaign type.
Finally a button at the top, so when we click it, it performs all the operations and prints it in a new tab as the output.
I will provide a sample of the output file, and I'll answer questions via chat very quickly, my goal is to have this ready as soon as possible.
The project shouldn't take long to anyone with enough experience in excel.
NOTE: If you believe you can quickly create a similar application for web, maybe javascript, instead of excel, creating the output as excel, we could consider that, however if that increases the budget, we prefer to keep it simple just with excel macros.
Thanks for reading.
I want to input lists of keywords and a few other data, and output a tab with all the keywords formatted in a specific way so it can be uploaded as a bulk operations file to Amazon Seller Central.
I want to have the following fields on the input:
SKU: We will input the SKU which will be used to to name campaigns.
ASIN: We will input the ASIN which will be used to to name campaigns as well.
Exact Keywords List: All the keywords that we want to create exact campaigns with.
Phrase Keywords List: All the keywords that we want to create phrase campaigns with.
Broad Keywords List: All the keywords that we want to create phrase campaigns with.
Negative Exact Keyword List: All the negative keywords that will be applied to Phrase campaigns.
Negative Phrase Keyword List: All the negative keywords that will be applied to Broad campaigns.
Groups of: Default value of 10. Which means it will create 1 campaign for every 10 keywords, so if the list has 1000 keywords, it would create 100 campaigns with 10 keywords each (in the same order).
Bid: Default value of 2.5 - It will apply Bid of 2.5 to each one of the campaigns.
Budget: Default value of 100 - It will apply default budget of 100 to each one of the campaigns.
Strategy: There are 3 types of strategy, Fixed bids, Dynamyc bid down, and Dynamic bid up and down. It will apply the strategy to all campaigns.
The output will show up the header for each campaign, (2 rows) defining the values we input above.
And then the # of keywords (exact, broad and phrase) on groups of whatever number we have in the input "Groups of". As well as the negative keywords corresponding to each campaign type.
Finally a button at the top, so when we click it, it performs all the operations and prints it in a new tab as the output.
I will provide a sample of the output file, and I'll answer questions via chat very quickly, my goal is to have this ready as soon as possible.
The project shouldn't take long to anyone with enough experience in excel.
NOTE: If you believe you can quickly create a similar application for web, maybe javascript, instead of excel, creating the output as excel, we could consider that, however if that increases the budget, we prefer to keep it simple just with excel macros.
Thanks for reading.