This guide gives instructions on how to connect Vkontakte Public Data with Google Sheets, Data Studio, and Microsoft Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.
Before you begin
The Supermetrics Vkontakte Public Data data source doesn't need you to log in to a specific account. Therefore, no access requirements are needed for this data source.
Data protection agreement
If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.
Query types
- Vkontakte posts - returns metadata on the public post that matches the search keyword given, as well as counts of basic things like the number of comments, likes, etc.
- Vkontakte user data - returns public username and metadata about users like number of friends, number of videos, number of photos from their account.
Instructions
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
- Open a new Google Sheets file.
- Click Add-ons → Supermetrics → Launch to open the sidebar.
- Under Data source, select the data source.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert Keywords or User IDs.
- Depending on the query type you choose, there will be additional options (Number of posts, Translate to).
- Open the Supermetrics data source gallery.
- Navigate to the data source and click Try.
- Click Authorize to authorize Supermetrics in Data Studio.
*If you're authenticating the data source for the first time, log in with the Google account you use with Supermetrics. Click Allow.* - Click Authorize to log in to the data source.
- Under Timezone, select the timezone.
- Query type, select the query type.
- Depending on the query type you choose, there will be additional options (Number of posts, Translate to).
- Click Connect on the top right-hand side.
- This will open a full list of fields available in this connector. You can skip this list.
- Click Create report.
- Click Add to report to complete the authentication steps.
Before you can authenticate Semrush Analytics in Excel, you need to
install the Supermetrics add-on.
- Open an Excel file.
- Click Data → Show Supermetrics
- Under Data source, select the data source.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert Keywords or User IDs.
- Depending on the query type you choose, there will be additional options (Number of posts, Translate to).
Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up Data warehouse and cloud storage (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up Supermetrics API