@kapa.ai can you give me some documentation on how to use the bing ads custom report function

Certainly! I can provide you with information on how to use the Bing Ads custom report function in Airbyte. Here's a summary of the documentation: To create a custom report for Bing Ads in Airbyte, you need to provide the following information: 1. Report Name: Choose a name for your custom report stream. 2. Reporting Data Object: Select a Bing Ads reporting data object. You can find the available objects in the [Bing Ads documentation](https://learn.microsoft.com/en-us/advertising/reporting-service/reporting-data-objects?view=bingads-13). Use objects that end with "ReportRequest". 3. Columns: Specify the columns you want to include in your report. These should be columns from the chosen Reporting Data Object. You can find the available columns in the Bing Ads documentation by clicking on the "...ReportColumn" link for your chosen object. Remember to include the required columns at a minimum. 4. Aggregation: Choose a time aggregation option such as Hourly, Daily, Weekly, Monthly, DayOfWeek, HourOfDay, WeeklyStartingMonday, or Summary. [Source](https://docs.airbyte.com/integrations/sources/bing-ads#custom-reports) When setting up the Bing Ads source connector in Airbyte, you'll need to follow these steps for custom reports: For Airbyte Cloud: 1. Enter the Report Name. 2. Add the Bing Ads Reporting Object for the Reporting Data Object. 3. List the columns you want to see in the custom report. 4. Select the time aggregation. [Source](https://docs.airbyte.com/integrations/sources/bing-ads#for-airbyte-cloud) For Airbyte Open Source: 1. Enter the Report Name. 2. Add the Bing Ads Reporting Object for the Reporting Data Object. 3. Add the columns you want to see in the custom report. 4. Select the time aggregation. [Source](https://docs.airbyte.com/integrations/sources/bing-ads#for-airbyte-open-source) Remember to be careful when selecting columns and ensure you include the required columns. As a general rule, each report must include at least one attribute column and one non-impression share performance statistics column. This custom report feature allows you to tailor the Bing Ads data you sync to your specific needs within the Airbyte platform.

@kapa.ai im getting a SOAP processing fault because of "invalid client data" - said to validate your column and aggregation configuration

A message from kapa.ai

The error message you're seeing suggests that there might be an issue with the columns or aggregation configuration you've set up for your Bing Ads custom report in Airbyte. Here are some steps you can take to troubleshoot this issue: 1. Check Your Columns: Make sure that the columns you've added to your custom report are valid for the Reporting Data Object you've chosen. You can find the available columns for each Reporting Data Object in the Bing Ads documentation by clicking on the "...ReportColumn" link for your chosen object. Remember, each report must include at least one attribute column and one non-impression share performance statistics column. 2. Check Your Aggregation: Ensure that the aggregation you've chosen is valid. The available options are Hourly, Daily, Weekly, Monthly, DayOfWeek, HourOfDay, WeeklyStartingMonday, or Summary. 3. Check for Extra Columns: Be careful not to add extra columns that are not specified in the Bing Ads documentation. Not all fields can be skipped. If you've checked all of these and are still encountering the error, it might be helpful to refer to the [Airbyte Forum](https://github.com/airbytehq/airbyte/discussions) for common troubleshooting issues or the [Bing Ads API documentation](https://docs.microsoft.com/en-us/advertising/guides/services-protocol?view=bingads-13#throttling) for more information on rate limiting and other potential issues. [Source](https://docs.airbyte.com/integrations/sources/bing-ads#custom-reports)

@kapa.ai im getting this now

[33mWARN[m i.a.m.l.MetricClientFactory(getMetricClient):43 - MetricClient has not been initialized. Must call MetricClientFactory.CreateMetricClient before using MetricClient. Using a dummy client for now. Ignore this if Airbyte is configured to not publish any metrics.

A message from kapa.ai

The warning message you're seeing is related to the initialization of the

MetricClient

in Airbyte. This message typically appears when the

MetricClient

has not been properly initialized before it's used. Here's the warning message for reference:

[33mWARN[m i.a.m.l.MetricClientFactory(getMetricClient):43 - MetricClient has not been initialized. Must call MetricClientFactory.CreateMetricClient before using MetricClient. Using a dummy client for now. Ignore this if Airbyte is configured to not publish any metrics.

The

MetricClient

is a component in Airbyte that's used for publishing metrics. If you're seeing this warning, it means that the

MetricClient

is currently using a dummy client because the actual client has not been initialized. To resolve this, you need to call

MetricClientFactory.CreateMetricClient

before using

MetricClient

. This is typically done during the setup or initialization phase of your Airbyte instance. However, if you have configured Airbyte to not publish any metrics, you can safely ignore this warning message as it won't affect the functionality of your data pipelines. Please refer to the [Airbyte Documentation](https://docs.airbyte.io/) or the [Airbyte GitHub Repository](https://github.com/airbytehq/airbyte) for more detailed information on how to properly configure and initialize the

MetricClient

.

@kapa.ai yeah but it wont let me configure the bing data source because of this error, so i cant ignore it

A message from kapa.ai

I'm sorry for the confusion, but based on the provided knowledge sources, there's no specific information about how to resolve the

MetricClient

initialization issue in the context of configuring the Bing data source in Airbyte. The warning message you're seeing is a general one related to the initialization of the

MetricClient

and it's not directly tied to the Bing data source configuration. This warning message should not prevent you from configuring a data source. If you're unable to configure the Bing data source and you're seeing this warning message, it's possible that there might be other issues at play. I would recommend checking the following: 1. Ensure that your Airbyte instance is running the latest version. 2. Check the logs for any other error messages that might indicate what's going wrong. 3. Try resetting your Airbyte instance or restarting the server. If the issue persists, I would recommend reaching out to the Airbyte community on their [Slack channel](https://slack.airbyte.io/) or [GitHub Discussions](https://github.com/airbytehq/airbyte/discussions) for more specific assistance.