1. What is the Google Analytics add-on and why should I care?
Google Analytics add-on is an extension for Google Sheets that enables you to make custom reports inside Sheets. The extra works by linking up to a current Analytics account, utilizing Google’s Analytics API and Regular Expressions to channel the information you need to pull, lastly assembling the information into a simple and natural organization that is ready for detailing.
The Add-On enables you to:
- Pull any information that you’d have the capacity to get to the Analytics API (i.e analytics.google.com) straightforwardly into a spreadsheet
- Effortlessly look at verifiable information crosswise over eras
- Channel and fragment your information
- Robotize normal detailing
- Make changes to existing reports to get new information (no more re-designing wheels!)
Step by step instructions to install and set up the Google Analytics add-on
Installing the add-on is simple.
Begin by opening another Google Sheet.
At that point, click on the “Add-ons” menu option at the top, and pick “get add-ons.”
Another window will fly up. Sort in “Google examination” into the search box at the upper right side, at that point press “Enter.”
There ought to be one evident add-on with the Google Analytics name and image. Click it, at that point press the “+free” button on the following window to introduce it.
The add-on ought to now be introduced for use with all your future sheets.
Click on the “add-ons” menu once more, and you ought to see another posting for “Google Analytics.”
How to create a custom report with Google Analytics add-on?
Reports can be made physically or with the assistance of the extra’s report creation instrument. To utilize the device, select “Additional items” > “Google Analytics” > “Make a New Report” from the menu bar. This will show a sidebar on the correct that enables you to effectively look into your Google Analytics account data and also pick what measurements and measurements to question. When you’re done, click the “Make Report” catch and your report data will show up in a sheet named “Report Configuration” (if the sheet doesn’t as of now exist, it will be made).
To make extra reports, simply rehash the means above. Each extra report you make will include another segment of information to one side of the past report.
In the event that you take a gander at the qualities the report creation apparatus goes into the report setup sheet, you’ll see that a significant number of the cells are left clear. This is deliberate. The apparatus is intended to help kick you off and furnish you with the data you won’t know off the highest point of your head. Whatever is left of the fields should be entered by you. In the event that you have any inquiries concerning what to put in each field, see the reference at the base of this page.
Running a report:
Presently backpedal to the “Additional items” menu, yet this time, click on “run reports.”
This will run every one of the reports you set up in the dynamic spreadsheet, however since we just have one, for the present, it’ll do only that one.
A few moments later, you’ll get an affirmation box, saying the report was run. What’s more, at the last, another tab will show up:
Click the tab, and you ought to see the information in the report, not surprisingly:
You can make the same number of reports as you’d like. The settings will all be put away in the primary tab. When you run your reports, you’ll get a tab for each report (you won’t get another tab if the report has as of now been keep running some time recently).
On the first “report setup” tab, your report settings will dependably be accessible to be altered.
You can change dates, include and expel measurements or measurements, and even include things like channels, which I’ll go into next.
To add more than one metric to a report, you’ll have to choose the metric box, put the cursor toward the end, and after that press “alt + enter” to make another line. At that point sort in the new metric not surprisingly.
Understand all the different options
We should experience every one of the fields in the principle report design tab, one by one. You have to comprehend what each of them does and how you can utilize them:
Report name – Just a fast note: on the off chance that you erase the name in this cell, the report won’t be run when you run your reports. This name will appear at the highest point of each report, however it will likewise be the mark of the report sheet at the base of your spreadsheet.
See (profile) ID – That’s the ID of your Analytics property that information is being pulled from. It will be pulled naturally when you make the report. In any case, you could copy reports for different locales by duplicate/gluing whatever remains of the cells and changing this esteem.
Begin date/End date – You can indicate the date extend that the information is pulled from.
Keep going N days – You can likewise indicate to simply pull information from the keep going “N” number of days, where N is any number you contribution to the cell. Take note of that you can utilize either this alternative or the begin/end date choice—not both.
Metrics – You can include different measurements for each report.
Dimension – You utilize these to fragment your movement to get measurements isolated for each sort of client. In any case, measurements should be good with the measurements in your report; else, they won’t work. In case you’re simply writing in measurements, go to that rundown of measurements, and select either a measurement or metric to see which ones are perfect.
Sort – You can set up the answer to consequently sort the results on the off chance that you end up sitting around idly doing that physically. You’ll need to physically include the metric or measurement here that you need to sort by (e.g., “ga:sessions”). You can sort backward by putting a short sign in front (e.g., “–ga:sessions”).
Channels – You can utilize channels to expel certain parts of your activity that you would prefer not to see. For instance, on the off chance that you would not like to incorporate referral movement in your report, you’d enter “ga:medium%3D%3Dreferral” in this crate.
Fragment – This is genuine portioning, enabling you to take a gander at a particular segment of information. To utilize this field, you’ll have to enter an esteem like “sessions::condition::ga:medium%3D%3Dreferral.”
Testing level – There are three worthy esteems here: “DEFAULT,” “Quicker,” or “HIGHER_PRECISION.” For most measurements, the default esteem (of “DEFAULT”) is fine. On the off chance that the report is taking too long, pick “Speedier” to yield precision for speed.
Begin record – If for reasons unknown you need to overlook the principal “X” results, you can do as such by indicating a begin list. For instance, in the event that you write in 5 here, the initial 4 results won’t be appeared.
Max results – You can pick the quantity of results to be returned in your reports, up to 10,000. Of course, you’ll get 1,000.
Spreadsheet URL – If you need your report information to be sent to an alternate spreadsheet for any reason (e.g., on the off chance that you have a sheet for a particular customer as of now), you can simply enter the URL of the record where the report ought to go.
Sparing time and having the capacity to make reliable reports from your investigation information are both vital things for marketers.
In the event that you make reports from Google Analytics all the time, you’ll likely profit by try this extra for Google Sheets attempt.
Once you’ve made a report, you can then make diagrams from the information or offer the information specifically with your customer (on the off chance that you don’t need them messing around in Google Analytics).