Balazs Vajna

Ireland

6 Swipes

About

Balazs is an experienced professional in project, team, and work stream management, adept at handling aggressive deadlines. He has expertise in advanced analytics, machine learning, and end-to-end analytics processes. Skilled in working with various data types, he excels in business intelligence, data governance, and univariate statistics. Proficient in numerous statistical software and business intelligence tools, he also has strong skills in SQL, data modeling, and server administration.

Achievements

Coming Soon 🤞

Swipes

BigQuery Sharded Tables: Beware Schema Changes Affecting Data Transfer and Queries

5 months ago

BigQuery

Sharded tables in BigQuery can be problematic when the schema changes, such as adding columns or altering data types. These changes can disrupt data loading and querying using wildcards, as BigQuery uses the latest metadata for all shards, making it difficult to union shards with different schemas. This issue was highlighted when date columns in BigQuery Data Transfer for Facebook changed. Partitioned and clustered tables are recommended alternatives.

Facebook Ads Transfer in BigQuery Now Supports Adjustable Refresh Window

6 months ago

BigQuery Meta Ads

Facebook Ads Data Transfer in BigQuery now allows adjusting the refresh window for data fetching. The table has become historical, accumulating data instead of daily reloads. Some column data types have changed, causing some issues. Though in preview and less stable than previous features, it remains a viable alternative to costly ELT tools for basic needs.

Google Ads Data Manager: Central Hub for Data Loading Enhances Advertising Efficiency

7 months ago

Google Ads

Google Ads Data Manager enhances advertising efficiency by allowing data loading from various platforms. It manages Google Tag and product linkages, and enables loading of first party data as audiences or conversions, eliminating the need for paid ReverseETL products. It expects Unix timestamp format for dates, doesn't accept conversion timestamps older than 14 days, and requires accurate mapping initially. Despite some issues, it's effective.

Top-Notch Google Ads Audit Tool

Featured

Effortlessly audit your Google Ads account with Marketing Auditor. Perform 200+ automated checks to uncover optimization opportunities and save over 10 hours per audit. Generate white-label reports in minutes with 50+ pages of actionable insights. Customize your reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides. This tool is the ultimate solution for efficient and impactful Google Ads audits.

Trending ️‍🔥

Google Ads Data Manager: Load your First Party Data via BigQuery

8 months ago

Google Ads BigQuery

Google's new Data Manager in Google Ads simplifies loading first party data by directly connecting to BigQuery. This enables data analysts and marketers to process in-house sales data, create customer audiences, or load sales as conversions, tasks that previously needed a custom-built API connector or third-party tool. The Data Manager also handles aspects of the Google Tag and other connected products.

BigQuery's Connected Sheets: A Free and Simple Alternative for Marketing Data Analysis

9 months ago

Google Sheets BigQuery

Organizations hesitate to use BigQuery, preferring Excel or Google Sheets due to their simplicity. However, using third-party tools to load data into Sheets can be costly. BigQuery provides a cost-effective solution with Connected Sheets. For instance, marketing teams can generate a daily campaign cost table using BigQuery Data Transfer for Google Ads and basic SQL logic. Despite seeming complex, BigQuery is worth considering for its cost-effectiveness.

Google Consent Mode Issues Disrupting Companies, E-commerce Platforms Struggle