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
- Access: a service account or OAuth integration with read-only permissions wherever possible.
- Daily import: data per day in your own database, with the dimensions you need.
- Enrichment: linking it to your own data, such as page type, publication date from the CMS or leads from the CRM.
- 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.
Frequently asked questions
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.
Your brief has reached us
We'll read it through and usually respond within one working day. Anything to add? Send it to fabian.vandijk@appfront.nl.
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.
Or take a look at our case studies, blog posts or get to know our team.