Bing Ads Migration Guide
This version update affects all hourly reports (end in report_hourly) and the following streams:
- Accounts
- Campaigns
- Search Query Performance Report
- AppInstallAds
- AppInstallAdLabels
- Labels
- Campaign Labels
- Keyword Labels
- Ad Group Labels
- Keywords
- Budget Summary Report
All date and date-time fields will be converted to standard RFC3339. Stream state format will be updated as well.
For the changes to take effect, please refresh the source schema and reset affected streams after you have applied the upgrade.
| Stream field | Current Airbyte Type | New Airbyte Type |
|---|---|---|
| LinkedAgencies | string | object |
| BiddingScheme.MaxCpc.Amount | string | number |
| CostPerConversion | integer | number |
| Modified Time | string | timestamp with tz |
| Date | string | date |
| TimePeriod | string | timestamp with tz |
Detailed date-time field change examples:
| Affected streams | Field_name | Old type | New type (RFC3339) |
|---|---|---|---|
AppInstallAds, AppInstallAdLabels, Labels, Campaign Labels, Keyword Labels, Ad Group Labels, Keywords | Modified Time | 04/27/2023 18:00:14.970 | 2023-04-27T16:00:14.970+00:00 |
Budget Summary Report | Date | 6/10/2021 | 2021-06-10 |
* Report Hourly | TimePeriod | 2023-11-04|11 | 2023-11-04T11:00:00+00:00 |
This version update only affects the geographic performance reports streams.
Version 1.0.0 prevents the data loss by removing the primary keys from the GeographicPerformanceReportMonthly, GeographicPerformanceReportWeekly, GeographicPerformanceReportDaily, GeographicPerformanceReportHourly streams.
Due to multiple records with the same primary key, users could experience data loss in the incremental append+dedup mode because of deduplication.
For the changes to take effect, please reset your data and refresh the stream schemas after you have applied the upgrade.