CrateJoy
What is Cratejoy Connector?
Cratejoy is a Looker Studio connector that helps to connect Looker Studio with CrateJoy and use it as a data source in Looker Studio.
CrateJoy turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.
What is Cratejoy ?
CrateJoy is home to hundreds of monthly subscription boxes for all hobbies, interests, and passions.
This CrateJoy review will focus on the consumers who can enjoy subscription boxes from several categories, including self-care, wellness, beauty, geek & gaming, art, etc.
How does it work?
Step 1: Choose “CrateJoy” connector by Jivrus Technologies from Google Looker Studio Partner Gallery.
Step 2: Click on the 'AUTHORIZE' button for authorizing your Google account.
Step 3: Once you are authorized to google account, then you need to authorize for third-party service. In this case, CrateJoy.
Step 4: Enter your CrateJoy username and password to authorize your CrateJoy account.
Step 5: Enter Client ID as the username and Client Secret as the password.
How to get Client ID and Client Secret
Go to your Cratejoy dashboard at https://my.cratejoy.com/, and select the Platform Settings option from the left sidebar.
And select API from the Platform Setting dropdown list.
You will see API Credentials there. Generate new credentials or use existing one for authorizing with connector.
Step 6: Choose the Object you want to use.
Step 7: Click on the 'Connect' button.
Step 8: The available fields from the Object are listed.
Step 9: Use this as a data source and continue normally with designing your report in Looker Studio.
Step 10: Click on the 'Create Report' button.
Step 11: You can customize the dashboard as you want.
CrateJoy - Looker Studio Dashboard
An example of a dashboard created in Looker Studio with CrateJoy Data Connector.
CrateJoy_-Dashboard_report-_by_Jivrus_Technologies.pdf