Reg:Search Impression Share in v201402

[bhargava gudlavalleti]

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 

[Josh Radcliff (AdWords API Team)]

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 1	Day 2	Day 3	Day 4
Impressions received	5	3	6	1
Eligible impressions	10	30	8	50
Search Impression Share	50.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

[Jahanger Gull]

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

[Josh Radcliff (AdWords API Team)]

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

[Jahanger Gull]

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.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@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.

For more options, visit https://groups.google.com/d/optout.

[Josh Radcliff (AdWords API Team)]

Hi,

For Search Impression Share, the formula (per the report field notes) is:

The impressions you’ve received on the Search Network divided by the estimated number of impressions you were eligible to receive.

Therefore, if you use Impressions where AdNetworkType1 = SEARCH for the impressions you've received (IS in your formula), then your formula looks correct to me.

For AveragePosition, you won't be able to calculate that using daily totals because all of the inputs to that formula are not available in API (or user interface) reports.

[Jahanger Gull]

Search Impressions: 

yes doing the same thing and so far results are getting match.

Average Position:

ok, will pull this data directly from Google Adwords.

Thanks, appreciate your help.

--

--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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...@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/37530f9b-aa79-4441-82fe-5588c4e3af1f%40googlegroups.com.