@kapa.ai I am pulling keyword_performance_report_daily from bing api. spend number is different from UI vs api pull. is this a known issue ?

The knowledge sources do not explicitly mention a known issue with spend number discrepancies in the

keyword_performance_report_daily

stream specifically. However, there are a couple of relevant things to be aware of from the Bing Ads connector documentation: Potential Cause: Removed Fields Affecting Report Accuracy The Bing Ads docs include an important warning about report streams: > "Be careful when removing fields that you don't want to sync in the replication stream settings. Reports are generated with all fields in the stream schema. Removing fields in the replication settings does not change the actual API request for the report. *The results of such a report may be inaccurate due to invisible values in the removed fields.*" If you have deselected any columns in your replication settings, this could cause inaccurate values like

Spend

. [Supported Streams] The recommended fix in this case is to use a custom report where you explicitly define only the fields you want — no extra fields will be included in the request. [Supported Streams] Other Things to Check • Ensure you are on the latest version of the connector, as several fixes have been made over time (e.g., fixing duplicated records for report-based streams in v2.1.3, adding missing fields in

keyword_performance_report

in v2.6.0). [Reference] • If you upgraded to v2.0.0, date/time field formats changed to RFC3339, which could affect how data is filtered or compared. [Migration Guide] If the issue persists after checking the above, I'd recommend opening a GitHub issue with the Airbyte team with specific details (connector version, sample data comparison, etc.). 👍 0 button 👎 0 button ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.