Bing Ads missing a lot of fields, is this intentional?

Connector Development
1

For some reason, the bing ads schema is missing a lot of fields, just want to see if this is intentional or if there’s some other consideration that goes into this.

E.g. For the CampaignPerformanceReport. The source.py only supports the following fields:

report_columns = [
        "AccountName",
        "AccountNumber",
        "AccountId",
        "TimePeriod",
        "CampaignId",
        "CampaignName",
        "DeviceType",
        "Network",
        "Impressions",
        "Clicks",
        "Ctr",
        "AverageCpc",
        "Spend",
        "ReturnOnAdSpend",
        "RevenuePerConversion",
        "ConversionRate",
    ]

source code
However, based on the official documentation of bing ads for CampaignPerformanceReport, we have way more columns:

<xs:simpleType name="CampaignPerformanceReportColumn" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:restriction base="xs:string">
    <xs:enumeration value="AccountName" />
    <xs:enumeration value="AccountNumber" />
    <xs:enumeration value="AccountId" />
    <xs:enumeration value="TimePeriod" />
    <xs:enumeration value="CampaignStatus" />
    <xs:enumeration value="CampaignName" />
    <xs:enumeration value="CampaignId" />
    <xs:enumeration value="CurrencyCode" />
    <xs:enumeration value="AdDistribution" />
    <xs:enumeration value="Impressions" />
    <xs:enumeration value="Clicks" />
    <xs:enumeration value="Ctr" />
    <xs:enumeration value="AverageCpc" />
    <xs:enumeration value="Spend" />
    <xs:enumeration value="AveragePosition" />
    <xs:enumeration value="Conversions" />
    <xs:enumeration value="ConversionRate" />
    <xs:enumeration value="CostPerConversion" />
    <xs:enumeration value="LowQualityClicks" />
    <xs:enumeration value="LowQualityClicksPercent" />
    <xs:enumeration value="LowQualityImpressions" />
    <xs:enumeration value="LowQualityImpressionsPercent" />
    <xs:enumeration value="LowQualityConversions" />
    <xs:enumeration value="LowQualityConversionRate" />
    <xs:enumeration value="DeviceType" />
    <xs:enumeration value="DeviceOS" />
    <xs:enumeration value="ImpressionSharePercent" />
    <xs:enumeration value="ImpressionLostToBudgetPercent" />
    <xs:enumeration value="ImpressionLostToRankAggPercent" />
    <xs:enumeration value="QualityScore" />
    <xs:enumeration value="ExpectedCtr" />
    <xs:enumeration value="AdRelevance" />
    <xs:enumeration value="LandingPageExperience" />
    <xs:enumeration value="HistoricalQualityScore" />
    <xs:enumeration value="HistoricalExpectedCtr" />
    <xs:enumeration value="HistoricalAdRelevance" />
    <xs:enumeration value="HistoricalLandingPageExperience" />
    <xs:enumeration value="PhoneImpressions" />
    <xs:enumeration value="PhoneCalls" />
    <xs:enumeration value="Ptr" />
    <xs:enumeration value="Network" />
    <xs:enumeration value="TopVsOther" />
    <xs:enumeration value="BidMatchType" />
    <xs:enumeration value="DeliveredMatchType" />
    <xs:enumeration value="Assists" />
    <xs:enumeration value="Revenue" />
    <xs:enumeration value="ReturnOnAdSpend" />
    <xs:enumeration value="CostPerAssist" />
    <xs:enumeration value="RevenuePerConversion" />
    <xs:enumeration value="RevenuePerAssist" />
    <xs:enumeration value="TrackingTemplate" />
    <xs:enumeration value="CustomParameters" />
    <xs:enumeration value="AccountStatus" />
    <xs:enumeration value="BudgetName" />
    <xs:enumeration value="BudgetStatus" />
    <xs:enumeration value="BudgetAssociationStatus" />
    <xs:enumeration value="LowQualityGeneralClicks" />
    <xs:enumeration value="LowQualitySophisticatedClicks" />
    <xs:enumeration value="CampaignLabels" />
    <xs:enumeration value="ExactMatchImpressionSharePercent" />
    <xs:enumeration value="CustomerId" />
    <xs:enumeration value="CustomerName" />
    <xs:enumeration value="ClickSharePercent" />
    <xs:enumeration value="AbsoluteTopImpressionSharePercent" />
    <xs:enumeration value="FinalUrlSuffix" />
    <xs:enumeration value="CampaignType" />
    <xs:enumeration value="TopImpressionShareLostToRankPercent" />
    <xs:enumeration value="TopImpressionShareLostToBudgetPercent" />
    <xs:enumeration value="AbsoluteTopImpressionShareLostToRankPercent" />
    <xs:enumeration value="AbsoluteTopImpressionShareLostToBudgetPercent" />
    <xs:enumeration value="TopImpressionSharePercent" />
    <xs:enumeration value="AbsoluteTopImpressionRatePercent" />
    <xs:enumeration value="TopImpressionRatePercent" />
    <xs:enumeration value="BaseCampaignId" />
    <xs:enumeration value="AllConversions" />
    <xs:enumeration value="AllRevenue" />
    <xs:enumeration value="AllConversionRate" />
    <xs:enumeration value="AllCostPerConversion" />
    <xs:enumeration value="AllReturnOnAdSpend" />
    <xs:enumeration value="AllRevenuePerConversion" />
    <xs:enumeration value="ViewThroughConversions" />
    <xs:enumeration value="Goal" />
    <xs:enumeration value="GoalType" />
    <xs:enumeration value="AudienceImpressionSharePercent" />
    <xs:enumeration value="AudienceImpressionLostToRankPercent" />
    <xs:enumeration value="AudienceImpressionLostToBudgetPercent" />
    <xs:enumeration value="RelativeCtr" />
    <xs:enumeration value="AverageCpm" />
    <xs:enumeration value="ConversionsQualified" />
    <xs:enumeration value="LowQualityConversionsQualified" />
    <xs:enumeration value="AllConversionsQualified" />
    <xs:enumeration value="ViewThroughConversionsQualified" />
  </xs:restriction>
</xs:simpleType>

Is this something I would have to implement on my own?

2

Hi and welcome to the community, @SPTKL! Yes - please feel free to open a PR and assign it to me. If you need direction on how to do this, let me know and I’d be happy to help.