Feature #1912
Updated by Kevin Zaleski 8 months ago
Ref: http://dev.classygroundcovers.com/issues/1867
This task is to do the "Setup Google PPC" subtask remaining from that issue above.
- create a template adgroup
- populate BRAND and CODE in headlines and descriptions
- make sure headlines and descriptions do not exceed limits
- create a new AdGroup spreadsheet that can be imported in Google Ads
See attached file Classy Groundcovers+Affiliate Doors, Low Max CPC+Rokne+2024-08-02.csv - it contains a "basic" ad and set of set of keywords for BRAND = Rokne.
Import it, make it into a template by replacing:
- Rokne with BRAND
- CELIAYANG with CODE
- 10% with DISCOUNT
everywhere.
This becomes the template.
How do we make a new spreadsheet? Not sure.
Perhaps make a new sheet "New Affiliates" with columns BRAND, CODE, DISCOUNT and we populate it manually?
For example, we need to add:
Poach, CELIA15, 15%
If you could make a spreadsheet that clones the template, and makes those three global replacements, I think it could quickly be imported into Google.
If we had to do a large number perhaps TinyTask could collect multiple importable adgroup spreadsheets.
Ideally make the name of the new sheet "{BRAND} adgroup to import" - if that is not possible, we need to discuss.
h2. You must check that the created spreadsheet does not violate field size limits.
If any limits are violated, make it obvious with color-coding and possibly some other alert; allow manual editing of that field and remove the magenta background color alert once the field length no longer violates the restriction.
*The contents of the fields in "headlines" (row 27, columns A-BZ) must not exceed 30 characters.*
*The contents of the fields in "descriptions" (row 27, columns CA-CH) must not exceed 90 30 characters.*
This task is to do the "Setup Google PPC" subtask remaining from that issue above.
- create a template adgroup
- populate BRAND and CODE in headlines and descriptions
- make sure headlines and descriptions do not exceed limits
- create a new AdGroup spreadsheet that can be imported in Google Ads
See attached file Classy Groundcovers+Affiliate Doors, Low Max CPC+Rokne+2024-08-02.csv - it contains a "basic" ad and set of set of keywords for BRAND = Rokne.
Import it, make it into a template by replacing:
- Rokne with BRAND
- CELIAYANG with CODE
- 10% with DISCOUNT
everywhere.
This becomes the template.
How do we make a new spreadsheet? Not sure.
Perhaps make a new sheet "New Affiliates" with columns BRAND, CODE, DISCOUNT and we populate it manually?
For example, we need to add:
Poach, CELIA15, 15%
If you could make a spreadsheet that clones the template, and makes those three global replacements, I think it could quickly be imported into Google.
If we had to do a large number perhaps TinyTask could collect multiple importable adgroup spreadsheets.
Ideally make the name of the new sheet "{BRAND} adgroup to import" - if that is not possible, we need to discuss.
h2. You must check that the created spreadsheet does not violate field size limits.
If any limits are violated, make it obvious with color-coding and possibly some other alert; allow manual editing of that field and remove the magenta background color alert once the field length no longer violates the restriction.
*The contents of the fields in "headlines" (row 27, columns A-BZ) must not exceed 30 characters.*
*The contents of the fields in "descriptions" (row 27, columns CA-CH) must not exceed 90 30 characters.*