I am trying to make an application where Adwars user can authorise my google Project APP and My code can pull their campaign's performance report like clicks impression charged amount for that day on that campaign.
But as I execute below query, API returns a below error
"
SELECT
campaign.id, "
. "campaign.advertising_channel_type, "
. "
ad_group.id, "
. "ad_group.status, "
. "metrics.impressions, "
. "metrics.hotel_average_lead_value_micros, "
. "segments.hotel_check_in_day_of_week, "
. "segments.hotel_length_of_stay "
. "FROM hotel_performance_view "
. "WHERE segments.date DURING LAST_7_DAYS "
. "ORDER BY metrics.impressions DESC "
. "LIMIT 50"
I am using the inbuild google API PHP library to pull report
Please help me to resolve the error .
Thanks you so much
Mehul