Update v.2.0 has been released

Yandex Metrika
for Google Sheets

Get all the key data on your website traffic directly into online tables using simple formulas

Install the extension → Watch the video

What the extension can do

Basic data
no longer needs to be taken from Metrica

All work is based on formulas that will take data for you.

Any period between two dates

In all expansion formulas, the range for which data needs to be downloaded is taken from two table cells.

  • Specify the start date in one cell, for example 04.07.26
  • Specify the end date in another cell, for example 10.15.27
  • Receive data within the specified date range

Visitors by source

The extension allows you to get the number of visitors from all major traffic sources.

  • Organic and paid
  • Direct and referral
  • From instant messengers, newsletters, social networks and recommendation systems

Number of completed goals

Data on goal achievements is transmitted according to its number in Metrica.

  • When you call the function, the extension will ask you to specify the target number.
  • In Yandex.Metrica, go to the "Goals" section and copy the number of the desired goal.
  • There are no limits on the number of targets that can be withdrawn.

All data without robots

The number of visitors and completed goals is calculated without any robots. This functionality is already built into all features; it doesn't need to be enabled separately.

  • Get clean data without robots
  • No need to worry about forgetting to check a box somewhere in the settings.
  • If you have little robot traffic and you've always looked at data with robots, you won't notice a difference.

Missing features?

I understand that the functionality is currently limited, but I also didn't want to create a monster with a ton of features, most of which no one would use. So, please let me know what you personally miss. And if I get a lot of such emails, I'll add them.

  • Write letters or leave a review in the extension store
  • The Yandex.Metrica API has limitations, so you can't implement just anything.
  • I would be grateful for your feedback in any case.