Cost Discrepancy Between Campaign View and Location View for Customer 2045721490

[Zhu caidong]

Issue Summary

We have identified a significant cost discrepancy when querying the same customer account (2045721490) for the same date (2025-10-13) using different views:

• Campaign View: Shows total cost of  146,049.191156 (cost_micros)
• Location View: Shows total cost of 64,132.85 (cost_micros)
• Geographic View: Shows total cost of 64,132.85 (cost_micros)
• Discrepancy Amount: 81,916.34

The entire discrepancy is attributed to Campaign ID 23034485260, which shows costs in the campaign view but zero costs in both location and geographic views.
Thank you for your assistance.