Categorisation of keywords

[mounasree]

Hello Guys!

I have an excel spreadsheet which contains a list of AdWords Keyword report. The report contains a sample of Campaigns, Ad Groups and Keywords from their Adwords campaign.

what I would like to achieve is, to Re-categorise keywords into the following Categories by use of excel formula :

• Mattresses
• Pillows
• Doonas & Quilts

Even though the report contains the very small sample. I would like to know the formulas/steps to use.

I thought my excel knowledge was okay, but I'm not really sure where to start with this - The logic behind it seems fairly straightforward but I am not even sure if this is achievable using excel so I thought I'd ask the experts!

I have attached a sample, which just contains the data for this problem.

Thank you

 

[vletm]

mounasree
Why did You send cvs-file instead of Excel-file?
What would be needed result - layout?

 

[mounasree]

mounasree
Why did You send cvs-file instead of Excel-file?
What would be needed result - layout?

hi there, sorry I have re-uploaded the file in excel. I want to know the formula to categorise the keywords to the above-given categories. it would be helpful if you can help with it. thank you

 

[Haz]

Something like this will give the categories you want
=IFERROR(CHOOSE(MATCH(0,SEARCH({"mattress","pillow","doona","quilt"},B2),-1),"Mattresses","Pillow","Doonas & Quilt","Doonas & Quilt"),"-")

 

[vletm]

mounasree
... as no answer to my questions

You wrote ... Even though the report contains the very small sample.

>> I won't use formulas >>
... I would only guess and so something ...

 

[mounasree]

mounasree
... as no answer to my questions

You wrote ... Even though the report contains the very small sample.

>> I won't use formulas >>
... I would only guess and so something ...

Hi There,

yes, it is a small sample. my intention behind this question is to know what formulas can be used to do the process. I know for small sample no need to use formulas can do it manually by find & filter option. Thank you for the response.

 

[mounasree]

Something like this will give the categories you want
=IFERROR(CHOOSE(MATCH(0,SEARCH({"mattress","pillow","doona","quilt"},B2),-1),"Mattresses","Pillow","Doonas & Quilt","Doonas & Quilt"),"-")

Hi Haz,

Thank you so much for the reply. it helped me.