Hello, I am trying to write a script that will alert me when a shoppingcart (conv.value) of today is significantly bigger than the average shoppingcart during the last year. To give you an example of what its for : A customer sells shirts and usually not too many of them, one day a local sportsclub buys shirts for all their teams, a total of e.g. 100. The Bidmanagement software is now incorrectly going to raise the CPC over the next couple of months, because a big conversion has taken place, and it expects this to happen again. The script should notify me each day, if significatly high conv.values are found.
The problem that I have is that I can't seem to pull the Data form two seperate shopping_performance_reports and compare them. Either i get undefined values for conv.values or the adgroups that the report is at, dont match. I tried to set the second report like this, : var reportDay = AdsApp.report( "SELECT AccountDescriptiveName, CampaignName, AdGroupName, AdGroupId, ValuePerConversion, Conversions " + "FROM SHOPPING_PERFORMANCE_REPORT " + "WHERE AdGroupId = '" +adGroupId+ "' " + "AND AccountDescriptiveName = '" +accountName+ "' " + "DURING TODAY"); hoping that "WHERE AdGroupId = '" +adGroupId+ "' " + would line the two reports up but it doesnt do the job. Any Help is greatly appreciated! Greetings, Jan -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/72acc47b-07c9-46ba-8211-cb540fe2a6bd%40googlegroups.com.
