Connections enable seamless data retrieval from your data sources, ensuring consistency—let’s get started with creating one for Looker Studio.
| 💡Terminologies used Connector: A Connector facilitates connectivity to a specific data source. For example, a Facebook Ads Connector provides connectivity to a Facebook Ads account. Connection: A Connection is a link between the data source and the Connector. For example, to get data from Google Ads, you must use the Google Ads Connector to create a Connection with your Google Ads account. |
Step 1: Visit the Gox – App Manage page and select the appropriate Connector based on your reporting needs as shown below.
For instance, let us consider Facebook Ads. Once you click the Facebook Ads Connector, a dialog box appears.
Here you can visualize a unified view — Connections, Accounts and Query Configs.
- Connections – Easily access the Connections you create directly via the “New Connection”.
- Accounts – View the list of accounts mapped under respective Connections.
- Query Configs – Helps you group a list of accounts from which you can fetch and visualize data in your Looker Studio dashboard.
| You can rename, re-authenticate and delete the connections by clicking the “three dots” on the right. |
Step 2: To create a Connection, click “New Connection”. The “Adding new Connection” dialog box appears. Specify your Connection’s name and authenticate by entering the login credentials.
Step 3: Once the authentication is done, you can visualize a centralized interface that displays the account name, ID, connection name, status, and Speedboost as shown below.
Step 4: You must enable the toggle for the accounts on which you want to run queries. Please note that the disabled accounts cannot fetch data or execute queries. This uncluttered approach makes your Looker Studio dashboard neat and organized, allowing you to perform data analysis efficiently.
| 💡Terminologies used Warm-up: The time when data is being fetched from the respective platform by Two Minute Reports. Periodic sync: Appending fresh data to retrieve the latest insights quickly. |
Step 5: The warm-up stage will automatically begin for the enabled accounts by default (as shown in the above screenshot).
For most connectors, you can extract and run queries during the warm-up stage. However, for the Amazon Ads Connector and Shopify Connector, you’ll need to wait until the warm-up stage is complete, which may take approximately 2 to 24 hours. TMR will email you once the warm-up is finished, allowing you to start running queries.
Note: The following terminologies indicate the Speedboost milestones you need to know to track your progress.
Speedboost milestone status
In-progress:
The small green dot indicates that the warm-up is about to begin. Once the warm-up completes, the ✅ sign appears, signaling the start of the periodic sync.
Completed:
Both the warm-up and the periodic sync is completed.
Errored:
The red caution mark indicates an error occurred while performing warm-up or periodic sync.
You have now created a new Connection in Looker Studio. This simplified process of creating and managing connections lays the foundation for diligently generating actionable insights.
That’s it! You are now ready for the next step: running queries to extract actionable insights in Looker Studio. Check out “How to create a report in Looker Studio” to get started.
We hope you found this guide helpful. If you have any questions, please contact our support team via support@twominutereports.com.