Make a script for Google Sheets
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.
-
1 day45 USD
2528 26 0 1 1 day45 USD
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.
Current freelance projects in the category Javascript and Typescript
Development of the AM Mobility platform (car service, parking, insurance, car rental)
5770 USD
We are looking for a team or an experienced Full Stack developer to create the MVP of the AM Mobility platform. AM Mobility is a unified digital ecosystem for motorists, combining in one application and web platform: parking; car service; tire fitting; car wash; car rental;… Javascript and Typescript, Web Programming ∙ 5 days 5 hours back ∙ 113 proposals |
Gsap animations
22 USD
Good day. Corrections need to be made in the current project. A specialist is needed who works well with gsap/lenis. Animation of cards needs to be done. Detailed specifications here:… Javascript and Typescript, Web Programming ∙ 5 days 11 hours back ∙ 21 proposals |
I am looking for a mentor with Claude Code to launch a web project from scratch.Brief about the task: I am a beginner with no programming experience. I have a ready specification for website development (42 pages, Next.js, PostgreSQL). I want to implement it myself using Claude Code - I need a specialist who will set up the environment and teach me how to… Javascript and Typescript, Tuition ∙ 7 days 10 hours back ∙ 19 proposals |
Website design updateIt is necessary to update the design of the existing website using HTML, CSS, JS: refresh the appearance, make it modern and responsive for mobile devices. Smooth animations and interactive elements need to be added. HTML & CSS, Javascript and Typescript ∙ 8 days 3 hours back ∙ 97 proposals |
Consultation and audit of the current project on Odoo 19 Community Edition
We are looking for an Odoo Developer — a solo developer with experience in Odoo 19 Community Edition, including using Claude Code. We need a specialist who has successfully implemented projects in Odoo and practical experience in development using Claude Code. Important: we only… C & C++, Javascript and Typescript ∙ 8 days 9 hours back ∙ 8 proposals |
Kyiv