Make a script for Google Sheets

Javascript and Typescript — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original Good day, here is the project brief: ----- There is a table at https://docs.google.com/spreadsheets/d/1LlVWVzv2c_WD7LTdQXFnW7kQsniLyNdXma8ihVDg9bc/edit?usp=sharing In this table, the tabs Auto, Broad, Exact, and Compet are examples of campaign structures for the product HB-UM43 on Amazon. Auto - campaign type with automatic targeting. Broad - campaign type with broad match targeting. Exact - campaign type with exact match targeting. Compet - campaign type with competitor targeting. Task: create a Google Sheets script (not Python) that will generate similar campaigns for other products on tabs Auto1, Broad1, Exact1, Compet1. Also, on the All_together tab, it will gather all these three newly created advertising campaigns under one header. For the new campaigns, variables from the Data tab will be used: 1) Daily budget - has one value and will be used for all campaigns in column U "Daily budget," in cell U2. Also, similar values need to be added in the other cells in row 2 (further instructions will follow). 2) SKU - the product name has one value and will be used for all campaigns in the columns: - Campaign ID column - this is the ID of the advertising campaign, to be formatted as SKU-+campaign type. These values are present in each row of the campaign structure in this column. - Ad group ID column - this is the ad group ID, to be formatted as SKU-+campaign type. These values are present in each row of the campaign structure in this column except for the row where Campaign ID is present. - Ad group name column - this is the ad group name, to be formatted as SKU-+campaign type. This value is present once in the row below where the value for Campaign ID is present. - Campaign name column - this is the campaign name, to be formatted as SP-A-(SKU value)-/Category (for Auto campaign), SP-B-(SKU value)-/Category (for Broad campaign), SP-E-(SKU value)-/Category (for Exact campaign), SP-C-(SKU value)-/Category (for Compet campaign). You will also find the Category value on the Data tab. Campaign name is used once in the same row where there are values for Campaign ID. - SKU column - the product name or number is used once in column V. 3) Basic bid - the base bid value for targeting and is used in the "Ad Group Default Bid" columns (once in the row where Entity is Ad Group). Also, in the "Bid" column where the Entity value is Product targeting (for Auto and Compet campaigns). The value in the "Bid" column varies depending on the campaign: - For Auto campaign, it is equal to the base bid. - For Compet campaign, add +0.1 to the base bid. 3.1) Bid - the bid value for each keyword in Broad campaigns (where the Entity value is Keyword for Broad and Exact campaigns). For Exact campaign, add +0.15 to this value. 4) Keyword text - values of keywords, the quantity may vary for different products (in the example 1). Accordingly, there will be more necessary rows in the structure. Used in Broad and Exact campaigns. In these rows, Entity is equal to Keyword. And the Match type column should have the corresponding match type value for Broad or Exact. 5) Negative keyword - these values come in rows after the Keyword text values. The quantity of these values can also vary, from 0 to 1000 (in example 1). Used for Auto, Broad, and Exact campaigns. In these rows, Entity is equal to Negative keyword. And the Match type column should have the value Negative phrase. 6) Asins - values of competitor ASINs, the quantity may vary for different products (in example 1). Used for Compet campaigns, added in the row where Entity is Product targeting in the format asin="B07VMXG354" - meaning quotes are added around the ASIN and asin= at the beginning. Additional details: 1) For the Operation column in each created row, give the value "create". 2) The Start date value is used once in the row where Entity is Campaign. The Start date value should be a date, the date when the script is launched. Format: 20240502. 3) For the Targeting type, State, Bidding strategy columns - use values and placements of these values similar to our examples in the structures in the Auto, Broad, Exact, Compet tabs. Additional script operation details: Upon each run, the script should delete previously created structures on the Auto1, Broad1, Exact1, Compet1, All_together tabs if they exist. In other words, do not accumulate data.

Proposals 3 Withdrawn 1

Andrii Nikulin

26 0

Budget: 2000 UAH Deadline: 1 day

Hello! Our team has been selling on Amazon since 2016, creating SEO-optimized listings, infographics, setting up PPC advertising, providing full support for accounts (registration, maintenance), niche analysis.
- I have a few questions, how many products are you planning to list on Amazon? I will clearly explain the cost!
If you need professionals, we are ready to cooperate.
You can see our work in the Portfolio.

Danilo Danilo
Kyiv, Ukraine

Projects 51
Contests 1
Rating 5.0
Rating 1 116

Make a script for Google Sheets

Andrii Nikulin

Proposals concealed

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Javascript and Typescript

Creation of a website for ticket sales

Fix the calculation of Realized PnL, ROI, and Win Rate for cryptocurrency wallets.

Website on the Next.js framework (based on React)

Need a frontend developer / layout designer for a one-time improvement of a website on Magento 2.

Optimization of Core Web Vitals (OpenCart) for Google PageSpeed — Mobile and PC versions