I attached an excel file for testing. On Friday, July 8, 2016 at 2:58:59 PM UTC-7, Li Tan wrote: > > Hello, > > > How to calculate the total Avg Position for a campaign during a given > period? > > > How to calculate the total Avg Position for campaign **XX GPP - Real > Estate - A? Thank you > > > Sample CSV Data: > > > CAMPAIGN_PERFORMANCE_REPORT (Jun 1, 2016-Jun 14, 2016) > > Customer ID Day Network Cost Clicks Impressions Avg. position Conversions > Campaign > ID Campaign Budget > > xxxxxxxxxxx 2016-06-01 Search Network 18160000 17 260 4.1 1 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-02 Display Network 3190000 3 1060 1 0 280171157 **XX > GPP - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-07 Search Network 24320000 24 232 3.8 0 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-08 Search Network 18160000 16 190 3.6 0 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-02 Search Network 19730000 16 203 3.7 1 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-08 Display Network 3400000 4 605 1 0 280171157 **XX > GPP - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-05 Search Network 26330000 22 318 3.2 0 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-10 Search Network 14710000 4 304 1.1 0 280251197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-05 Display Network 1800000 2 1274 1 0 280171157 **XX > GPP - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-09 Display Network 1360000 2 334 1 0 280171157 **XX > GPP - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-12 Display Network 3370000 4 890 1 0 280171157 **XX > GPP - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-06 Search Network 14010000 4 363 1.1 0 280251197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-13 Search Network 18990000 18 252 3.6 1 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-03 Search Network 31760000 25 212 3.7 0 280257197 **XX > GPP - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-01 Search Network 4070000 2 398 1.1 0 280251197 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-09 Search Network 53780000 11 304 1 0 280251197 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-10 Display Network 3540000 4 495 1 0 280171157 **XX > GPP - Real Estate - B 3000000 > > xxxxxxxxxxx 2016-06-14 Search Network 20880000 18 230 3.5 0 280257197 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-12 Search Network 20520000 17 148 3.3 0 280257197 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-01 Display Network 2070000 2 1551 1 0 280171157 **XX > GPP - Real Estate - B 3000000 > > xxxxxxxxxxx 2016-06-02 Search Network 15140000 4 374 1.1 0 280251197 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-03 Search Network 2140000 2 6 1.3 0 280256957 **XX > GPP - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-11 Search Network 26570000 53 429 2 0 280248797 **XX > GPP - Real Estate - B 40430000 > > xxxxxxxxxxx 2016-06-13 Search Network 3840000 3 10 1 0 280256957 **XX GPP > - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-14 Search Network 1480000 3 8 1 0 280257077 **XX GPP > - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-03 Search Network 18970000 26 3301 2.3 0 280250597 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-03 Search Network 27240000 52 485 2 0 280248797 **XX > GPP - Real Estate - B 40430000 > > xxxxxxxxxxx 2016-06-04 Search Network 30260000 41 2998 2.2 2 280250597 **XX > GPP - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-13 Search Network 14880000 24 4518 2.8 0 280250597 **XX > GPP - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-08 Search Network 760000 1 6 1 0 280257077 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-09 Search Network 20450000 8 97 1.1 0 280250717 **XX > GPP - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-12 Search Network 12110000 5 61 1.1 0 280250717 **XX > GPP - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-02 Search Network 1740000 1 11 1.2 0 280256957 **XX > GPP - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-01 Search Network 1550000 1 8 1.1 0 280256957 **XX > GPP - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-06 Search Network 28170000 50 431 2 0 280248797 **XX > GPP - Rentals - A 40430000 > > xxxxxxxxxxx 2016-06-02 Search Network 1790000 2 6 1 0 280257077 **XX GPP > - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-14 Search Network 28530000 38 4186 2.5 0 280250597 **XX > GPP - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-11 Search Network 820000 2 3 1 0 280257077 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-04 Search Network 0 0 4 1.5 0 280256957 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-10 Search Network 0 0 7 1 0 280256957 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-06 Search Network 0 0 7 1.3 0 280256957 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-01 Search Network 980000 2 4 1 0 280257077 **XX GPP - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-01 Search Network 14700000 7 55 1.1 0 280250717 **XX > GPP - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-09 Search Network 16130000 23 2866 2 0 280250597 **XX > GPP - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-10 Search Network 26680000 36 2853 2.1 0 280250597 **XX > GPP - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-12 Search Network 26840000 54 469 2.1 0 280248797 **XX > GPP - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-14 Search Network 2130000 1 2 1 0 280256837 **XX GPP > - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-13 Search Network 27750000 58 596 1.8 0 280248797 **XX > GPP - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-05 Search Network 1100000 1 11 1.4 0 280256957 **XX > GPP - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-07 Search Network 12150000 5 154 1.1 0 280250717 **XX > GPP - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-13 Search Network 7570000 5 81 1.1 0 280250717 **XX > GPP - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-10 Search Network 26990000 54 529 1.9 0 280248797 **XX > GPP - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-03 Search Network 26440000 9 124 1.1 0 280250717 **XX > GPP - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-05 Search Network 1620000 4 6 1 0 280257077 **XX GPP > - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-07 Search Network 2220000 1 5 1 0 280256957 **XX GPP > - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-10 Search Network 0 0 2 1 0 280257077 **XX GPP - > Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-09 Search Network 0 0 11 1.3 0 280256957 **XX > Remarketing 25000000 > > xxxxxxxxxxx 2016-06-11 Search Network 0 0 10 1.4 0 280256957 **XX > Remarketing 25000000 > > xxxxxxxxxxx 2016-06-02 Search Network 0 0 2 1 0 280256837 **XX Remarketing > 75000000 > > xxxxxxxxxxx 2016-06-13 Search Network 0 0 7 1 0 280257077 **XX Remarketing > 25000000 > > xxxxxxxxxxx 2016-06-13 Search Network 0 0 1 1 0 280256837 **XX Remarketing > 75000000 > > xxxxxxxxxxx 2016-06-14 Search Network 29940000 10 523 1.1 0 280251197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-04 Search Network 14790000 13 170 3.6 0 280257197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-12 Search Network 42400000 15 370 1.1 0 280251197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-07 Search Network 18200000 6 342 1.1 0 280251197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-10 Search Network 21290000 15 196 3.1 0 280257197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-03 Search Network 24840000 7 282 1.1 0 280251197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-11 Search Network 34040000 25 216 3 0 280257197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-13 Display Network 3970000 5 1192 1 0 280171157 **XX > Remarketing 3000000 > > xxxxxxxxxxx 2016-06-08 Search Network 4930000 2 322 1 0 280251197 **XX > Remarketing 75000000 > > xxxxxxxxxxx 2016-06-07 Display Network 3050000 3 1612 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-04 Search Network 20490000 5 317 1.1 0 280251197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-13 Search Network 0 0 369 1.1 0 280251197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-05 Search Network 19910000 7 326 1.1 0 280251197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-06 Search Network 28760000 26 269 3.8 0 280257197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-11 Search Network 17430000 6 338 1 0 280251197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-04 Display Network 850000 2 742 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-03 Display Network 3050000 3 852 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-11 Display Network 3070000 3 898 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-14 Display Network 860000 1 1355 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-06 Display Network 3270000 3 893 1 0 280171157 **XX > Sconset - Real Estate - A 3000000 > > xxxxxxxxxxx 2016-06-09 Search Network 9980000 8 163 3.9 0 280257197 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-02 Search Network 0 0 28 1 0 280250717 **XX Sconset - > Real Estate - A 25000000 > > xxxxxxxxxxx 2016-06-07 Search Network 19650000 28 4065 2.1 2 280250597 **XX > Sconset - Real Estate - A 75000000 > > xxxxxxxxxxx 2016-06-02 Search Network 25510000 35 4253 2.1 0 280250597 **XX > Sconset - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-06 Search Network 9750000 2 160 1.1 0 280250717 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-07 Search Network 26690000 57 525 2 0 280248797 **XX > Sconset - Real Estate - B 40430000 > > xxxxxxxxxxx 2016-06-11 Search Network 19990000 8 81 1 0 280250717 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-11 Search Network 23890000 31 3130 2.4 2 280250597 **XX > Sconset - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-08 Search Network 19880000 27 3735 2.2 0 280250597 **XX > Sconset - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-10 Search Network 8580000 4 96 1.1 0 280250717 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-12 Search Network 16010000 5 12 1.1 0 280256957 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-05 Search Network 24660000 44 490 2.2 0 280248797 **XX > Sconset - Real Estate - B 40430000 > > xxxxxxxxxxx 2016-06-08 Search Network 3930000 3 130 1 0 280250717 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-09 Search Network 3800000 1 1 1 0 280256837 **XX > Sconset - Real Estate - B 75000000 > > xxxxxxxxxxx 2016-06-12 Search Network 1840000 4 6 1 0 280257077 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-14 Search Network 1840000 2 11 1.4 0 280256957 **XX > Sconset - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-04 Search Network 0 0 27 1.2 0 280250717 **XX Sconset > - Real Estate - B 25000000 > > xxxxxxxxxxx 2016-06-12 Search Network 0 0 1 1 0 280256837 **XX Sconset - > Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-04 Search Network 0 0 2 1 0 280257077 **XX Sconset - > Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-01 Search Network 12010000 18 4503 2.2 0 280250597 **XX > Sconset - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-09 Search Network 26890000 51 485 1.9 0 280248797 **XX > Sconset - Rentals - A 40430000 > > xxxxxxxxxxx 2016-06-01 Search Network 27440000 58 537 2.1 0 280248797 **XX > Sconset - Rentals - A 40430000 > > xxxxxxxxxxx 2016-06-08 Search Network 4660000 2 3 1 0 280256837 **XX > Sconset - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-07 Search Network 610000 2 5 1 0 280257077 **XX > Sconset - Rentals - A 25000000 > > xxxxxxxxxxx 2016-06-01 Search Network 4260000 1 3 1 0 280256837 **XX > Sconset - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-04 Search Network 26570000 56 443 2.1 1 280248797 **XX > Sconset - Rentals - A 40430000 > > xxxxxxxxxxx 2016-06-12 Search Network 20820000 28 2524 2.7 1 280250597 **XX > Sconset - Rentals - A 75000000 > > xxxxxxxxxxx 2016-06-14 Search Network 23740000 49 513 2 0 280248797 **XX > Sconset - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-03 Search Network 980000 2 4 1 0 280257077 **XX > Sconset - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-05 Search Network 7710000 5 205 1.1 0 280250717 **XX > Sconset - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-06 Search Network 13290000 23 4461 2.3 2 280250597 **XX > Sconset - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-08 Search Network 28190000 57 469 2 0 280248797 **XX > Sconset - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-09 Search Network 2420000 2 7 1 0 280257077 **XX > Sconset - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-05 Search Network 27390000 40 4531 2.1 0 280250597 **XX > Sconset - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-06 Search Network 2080000 4 9 1 0 280257077 **XX > Sconset - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-02 Search Network 21800000 40 492 2.2 0 280248797 **XX > Sconset - Rentals - B 40430000 > > xxxxxxxxxxx 2016-06-08 Search Network 3570000 2 8 1.3 0 280256957 **XX > Sconset - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-03 Search Network 1620000 1 2 1 0 280256837 **XX > Sconset - Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-14 Search Network 0 0 54 1.1 0 280250717 **XX Sconset > - Rentals - B 25000000 > > xxxxxxxxxxx 2016-06-06 Search Network 0 0 2 1 0 280256837 **XX Sconset - > Rentals - B 75000000 > > xxxxxxxxxxx 2016-06-04 Search Network 0 0 1 1 0 280256837 **XX Sconset - > Rentals - B 75000000 > > Total -- -- 1501080000 1648 82128 2 13 -- -- 143430000 > > > >
-- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/71902299-39ae-477a-8110-30318a48290c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
adwords-report-avg-position.xls
Description: MS-Excel spreadsheet
