URL specific values with Google Analytics connection

[cbock]

Hello SEO tools for Excel community,

I have got one question. I'd like to get URL specific values out of Google Analytics with SEO tools for Excel.

That means:

I've got a list of URLs and like to have the values sessions, transactions and revenue only for these URLs. (Please see screen attached. I'd like to fill the green cells)

Is this possible?
At the moment I'm only getting all URLs with these values out of Analytics.

Thanks and best regards
Chris

[diskborste]

Hi Chris,

Yes, you can use formula mode and change the input string to a cell reference. Then expand the formula to the cells below in the column with your inputs.

Are these URLs pages which are connected to your GA account? If so, then use the Profile ID:s as inputs.

[cbock]

Hey diskborste,

yes, the URLs are connected to my GA account.
How do i get to the formula mode. And can you give me an example of the formula I should fill into the cell?

I'm new to SEO tools for excel. So, I'm not that familiar with every function of the tool. Sorry.

Thanks and regards
Chris

[diskborste]

Hi Chris,

See my reply in this thread:

Google Analytics Function help requested

Hi, I am trying to use the google analytics plugin to pull GA Sessions for a specific url. I am able to login to GA and able to pull TOTAL GA Sessions but, cannot seem to figure out how to pull the sessions for a particular page. Can you please give me some direction. The specifc page is:[image] This formula successfully pulls the data for the entire site. Can you help me with the formula that would display GA sessions for just that page? =GoogleAnalytics("ga:110736641","ga:sessions,ga:bou…

You select the Formula mode and alter the formula to replace the string with a reference to the column with cells containing your URLs.

In the example below, I've looked at URLs containing the words spider, download, and connectors: