After migration to V201506, I am unable to balance API numbers to portal. End of month blues.
I'be been able to isolate the out of balance to "criteriaType" = Product Partition. Unfortunately not all Campaigns/adGroups are out of balance, which make researching difficult.
I reviewed V201506 notes and could not find help. Simple report grabbing basic dimensions/metrics to balance client spend.
<report-name name="CRITERIA_PERFORMANCE_REPORT"/>
<date-range date="Aug 1, 2015"/><table>
<columns><column name="day" display="Day"/>
<column name="keywordID" display="Keyword ID"/>
<column name="campaign" display="Campaign"/>
<column name="adGroup" display="Ad group"/>
<column name="keywordPlacement" display="Keyword / Placement"/>
<column name="criteriaType" display="Criteria Type"/>
<column name="impressions" display="Impressions"/>
<column name="clicks" display="Clicks"/>
<column name="cost" display="Cost"/>
<column name="avgCPC" display="Avg. CPC"/>
<column name="ctr" display="CTR"/>
<column name="convertedClicks" display="Converted clicks"/>
<column name="viewThroughConv" display="View-through conv."/>
<column name="totalConvValue" display="Total conv. value"/>
<column name="conversions" display="Conversions"/>
<column name="clickConversionRate" display="Click conversion rate"/>
<column name="costConvertedClick" display="Cost / converted click"/>
<column name="avgPosition" display="Avg. position"/>
<column name="costConv" display="Cost / conv."/>
</columns>
Using my homegrown apps and the query structure for report definition.
Dim postParams As String = "__rdquery=SELECT Date, Id, CampaignName, AdGroupName, Criteria, CriteriaType, " & _
"Impressions, Clicks, Cost, AverageCpc, Ctr, ConvertedClicks, ViewThroughConversions, ConversionValue, ConversionsManyPerClick, " & _
"ClickConversionRate, CostPerConvertedClick, AveragePosition, CostPerConversionManyPerClick FROM CRITERIA_PERFORMANCE_REPORT " & _
"DURING {0},{1}&__fmt=XML"
Thanks,
David