TMR’s YouTube Analytics Connector easily extracts relevant metrics for you and creates client-specific channel reports directly from Google Sheets with encrypted security. Now, let’s understand how to connect your YouTube Analytics account with Google Sheets through TMR.
Step 1: Install and Launch Two Minute Reports
Install Two Minute Reports if you have not done so already.
Sign in to your Google Sheets with the associated Gmail ID.
Go to Extensions > Add-ons > Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Once you’ve accepted the terms and conditions, click Allow for Two Minute Reports to manage and access your data.
Note: Allow access is mandatory for TMR to function and efficiently analyze your data.
Next, open your Google Sheets and go to Extensions > Two Minute Reports > Launch.
Once your TMR sidebar opens, you can connect your data sources and run queries.
Step 2: Create a new Connection to streamline YouTube accounts
| A Connection is a link between the data source and the Connector. For example, you must use the YouTube Analytics Connector to create a new Connection with your YouTube Analytics account to get data from YouTube Analytics. |
Step 1: Click Menu at the top left of the sidebar to navigate to the Connections section. Next, click Add to create a new Connection.
Step 2: The “Adding new connection” dialog box appears. Here, you can perform three key steps to organize your client’s YouTube Analytics accounts.
- Selecting the YouTube Analytics Connector
- Authentication
- Enabling respective accounts with YouTube Analytics Connector
Select YouTube Analytics Connector from the list of options. Next, authorize your Connection by specifying your login credentials.
Step 3: Once you’ve successfully authenticated, you’ll visualize a screen displaying your Account name, ID, Connection name, and Status, as shown below:
Step 4: Enable the toggle for the accounts for which you want to run queries. Please note that you cannot extract data from the disabled accounts.
| Once you’ve enabled the associated accounts, you can hit “Refresh Connections” to ensure the connected accounts are reflected in the TMR sidebar. |
And that’s it. You can now extract YouTube Analytics KPIs in Google Sheets to gain actionable insights.
Step 3: Fetching YouTube Analytics data to Google Sheets
To pull YouTube Analytics performance data, you must create a new query by navigating to the Data Queries section.
Click Add and choose the respective YouTube accounts to analyze your channel performance. You can manage multiple clients’ YouTube accounts under one roof. Simply select one or more accounts to analyze and gather channel insights.
Alternatively, navigate to the Clients section. Add your client and map their corresponding YouTube Analytics account.
Click on “Manage Clients” and map the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
Note: To save time, you can add multiple clients and map their respective ad accounts. You can get a unified view of your client campaigns and track critical metrics in a centralized dashboard. For further information, please read our guide – How to Create Queries Using Clients?
Next, add the YouTube Analytics metrics and dimensions you want to analyze. Once done, select the date range for which you want to analyze channel performance.
Next, you have to configure your data reporting by choosing how to customize it.
It would be best to customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the necessary information.
Once you finish the above steps, click Run Query to visualize the output.
Now, you can use different Google Sheet features, such as pivot table and VLOOKUP(), to extract critical insights and build charts to visualize your YouTube channel performance.
Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action.
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ Schedule Refresh feature has further capabilities. Continue reading about this feature: “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. If you have any questions, please get in touch with our support team via chat or support@twominutereports.com.