Functionality

---

Our application support reading a CSV file that contains keywords separated by a comma. Then analyze the google search and return:

• Total links on the search page
• Total advertises on the search page
• Total results with the keyword
• HTML of the page (You also can preview it)

Versioning

---

We use the following library with version:

• Ruby - 3.0.0
• Rails - 7.0.3
• psql (PostgreSQL) - 14.5

Setup and run application

---

1. Clone project: git clone https://github.com/sanG-github/Search-Analytics.git
2. Install Gem: bundle install
3. Using your credentials with the example: .env.example
   1. With JWT_SECRET_KEY, generated by bin/rails secret
4. Setup database: bin/rails db:create db:migrate
5. Precompile: rake assets:precompile
6. Run server: rails server
7. Run sidekiq: bundle exec sidekiq

Database design

---

• users store information of the user
• attachments store the name and contents of the file after removing duplicate keyword
• results store the necessary datas (like the numbers)
• source_codes store source code of the Advertisement, Links, and HTML code of the Google search page. That needs to be separated because it contains large data.

About index, please take a look at the db/schema.rb