AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Importing data from Google Sheets, is it only certain data that can be pulled into data studio?

 

I would like to add just text to the page but it's not recognizing the content from the table. The headers are appearing in GDS. Can anyone help on how I can do that? TIA

1 Expert replyverified_user

Data Studio and Google Sheets

Google Employee
# 2
Google Employee

Hi Beth -- you should be able to pull just about any type of data from a Google Sheet into a Data Studio report.

 

Would you be able to share the Sheet with data-studio-help@google.com? We'd be able to troubleshoot from there. You can anonymize or truncate the data if it is sensitive. Thanks!

Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

Hi Alon, I am also having some issues with importing data from Google Sheets. Any chance you have an example of a sheet, which I can copy? My issue is about not finding the dimensions / metrics I have. 

Data Studio and Google Sheets

Google Employee
# 4
Google Employee

@Dick R: I'm not sure I fully understand your question, but can you use this template? It's a super Sheet -- save it to your drive and create a Data Studio report off of it. If you are having problems here please share screenshots and I'll troubleshoot. Thanks!

Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

When starting the creation of a new data source in Data Studio and Google Sheets, I do not see the Create report button.
Would appreciate if there are limitations to the BETA version.

Best regards @andabi

Re: Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

 Data Studio and Google Sheets andabi.jpg

Create Report Botton does not appear???

Data Studio and Google Sheets

Google Employee
# 7
Google Employee

@Nicolas Julio V and @Dick R: we fixed a handful of related issues last night. Can you please let me know if you are still seeing problems? Thanks!

Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Hi Alon, thanks! Just a quick follow up question. I am using the table below. 

So I have 1 dimension (week) and 7 metrics. I dont succeed in getting all the metrics in a graph. I can only put in max 5. How would you solve this to get this for example in a Pie chart? To make it concrete: a pie chart for week 43 with the different contact methods. 

 

Week Chat Whatsapp Email Facebook Outbound Email Phone Total
43 1 0 15 0 10 33 59
44 12 2 22 0 7 44 87
45 9 3 22 2 5 45 86
46 10 0 22 0 9 48 89
47 12 1 14 0 7 72 106
48 10 1 14 0 8 67 100
49 14 1 40 0 5 85 145
50 315 1 85 0 27 67 495
51 164 0 84 0 26 98 372
52 74 2 65 0 4 41 186
1 153 6 86 0 10 69 324
2 242 4 60 2 16 74 398
3 266 2 54 0 18 77 417
4 266 2 54 0 18 77 417

Data Studio and Google Sheets

Google Employee
# 9
Google Employee

@Dick R: to make sure I answer this correctly could you please share the report you are working on with data-studio-help@google.com? I'll be able to better understand the issue once I see the actual data and report. Thanks!

Data Studio and Google Sheets

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

Thanks Alon. Shared it with you. Also have some issues with the dimension (week), you will see in the dashboard. Thanks for your help!