@kapa.ai I am loading my data into bigquery but several syncs are loading 0 records. For some of the ad accounts only the most recent data is being loaded. how do we fix this?

Based on the information provided in the knowledge sources, there are a few potential reasons for your issue with loading data into BigQuery and some syncs resulting in 0 records. Let's address these points: 1. Custom Insights Configuration: There seems to be an issue with the Facebook Marketing source connector where custom insights configurations may only load 1 record per account ID. This could explain why only the most recent data is being loaded for some ad accounts. This is a known issue that the Airbyte team is investigating [source-facebook-marketing issue](https://github.com/airbytehq/airbyte/issues/38088). 2. API Limitations: For some advertising sources like Google Ads, there are API limitations that prevent getting performance data at a granularity smaller than a day. This means that data is usually pulled up until the previous day, which could result in 0 records if you're trying to sync very recent data [Google Ads Performance Considerations](https://docs.airbyte.com/integrations/sources/google-ads#performance-considerations). 3. Sync Interval: If you're using intra-day syncs, it's possible that the data isn't ready on the source side yet. It's recommended to use daily syncs instead to ensure all data is available [Forum Post](https://discuss.airbyte.io/t/922). To address these issues, you can try the following: 1. Check your sync interval and consider adjusting it to daily syncs if you're currently using intra-day syncs. 2. If you're using custom insights for Facebook Marketing, be aware of the current limitation and wait for the Airbyte team to resolve the issue. 3. Verify that your start date for syncing is correct and falls within the allowed range for historical data retrieval. 4. If the problem persists, you may want to try clearing the data for the affected streams and resyncing. You can do this by navigating to the Connection's status page, clicking the three grey dots next to the stream, and selecting "Clear data" [Clear Data Documentation](https://docs.airbyte.com/operator-guides/clear#steps-to-clear-data). 5. Review the connection status and check for any error messages or rate limiting issues that might be causing the syncs to fail or retrieve 0 records [Connection Troubleshooting](https://docs.airbyte.com/cloud/managing-airbyte-cloud/review-connection-status#connection-troubleshooting). If these steps don't resolve the issue, you may need to reach out to Airbyte support for further assistance, as there could be specific issues with your setup or the connectors you're using.

@kapa.ai it appears to just be for Google Search Console

A message from kapa.ai

Based on the knowledge sources provided, there isn't specific information about issues with the Google Search Console source connector resulting in 0 records. However, here are some general troubleshooting steps you can take: 1. Check your configuration settings: Make sure you've correctly set up the Google Search Console source in Airbyte. This includes verifying your credentials and ensuring you've correctly specified the domain or URL you want to pull data from. 2. Review your date range: If you've set a date range for your sync, make sure it's a period during which data is available. If the date range is too recent, it's possible that the data isn't ready yet, which could result in 0 records being synced. 3. Check for errors: Review the logs for your sync operation. Look for any error messages that might indicate what's going wrong. If you're seeing errors related to permissions or rate limits, you'll need to address those. 4. Update your connector: Make sure you're using the latest version of the Google Search Console source connector. Airbyte regularly releases updates to its connectors that include bug fixes and improvements. If these steps don't resolve the issue, you may need to reach out to Airbyte support for further assistance. They can help you diagnose and resolve issues specific to your setup or the Google Search Console source connector.