Hi Make Community,
I’m currently working on a scenario where I need to pull data from the Google Ads API using the “Run a custom report” module to retrieve product performance data from the shopping_performance_view
. Here’s my GAQL query:
SELECT
segments.product_item_id,
segments.product_title,
metrics.clicks,
metrics.cost_micros,
metrics.conversions,
metrics.conversions_value,
metrics.value_per_conversion,
segments.product_type_l1
FROM shopping_performance_view
WHERE
segments.date DURING LAST_30_DAYS
ORDER BY
metrics.conversions DESC
LIMIT 10000
The query works fine, but I’m only able to retrieve the first 500 rows in Make. I understand that the Google Ads API uses pagination to handle larger datasets, but I’m not sure how to implement it in Make.
Here’s a brief outline of my scenario:
- Google Ads – Run a custom report (with the above GAQL query).
- Array aggregator – To aggregate the results.
- Google Sheets – Update bulk rows – To update my report in a Google Sheet.
I need to retrieve all the products beyond the 500-row limit. How can I handle pagination properly in Make to get all the results from my query?
Thanks in advance for your help!
Any detailed steps or best practices would be greatly appreciated.