I am looking for an excel expert to built and workbook that will automate and generate reports based on raw data and keywords.
I will provide an example with a mockup report to help visualizing the needs.
I have a workbook with multiple tabs:
* Raw Data
* List with SKUs
* List with terms (Brands)
* List with terms (Keywords)
This data is added manually, and using this we need to generate several reports. (Please look at the attached file)
Using the data from the exiting tabs we generate the following reports.
Report #1: Sku report AUTOMATION
I this report we use the "Raw Data" tab and the "List with SKUs" tab data.
The idea of this report is to display all the data available for each SKU.
To do this, we check the search terms form "Raw Data" column A. And this is compared with the list of SKU. If there is a match the data is added to the report.
Each SKU should report the total for all the possible matches.
SKUs with out matches within the "Raw Data" tab don't need to be reported.
For each of the brands and keywords tabs, need new to create a new tab called with the "brand" or "keyword" and report all the search terms that contain the "brand" or "keyword"
If you look at the example attached will be easier to understand what need to be done.
The tab with the RAW data and SKU could contain 100k+ rows on a real report.
If you are interested in the task i will be able to provide further details and answer all your questions.