Overview
This guide will walk you through the steps to connect Looker Studio (formerly Google Data Studio) to StatsDrone using our custom-built connector. This connector allows you to fetch and visualise your StatsDrone data directly within Looker Studio, making it easier to generate reports and gain insights from your affiliate marketing activities.
Step 1: Review the Connector Code
Before setting up the connector, we encourage you to review the connector’s code, which is available on GitHub. This transparency ensures you understand how your data is being accessed and processed.
GitHub Repository: StatsDrone Looker Connector
The code repository provides the full implementation of the connector, including how it handles authentication, data fetching, and error handling.
Step 2: Add the StatsDrone Data Source
To start using the StatsDrone connector in Looker Studio, follow these steps:
1. Open Looker Studio:
Go to Looker Studio and log in with your Google account.
2. Create a New Data Source:
In Looker Studio, click on the Create button in the top left corner and select Data source.
3. Search for “Build Your Own”:
In the list of connectors, search for and select "Build Your Own" which will allow you to add our community connector by its Deployment ID.
4. Enter the Deployment ID:
When prompted, enter the following Deployment ID to connect to our StatsDrone connector:
Deployment ID: AKfycbxVuhiWtKEz-q5xz4aIwDwvtiPuqPWN8kp7DVH9FWwzFH3Pd_sfh-0ZvgtA30PWvrKf
5. Authenticate and Configure:
The connector will ask for an API key and a start date. Enter your StatsDrone API key and specify the start date for fetching data (in YYYY-MM-DD format).
6. Connect and Build Reports:
Once connected, you can start building reports by selecting the metrics and dimensions you want to visualise. The connector supports various fields, including clicks, deposits, revenue, and more.
Step 3: Build Your Custom Reports
After connecting, you can begin creating custom dashboards and reports in Looker Studio using your StatsDrone data. The connector fetches both historical and real-time data, ensuring your reports are always up to date.
Key Features:
Historical Data Fetching: Automatically pulls all available data from the specified start date.
Rolling Window: Ensures data continuity by handling gaps in data retrieval.