Swipe Insight Swipe Insight Logo
Balazs Vajna

Balazs Vajna

Open source LinkedIn

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.

Top Topics

Achievements

Coming Soon 🤞

Swipes

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

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

11 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.

Google Ads Monthly Slides with AI Insights

Google Ads Monthly Slides with AI Insights

Featured

Create professional Google Ads performance reports in Google Slides with AI insights and visualizations. Transform Google Ads data into polished presentations featuring AI-generated insights and custom visuals to impress stakeholders and streamline reporting. Use cases include reducing manual reporting time, presenting insights without design skills, maintaining reporting schedules, identifying trends, and sharing campaign insights for strategic decisions.

Markifact
Markifact

Verified Sponsor

Verified Sponsor

Markifact is a Verified Sponsor. Want to get featured here? Contact us.

Verified Sponsor
Open Source
Facebook Ads Transfer in BigQuery Now Supports Adjustable Refresh Window

Facebook Ads Transfer in BigQuery Now Supports Adjustable Refresh Window

1 years 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

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

1 years 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.

Google Ads Data Manager: Load your First Party Data via BigQuery Trending ️‍🔥

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

1 years 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

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

1 years 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

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

1 years ago

Tracking Google Tag Manager +1 more

Google Consent Mode is causing difficulties for companies due to improper cookie banner integration, GTM setup errors, and cookie consent tool configuration issues. Some e-commerce platforms haven't implemented Consent Mode correctly, leaving retailers in a tough spot. Even when implemented correctly, user volumes can shock. Close monitoring of Google Ads conversions is essential as any data loss can impact campaigns and revenue.