Trending February 2024 # How To Link Data Between Google Sheets # Suggested March 2024 # Top 7 Popular

You are reading the article How To Link Data Between Google Sheets updated in February 2024 on the website We hope that the information we have shared is helpful to you. If you find the content interesting and meaningful, please share it with your friends and continue to follow and support us for the latest updates. Suggested March 2024 How To Link Data Between Google Sheets

First, select the cell where you want the imported data to appear then type = followed by the name of the sheet you want to link to and the cell you want to link So in our case we’ll link the data in cell A1 from “Sheet2”:


That data will now appear in your first sheet.

If you prefer to pull a whole column, you can type your equivalent of the following:

={'Sheet2'!A1:A9} How to Link Data Using IMPORTRANGE

The “range string” is the name of the exact sheet you’re pulling data from (called “Sheet1,” “Sheet2,” etc. by default), followed by a ‘!’ and the range of cells you want to pull data from.

Here is the sheet we’ll be pulling data from:

Using QUERY to Import Data More Conditionally

IMPORTRANGE is fantastic for moving bulk data between sheets, but if you want to be more specific about what you want to import, then the Query function is probably what you’re looking for. This will search the source sheet for certain words or conditions you set, then pull corresponding data from the same row or column.

So for our example we’ll again pull data from the below sheet, but this time we’re going to grab only the “Units Sold” data from Germany.

To grab the data we want, we’ll need to type the following:

=QUERY( ImportRange( "1ByTut9xooZdPIBF55gzQ0Cdi04owDTtLVc_gPGtOKY0", "Sheet1!A1:O1000" ) , "select Col5 where Col2 = 'Germany'")

Here, the “ImportRange” data follows exactly the same syntax as before, but now we’re prefixing it with QUERY(, and afterwards we’re telling it to select column 5 (the “Units Sold” column) where the data in column 2 says “Germany”. So there are two “arguments” within the query – ImportRange and select ColX where ColY = 'Z'.

Robert Zak

Content Manager at Make Tech Easier. Enjoys Android, Windows, and tinkering with retro console emulation to breaking point.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

You're reading How To Link Data Between Google Sheets

How To Use Chatgpt In Google Sheets With Gpt For Sheets And Docs

There is absolutely no doubt that OpenAI’s uber-popular chatbot ChatGPT has taken over the digital world by storm since it was released to the public late last year. People have used ChatGPT for many text-based purposes, like creating their cover letters, and resumes, and even using it as a full-fledged language-translation tool.

Now, users have found a way to use the amazing text-generation capabilities in Google Sheets with the new GPT for Sheets and Docs extension. So, if you were looking for an in-depth guide on how you can use ChatGPT within Google Sheets using the GPT for Sheets and Docs extension, you have come to the right place.

What is GPT for Sheets and Docs Extension?

Now, if you are wondering what I am talking about, what this GPT for Sheets and Docs extension even is, or what is the use for ChatGPT within Google Sheets, just relax. We have explained each of these aspects and more in the following sections.

GPT for Sheets and Docs is essentially a free-to-use Chrome extension that allows users to integrate and use ChatGPT within Google Sheets and Docs to generate text content, manage sheets, translate content, and more. It is developed by a group of developers, cumulatively known as Talarian, and the extension is easily available to download on the Google Workspace Marketplace.

GPT for Sheets and Docs is designed to use OpenAI’s GPT API within Google Sheets and Docs to use various text-generation and management functions. With this, you can perform various complex tasks in Google Sheets such as summarizing content, extracting content, translating content, or using complex formulae without actually memorizing them!

While we will discuss the benefits of using GPT for Sheets and Docs in Google Sheets with examples in a later section, first let’s take a look at how you can get the extension installed.

How to Get GPT for Sheets and Docs for Google Sheets?

Getting the GPT for Sheets and Docs extension in Google Sheets is fairly easy. Simply follow the given steps below to download and install the extension in your Google Sheets account.

1. Open a Chromium-based web browser on your PC or laptop.

Note: Make sure your web browser is up to date.

2. Go to the Google Sheets page and log in with your Google account.

3. Next, create a new Sheet using the + button at the bottom right.

5. Take the cursor to the Add-ons option and select the Get add-ons option on the drop-down menu.

7. Hit the Install button and select your Google account that is associated with Google Sheets.

8. Allow GPT for Sheets and Docs the necessary permissions to work properly, and you are done with the installation.

So, it is that easy to get the GPT for Sheets and Docs extension in your Google Sheets account. However, we are not done yet!

How to Set Up GPT for Sheets and Docs in Google Sheets?

To actually use GPT for Sheets and Docs within Google Sheets, you will need to set it up with your OpenAI API key. So, follow the steps right below to generate your OpenAI API key and get the GPT for Sheets and Docs extension up and running for use.

1. Go to the OpenAI API keys page from this link and log in with your OpenAI account, if not already logged in. If you are a new user, you need to create an OpenAI account to generate your API key.

4. Now, OpenAI will generate a new secret API key for you to use.

Note: This API key will be viewable within your OpenAI account only once. If you lose this key, it needs to be re-generated.

5. Next, copy the secret API key and open the Google Sheet that you have already created.

7. Now, paste the copied OpenAI API key in the text field and press Enter.

8. Wait for the extension to verify the API key and then follow the on-screen instructions to set up the GPT for Sheets and Docs extension.

How to Access GPT for Sheets and Docs in Google Sheets?

So now that you have successfully installed and set up GPT for Sheets and Docs in Google Sheets, it is time to learn how you can access it when working in Sheets.

How to Use GPT for Sheets and Docs in Google Sheets?

For instance, in your Google Sheet document, you can select any cell and just type in the =GPT function to access all the ChatGPT functions that you can access within Sheets. These include functions like GPT_MAP, GPT_TAG, GPT_CODE, GPT_EDIT, and many more. Each of these functions comes with a short description of what it does. So, be sure to read them to choose the GPT function that will fulfill your current needs.

To provide a more clear picture of how you can use GPT for Sheets and Docs in Google Sheets, we have provided a few examples right below.

1. Generate Simple Text with ChatGPT in Google Sheets

The GPT for Sheets and Docs extension might take a few seconds to register the command and generate the appropriate textual content. However, as per our testing, it works completely as you would expect and generates relevant text content.

2. Translate Text with ChatGPT in Google Sheets

So, if we want to translate the above-generated sentence into German, we have to first mention the source (English) and the target (German) languages in random cells, In this case, we have put them in cells C5 and D5, respectively.

Now, with that in place, we can simply use the function =GPT_TRANSLATE (A1, D5, C5) and press Enter in a new cell (in this case, A3) to instantly translate the content of A1 into German.

3. Summarize Text with ChatGPT in Google Sheets

As an example, we made GPT for Sheets and Docs generate a 200-word article on global warming in cell A9 and summarized the content in cell A12. You can check out the result in the following screenshot.

4. Create Lists with ChatGPT in Google Sheets

5. Extract Data with ChatGPT in Google Sheets

Another cool thing that you can do with the power of ChatGPT within Google Sheets is to extract specific data from a text file. For this, you need to use the =GPT_EXTRACT function and specify the type of data – email IDs, contact numbers, country, or any other, to extract the same in a specified cell.

As an example, we generated a random introduction for John Doe with an email address in cell A30, specified the type of data (in this case, email) that we want to extract in cell A33, and used the function =GPT_EXTRACT (A30,A33) to extract the email address from the chunk of text in A30. It worked like a charm!


Can I use ChatGPT in Google Sheets?

Yes, you can integrate OpenAI’s GPT API into Google Sheets using the GPT for Sheets and Docs extension and use ChatGPT within Sheets to generate content, create lists, extract data, and do various other things using simple prompts.

Is GPT for Sheets and Docs free to use in Google Sheets?

GPT for Sheets and Docs is a free-to-use Chrome extension that allows users to use ChatGPT features within Google Sheets and Google Docs.

Which GPT model does GPT for Sheets and Docs use in Google Sheets?

According to the developers of GPT for Sheets and Docs, the default GPT model for all functions is set to GPT-3.5-Turbo. However, users can set other base models as well as GPT-4 (if they have access) as the default model for functions within Google Sheets and Docs.

Wrapping Up

Difference Between Data Type And Data Structure

Computer programming entirely revolves around data. It is data over which all the business logic gets implemented and it’s the flow of data which comprises the functionality of an application or project. Hence, it becomes critical to organize and store the data for its optimized use and perform effective programming with good data model.

From the surface, both data type and data structure appear to be the same thing, as both deal with the nature and organizing of data, but there is a big difference between the two. One describes the type and nature of data, while the other represents the collections in which that data can be stored.

In this article, we will highlight how a data type is different from a data structure. Let’s start with a basic overview of the two before getting into the differences.

What is Data Type?

The Data Type is the concept that defines the nature of the data or value assigned to a variable in programming. The data type is basically a classification of data. In computer programming, the data type helps the compiler to select a proper machine representation of data.

The implementation of data type is referred to as “abstract implementation“. This means, different programming languages provide the definition of a data type in different ways. The data type does not store any value, but it defines that which type of value can be stored in a variable. Some common data types include− int (integers), float (floating point), char (characters), etc.

What is Data Structure?

A Data Structure is the collection that holds data which can be manipulated and used in programming so that operations and algorithms can be more easily applied. Thus, a data structure is a group of data types. It is a collection of data on which certain types of operations can be executed.

The implementation of data structure is known as “concrete implementation”. It is because, the definition of a data structure is already defined by the programming language. Data structures have the ability to hold different types of data within a single object. Some operations and algorithms like pop, push, etc. are used to assign values to a data structure.

Data structures suffer from the problem of time complexity. Some common examples of data structures include− Tree, Queue, Linked List, etc.

Difference between Data Type and Data Structure

The following table highlights the important differences between a Data Type and a Data Structure −

Key Data Type Data Structure

Definition A data type represents the nature and type of data. All the data that belong to a common data type share some common properties. For example an integer data type describes every integer that the computers can handle. CoA data structure is the collection that holds data which can be manipulated and used in programming so that operations and algorithms can be more easily applied. For example, tree type data structures often allow for efficient searching algorithms.ntent

Implementation Data types are implemented in an abstract manner. Their definitions are provided by different languages in different ways. Data structures are implemented in a concrete manner. Their definition includes what type of data they are going to store and deal with.

Storage Data types don’t store the value of data; they represent only the type of data that is stored. Data structures hold the data along with their values. They occupy space in the main memory of the computer. Also, data structures can hold different types of data within one single object.

Assignment Data types represent the type of value that can be stored, so values can directly be assigned to the data type variables. In case of data structures, the data is assigned using some set of algorithms and operations like push, pop, etc.

Performance There is no issue of time complexity because data types deal only with the type and nature of data. Time complexity plays an important role in data structures because they deal with manipulation and execution of logic over data that it stored.


The most significant difference between a data type and a data structure is that a data type is the representation of nature and type of data, whereas a data structure is a collection that holds different types of data which can be manipulated and used in programming so that different programming logic and operations can be applied in an efficient manner.

How To Link Your Tiktok Account To Instagram

These days most of us have active profiles on multiple social apps. Connecting your other accounts is supported on apps such as TikTok, where you can also add your Instagram and YouTube. This post shows you how to do that so that you can bring more visitors to your Instagram and also cross-post with ease.

Tip: have you found a cool clip on Instagram? Learn how to repost on TikTok to share videos.

How to Connect Your TikTok to Instagram

Before we begin, we need to note one thing: while connecting your TikTok to your Instagram account is possible, you won’t be able to do it the other way around, meaning you can’t add your TikTok to the Instagram app. Instagram only lets you connect a Facebook or Meta account to it, so it’s a bit restrictive in that sense.

Secondly, you’ll need to use the TikTok app for Android or iOS to connect the two accounts, as the operation can’t be done from a PC. Follow the steps below to link your accounts.

Open the TikTok app and log in with your credentials (if you haven’t already).

Press the “Profile” button in the lower part of the display.

On your profile page, tap “Edit Profile” underneath your Followers/Following stats.

In the lower part of the display, you’ll notice the “Social” section. Here you can add your Instagram or YouTube account. Tap on Instagram.

You’ll be taken to a login screen where you’ll be asked to add your credentials for the Instagram account you want to link.

Good to know: if you linked your Instagram to your Facebook account, learn how to disconnect them should the need arise.

TikTok asks for permission to receive your Instagram profile information on the next screen. Press “Allow.”

Your Instagram account should be visible in the “Edit Profile” screen.

If you visit your profile, you’ll be able to view a small Instagram logo icon next to the “Add friends” button. Every user who has liked their Instagram account to their TikTok profile will receive this same logo on their profile (or the YouTube logo, if they opted only to link their YouTube account).

If you press the icon, you’ll be taken directly to the user’s Instagram profile. If the person has also linked their YouTube account, you’ll see a pop-up appear at the bottom that lets you tap on the profile you’re interested in.

Note: the Instagram or YouTube icons won’t be visible if you’re browsing TikTok profiles from your PC.

How to Disconnect Your TikTok from Your Instagram

If you decide you no longer want your TikTok to be linked to your Instagram, it’s easy to disconnect the two. Retrace steps #1 through #4 from the above section. Tap on Instagram, and you’ll see a pop-up notifying you that “Your Instagram link will be removed from your profile.” Tap “Confirm,” and the account will be removed from your profile. It’s that simple.

Tip: did you know that you can create Stories on TikTok as well? We show you how.

How to Post on TikTok and Instagram at the Same Time

Having your Instagram account on your TikTok profile may get you more followers on the Meta-owned app, but linking the two together also has another important benefit: cross-posting. You can automatically share your TikTok posts straight to Instagram. We show you how in the steps below.

New Video

If you just created a video, follow these steps to share your TikTok video to Instagram from the creation screen.

Open the TikTok app.

Tap the “+” button at the bottom to start shooting a new video.

Alternatively, upload a video from your gallery.

Once you have the video, press the red checkmark at the bottom.

If you’d like to edit the video, you can do so on the next screen.

Once you’re satisfied, press “Next.”

Look at the bottom of the display on the “Post” screen. You’ll notice multiple buttons underneath “Automatically share to.” Even if you can’t link your Facebook to TikTok, there’s an option to share automatically to the app as well as WhatsApp. The other two options are dedicated to Instagram.

Press the first option if you wish to send the video via Direct message or to transform it into a Reel or Story. The other button auto-creates a Story.

Once you’ve made your selection, tap on “Post.”

While your TikTok video is uploading, you’ll see a message at the top that says: “We’ll redirect you to Instagram to share your video.”

Once the TikTok finishes uploading, a pop-up will appear at the bottom, asking you to select how you want to share it on Instagram (if you selected the first Instagram button while in the TikTok “Post” screen). Alternatively, if you opted for the second button, it will directly generate an Instagram Story.

The Story or Reel will be automatically generated on Instagram.

The Instagram video will feature the TikTok watermark with the app’s logo and your account name.

Old Video

If you want to share an older TikTok video (which is already on your profile) to Instagram, following the instructions below:

Open the video in question in the TikTok app.

Press the three dots on the right.

Select “Stories,” “Instagram Direct” or simply “Instagram” from the options that appear at the bottom.

Opting for the last option will allow you to share the video as a Reel as well.

As above, the video will feature the TikTok watermark.

Tip: did you know that you can take notes on Instagram? Here’s how to use it in Direct messaging.

Frequently Asked Questions Can I link more than one Instagram account to my TikTok?

It’s not possible. Only one Instagram account can be linked to TikTok at a time. If you want to add another Instagram account, you’ll have to delete the existing one, then add the other one, as shown above.

Can I share a TikTok video to Instagram even if I haven’t linked the two accounts?

Yes! Press the three dots on the right side of ANY video and select one of the Instagram buttons from the options that appear. Note that these are available only in the mobile TikTok app and not via PC. On mobile, you can also share to apps like Facebook, Discord, Telegram, Snapchat, and Reddit. Some of these options also appear on PC. This applies to your videos as well as other people’s videos.

Image credit: Unsplash. All screenshots by Alexandra Arici

Alexandra Arici

Alexandra is passionate about mobile tech and can be often found fiddling with a smartphone from some obscure company. She kick-started her career in tech journalism in 2013, after working a few years as a middle-school teacher. Constantly driven by curiosity, Alexandra likes to know how things work and to share that knowledge with everyone.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Sign up for all newsletters.

By signing up, you agree to our Privacy Policy and European users agree to the data transfer policy. We will not share your data and you can unsubscribe at any time.

How To Install And Use Command Line Cheat Sheets On Ubuntu

Cheat is a command line primarily based on Python software that lets in system administrators to view and save helpful cheat sheets. It retrieves simple-text examples of a delegated command which will remind the user of alternatives, arguments, or commonplace makes use of. Cheat is used for “commands which you use frequently, however now not frequently sufficient to consider”

Installing Cheat

Before installing Cheat, we need to make sure that everything’s up to date on the system as shown in the below command –

$ sudo apt-get update && sudo apt-get upgrade

Installing Cheat is best done with the Python package manager Pip. To install pip, use the following command –

$ sudo apt-get install python-pip

To install cheat, use the following command –

$ sudo pip install cheat

The sample output should be like this –

Collecting cheat    Downloading chúng tôi (42kB)    Downloading docopt-0.6.2.tar.gz    Downloading chúng tôi (755kB) Installing collected packages: docopt, pygments, cheat    Running chúng tôi install for docopt ... done    Running chúng tôi install for cheat ... done Successfully installed cheat-2.1.24 docopt-0.6.2 pygments-2.1.3

To verify if the cheat is installed or not, use the following command –

$ cheat -v

The sample output should be like this –

cheat 2.1.24 Setting the Text Editor

we are able to pass on to create our personal cheat sheets, Cheat desires to know which textual content editor we would love to apply to edit sheets by means of chúng tôi set nano text editor, use the following command –

$ export EDITOR=/usr/bin/vim

We can confirm the above command was successful using the following command –

$ printenv EDITOR

The output should be like this –


To make this change persistent and permanent across all future shell sessions, you must add the environment variable declaration to your .bashrc file. This is one of several files that are run at the start of a bash shell session. To open bashrc file, use the following command –

$ nano ~/.bashrc

The sample output should be like this –

# ~/.bashrc: executed by bash(1) for non-login shells. # see /usr/share/doc/bash/examples/startup-files (in the package bash-doc) # for examples # If not running interactively, don't do anything case $- in    *i*) ;;      *) return;; esac export EDITOR=/usr/bin/vim # don't put duplicate lines or lines starting with space in the history. # See bash(1) for more options HISTCONTROL=ignoreboth # append to the history file, don't overwrite it shopt -s histappend # for setting history length see HISTSIZE and HISTFILESIZE in bash(1) HISTSIZE=1000

Then add the same export command as shown below

..................................................... # If not running interactively, don't do anything case $- in *i*) ;; *) return;; esac export EDITOR=/usr/bin/vim # don't put duplicate lines or lines starting with space in the history. # See bash(1) for more options HISTCONTROL=ignoreboth ...........................................

Save and exit the file.

Running Cheat

To run Cheat in its most basic form for tail command, use the following command –

$ cheat tail

The sample output should be like this –

# To show the last 10 lines of file tail file # To show the last N lines of file tail -n N file # To show the last lines of file starting with the Nth tail -n +N file # To show the last N bytes of file tail -c N file # To show the last 10 lines of file and to wait for file to grow tail -f file

To see the list of all existing cheats, use the following command –

$ cheat -l

The output should be like this –

7z /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/7z ab                     /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/ab apk                    /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/apk apparmor               /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/apparmor apt                   /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/apt apt-cache             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/apt-cache apt-get             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/apt-get aptitude             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/aptitude asciiart             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/asciiart asterisk             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/asterisk at                   /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/at awk                   /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/awk bash                /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/bash bower                /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/bower chmod                /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/chmod chown                 /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/chown convert             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/convert crontab             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/crontab csplit             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/csplit cups                 /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/cups curl                 /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/curl cut                /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/cut date                 /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/date dd                   /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/dd df                   /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/df dhclient             /usr/local/lib/python2.7/dist-packages/cheat/cheatsheets/dhclient .............................................................................................. Creating and Editing Cheat Sheets

To create a cheat sheet, use the following command –

$ cheat -e tutorialspoint

The above command tutorialspoint is a cheat sheet name. It will open a blank cheat sheet. Now add your cheats and save it.

Searching Cheat Sheets

To search cheat sheet, use the following command –

$ cheat -s tail

The above command is searching for tail command. The sample output should be like this –

asterisk:    # To print out the details of SIP accounts: dnf:    # To search package details for the given string dpkg:    # List all installed packages with versions and details hardware-info:    # Display all hardware details journalctl:    # Actively follow log (like tail -f) mdadm:    # See detailed array confiration/status    mdadm --detail /dev/md${M} p4:    # Print details related to Client and server configuration pacman: pip:    # Show details of a package tail:    tail file    tail -n N file    tail -n +N file    tail -c N file    tail -f file

That’s it. After this article, you will be able to understand – How To Install and Use Command Line Cheat Sheets on Ubuntu, we will come up with more Linux based tricks and tips. Keep reading!

4 Ways To Supercharge Your Google Analytics Data

Download our Free Resource – Google Analytics Fast Start – 10 mistakes to avoid

This guide in the Smart Insights ‘Fast Start’ series gives you a checklist of issues to review to improve your implementation.

Access the

Reap the benefits of Google Tag Manager

Most of the recommendations you’ll read about here utilize Google Tag Manager (GTM) to enhance your Google Analytics data. Tag Manager acts as a link between your site and your Google Analytics data, helping you to set up marketing tags and tracking without needing to write any code or use your development team’s resources.

If you want to learn more about Google Tag Manager then it’s well worth taking the free course from Google to understand how it works, and whether you can further enhance your marketing reports to reflect your objectives.

Measure on-page readership with scroll tracking

Tracking the readership of your articles and blog content can be a challenge without some additional setup in Google Analytics. Often, you’ll find that article pages have a very high bounce rate. That’s because the majority of article pages receive single-page visits, meaning users don’t visit any other page while on your site. The result is a lack of data on how people used your page – did they leave because they couldn’t find what they wanted, or were they able to complete what they needed to do?

Scroll tracking is a solution for this, and a must-have for any content-heavy site. This allows you to trigger Google Analytics events when users reach 25, 50, 75, or any other percentage of your choosing in terms of depth on your page. That means you’ll learn what percentage of users actually read an entire page, or at what point on the page they tend to drop off.

You’ll then need to set the following options:

Vertical Scroll Depths – I typically use 25, 50, 75, 90 and 100. Both 90 and 100 are in there as in many cases, users won’t scroll all the way to the very bottom – think about how deep your footer is, especially on mobile. 90% may be a more accurate representation of someone reading an entire article

Horizontal Scroll depths – You can also measure horizontal scrolls, though I rarely use this. Besides, if you’re building websites that go horizontally instead of vertical, you should probably stop!

All Pages or Some Pages – You may only want to apply scroll tracking to a certain subfolder like your blog, or set up multiple sets of scroll tracking with different depth percentages for different templates or areas of the site

Save your settings, publish your changes, and then use preview mode in Tag Manager to test it’s working. The debug console should show your scroll depth events being triggered under the Data Layer tab:

The next step is to set up your Google Analytics Tag using the following steps:

Choose Universal Analytics as the tag type

Name the Category Scroll Depth (include the section of the site if you’ve decided to limit this to a single subfolder rather than the entire site)

For the Action label, use the Page Path variable to pull in the page’s URL

For Label, use the Scroll Depth Threshold. You can add a % symbol after the variable (marked by double curly brackets) so the values you get in your Analytics reports will show as 25%, 50%, etc

Content groupings

You’ll be able to group your content into a logical structure and then analyze aggregated metrics for these groups as well as individual URLs.

If you use WordPress, then this is very easy to set up using Google Tag Manager and the Google Tag Manager for WordPress plugin.

First, set up the GTM plugin on your WordPress site and verify that the GTM container is appearing by using Google Tag Assistant. You may want to ask a developer to do this for you.

Post type



Post author name

Repeat these steps for the other groups:

Slot 2: Post Tags

Slot 3: Page Post Type

Slot 4: Post Author

Finally, the set up needs to be completed in Tag Manager.

Index 1: {{Post Category}}

Index 2: {{Post Tags}}

Index 3: {{Page Post Type}}

Index 4: {{Post Author}}

Track outbound links

Again, this is really easy to set up with Google Tag Manager:

Name your trigger “Outbound Link Trigger”

The next step is to connect the trigger to your Google Analytics Tag. Still, within Tag Manager, complete the following steps:

Choose Universal Analytics as the tag type

Add your Google Analytics Settings variable to the tracking ID

Choose Event in the Track Type field

Under Category, choose Outbound Link

Under Label, choose Page Path

Track Google My Business searches with UTM parameters

If you have one or more bricks and mortar locations, then you’ve likely set up each with their own Google My Business page, allowing you to appear in Google Maps and local search results. As a result of this, you may see a panel with information about your business appear in Google search results, including a “website” button, such as the one below:

You can also incorporate this traffic into your organic traffic by using “organic” as your campaign medium in your UTM parameter. For many, this makes sense as this traffic technically is organic, however alternatively you can choose any campaign medium of your choice. Just be aware that you may see this traffic listed as (other) in your channels report, which you can find out more about here.

Update the detailed information about How To Link Data Between Google Sheets on the website. We hope the article's content will meet your needs, and we will regularly update the information to provide you with the fastest and most accurate information. Have a great day!