SSB Query Templates
Representative SQL and DataFrame renderings for each of the 13 SSB queries. Every page also shows how to extract the exact query for a given platform and scale.
| Query | Name |
|---|---|
| Q1.1 | Revenue by Year |
| Q1.2 | Revenue by Year-Month |
| Q1.3 | Revenue by Week |
| Q2.1 | Revenue by Year/Brand (Category) |
| Q2.2 | Revenue by Year/Brand (Brand Range) |
| Q2.3 | Revenue by Year/Brand (Single Brand) |
| Q3.1 | Revenue by Nation/Year |
| Q3.2 | Revenue by City/Year (Nation) |
| Q3.3 | Revenue by City/Year (City Pairs) |
| Q3.4 | Revenue by City/Year-Month |
| Q4.1 | Profit by Year/Nation |
| Q4.2 | Profit by Year/Nation/Category |
| Q4.3 | Profit by Year/City/Brand |