Avantlink Platform: The data flow starts at the Avantlink platform, which serves as the source of affiliate data. Various reports (such as performance summaries and sales data) are made available through API calls.

API Calls: For each report, API calls are made to fetch the data from Avantlink's platform for different merchants. These reports provide essential affiliate information like ad impressions, click-throughs, sales, commissions, etc.

Compiled Merchant Data: The data fetched from each report is aggregated into merchant-specific datasets (e.g., Merchant 1 and Merchant 2). These datasets are compiled and prepared for storage.

BigQuery: The compiled data for each merchant is then sent to Google BigQuery, where it is stored in a centralized data warehouse. This allows for scalable storage and efficient querying of large datasets.

Looker Studio Dashboards: The data stored in BigQuery is then retrieved and visualized in separate Looker Studio Dashboards. These dashboards provide an analytical interface for understanding the affiliate data, enabling deeper insights and reporting.