Hi Dorian, The reason it doesn't depend on *Cost* is because *CostPerConversion* is the *total cost *divided by the *ConversionValue*. The total cost is the total aggregated cost, which includes total click cost and any other costs, including phone cost. The *Cost* field does not include all the additional expenses. That's why just dividing the *Cost* by *ConversionValue* will not get you the *CostPerConversion*.
As for getting back 0 conversions in a row when specifying *ConversionTypeName*, could you please click *Reply privately to author* in the forum and send me the customer ID where you're seeing this? Thanks, Nadine, AdWords API Team On Tuesday, June 21, 2016 at 5:10:46 AM UTC-4, Dorian Kind wrote: > > Hi Nadine, > > thanks for your feedback. I have a hard time understanding how > "CostPerConversion" isn't dependant on "Cost". If I have the number of > conversions and the cost per conversion, can't I just multiply the two to > get the total cost? > > Here's an example for the extra lines I've mentioned. I've chosen a > different client this time to keep the output small. Consider the following > report definition: > > <reportDefinition xmlns="https://adwords.google.com/api/adwords/cm/v201603 > "> > <selector> > <fields>CampaignId</fields> > <fields>ConversionTypeName</fields> > <fields>Conversions</fields> > <fields>CostPerConversion</fields> > </selector> > <reportName>Test Report</reportName> > <reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType> > <dateRangeType>THIS_MONTH</dateRangeType> > <downloadFormat>CSV</downloadFormat> > </reportDefinition> > > This leads to this report being generated: > > Campaign ID,Conversion name,Conversions,Cost / conv. > 227533244,<CONV_TYPE_A>,0.0,0 > 233123084,<CONV_TYPE_B>,4.0,78832500 > 227533244,<CONV_TYPE_C>2.0,675585000 > 234932444,<CONV_TYPE_B>,1.0,101330000 > Total, --,7.0,445571429 > > If I add a predicate like so: > > <reportDefinition xmlns="https://adwords.google.com/api/adwords/cm/v201603 > "> > <selector> > <fields>CampaignId</fields> > <fields>ConversionTypeName</fields> > <fields>Conversions</fields> > <fields>CostPerConversion</fields> > <predicates> > <field>Conversions</field> > <operator>GREATER_THAN</operator> > <values>0</values> > </predicates> > </selector> > <reportName>Test Report</reportName> > <reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType> > <dateRangeType>THIS_MONTH</dateRangeType> > <downloadFormat>CSV</downloadFormat> > </reportDefinition> > > the output looks different: > > Campaign ID,Conversion name,Conversions,Cost / conv. > 233123084,<CONV_TYPE_B>,4.0,78832500 > 227533244,<CONV_TYPE_C>,2.0,675585000 > 234932444,<CONV_TYPE_B>,1.0,101330000 > Total, --,7.0,252547143 > > This seems to contradict the documentation's statement "Prevents > zero-conversion rows from being returned." for the field > "ConversionTypeName". > > Best regards, > Dorian > > On Monday, June 20, 2016 at 11:48:55 PM UTC+2, Nadine Sundquist (AdWords > API Team) wrote: >> >> Hello Dorian, >> >> So, it looks like you caught an issue in our documentation. We'll be >> updating *ConversionCategoryName* to be listed as a segment. Thanks for >> catching that and telling us about it! >> >> As for the answer to your second question, the *CostPerConversion* does >> not directly depend on *Cost*. That's why the two fields are compatible. >> As a follow-up to this, I have a question for you. You mentioned that >> adding *CostPerConversion* results in more lines. Is the same >> *CostPerConversion* returned for the same *ConversionTypeName*, or are >> they different? I just want to verify that everything is working as >> expected. >> >> Thanks, >> Nadine, AdWords API Team >> >> On Monday, June 20, 2016 at 5:35:19 PM UTC-4, Nadine Sundquist (AdWords >> API Team) wrote: >>> >>> Hi Dorian, >>> >>> Thanks for checking in. Let me ping one of my teammates again because I >>> haven't gotten the answer back, yet. I've always found >>> *ConversionCategoryName* unique, and I just want to make sure I have it >>> right before giving you a definitive answer. >>> >>> Cheers, >>> Nadine, AdWords API Team >>> >>> On Monday, June 20, 2016 at 11:10:47 AM UTC-4, Dorian Kind wrote: >>>> >>>> Hi Nadine, >>>> >>>> any news on this subject? I just noticed that "ConversionCategoryName" >>>> actually is defined as having behavior "Segment", so it seems that >>>> "ConversionCategoryName" should be a segment, too. >>>> >>>> I would also be very interested in any feedback to the second part of >>>> my question, i.e. why "CostPerConversion" is compatible with >>>> "ConversionTypeName" while "Cost" is not. I have a feeling that all >>>> click-related metrics (impression-related, actually) should be >>>> incompatible >>>> with "ConversionTypeName" (and "ConversionCategoryName" for that matter) >>>> as >>>> a single click can lead to multiple conversions of different >>>> categories/types. But I could be wrong. >>>> >>>> Thanks and best regards, >>>> Dorian >>>> >>>> On Friday, June 10, 2016 at 10:56:59 PM UTC+2, Nadine Sundquist >>>> (AdWords API Team) wrote: >>>>> >>>>> Hi Dorian, >>>>> >>>>> I've taken a look at this, and I thought for some reason it was a >>>>> segmenting field as well at some point. Perhaps, the documentation is out >>>>> of date or something has changed. Sometimes, we do have implicit >>>>> segmentation that happens, but I'm not sure if that is what is happening >>>>> here. Let me check with a couple of teammates here, and I'll get back to >>>>> you. >>>>> >>>>> Best, >>>>> Nadine, AdWords API Team >>>>> >>>>> On Friday, June 10, 2016 at 4:08:11 AM UTC-4, Dorian Kind wrote: >>>>>> >>>>>> Hi Umesh, >>>>>> >>>>>> thanks for your reply. I'm really not sure whether ConversionTypeName >>>>>> is an attribute. As an example, for a given account and the >>>>>> following report definition: >>>>>> >>>>>> <reportDefinition xmlns=" >>>>>> https://adwords.google.com/api/adwords/cm/v201603";> >>>>>> <selector> >>>>>> <fields>CampaignId</fields> >>>>>> <predicates> >>>>>> <field>Conversions</field> >>>>>> <operator>GREATER_THAN</operator> >>>>>> <values>0</values> >>>>>> </predicates> >>>>>> <dateRange> >>>>>> <min>20150126</min> >>>>>> <max>20150201</max> >>>>>> </dateRange> >>>>>> </selector> >>>>>> <reportName>Test Report</reportName> >>>>>> <reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType> >>>>>> <dateRangeType>CUSTOM_DATE</dateRangeType> >>>>>> <downloadFormat>CSV</downloadFormat> >>>>>> </reportDefinition> >>>>>> >>>>>> the returned report contains 99 lines. If I add ConversionTypeName: >>>>>> >>>>>> <reportDefinition xmlns=" >>>>>> https://adwords.google.com/api/adwords/cm/v201603";> >>>>>> <selector> >>>>>> <fields>CampaignId</fields> >>>>>> <fields>ConversionTypeName</fields> >>>>>> <predicates> >>>>>> <field>Conversions</field> >>>>>> <operator>GREATER_THAN</operator> >>>>>> <values>0</values> >>>>>> </predicates> >>>>>> <dateRange> >>>>>> <min>20150126</min> >>>>>> <max>20150201</max> >>>>>> </dateRange> >>>>>> </selector> >>>>>> <reportName>Test Report</reportName> >>>>>> <reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType> >>>>>> <dateRangeType>CUSTOM_DATE</dateRangeType> >>>>>> <downloadFormat>CSV</downloadFormat> >>>>>> </reportDefinition> >>>>>> >>>>>> I get back 110 lines. The additional lines are from campaigns that >>>>>> had conversions of multiple types during the reporting period. This >>>>>> seems >>>>>> consistent with the hypothesis that ConversionTypeName is a segmenting >>>>>> field. >>>>>> >>>>>> About the zero-conversion lines, I realized that these only show up >>>>>> if you add certain other fields. If you take the last example, remove >>>>>> the >>>>>> predicate and add 'CostPerConversion': >>>>>> >>>>>> <reportDefinition xmlns=" >>>>>> https://adwords.google.com/api/adwords/cm/v201603";> >>>>>> <selector> >>>>>> <fields>CampaignId</fields> >>>>>> <fields>ConversionTypeName</fields> >>>>>> <fields>CostPerConversion</fields> >>>>>> <dateRange> >>>>>> <min>20150126</min> >>>>>> <max>20150201</max> >>>>>> </dateRange> >>>>>> </selector> >>>>>> <reportName>Test Report</reportName> >>>>>> <reportType>CAMPAIGN_PERFORMANCE_REPORT</reportType> >>>>>> <dateRangeType>CUSTOM_DATE</dateRangeType> >>>>>> <downloadFormat>CSV</downloadFormat> >>>>>> </reportDefinition> >>>>>> >>>>>> Now 226 lines are returned. The additional lines are all for >>>>>> conversion type "Other" and have zero conversions. >>>>>> It's a bit strange that this field is compatible with the >>>>>> "ConversionTypeName" field anyway, because the "Cost" field (which seems >>>>>> to >>>>>> be required to be able to calculate cost per conversion) is *not* >>>>>> compatible >>>>>> with "ConversionTypeName". >>>>>> >>>>>> To summarize: >>>>>> 1. Would you agree that "ConversionTypeName" is a segmenting field? >>>>>> (If so, the documentation should be updated.) >>>>>> 2. Why is "CostPerConversion" compatible with "ConversionTypeName" >>>>>> when "Cost" is not? And why does adding the "CostPerConversion" field >>>>>> result in the returned report having more lines (namely the "Other" >>>>>> ones)? >>>>>> >>>>>> Thanks and cheers, >>>>>> Dorian >>>>>> >>>>>> On Thursday, June 9, 2016 at 7:12:05 PM UTC+2, Umesh Dengale wrote: >>>>>>> >>>>>>> Hi Dorian, >>>>>>> >>>>>>> The ConversionTypeName >>>>>>> <https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report#conversiontypename> >>>>>>> field prevents >>>>>>> zero-conversions rows from being returned as you mentioned above. The >>>>>>> ConversionTypeName is field of type *attribute* and not a *segment* >>>>>>> type. >>>>>>> It may happen that you might be using some other segment field in the >>>>>>> report selector. If you getting records for ConversionCategoryName >>>>>>> <https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report#conversioncategoryname> >>>>>>> (Other) >>>>>>> for zero conversions then provide me *privately* the report query >>>>>>> and clientCustomerId. Just click *Reply privately to author* in the >>>>>>> forum when responding. >>>>>>> >>>>>>> Thanks, >>>>>>> Umesh, AdWords API Team. >>>>>>> >>>>>> -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/91cb5cc9-0ff4-4114-8b7e-eb87c81c7c8c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
