Data Studio
6K members online now
6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Good morning,

 

I am new using Google Data Studio and I am a bit lost. I have 2 questions:

 

1) How can you include an Excel which GDS checks automatically? For example, in order to upload an Excel with a call center sales information, how could I do so that GDS keeps track of the changes I do on my Excel sheet? 

 

2) Can you include AhRef, SEM rush and PRORANKTRACKER data in GDS? Is there any direct connection between GDS and any of these tools? 

Can you integrate any of them with a direct API?

 

Thank you very much!

 

Hope to hear from you asap!

 

Best regards!

  

Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

Instead of keeping your data in Excel, keep it in Google Sheets. There is a direct connection to Sheets from Data Studio (there's isn't to Excel). However, if you have sensitive data (like medical data that has privacy laws), then this might not be an option for you unless it's aggregate data without identifying personal information.  

 

SEMRush does have an API through the Supermetrics plugin to Google Sheets. However, you have to have the top subscription level ($400/month). I have the $200/month and have checked with Supermetrics and they don't support and API in that case. 

 

I don't have any info about the other tools you mentioned.

Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

thank you very much for your answer!

Automated Excel, AHREF, SEMRUSH, PRORANKTRACKER

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭

I'm also interested in that.