Home
Services
SEO analysisKeyword Analysis and MappingI find out what your customers actually search for SEO auditI find the issues holding your site back Content Gap AnalysisI find the content gaps where you can grow Backlink auditI review your links and prepare a clear plan Competitor Backlink AnalysisI find where competitors get links and how to get them
Ongoing workSEO managementContinuous work on your site with a monthly report Ecommerce SEOI take care of categories and products people find Link BuildingI build backlinks that strengthen your visibility SEO contentI create complete briefs or high quality content Local SEOI get your business into local search
Other SEO servicesTechnical SEOI thoroughly check the technical health of your site Website migrationI move you to a new site without losing rankings AI search visibilityI get your brand into AI search Training and mentoringI provide tailored SEO training SEO strategyI put together a clear growth plan for your project
Explore all services and prices
How I Work
About me
Blog
Contact

Home
Services
SEO analysisKeyword Analysis and MappingI find out what your customers actually search for SEO auditI find the issues holding your site back Content Gap AnalysisI find the content gaps where you can grow Backlink auditI review your links and prepare a clear plan Competitor Backlink AnalysisI find where competitors get links and how to get them
Ongoing workSEO managementContinuous work on your site with a monthly report Ecommerce SEOI take care of categories and products people find Link BuildingI build backlinks that strengthen your visibility SEO contentI create complete briefs or high quality content Local SEOI get your business into local search
Other SEO servicesTechnical SEOI thoroughly check the technical health of your site Website migrationI move you to a new site without losing rankings AI search visibilityI get your brand into AI search Training and mentoringI provide tailored SEO training SEO strategyI put together a clear growth plan for your project
Explore all services and prices
How I Work
About me
Blog
Contact

Automation

Manual SEO stops scaling when a site has thousands of URLs and data is scattered across multiple sources. This is where I show how I use BigQuery, Python, MCP servers and AI agents to speed up the work. Expect practical workflows, reusable code and honest lessons on what is worth automating and what still needs human judgement.

Cover illustration for the article on keeping Search Console data in BigQuery past 16 months.

Automation

Search Console BigQuery export: keeping your data past 16 months

April 29, 2026

Home Blog GSC + BigQuery Automation Apr 29, 2026·10 min read Search Console BigQuery export: keeping your data past 16 […]

Jan Oberpfalzer

For 10 years, I’ve helped online stores and business websites turn traffic into inquiries and orders. You work directly with me, not through an account manager and a junior team. Let’s talk about your website.

Contact

Book a consultation seo@janoberpfalzer.com +420 721 627 467Taškentská 1413/8Praha 10, Vršovice101 00Company ID (IČO): 76263177

Scroll to Top

► Necessary Cookies Always Active

Necessary cookies enable essential site features like secure log-ins and consent preference adjustments. They do not store personal data.

None

► Functional Cookies Remark

Functional cookies support features like content sharing on social media, collecting feedback, and enabling third-party tools.

None

► Analytical Cookies Remark

Analytical cookies track visitor interactions, providing insights on metrics like visitor count, bounce rate, and traffic sources.

None

► Advertisement Cookies Remark

Advertisement cookies deliver personalized ads based on your previous visits and analyze the effectiveness of ad campaigns.

None

► Unclassified Cookies Remark

Unclassified cookies are cookies that we are in the process of classifying, together with the providers of individual cookies.

None