Loading ...
Sorry, an error occurred while loading the content.

302Re: [yws-searchmarketing] addReportRequestWithAccountAggregation Returns variable XML attributes

Expand Messages
  • Yahoo! Search Marketing Monkey
    Dec 4, 2006
    • 0 Attachment
      Hey Don,

      I'd suggest creating a list of all possible columns up front, as they
      are documented in the Reports section of the online documentation. Then
      just fill in blank/null values for the columns not present in a given
      row. You should be able to generalizer this concept to work in all your
      xml to tsv conversions.

      Hope that helps,
      -Y!SM Monkey

      don.frazier wrote:
      > Hello all ... I am submitting a
      > addReportRequestWithAccountAggregation() for my account. In the
      > returned XML, there seems to be quite a bit of variance on the
      > reports, depending on the the data. In Adcenter and Adwords,
      > every "row" in the XML report has the same "columns" regardless of
      > the data.
      >
      > Panama seems to return different "rows" depending on the actual
      > data. For example, the "analytics" element may contain the
      > attributes numImpr, numClick, ctr, numConv, revenue, cost and
      > averagePosition. But if ctr is anything other than "0.0", then the
      > additional columns cpc, numConv, clickConvRate and roas are also
      > present.
      >
      > My technique for parsing this report is to flatten it into a tab
      > delimited file that I then bulk load into my data base for further
      > processing. Obviously, the variable columns are killing my process.
      > I'd like to keep my XML parser generic cuz it works basically the
      > same for any XML data, as long as the data follows a set pattern.
      > Any idea if there's a way to get a consistent set of columns in the
      > output? Samples below.
      >
      >
      > <row cmpgnID="92" adGrpID="100" keywordID="22" urlID="48820"
      > accountName="xxx" accountID="30" cmpgnName="s" adGrpName="xx2"
      > keywordName="xx" url="http://xxx">
      > <analytics numImpr="1" numClick="0" ctr="0.0" numConv="0"
      > revenue="0.0" cost="0.0" averagePosition="1.0" />
      > </row>
      >
      >
      > <row cmpgnID="92" adGrpID="100" keywordID="222" urlID="8"
      > accountName="xxx" accountID="30" cmpgnName="s" adGrpName="xx"
      > keywordName="xx" url="http://xx">
      > <analytics numImpr="26" numClick="5" ctr="0.19230769230769232"
      > cpc="0.11" numConv="0" clickConvRate="0.0" revenue="0.0" roas="0.0"
      > cost="0.55" averagePosition="1.1153846153846154" />
      > </row>
      >
      >
      >
      >
      >
      > Yahoo! Groups Links
      >
      >
      >
    • Show all 6 messages in this topic