VLOOKUP in a formula

[charl]

I am trying to run a comparison formula on a set of data from Google Adwords.


In one worksheet, "adgroups_data" I have data relating specific to ad groups over a 90 day period, in another worksheet, "sqr_data" I have the specific keyword data with all of the accompanying data, including the matching Ad Group.


What I am trying to do is run a comparison of the average data for the adgroup and how it relates to the keyword.


As example:

If the Ad Group "Cheap" has an average CTR of 17% how do the search queries relating to that Ad Group stack up. Let's say I have the following keywords in that ad group:


cheap chairs

cheap tables

cheap floors

cheap gum

cheap cars


And each of these keywords have their own CTR, I want to compare the two CTR's


So to do this I need to compare the clicks and impressions data of the specific keywords and match it to the corresponding ad group's data. Considering that there are other ad groups with their own keywords and data.


Am I making sense? Have the feeling I need to draw a picture


Basically... how do I call a value that relates to the same data set in a formula using vlookup?

(adgroup_clicks – keyword_clicks)/(adgroup_imp – keyword_imp)

 

[srikandi2000]

Hi charl.


I think you should upload your workbook.


Regards

 

[charl]

I quickly made a dataset in Google Docs:


https://docs.google.com/spreadsheet/ccc?key=0AjOf1rWqZkz2dEVOQ3JrTWpIbU15VTA2c0I4a2txUGc

 

[Faseeh]

Hi charl,


.. on adgroup data:


For Click in cell B2:

=SUMIF(keyword_data!$B$2:$B$11,adgroup_data!A2,keyword_data!$C$2:$C$11) Drag Down


For Impression in Cell C2:

=SUMIF(keyword_data!$B$2:$B$11,adgroup_data!A2,keyword_data!$D$2:$D$11)

Drag Down


Regards,

 

[Guest]

    Summer said with a smile: ice jade,Brook, in fact, I want to meet you,norman, there are a few words want to say to you personally,york, then take a look at how you answer me