Uzii
Power Member
- Apr 9, 2018
- 562
- 166
Hey, I'm looking for a way to rank how commonly each word occurs in a column of an excel table. I'm using this to determine the most commonly occurring terms in my Amazon customer searches to specify my targeting further.
Basically, my current table looks like this:
I want to add a new table in on the side which will contain every word included in the phrases from "Customer Search Term" column and the number of times it occurs.
For example, one search might be "Black Hat World", another may be "Black Shoe World"
I'd like the table to return that Black occurred twice, World occurred twice, Hat occurred once, Shoe occurred once
If you can make the formula for this I will pay you $10 (in BTC, ETH, or USDT), if you can explain it to me with a short write up I'll pay an additional $5 ($15 total)
PM me and we can discuss, please do not PM me with a finished product before I agree.
Basically, my current table looks like this:
| Customer search term (phrase) | Keywords (words) | Match type (#) | Impressions (#) | Clicks (#) | CTR (#) | Spend(USD) (#) | CPC(USD) (#) | Orders (#) | Sales(USD) (#) | ACOS (#) | ROAS (#) | Conversion rate (#) |
I want to add a new table in on the side which will contain every word included in the phrases from "Customer Search Term" column and the number of times it occurs.
For example, one search might be "Black Hat World", another may be "Black Shoe World"
I'd like the table to return that Black occurred twice, World occurred twice, Hat occurred once, Shoe occurred once
If you can make the formula for this I will pay you $10 (in BTC, ETH, or USDT), if you can explain it to me with a short write up I'll pay an additional $5 ($15 total)
PM me and we can discuss, please do not PM me with a finished product before I agree.