Hi team,
I am writing a script to pull these raw data: impressions, cost, clicks, views of my PMAX campaigns and paste them inside my spreadsheet.
The concept will be 3 reports by age, gender, and location with the aforementioned metrics but whenever I run the script, it returns blank even though I tested it successfully for other types of campaign such as SEARCH, DISPLAY, etc.
Here is my query to get the data for gender report:
SELECT ad_group_criterion.gender.type, metrics.impressions, metrics.clicks, metrics.ctr, metrics.video_views, metrics.video_view_rate, metrics.average_cpv, metrics.cost_micros, metrics.conversions, metrics.cost_per_conversion FROM gender_view WHERE segments.date DURING LAST_MONTH AND campaign.advertising_channel_type = 'PERFORMANCE_MAX'
Please help me confirm this!
Sincerely,