But there is a way out! Google Analytics capabilities provide the option of working with external tools. They allow you to automatically collect Analytics API data and generate reports in Excel tables. Moreover, all this can be uploaded to online Google Sheets documents. There is a special add-on for this, it is free and does all the necessary work for you.SEO specialistsIt is not without reason that they resort to this plugin, since it helps to qualitatively optimize the generation of reports.
Instructions for installing the plugin for report automationGoogle Analytics
First of all, you need to visit Google Drive through your Google Analytics account.
Then go to the sectionGoogle Sheetsand create a new document.
In the new table, in the upper right part, there is a button "Access settings". There you can connect Google Analytics. To do this, click "Add-ons" - "Install add-ons". Next, you need to select Google Analytics and the "free" button.
How to Automate Google Analytics Reporting with Google Sheets - image
Generating a report via Google Sheets
The data will start flowing into the page you created after chinese student contact list you click the "Create a new report" path. A form will open in front of you where you can:
give a name to the report;
indicate from which Google Analytics profile you need to pull data;
Specify the parameters to be monitored;
How to Automate Google Analytics Reporting with Google Sheets - 2 - image
After filling in all the data, a table should appear. To start collecting reports, simply click "Get reports". The report will appear in a new tab of your table.
How to Automate Google Analytics Reporting with Google Sheets - 3 - image
Moreover, you are given the opportunity to save a new report to compare it with the previous one. To do this, simply add a new column using ctrl+c and ctrl+v of the previous version of the report, changing the key values.
Setting up a panel for SEO
So, you have filled in the following table fields with data:
id representation
deadlines
number of last days
indicators and parameters
sorting
filters
segments
Now it's time to create a toolbar that will tell you how to quickly analyze key indicators.
SEO website promotionincludes different types of traffic, including organic. Therefore, to track it, pay attention to the "Total" line, formed by functions and calculations from other lines. Use the formula
=VLOOKUP(B$2, OrganicDesktop!$A$16:$D$27, 2, FALSE)
to scan organic queries from desktop computers. The same scheme works for "Mobile" and "Tablet".
Using the formula
=VLOOKUP(B$2, OrganicDesktop!$A$16:$D$27, 3, FALSE)+VLOOKUP(B$2, OrganicDesktop!$A$16:$D$27, 4, FALSE),
you can track the number of leads.
So, it is clear that the Google Sheets toolbar allows you to efficiently automate the process of collecting and comparing key data from Google Analytics.
