How to get campaign report performance using filter by date?

[Hendra]

i want try to get campaign report performance and other report but using filter by date,
in dasboard adwords i can manage it by use filter start_date -> after -> date, 

how i can do that using AWQL in c#?

i have try use query like  "SELECT <fields> FROM <report_performance> WHERE start_date = datetime , but this query just give me one output in that date.

what is query to get me data for between date? can i do simillar like sql query?

can anyone help me?

[Teja Makani]

Hello Hendra,

Using AWQL you can pull a report with in custom date range, you need to use DURING clause in your AWQL query with start date(YYYYMMDD) and end date(YYYYMMDD). Improvising your example by adding DURING clause "SELECT <fields> FROM <report_performance> WHERE <condition> DURING YYYYMMDD,YYYYMMDD;". Please refer this guide to know more on custom date ranges. Let me know if you have any further questions.

Regards,
Sai Teja, AdWords API Team.