AWQL language script. Two periods DURING variable

[Blanca]

Hey! What's going on?

I want to make a AWQL query using two different conditions related to time. I mean, I want these filters for product :

- Clicks > 1 DURING LAST_30_DAYS AND

- Impressions > 0 DURING (BETWEEN  last 90 and 30 days) 

So, I have two problems to deal with.

First, how can i combine two different DURINGS for each filter?

Second, how can i filter between the last 90 and 30 days, from today (dinamically)?

Third, maybe I could make an INNER JOIN or a SUBSELECT? Is this possible, I've not seen it yet!!

Thanks so much for your help.

Kind regards,

Blanca

[Google Ads API Forum Advisor]

Hello Blanca,

Thank you for reaching out to us.

With regard to making an AWQL query using two different conditions related to time, I'm afraid that this isn't possible. You can only include 1 DuringClause as per this grammar guide.

As for your 2nd concern on filtering between the last 90 and 30 days, from today (dynamically), this is possible programmatically. You can update your code that will hold the current date and from there, you can create your DateRange in this format (8-digit integer: YYYYMMDD).

Lastly, for INNER JOIN or a SUBSELECT, I'm afraid that this is also not supported in the API. With that, can you try if a feature to join is available in the UI? You may provide screenshots so our team can create a feature request for this.

Regards,

Mark Kevin Albios Google Ads API Team

ref:_00D1U1174p._5004Q2LlxiR:ref