Analytics
4.7K members online now
Understand information in your reports and troubleshoot reporting issues such as self-referrals, (not set) data, and inaccurate information
 
Guide Me
star_border
Reply

DATA EXPORT GA RAW DATA TO SQL SERVER

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hey,

 

I want to build a system which export raw data from GA everyday automatically directly into SQL server.

 

What is  is the best way to do? I am aware of different ways like reporting api, SSIS, Google sheet but none I know which are capable of schedule exporting of GA data directly into sql server.

 

1 Expert replyverified_user

DATA EXPORT GA RAW DATA TO SQL SERVER

Participant ✭ ☆ ☆
# 2
Participant ✭ ☆ ☆

Hi @puneet y,

 

You can write your own script using GA reporting API that runs every day automatically. In your script if you make the date change everyday, you can achieve what you need.

 

I hope this helps.

Regards

Marked as Best Answer.
Solution
Accepted by James_Clemens (Top Contributor)
September

DATA EXPORT GA RAW DATA TO SQL SERVER

Rising Star
# 3
Rising Star

Premium GA also offers this opportunity. You can export to BigQuery and use SQL to query the data. However, Premium GA has a significant price tag (ca.150k USD) and cloud storage also occurs some, more minor, costs.

John Wedderburn, Advertiser Community, Rising Star
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.

DATA EXPORT GA RAW DATA TO SQL SERVER

Participant ✭ ☆ ☆
# 4
Participant ✭ ☆ ☆

@John W is right. If you want really raw data, GA 360 provides the export option.

DATA EXPORT GA RAW DATA TO SQL SERVER

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

 

Can you explain this solution in detail. 

If you can give an example or illustration, that would be great!

 

Much appreciated!

 

Thanks