Xpath not pulling Google My Business Map data from Serp :(

Support
#1

Hi - referencing your guiance here:
/xpathonurl/
/xpath-and-chrome-devtools/

and the associated cookbook example downloaded from Github.

I am using this awesome extension https://chrome. google.com/webstore/detail/xpath-helper/hgimnogjllphhhkhlmebbmlgjoejdpjl?hl=en to identify the correct xpaths.

When I run your cookbook example all works well (see #1 in screenshot)
When I try applying the same exact process to grab the 3 Google My Business results from the serp, I get blanks :frowning:

https://www.screen cast.com/t/Qx2y3V0pp9Wy

To me, logically, it seems that it should work. Can you please offer any insights on what I might be missing/doing wrong.

Your help would be grealty apprecaited.

Thanks!
Chris

#2

Can you provide a specific URL and the exact formula you are using?

#3

Hi - thanks for the quick reponse!

This is the info from the "cookbook" XPathOnUrl.xlsx from the seotoolsforexcel site:

URL: http://www.google.com/search?q=chicago+accident+lawyer&num=10 in cell A2
Xpath: //h3[@class='r']/a in Cell B2
Formula: =XPathOnUrl(A2,B2,"href") Cell C2

that works fine.

In my example where I try to pull the Google My Business Serp results (3 pack)
URL: http://www.google.com/search?q=chicago+accident+lawyer&num=10 in cell A25
Xpath: //div[@class='_Orh'] in Cell B25
Formula: =XPathOnUrl(A25,B25,"href") Cell C25

That does not pull any data :frowning:

Any insight would be appreciated.

Thanks!
Chris

#4

Hi Victor - I thought that I would bump this to see if you had a chance to look at my issue. I just checked again and I'm getting the same blank result :(.
Any insights/help would be appreciated.
Chris

#5

Hi Chris,

I managed to find the My Business results with regex:
=Dump(RegexpFindOnUrl(A1;"role=""heading"">([a-zA-Z0-9_\s,.&]*)";1))

The class name was different for me so those are probably generated with some kind of random input.

#6

Hey Victor - Thanks very much for the respsonse. The data that I was trying to grab is the url. Would you pssibly be able to give me any insights on that? https://www.screencast. com/t/zEH6R7LR4g
Chris

#7

=Dump(RegexpFindOnUrl(A1;"action-button.?href=""([a-zA-Z0-9_\s,.&:/\])"" data";1))

#8

Hi Victor,
I really appreciate your help on this. I am learning some great ways to use seo tools for execl.
Just one last follow-up on your last post.

https://www.screencast. com/t/tpsDiAbGy

Using the following 2 formulas:
Where A18 is the url google: http://www.google.com/search?q=chicago+accident+lawyer&num=10
(1) =Dump(RegexpFindOnUrl(A18,B18,1))
Where B18 is: action-button.?href=""([a-zA-Z0-9_\s,.&:/])"" data
I get error #1 in the screenshot.

(2) =Dump(RegexpFindOnUrl(A18;"action-button.?href=""([a-zA-Z0-9_\s,.&:/])"" data";1))
I get error #2 in the screenshot.

Am I doing something wrong in either case.

Any addition help you can provide would be apprecaited.

Chris

#9

Yeah, that regex wasn't very good. This xpath should work better :smile:

=Dump(XPathOnUrl(A1;"//div[1]/div[*]/div/div/a[2]";"href"))

#10

Absolutely Perfect!!!!!!!!!!! I am SO happy right now. Thank very much Victor!