Source Bing Ads: missing keywords & Microsoft Click ID

[LuliRib]

Hi all, I´m connecting to the Bing Ads source.

Environment

• Airbyte version: 0.40.17
• OS Version / Instance: Windows 10,
• Source Connector and version: Bing Ads
• Destination Connector and version: Redshift, with S3 copy

Current Behavior

I have a connection that syncs the following streams:

• accounts (full refresh | overwrite)
• ad_group_performance_report_daily (Incremental | Deduped+history)
• ad_groups (full refresh | overwrite)
• campaign_performance_report_daily (Incremental | Deduped+history)
• campaigns (full refresh | overwrite)
• keyword_performance_report_daily (Incremental | Deduped+history)

Expected Behavior

The syncs passes successfully. In the keyword_performance_report_daily I receive the keyword and the keywordstatus, BUT I can´t find anywhere the keyword itself.

Another issue is the msclkid: We enabled the auto-tagging everywhere in Bingads. But I can´t find it in any report.

[LuliRib]

Hi, attached the logs of the inital upload. Therefore, it´s like a full refresh overwrite. In the keyword_performance_report_daily I get KeywordId and KeywordStatus fields, But I need also the keyword itself. Can you add it to the report?? It´s really importanta, as I can´t show any keywords insights without the word used (the text).

Regarding the msclkid, it´s the equivalent to the google ads gclid. It contains the information regarding the click. We have implemeted the msclkid in all the campaigns, which means that we record the msclkid. BUT I don´t have it in any report.

The first thing is crucial (the keyword text)

9d9aea6f_8f2e_4ef1_9c3e_0bbf57935780_logs_446_txt.txt

[LuliRib]

Hi, hereby is the list of columns that can be included in the KeywordPerformanceReportRequest. I need the keyword to be added for the keyword_performance_report_daily. As shown in the image, it´s just to add the keyword column to the list.

Can someone help me with that??

[marcosmarxm]

Using the integration account the Keyword field is in the schema but it is always NULL

[darynaishchenko]

Hi, @LuliRib! I'm working on this issue now. Could you please add more specific information about Microsoft Click ID. What kind of info about Microsoft Click ID you want to see in reports? Also you use outdated version of connector, you can update to newest and see the reports. CampaignPerformanceReport, AdPerformanceReport, AdGroupPerformanceReport KeywordPerformanceReport and AccountPerformanceReport have Clicks, LowQualityClicks, LowQualityClicksPercent and LowQualitySophisticatedClicks columns. Is this what you want to see in reports?

[darynaishchenko]

Hi, @LuliRib! Any updates about Microsoft Click ID?

[lazebnyi]

Now close. If need will re-open.