Setup page filter for GSC

Support
#1

I try to setup page filters to query GSC metric and don't know how to reference a cell correctly.

I'm doing it on the following way:

  1. Setup a domain, like https://example.com
  2. In the cell A2 i fill a unique URL part, like https://example.com/page1/
  3. Setup filter to get filter setting from B2
  4. Into B2 i write the filter setting page == https://example.com/page1/

If i now query the data, i get it correctly.

But: if i try to setup the filter in B2 like page == A2 i get only empty cells. Seems, my syntax of the cell reference is wrong.

How can i setup the cell reference in the filter? What is the correct syntax for this?

#2

In B2, try:
= "page == " & A2

1 Like
#3

Works! Many thanks!

#4

Trying the exact same formula for query and getting an error. Anything I'm doing wrong?

image
image295×723 13 KB

#5

It works with a reference using brackets like this inside the connector taskpane textboses:
[B4]

But I don't think it's possible to write partial range references. I would manually change the formula after inputting it to the sheet:
image

1 Like