Tim Kahlert

Member
Joined
May 24, 2019
Messages
78
Reaction score
58
Does anyone happen to know how to get the csv file into a good format? Good in terms of easily readable so that one could turn it into a graphic.

screenshot-business.google.com-2021.02.22-23_36_31.png
 

Phil Rozek

Local Search Expert
Joined
Jul 26, 2012
Messages
1,892
Solutions
13
Reaction score
1,467
@Tim Kahlert, the "phone calls" report is a mess. What I'd do is remove a bunch of columns and labels, so you have only the days and numbers of phone calls. Then turn that into a pivot chart.

gmb-pivot-chart.png


gmb-pivot-chart2.png


It's not beautiful, but it is simple and fast.

The "discovery" GMB Insights report is far less cluttered, by the way. (Not that I use or export anything in GMB Insights much.)
 

Lluc

Member
Joined
Sep 20, 2018
Messages
104
Solutions
1
Reaction score
87
Hi @Tim Kahlert , I'm not sure if I'm understanding correctly but have you tried importing the csv file to Google sheets? I believe in Excel you can also convert de csv format.

Screenshot_2021-02-23_at_10_15_43.png

Screenshot_2021-02-23_at_10_22_30.png


P.S. We switched to Supermetrics over two years ago for the GMB data extraction and it is well worth it! you can schedule the data extraction and you can export data from many different services/tools like GSC, SEMRUSH, MOZ, etc.
 

raellovepie

Member
Joined
Jul 15, 2019
Messages
85
Solutions
1
Reaction score
83
@Tim Kahlert it seems it exported all the data in a single column. Not sure if this is the problem you are trying to solve. If it is, you have to fix the data first - then I will refer to what @Phil Rozek just mentioned above to create a Pivot Table.

To fix the single column issue, follow the steps:

  • Highlight the cells with the data
1614205388430.png


  • From the menu, click - Data
1614205427967.png


  • Click Text to Columns
1614205455537.png

  • Select Delimited and click Next
  • Check Comma (it's the one separating your data columns) and click Finish
1614205588737.png


That should separate the data from a single column to multiple columns. Then use it to create pivot charts.
 

Tim Kahlert

Member
Joined
May 24, 2019
Messages
78
Reaction score
58
@Tim Kahlert, the "phone calls" report is a mess. What I'd do is remove a bunch of columns and labels, so you have only the days and numbers of phone calls. Then turn that into a pivot chart.

gmb-pivot-chart.png


gmb-pivot-chart2.png


It's not beautiful, but it is simple and fast.

The "discovery" GMB Insights report is far less cluttered, by the way. (Not that I use or export anything in GMB Insights much.)
That's a really good tip, thank you! I expected it to be more user-friendly, to be honest. Not sure if I'm going to use it though. :D
 

Tim Kahlert

Member
Joined
May 24, 2019
Messages
78
Reaction score
58
Hi @Tim Kahlert , I'm not sure if I'm understanding correctly but have you tried importing the csv file to Google sheets? I believe in Excel you can also convert de csv format.

Screenshot_2021-02-23_at_10_15_43.png

Screenshot_2021-02-23_at_10_22_30.png


P.S. We switched to Supermetrics over two years ago for the GMB data extraction and it is well worth it! you can schedule the data extraction and you can export data from many different services/tools like GSC, SEMRUSH, MOZ, etc.
Thank you! I haven't tried the import, no. I'm not sure if I even want to use it this way. I may check out Supermetrics, thanks.
 

Tim Kahlert

Member
Joined
May 24, 2019
Messages
78
Reaction score
58
@Tim Kahlert it seems it exported all the data in a single column. Not sure if this is the problem you are trying to solve. If it is, you have to fix the data first - then I will refer to what @Phil Rozek just mentioned above to create a Pivot Table.

To fix the single column issue, follow the steps:

  • Highlight the cells with the data
1614205388430.png


  • From the menu, click - Data
1614205427967.png


  • Click Text to Columns
1614205455537.png

  • Select Delimited and click Next
  • Check Comma (it's the one separating your data columns) and click Finish
1614205588737.png


That should separate the data from a single column to multiple columns. Then use it to create pivot charts.
Man, thanks for that. I ever wanted to know how that works. :D Whenever I have such a problem I will come back to this thread now. haha
 
Similar threads
Thread starter Title Forum Replies Date
AndySimpson Your insights are moving - New Look for Insight Reports NAP, Categories, Dashboard Data 7
BipperMedia GMB Insights & Local SEO Reports Recycle Bin 1
Vicky Trainor GMB Insights & Local SEO Reports Recycle Bin 1
IanJohnson GMB Insights & Local SEO Reports Google My Business & Google Maps 22
Nathan_NZ GMB Insights Reporting for 50+ Locations Local SEO Tools & Software 6
P GMB Insights Reporting Bug? Google My Business & Google Maps 28
P Insights Reports - Do you trust the accuracy? Google My Business & Google Maps 13
Tim Colling GMB Insights call report wrong by a factor of 3 - Surprising? NAP, Categories, Dashboard Data 4
AndiFox Google Insights Reported Calls. Is is accurate? Google My Business & Google Maps 1
B Google My Business insights reporting Google My Business & Google Maps 4
C Google Insights not reporting? Google My Business & Google Maps 6
Linda Buquet Local Consultants - New YP Report Yields Tons of Local Marketing Insights Local Search 2
JamesGreenaway Google Insights query Google My Business & Google Maps 1
J Can You Access the Business Profile Performance Insights feature? Google My Business & Google Maps 4
JoyHawkins Search Console vs Google My Business (GMB) Insights: A Large Case Study Google My Business & Google Maps 4
Colan Nielsen NEW October 2020 Google My Business Insights Update Google My Business & Google Maps 0
K "What Your Business Is Known For" In GMB Insights Google My Business & Google Maps 2
Nicole Basham How early can you pull data on GMB Insights? Google My Business & Google Maps 1
K Insight Data Stops June 22nd? Google My Business & Google Maps 1
L GMB Insights Data not Updating Properly Google My Business & Google Maps 2
Nikki Stine GMB Insights Data missing for May 4 - 6? NAP, Categories, Dashboard Data 5
S February GMB Insights-HUGE DROP Google Algorithm Discussions 8
Lachlan_Wells GMB Insights data not updating for two weeks Google My Business & Google Maps 1
Gerry.Foster Products & Services insights? Google My Business & Google Maps 1
cleverlyengaged GMB Insights Views on Maps Increasing over Search Google My Business & Google Maps 7
P GMB products insights Google My Business & Google Maps 20
JoyHawkins Is Google My Business Insights for Messaging Broken? Google My Business & Google Maps 0
J GMB Insights Comparison Google My Business & Google Maps 3
eshad Seen a big drop in views on GMB insights? Local Search 19
JoyHawkins GMB Insights Now Show on Google Maps Google News: Important Changes & Features 1
H Google My Business - Bulk Insights download Google My Business & Google Maps 7
pony BrightLocal - Google My Business Insights Study Google My Business & Google Maps 4
ashley.smith GMB Listings Not Pulling Any Discovery Insights Numbers for March Google My Business & Google Maps 2
djbaxter PageSpeed Insights Score Can Change Without Any Changes to a Site Organic SEO 2
JohnS GMB & Branded Search Insights Google My Business & Google Maps 0
hajnasiewicz Google Analytics vs GMB Insights Google My Business & Google Maps 1
P Damaging insights queries GMBL Local Search 8
OnlineLobstar GMB Insight Showing Completely Irrelevant Search Terms Recycle Bin 0
OnlineLobstar GMB Insight Showing Completely Irrelevant Search Terms NAP, Categories, Dashboard Data 8
Garrett Sussman Insights for Consultants: Getting Started With Local SEO with Phil Rozek of Local Visibility System Local Reviews 21
Phil Rozek GMB "insights" missing from search results? NAP, Categories, Dashboard Data 2
Garrett Sussman Wedding Industry Review Management Tips & Insights Local Reviews 0
Garrett Sussman Realty Industry Review Management Tips & Insights Local Reviews 0
OnlineLobstar GMB Insight: Why Two Different Dataset When It Comes to Direction Request? Google My Business & Google Maps 3
Garrett Sussman Healthcare Industry Review Management Tips & Insights Local Reviews 2
Garrett Sussman Hospitality Industry Review Management Tips and Insights Local Reviews 0
Garrett Sussman Legal Industry Review Management Tips & Insights Local Reviews 0
JoyHawkins New: Change to GMB Insights on August 13, 2018 Google My Business & Google Maps 6
Garrett Sussman Home Services Industry Review Management Tips & Insights Local Reviews 2
M Keywords BACK in GMB Insights? Google My Business & Google Maps 2

Similar threads

Login / Register

Already a member?   LOG IN
Not a member yet?   REGISTER

Most UpVoted Answers

Trending: Most Viewed

LocalU Podcasts

  Promoted Posts

New advertising option: A review of your product or service posted by a Sterling Sky employee. This will also be shared on the Sterling Sky & LSF Twitter accounts, our Facebook group, LinkedIn, and both newsletters. More...
Google Product Exert


Top Bottom