Other

We need to add these affiliate adgoups to Google (note: we setup Microsoft Ads to automatically import these affiliate adgroups from Google, do NOT automate importation of any other adgroups without SUBSTANTIAL consideration - it is CRITICAL that we NOT automate importation of ANY Classy Groundcovers adgroups from Google to Microsoft because the destination URLs are different so we can track performance.)¶

We need to add these affiliate adgroups: (please confirm that % off and $ off display correctly - we may need to revise).

BestPaddle, HAPPY, 15%
Dingk, ELIXIR, 10%
Gamma, ba_edwards20, 20%
Glory, CE10, 10%
Gruvn, carleye15, 15%
Holbrook, CELIAYANG20, 20%
Jolle, Celia10, 10%
JustPaddles, HAPPY10, 10%
Lix Pickleball, Xuan15, $15
Mozi Pickleball, PICKLEBALLPSYCHO, 10%
OM Pickleball, OMxNAMASTE, 10%
Onix, 8VY4H7ZP8EV8, 15%
Owl, CLEO32323, 15%
Poach, CELIA15, 15%

https://docs.google.com/spreadsheets/d/11Wjnj9fWALW-1wsIE_a7nxNSR8udNKUuwXBv3VYPlKc/edit?usp=sharing

I finished everything except column AK and the last several columns.

Column AK:
The structure is not consistent — The first cell in each “category” is different.

The last several columns — not completely consistent (see color coding), but maybe those columns should be blank. They seem to be the status within Microsoft Ads, rather than something instrinsic to the ad itself.

For AK you need to use SUBSTITUTE.

I suggested you change the template, replacing:
- Rokne with BRAND
- CELIAYANG with CODE
- 10% with DISCOUNT
everywhere.

Then for AK if you are processing
BestPaddle, HAPPY, 15%
you do

=SUBSTITUTE(AK, "BRAND", "BestPaddle")

... and similar substitions for BRAND, CODE and DISCOUNT in other cells.

Note: we only need to add these (the others are already done):
BestPaddle, HAPPY, 15%
Gamma, ba_edwards20, 20%
Glory, CE10, 10%
Gruvn, carleye15, 15%
Holbrook, CELIAYANG20, 20%
Jolle, Celia10, 10%
JustPaddles, HAPPY10, 10%
Lix Pickleball, Xuan15, $15
Mozi Pickleball, PICKLEBALLPSYCHO, 10%
OM Pickleball, OMxNAMASTE, 10%
Onix, 8VY4H7ZP8EV8, 15%
Owl, CLEO32323, 15%

To do: conditional formatting:

check if cell has more than a certain length (too long description -> make red). Then alert (in the "Information" spreadsheet? if there are any such cells.

Tell users where it's done (check for when the import list is done, and starts being blank thereafter, and then make the relevant rows in the export list (everything from there down) grayed out or red or similar. OR, have a different spreadsheet that copies all of the values of the original output spreadsheet, but only copies if the relevant line in the import (currently "List") is filled.