We have given unprecedented data access to our users - first through downloading CSV files in-app, and now via a Looker Studio Connector.
The steps to set up your custom report
We show details below; scroll to view all steps in sequence, click the link to jump to any step directly!
[Optional] Filter out unwanted data
[Optional] Make your dashboard Public
FAQ
Details for each step
2. Access the FluentPet Data Connector (authorizes w/ your app account)
In the top left, click "+". then select Data Source.
In the connectors list, search for (and select) "FluentPet Button Events" Data Source.
Authorize with your FluentPet App account information (2X), and click "Connect"
Note: if you are already authorized, you will see a (long) list of fields
Go back to Looker Studio homepage
3. Add an "Extract Data" data source (caches data for fast loading, allows you to make it public)
In the top left, click "+". then select Data Source.
In the connectors list, search for (and select) Extract Data.
Select as a data source âFluentPet Mobile Activity Appâ. (Authorize if needed.). Sometimes it takes about 5 minutes for the âFluentPet Mobile Activity Appâ. connector to appear.
[Figure 1, below] Select the dimensions to extract by dragging them from the Available Fields list onto the Dimensions targets, or by clicking Add.
Select Dimensions (these are necessary to get our Demo running, but you can select more if needed) :
All Buttons
Breed
Button 1
Button 1 Normalised word
Interactions Started At Local
Is Human
Learners In Household
Name
Species
Name your new data source
[Figure 2, below] In the bottom right corner, enable Automatic Update, select "daily"
In the bottom right click âSave and extractâ
Figure 1
Figure 2
4. Make your own copy of the dashboard and connect it to your data source
Open our example dashboard.
Click the 3 dots in the top right corner.
Then âMake a copyâ.
It will ask you for three new data sources -as the first one, select the "extracted" one created in the previous steps. Don't select anything for the other two. Sometimes the "extracted data source" takes about 5 minutes to be available.
Your report should now be up and running!
5. Customize your report
Enter Edit mode.
In the toolbar, click Theme and layout.
[Figure 3, below] At the top of the panel, click Customize.
Use the settings in the Edit theme panel to customize the theme.
You can choose background color, fonts, and text color.
Figure 3.
6. [Optional] Exclude household members or interactions with button presses
[Figure 4] In your extracted dataset, click "Add Filter"
[Figure 5] To filter by name, select "Exclude", field "Name", Contains your Household member.
[Figure 5] To filter all events with a button press you want excluded, select "Exclude", field name "All Buttons", Contains your button text.
There are advanced ways to do this, but this is the simplest
Figure 4
Figure 5
7. Make your report public (optional)
Navigate to your report
Move your mouse cursor to the top right corner of the web view; this should unveil a "Share" button
Click the "Share" button to show the "Share with people and groups" dialog
[Figure 6] In the "link settings" dropdown, select "Public" and "Viewer" (default)
Click "Save"
Figure 6
Frequently Asked Questions
Can I add custom fields that I want to show in my dashboard, e.g. "usage context" and "notes"?
Yes, you can add to the Extracted Dataset all the fields available. You can do so when setting up your dashboard or later, by going to:
Looker Studio > Owned by Me > Data Sources > The name of your Extracted Datasource > Edit Connection
Troubleshooting
My dashboard stopped updating
My extracted dataset shows invalid dimensions (red) on all fields
It's possible that you need to authorize again the original data source. Please follow the instructions on the video.