Custom Google Search Console integration

Search Console shows how your site performs in Google, but the interface keeps limited history and shows a maximum of 1,000 rows per view. With an integration on the Search Console API, Appfront retrieves that data automatically and stores it in your own database, dashboard or CRM.

What the Search Console API can do

  • Search Analytics: clicks, impressions, CTR and average position by query, page, country, device and date.
  • URL Inspection: the indexing status of a URL as Google sees it.
  • Sitemaps: submit, retrieve and delete sitemaps.
  • Sites: the properties an account has access to.

Search Console keeps performance data for 16 months. If you want to compare over a longer period, you need to store the data yourself. Google also offers a bulk export to BigQuery.

What we build

  1. Access: a service account or OAuth integration with read-only permissions wherever possible.
  2. Daily import: data per day in your own database, with the dimensions you need.
  3. Enrichment: linking it to your own data, such as page type, publication date from the CMS or leads from the CRM.
  4. Display: in an SEO dashboard, in your CMS or as a report.

What to watch out for

The API has quotas per property and per project, and returns a limited number of rows per request, so large sites require pagination. Queries that Google anonymises for privacy reasons are missing from the per-query rows, so don't add up clicks per page from those rows. We know these pitfalls from our own use.

Appfront itself uses an integration with the Search Console API for appfront.nl. The figures in the HunterSEO case come from it too. Similar work: the Google Analytics API integration.

Indexing requests

Google's Indexing API is officially intended only for pages with job postings (JobPosting) and livestreams (BroadcastEvent). For regular pages, you work with sitemaps and URL inspection. For job postings, see the Google for Jobs integration.

Search Console data in your own systems?

Tell us what's going on: which site, which platform and what is going wrong or could be better. We'll take a look and tell you honestly whether the work suits us, or is better suited to an SEO agency.

Get in touch

Frequently asked questions

Retrieve performance data (clicks, impressions, CTR, position by query, page, country and device), check the indexing status of URLs via URL Inspection, and manage sitemaps.

Performance data for 16 months. If you want to compare over a longer period, you store the data yourself via the API or the bulk export to BigQuery.

No. Google intends the Indexing API only for pages with JobPosting or BroadcastEvent in a VideoObject. For other pages, you use sitemaps and URL inspection.

Yes. We link the data per page to your own data, such as leads from the CRM, so you can see which pages generate enquiries.

Want to start a project?

We'd love to hear from you.

Long story, or would you otherwise have emailed it? Choose Detailed briefing: headings and bullet lists, images in the text and attached files.

Mies

Contact Mies

Business Developer

Contact Martijn

Founder of Appfront

Martijn

Your message has been sent

Thanks for your interest! We'll get back to you as soon as possible, usually within 1 working day.

Let's get started

Together, we create smart digital solutions for your organisation's challenges. No rushed, short-lived products, but well-considered, high-quality solutions built on a foundation of UX Design and technological expertise. So your organisation is ready for tomorrow.

Edit content