SHOPIFY
BIGQUERY
Conecta tu Tienda Shopify a
BigQuery
.
100% sin código.
Más de 2,975 tiendas Shopify confían en nosotros
How It Works
Export Meta Ads (Facebook Ads) to BigQuery—or anywhere
Under one subscription, send Meta Ads data to BigQuery, Looker Studio, Google Sheets, Slack, or Zapier. Build dashboards, reports, alerts, notifications, and AI workflows.
Connect multiple data sources
Select from 22 data sources: Google Ads, GA4, LinkedIn Ads, TikTok Ads, HubSpot, Shopify, and more. Porter maps UTMs, campaign names, and performance metrics across channels automatically. No SQL joins.
Consolidate multiple Meta Ads accounts
Connect multiple Facebook profiles, select Ad Accounts under each. Consolidate dozens of accounts across brands, regions, or clients into one BigQuery table. Built for agencies and enterprise teams at scale.
Manage your data sources
Name, duplicate, delete connections, accounts, queries, and custom fields to manage multiple clients, brands, campaigns, or regions.
Three ways to connect to BigQuery
-
Google login: Sign in with Google and Porter auto-lists your BigQuery Project IDs. Select project, dataset location (US, EU, US-Central), name your dataset and table.
-
Service account (JSON): Upload your credentials. No Workspace admin approval needed.
-
New to BigQuery? Set up your first project automatically—no Google Cloud console, no billing, no technical setup. Create your report in Looker Studio directly.
Build your query with AI in natural language
The AI-native query builder. Describe what you need. No SQL, no complex forms.
-
Cross-channel fields: Select metrics and dimensions from Meta Ads and any data source. No data mapping or joins needed.
-
Custom fields: Use AI prompts to create custom metrics (e.g., blended ROAS, cost per lead) and dimensions (e.g., brand, region, creative hook). Segment data using naming conventions from campaigns, ad sets, or ads.
-
Filters: Include or exclude by any field. Combine with AND/OR logic.
-
Date ranges: Dynamic (Month-to-date, Last quarter) or fixed (custom start and end).
-
Schedule: Prompt refreshes like “Every day at 5am except weekends.” Freely schedule by hour, day, week, weekday, or month.
-
Refresh mode: Append (add rows), Update (match and refresh), or Overwrite (replace table).
-
Live preview: Preview your data before syncing to BigQuery. Catch errors before they cost you.
Scale data refreshes in natural language
Schedule refreshes in minutes, not hours. Real-time API data or stored BigQuery data—switch between both in the same connection. Refresh as frequently as Meta’s API allows. If you hit Meta’s rate limits, Porter automatically switches to BigQuery backups. Never blocked from accessing your data.
Monitor every Meta Ads sync to BigQuery
Track all queries in the Query Manager: name, data sources, last run at a glance. Open execution history—timestamp, success or failure. Toggle pipelines on/off anytime. Fix issues before they reach your reports, team, or clients.
Why Marketers Choose Porter
Revenue
Purchases
Purchase conversion value
ROAS
Budget
Amount spent
Campaign daily budget
Campaign total budget
Conversions
Standard conversions
Custom conversions
CPA
CPL
Conversion rate
Engagement
Link clicks
Clicks
Thruplays
Engagement
CTR
CPC
Visibility
Impressions
Reach
Frequency
CPM
Brand recall lift
Campaign
Campaign name
Objective
Ad set name
Creative
Ad headline
Ad text
Ad image
Ad preview
Audience
Placement
Publisher platform
Gender
Age
Device
Region/Country
Time
Hour
Date
Week
Month
Custom
Brand
Client (via naming conventions)
Integrations
Connect and standardise data from 22 sources:
Custom
Web Analytics
Testimonials
Frequently Asked Questions
How does the free trial work? +
Full proof of concept. Includes tool access, support, and migration assistance. No day limit—ends when you validate Porter meets your needs.
How much does Porter cost? +
Start with a 14-day free trial with full access. Free-forever plan available: up to 3 ad accounts, unlimited reports, 30-day historical data. For larger implementations, pricing starts at $500-$1,000/month based on support needed. Get a quote on a call.
Can I cancel anytime? +
Yes. Monthly or annual billing (2 months free with annual). Cancel anytime, no paperwork, immediate cancellation.
How much does BigQuery cost? +
Most clients operate within Google’s free tier. High-volume clients: $20-$30/month. See Google BigQuery pricing for details.
Can I use my own BigQuery or does Porter manage it? +
Both. Use your own project or Porter manages one for you. Your data is always yours.
How fresh is the data? +
Automatic refresh every 12 hours by default. Configurable to hours or minutes depending on Meta’s API limits. Direct API access available for real-time data.
Are there limits on rows, queries, or accounts? +
Porter has no limits. Limits depend on BigQuery and Meta.
Do you help migrate from another provider? +
Yes. 100% assisted migration by implementation and development team. Typical time: within the same week.
What support is included? +
Direct Slack access to support team, developers, and founders. Chat, scheduled video calls, email. Response in minutes or hours (Americas timezone).
How do you handle security? +
Google-only login (OAuth 2.0). No passwords stored. Data goes directly to your BigQuery.
Security
-
Google-only login (OAuth 2.0). No passwords to create or store.
-
Your existing Google security applies: 2FA, suspicious login detection, session management.
-
One identity for BigQuery, Looker Studio, Sheets, and Porter.
