Adding custom dimension or metric - I keep failing

Hi there,

 

so where do I start. 

Client wants to build out a table showing one landing page, query and positions. That's no issue as I can create a filter for the landing page and get all the queries from one page path. The problem is that positions is not there. 

 

The main issue is that I have 2 data sources for the google search console, while one has the landing page dimension, it misses the position or average position metric. While the other has the average position but missing the dimension of the landing page.

So I wanted to try create a custom position metric by going to the following:

 

1. Clicking on the resources tab
2. Manage Added Data Source
3. Clicking on the GSC that is missing "Average position"
4.  Click Add a Field
5. Click Add Calculated Field
6. Give it a name under "Position"
7. I put in different type of formulas and each give me a red code back such as the following:

AVG(average_position) or average_position

So yeah, none of these work. And I don't know what to do. 

 

0 0 574