AccuApi URL Rank for Keyword

#1

Recently installed SeoToolsforExcel, added the AccuAPI connector and registered for an AccuAPI account.

Wanted to check my page's ranking for a particular keyword. I know it is top 10 so I limited the results to 10.

I noticed the connector doesn't have the "Rank" field available. I can see this field on the demo page https://seotoolsforexcel.com/accuapi/

I tried adding it manually and the connector failed.

Does this connector no longer support rank? Is there a workaround besides getting clever with Excel vlookup and formulas?

#2

Thank you for bringing this up. We've converted the AccuAPI connector from hard-coded within SeoTools to regular connector and we missed the Rank metric.

I've updated the connector and you can get the new version from the Manager:
https://seotoolsforexcel.com/manage-connectors/

#3

Thanks so much for your help and fast response! I tried updating now and noticed version date was 08-26-2020.

Does that version contain the Rank update?

#4

Hi, I see the "Rank" field now.

But the connector still doesn't work correctly. The ranks don't run 1-10. Instead I see 1, 10,11,13, etc. The numbering is off.

Also, I don't get a single result for my domain. Instead, I see results 1-10 including my domain.

I would prefer just one row containing my domain's rank for this keyword. I tried recreating the demo and it didn't work either.

#5

Can you post a screenshot of the incorrect results?

#6

Hi, here it is. Maybe I grabbed the updated AccuAPI software incorrectly?

Below, I want the rank,url, and domain for theguardian.com using en-US for keyword "british news".

The formula in b2 uses keyword a2 and device b1.

The result is unexpected. 10 incorrectly numbered results instead of just 1 matching "theguardian.com" domain.

#7

You are right, I misunderstood. I thought AccuAPI handled the domain filtering but this needs to be done one our side. I've solved it but it required updating the Seotools code so here is a new build

#8

Thanks, will test this in the next day or so and reply.

Really appreciate your assistance. Just bought this tool yesterday and it is already making life much easier.

1 Like
#9

Hi, tried updating today. Saw the 12-09-2020 Version 35 in my update manager still.

Installed it thinking the version number hadn't changed.

Still get the same output as my screenshot. Do I have to refresh the local XML file or uninstall SEO Tools and reinstall?

#10

Oh, I thought the latest version was included by default in the install. Now it should be available in the Manager.

#11

Hi Victor, I still see Version 35 in my manager. Also tried uninstalling and downloading a fresh copy of SEO Tools.

Do I need to refresh my cache?

#12

Hmm, not sure. Try downloading the this file (right click->save as) and overwrite old AccuApi.xml in the connectors folder in the Seotools install directory.

Then Settings -> Reload Settings

#13

That won't run without SEOTools 9.5.4. The latest SEO Tools download is 9.3.0.6.

Is there a download link for 9.5.4?

#14

Okay, that explains it. Yes, I linked the latest build earlier, here it is again.

#15

Hi Victor, thanks, that worked!

Is there a way to limit the results to the top ranking number and URL?

Following my example above, a search for "the guardian uk" returns ~8 URLS from theguardian.com.

All 8 ranks and URLs would appear on the spreadsheet. I want to limit it to just 1. I think this would require a new feature unless there's a parameter I missed.

#16

Try setting this to 1:
bild