Script for Google Adwords (Selection of ineffective products)

A script needs to be developed for Google Adwords that will disable ineffective products within advertising campaigns such as:

– Google Performance Max

– Google Products (Product Advertising)

The product section is analyzed: https://roliki.ua/s/invaginating0505.png

**Product filtering principle:**

The script in Google Ads collects statistics by item_id, marks products with LABEL: AUTO_QUARANTINE, and writes to CSV/Google Sheet.

In Merchant Center — Feed Rule: if a product has the label AUTO_QUARANTINE → set custom_label_4=exclude (Merchant Label 4).

In PMax/Shopping, create a Listing group by custom_label_4=exclude and exclude the group.

**All products that fall under filtering must go into a separate Google Sheets**

Product ID / Name / Disable rule number / Date and time / Company

**Logic and conditions for filtering:**

1) The script calculates the cost price of the product from the retail price (column PRICE):

Cost price = Price * % (according to the price threshold)

Profitability = Price - Cost price

30000 UAH > 90% > 27,000 UAH > 3,000 UAH

27000 UAH > 85% > 22,950 UAH > 4,050 UAH

25000 UAH > 80% > 20,000 UAH > 5,000 UAH

20000 UAH > 75% > 15,000 UAH > 5,000 UAH

15000 UAH > 70% > 10,500 UAH > 4,500 UAH

10000 UAH > 60% > 6,000 UAH > 4,000 UAH

5000 UAH > 50% > 2,500 UAH > 2,500 UAH

2000 UAH > 40% > 800 UAH > 1,200 UAH

1000 UAH > 30% > 300 UAH > 700 UAH

200 UAH > 25% > 50 UAH > 150 UAH

100 UAH > 20% > 20 UAH > 80 UAH

1 UAH > 10% > 0.10 UAH > 0.90 UAH

**2) Disables products for a specific advertising campaign under the following conditions (checking the entire period of the campaign's operation):**

2.1)

If the product received [40] clicks

Did not receive [1] conversion (Column: Conversions)

2.2)

If the product's "Expenses" are already higher than "Conversion Value"

Provided that the conversion value is greater than 0 (zero)

2.3)

If the product's "Expenses" are already higher than [50%] of "Cost Price"

Did not receive [1] conversion (Column: Conversions)

2.4)

If the product received [500] impressions

Its CTR is below 0.25%

Did not receive [1] conversion (Column: Conversions)

2.5)

If the product received [3000] impressions

Its CTR is below 0.50%

Did not receive [1] conversion (Column: Conversions)

2.6)

If the product's "Expenses" are already higher than [200] UAH

Did not receive [1] conversion (Column: Conversions)

2.7)

If the product's "Average cost per click" is [4] times higher than the average CPC of the campaign

And CTR is below [2%]

Did not receive [1] conversion (Column: Conversions)

2.8)

If the product received [5] clicks

If the product's "Average cost per click" is [6] times higher than the average CPC of the campaign

Did not receive [1] conversion (Column: Conversions)

**Counting period:**

We count for the entire period of the advertising campaign, from the start date of the campaign's impressions to today, excluding the last 3 days (to wait for attribution).

Basic things

The script should operate on a regular daily rule (conditionally once a day)

The script should process only selected campaigns