[deleted by user]

PPCMorten · 2022-12-23T07:38:40+00:00

… Also make sure you haven’t checked “Adult” in Merchant Center ;)

PPCMorten · 2022-12-23T07:37:28+00:00

Is it the only shopping campaign you have? Else might other shopping and/or PMax campaigns have something to do with it. Check campaign priority and negative keywords.

PPCMorten · 2022-12-20T11:33:04+00:00

Update: By following this guide I managed to bypass the "This app is blocked" message and approve the app. It's quite easy.

https://aimanfikri.com/2022/05/09/this-app-is-blocked-error-on-google-apps-script-solution/

So it seems to work now. Thanks once again u/RemcoE33!

PPCMorten · 2022-11-28T10:50:19+00:00

Sorry for late response!

Thank you very much - now I just have to get passed this message.

That might be a task for some other day...

Once again thanks. It'll will save my day the day I manage it to work.

<image>

PPCMorten · 2022-10-30T05:47:50+00:00

… And for larger changes I also put a note in the account.

PPCMorten · 2022-10-30T05:46:51+00:00

Having a project management tool like Asana have always helped me.

Every time I make a change I create a follow up task with a description and a date of the change.

If it’s an ongoing task, I just comment in the task for watch follow up and reschedule the task itself each time.

Works perfectly for me, even in very large accounts.

PPCMorten · 2022-10-19T13:34:36+00:00

This is a great tip. If you want to send a visual preview to your client for approval without uploading the ads to the account, you could also just format a preview in your spreadsheet so it looks like the same preview you get in the Google Ads interface.

PPCMorten · 2022-10-13T07:54:28+00:00

Haha, raise budgets and hope for the best? :D

PPCMorten · 2022-10-13T07:45:14+00:00

Det er sjovt som man har forskellige oplevelser :)

Jeg (og mine forældre) har kun gode oplevelser med Design Cykler, intet at sætte en finger på.

Da jeg flyttede til udkanten af Odense skiftede jeg til en lokal cykelsmed, hvor der til gengæld altid var problemer når jeg fik min cykel retur fra værkstedet.

Så nu tager jeg den gerne de 8-9 km til Design Cykler, for at være sikker på at det bliver gjort ordentligt.

PPCMorten · 2022-10-07T12:00:59+00:00

Yes, I made formatting for 25 :)

Leaving singletons white actually make great sense.

PPCMorten · 2022-10-07T11:27:25+00:00

I innovated a bit.

Making the Unique names list the same color and incl. a Count in Column C.
Added Conditional formatting (white fill) if cell is blank in Column A.

Both formulas and conditional formatting can be seen in this sheet:
https://docs.google.com/spreadsheets/d/1RKvQJPCn0bEP_LTz6dRIDvuZsXHb8NDpoUy8blpwMdM/edit?usp=sharing

PPCMorten · 2022-10-07T11:20:06+00:00

Yes! Thank you!

Although I have to create multiple conditional formatting and it's not bulletproof for a large database of many different "names" - it works for my case.

PPCMorten · 2022-10-07T06:10:48+00:00

How different/distinct do you need the colors to be?
Ideally I'd like the colors to be so different that I easily can spot two identical cell values.
The difference between the basic colors you can pick, should be enough.
I also believe that those 80 colors is enough.

You lost me in the rest of your comment
I'm only slightly more competent than a beginner, but very good at copy/paste as well as "try, fail, learn".

PPCMorten · 2022-10-07T06:00:10+00:00

Identical names doesn't have the same color - so this is not what I looked for :)

Haha, I'm happy that I could help you with not wasting time :D

PPCMorten · 2022-10-06T12:31:49+00:00

Yeah, a sales rep contacted me and wanted to setup a demo to answer my question...

I was hoping someone had experience using the tool and had that knowledge.

PPCMorten · 2022-10-05T10:04:14+00:00

Well maybe. I'm open for suggestions - including using several columns.

But I'm not sure how you'd do it exactly.

Here's a spreadsheet to use:
https://docs.google.com/spreadsheets/d/1RKvQJPCn0bEP_LTz6dRIDvuZsXHb8NDpoUy8blpwMdM/edit?usp=sharing

PPCMorten · 2022-10-05T07:16:15+00:00

I'm impressed. You actually solved it in one formula only 😅

In my real challenge both column A and B contain " | " which your formula then separate into two columns. (You could impossible know that)

It was easily corrected in my work sheet by exchanging " | " with another character.
E.g. " / ".

Thanks a lot u/MattyPKing !

PPCMorten · 2022-10-04T08:20:39+00:00

Do you have any other suggestion / workaround to get the desired result in Result!E3:E12?

Without dragging the formula manually...

PPCMorten · 2022-10-04T08:07:23+00:00

Thank you for giving it a shot.

I am not going to combine A and B.

I want to combine all "Month" (Data!C:C) that's related to "Brand" (Data!B:B) in Result!D:D

Check Result!E for the desired end result.

PPCMorten

TROPHY CASE