Application of basic SQL using Google Analytics data
- How successful were campaigns in terms of total transactions.
- Average number of visits per user.
- Top 6 countries in terms of transaction revenue earned in a year.
- Customer Conversion Rate
- User Acquisition Source.
- Segregating Buyers into Repeat Buyers and New Buyers.
- Top products generating highest Revenue in a year.
- Number Of frequent customers region wise
- Frequently purchased products and their quantities city wise.
- Top Search keywords and their related Page Titles and Host Names