Spreadsheet
1. Access the entire Users dataset
Simply navigate to the Users tab in the Google Sheet.
2. Pull all data, for just the Acquisition Source field from the Users dataset
All data is displayed once we navigate to the Users tab in our Google Sheet.
3. What are the different ways users get acquired?
After giving it a shot on your own, here's our approach to solving this problem with the Remove Duplicates feature.
4. Pull all data, for the Payment Amount and Payment ID fields from the Payments dataset
All data is displayed once we navigate to the Payments tab in our Google Sheet.
5. In which countries do we have users with deleted accounts?
After giving it a shot on your own, here's our approach to solving this problem with the Remove Duplicates feature.
Database and SQL
-- 1. Access the entire Users dataset
-- 2. Pull all data, for just the Acquisition Source field from the Users dataset
-- 3. What are the different ways users get acquired?
-- 4. Pull all data, for the Payment Amount and Payment ID fields from the Payments dataset
-- 5. In which countries do we have users with deleted accounts?
-- 1. Access the entire Users dataset
SELECT *
FROM getting_started.users
;
-- 2. Pull all data, for just the Acquisition Source field from the Users dataset
SELECT acquisition_source
FROM getting_started.users
;
-- 3. What are the different ways users get acquired?
SELECT DISTINCT acquisition_source
FROM getting_started.users
;
-- 4. Pull all data, for the Payment Amount and Payment ID fields from the Payments dataset
SELECT
payment_amount
, payment_id
FROM getting_started.payments
;
-- 5. In which countries do we have users with deleted accounts?
SELECT DISTINCT
country
, user_deleted
FROM getting_started.payments
;
BI Software
1. Access the entire Users dataset
Your result should look like the table below. After giving it a shot on your own, here's our approach.
2. Pull all data, for just the Acquisition Source field from the Users dataset
Looker is primarily used to aggregate data (count, sum, average, ...). In contrast to pulling an entire dataset. So, for this reason you have to include a unique field (User ID) to see an entire row that's not unique (Acquisition Source). Your result should look like the table below. After giving it a shot on your own, here's our approach.
3. What are the different ways users get acquired?
Your result should look like the table below. After giving it a shot on your own, here's our approach.
4. Pull all data, for the Payment Amount and Payment ID fields from the Payments dataset
Your result should look like the table below. After giving it a shot on your own, here's our approach.
5. In which countries do we have users with deleted accounts?
Your result should look like the table below. After giving it a shot on your own, here's our approach.