You can use your Rubii custom reports as a data source in Google Looker Studio, so you can chart your campaign data there without exporting and importing files. You connect them with a token from the Data Sources page in Rubii, then add the Rubii connector in Looker Studio.
What is the Rubii Looker Studio connector?
The Rubii Looker Studio connector links your custom reports from Rubii directly into Google Looker Studio. There's nothing to switch on in the report itself: once a report has run successfully and returned data, you can pick it as a data source in Looker Studio and analyse it alongside your other data.
Connect Rubii to Google Looker Studio
- In a new browser tab, go to the Data Sources page in Rubii: https://app.rubii.io/account/datasources.
- Find the Looker Studio card in the Ad Serving & Analytics category, or type "Looker" in the search box at the top of the page.
- Click the Looker Studio card. A dialog opens with your token already filled in.
- Copy the token. You'll need it to sign in to the connector in Looker Studio.
- Go to Google Looker Studio at lookerstudio.google.com.
- Click + Create in the left navigation, then select Report.
- In the Add data to report window, go to the Connect to Data tab.
- Search for "Rubii" and select the Rubii Custom Reports connector.
- When asked for your credentials, enter the email address you use to sign in to Rubii as the username, and paste the token you copied from Rubii.
- Click Next or Authenticate (the button text may vary).
- Select the Rubii custom report you want to use from the dropdown, then click Add.
The dimensions and metrics from your report now appear in the Looker Studio data panel. Drag them onto the canvas to build charts and tables.
Note: The Data Sources page isn't available to external users.
If your report isn't listed in Looker Studio
Only reports that have had a successful run that returned data appear in Looker Studio. A report that has never run, or whose run finished with no data, won't be listed. Run the report over a date range and with filters that return results, then check again.
Keep your Looker Studio data up to date
Looker Studio reads the data from your report's latest run. It doesn't query Rubii live. Looker Studio's own date range control only filters the data from that run and can't add newer data.
To keep the data current, schedule the report to run daily and set the schedule's end date in the future. If you use the Life Time date range, you need both settings for the data to update. Expect the data to be about a day behind.
Build ratio metrics in Looker Studio
Rubii's ratio metrics, such as CTR, CPM, conversion rate, ROAS and frequency, are calculated for each row of the report. If Looker Studio sums or averages them across rows, the totals won't match Rubii's figures.
Instead, add the underlying metrics, such as spend, impressions, clicks and conversions, and build the ratio as a calculated field in Looker Studio. For example, calculate CPM as SUM(Spend) / SUM(Impressions) * 1000.