Filter Promotion ads (black friday, cyber monday ...) from all MCC accounts

[aladdin]

I want to Find all Promotion ads (black Friday, cyber Monday ... ).

These ads have exp 'Black Friday' in the description, path1, path2, headline1 or headline2 (expended text ads).

Does anyone has a script that can verify this and send it over to spreadsheet?

[Anthony Madrigal]

Hi Aladdin,

You should be able to create a report to return these ads onto a spreadsheet. You will want to use the Ad Performance Report to get the relevant fields. The one issue you may face is that, although you can add WHERE clauses to create filters to see if an ad contains a certain text, these clauses are AND conditions and cannot be used as ORs. You will either need to make several report requests, each with a different filter, or do some post processing.

Regards,

Anthony

AdWords Scripts Team