Analytics
3K members online now
3K members online now
Learn how to set up goals and Ecommerce tracking, verify accuracy of attribution traffic sources, and discuss funnel visualization, Multi-Channel Funnels, the Goal Flow Report, and Enhanced Ecommerce
 
Guide Me
star_border
Reply

Tables that contain Organic Searches

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I need to know underlying tables that contain Organic Search sessions to design a report using Power BI.

 

From GA Web platform, i selected 'Organic Search' as a Channel under All Traffic. Now it display Sessions per week/month/day.

 

Now, need to get this same report in Power BI. When i connect to GA, it gives list of tables. I tried Organic Searches columns in Traffic Sources table, Sessions column in Session table etc., but counts are not matching from what i see in the GA web platform (as an example, i checked on date basis).

 

So, which tables contains the Organic Sessions?

 

 

 

1 Expert replyverified_user

Re: Tables that contain Organic Searches

Top Contributor
# 2
Top Contributor
Hi Khanna,

I assume that you're accessing Google Analytics from your BI system via Google Analytics API. If so, you may check the relevant API expressions in the Google Analytics Query Explorer [1]. For sessions with organic traffic only, you have to use the segment sessions::condition::ga:medium==organic

Christoph

[1] https://ga-dev-tools.appspot.com/query-explorer/

Re: Tables that contain Organic Searches

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
HI Christoph,

I do not use API Link from Power BI. First it ask to connect to my Google Account, then this shows list of tables with columns. For example. i can see a table 'Channel Grouping', within that i can see a column 'Default Channel Grouping' which take values like Organic, Email, Display etc. And there is another table 'Session', i have taken column 'Sessions'.And from 3rd table Time, i have included column Date. Now created a Table Report, showing only Organic (filtered) showing Session for last one year.

Now, when i compare Session (value) with what was shown on GA Web on 31-12-2015, count is lesser in my Power BI Report. I would expect Session value to be same whether i access report from underlying tables (through Power BI) or directly seen on GA Web. Could you please let me know what is going wrong?

Re: Tables that contain Organic Searches

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Hi, could anyone please get back on this?

Re: Tables that contain Organic Searches

Top Contributor
# 5
Top Contributor
Hi Khanna,

do you mean Microsoft Power BI [1]? As third-party tool, almost certainly it uses Google Analytics API to get access to Analytics under the hood. In any case, data should match. Are you sure that you're accessing the web data exactly the way you're requesting it from your BI tool? Set up a custom report in web GA with 'date' as dimension and 'sessions' as metrics using a filter

Include "Default Channel Grouping" exact "Organic Search"

Then, do the corresponding set up in your BI tool.

Christoph

[1] https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-google-analytics/

Re: Tables that contain Organic Searches

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭
Dear Christoph,

Thanks for your response.

The data what is accessed through API and shown using MS Power BI is not matching. I have taken screenshots as below.

GA through MS Power BI -> http://www.screencast.com/t/sR0gaxTFTNsI
Top shows list of tables and columns I selected. Bottom shows data as '385' sessions on 1st Jan 2015. I have filtered 'Organic Search' for Default Channel Grouping.

GA Web -> http://www.screencast.com/t/tS4ptHKIYyus
Applies same filter on GA Web, on 1st Jan 2015 it shows as 307 issues. (while Power BI shows as 385 sessions)

GA Custom Report -> http://www.screencast.com/t/7MrDWTgT
I have created Custom Reports as advised by you. This report shows as 307 issues only.

Now, question is why API link shows as 385 sessions?. Is there any filter to be applied when getting number of sessions through BI tool?

I need to get this issue fixed soon.

Regards,
Khanna

Re: Tables that contain Organic Searches

Top Contributor
# 7
Top Contributor
Hi Khanna,

Absolutely no idea how this arises. If reports access the same analytics view potential view filters would be the same. Apparently, no sampling issues involved. Do you see that behaviour in other Analytics Power BI reports, too?

Christoph

Re: Tables that contain Organic Searches

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭
Hi Christoph,

The data seen on GA Web might be a sampled data, how to verify that it is not sampled?

Regards,
Khanna

Re: Tables that contain Organic Searches

Top Contributor
# 9
Top Contributor
Sampling of GA data doesn't depend on the way data is accessed. I see in your "GA Web" screenshot that there is no sampling involved, i.e. no yellow message in the upper right of the report page.