Pull Reddit Ads conversion and performance reports via the Ads Reporting API

Steps

1. Authenticate using OAuth 2.0 client credentials flow against the Reddit token endpoint to obtain a bearer token for the ads scope
2. Query the /api/v3/reporting/campaign endpoint with the account_id, campaign IDs, start_date, end_date, and a granularity parameter (TOTAL, DAY, or HOUR) to retrieve campaign-level metrics
3. Request conversion metrics by including event_type fields in the metrics parameter (e.g. view_conversion, click_conversion) alongside standard delivery metrics such as impressions, clicks, and spend
4. Paginate the response using the after cursor token returned in the pagination object when the result set exceeds the default page size
5. Join campaign-level report data with ad-level data from the /api/v3/reporting/ad endpoint to identify which individual promoted posts are driving the most conversions
6. Schedule regular pulls using a cron job, storing results incrementally with the report date as partition key; avoid re-pulling finalized data older than 7 days as it does not change