Thanks for the reply. Sorry i was unable to clear the exact requirement ...
*Search Impression Share:* I am caching the Google Adwords data of each day on local data base and then user can see that data over any date range. for e.g 1st April - 09 clicks - 20 Impressions 2nd April - 19 clicks - 200 Impressions Now if user want to see data from 1st April to 2nd April then from local data i will simply sum up clicks and impressions and make it display to user. 1st April to 2nd April - 28 Clicks - 220 Impressions But above sum/average does not work for searchImpShare, it could only be calculated if we have EligibleImpressions for each day, which i think is not available API, so my question is that is it ok to drive EligibleImpressions for each day with following formula and this will give us exact searchImpShare every time ? *searchImpShare = IS / Eligible Impressions* *Eligible Impressions = IS / searchImpShare* I have tested above formula over one of the Adwords Account and so far its looking good. *Average Position:* Now facing one more problem with Average Position as well ? How google is calculating Average Position at account level, campaign level for each day and over selected date range ? Avg Position 1st April Avg Position 2nd April Avg Position 1st to 2nd April Campaign 1 1.8 3.1 2.6 Campaign 2 2.4 4.1 2.7 Account Level 2.4 3.7 2.7 How goole is aggregating Average position over any selected date range ? As average(1.8+3.1) != 2.6 Thanks and really appreciate for your help. On Fri, May 8, 2015 at 10:18 AM, Josh Radcliff (AdWords API Team) < adwordsapiadvisor+j...@google.com> wrote: > Hi, > > You should be able to take the same approach I mentioned earlier, that is: > > 1. Run the report for the date range of interest and not include any > date-related fields. The results will contain the correct Search Impression > Share as calculated by AdWords, and should match what you see in the UI. > 2. To get daily Search Impression Share, run for the same date range but > include the *Date* field to segment results by date. > > I think that should work for your use case, but let me know if I missed > something. > > Thanks, > Josh, AdWords API Team > > > On Thursday, May 7, 2015 at 5:15:51 AM UTC-4, Jahanger Gull wrote: >> >> Hi >> >> i am working over caching the data so we can prepare reports quickly, now >> facing the same issue over displaying the search impression share, is there >> any way around to cache search impression share for each day and then make >> it calculate over any selected date range ? >> >> I have tried to get Eligible Impressions by =* Impressions/Impression >> Share* but still results are not getting match, is there any other way ? >> >> Thanks >> >> On Tuesday, June 3, 2014 at 2:24:57 AM UTC+12, Josh Radcliff (AdWords API >> Team) wrote: >>> >>> Hi Bhargava, >>> >>> *Search Impression Share* is calculated as: >>> >>> Impressions Received / Eligible Impressions >>> >>> Reports can give you *Impressions* (Impressions Received), but not Eligible >>> Impressions. Therefore, you cannot calculate this value yourself. For >>> example, assume you have the following results: >>> >>> Day 1Day 2Day 3Day 4Impressions received5361Eligible >>> impressions1030850Search >>> Impression Share50.00%10.00%75.00%2.00% >>> Calculating the Search Impression Share from these values, you get 15 >>> impressions received and 98 eligible impressions in total, which yields an >>> average of 15.31%. However, the *Eligible Impressions* values aren't >>> available from reports, so you cannot calculate this average. If you simply >>> average the *Search Impression Share* across the four days you'll get >>> 34.25%, which is incorrect. >>> >>> All is not lost, however -- you could simply run the report for the date >>> range of interest and not include any date-related fields. The results will >>> contain the correct *Search Impression Share* as calculated by AdWords, >>> and should match what you see in the UI. >>> >>> Cheers, >>> Josh, AdWords API Team >>> >>> On Friday, May 30, 2014 2:09:57 AM UTC-4, bhargava gudlavalleti wrote: >>>> >>>> Hi Team, >>>> >>>> I am using v201402 to fetch the data. >>>> I fetch Search Impression share for each date and when I calculate the >>>> average for 30 days the data is not matching with the data shown on Adwords >>>> interface. >>>> Please let me know how can I calculate SearchImpressionShare value for >>>> last 7/30 days using daily data. >>>> >>>> >>>> Thanks in advance >>>> Bhargava >>>> >>> -- > -- > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > 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 a topic in the > Google Groups "AdWords API Forum" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/adwords-api/wc8GTh8MIQA/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > adwords-api+unsubscr...@googlegroups.com. > Visit this group at http://groups.google.com/group/adwords-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/adwords-api/847f2901-17f4-4307-ad6f-a027133432cd%40googlegroups.com > <https://groups.google.com/d/msgid/adwords-api/847f2901-17f4-4307-ad6f-a027133432cd%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 http://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/CAJR0sFfwrJ8-QvMxTdyVMF9qZuPf%2BU7Wq2y6vFaaNeK24r2fWw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
