How can I use "as" syntax in GAQL?

[EladB]

Hello

How can I use "as" syntax in GAQL?

```

SELECT HourOfDay as col1, DayOfWeek, Clicks, Impressions, Conversions, Cost FROM ACCOUNT_PERFORMANCE_REPORT DURING 20211009,20211009

```

Thanks!

[Google Ads API Forum Advisor]

Hi,

 

It seems that you are trying to use AWQL. I'm afraid that the "as" syntax is not supported in AWQL. You can refer here for the supported grammar of AWQL. Please note that the AdWords API is deprecated and will be sunset on April 27, 2022. We strongly recommend that you migrate to the Google Ads API as soon as possible

 

Alternatively, you may do some post-processing on your end in order to rename columns. You will need to implement this on your end as this is already out of scope for our team.

 

Also, do you need assistance on adding a filter? If yes, can you please provide more details on your requirements so I can further investigate this and provide some suggestions?

 

Regards,

Kevin Gil Soriano Google Ads API Team

ref:_00D1U1174p._5004Q2PIMnC:ref