Overview

Connect SMAQ to every ad platform, analytics tool, and database it supports. Each integration is a one-time setup that powers datablocks, dashboards, and automations forever after.

A connection is an authenticated link between your SMAQ project and an external data source. Most connections use OAuth — sign in with the platform, grant SMAQ read-only access, done. SQL databases use direct connection strings instead.

What's supported

Ad platforms

Platform
Auth
Notes

OAuth

Search, Display, YouTube, Demand Gen — all under one connection

OAuth

Includes Instagram ad placements via the same Meta connection

OAuth

Organic Instagram content & insights — separate from ads

OAuth

TikTok for Business

OAuth

Sponsored content & message ads

API key or OAuth

iOS App Store campaigns

OAuth

Display & Video 360 — programmatic

Platform
Auth
Notes

OAuth

Web & app analytics; supports ecommerce events

OAuth

Organic search performance

Social

Platform
Auth
Notes

OAuth

Organic Facebook page insights

OAuth

Meta Threads — organic content & engagement

Attribution & ecommerce

Platform
Auth
Notes

API token

Mobile attribution

API key

Shopify alternative — orders, products, customers

Databases & custom

Source
Auth
Notes

Connection string

PostgreSQL, MySQL, BigQuery, ClickHouse, Microsoft Azure SQL, MongoDB

API key / bearer / none

Any JSON HTTP endpoint

What SMAQ does with the data

Once connected, SMAQ:

  • Pulls data on-demand when datablocks are fetched and dashboards refreshed.

  • Caches recent results to keep your dashboard interactive.

  • Runs scheduled automations against the connection.

  • Never writes back to your platform. Connections are read-only.

What you'll need

  • OAuth platforms: a login with the right account access. For ad platforms, you need at least read access to the ad account, property, or page you want to pull from.

  • API key platforms: the API key from the platform's developer/admin settings.

  • SQL databases: hostname, port, database name, username, password, and (for hosted databases) IP allowlist permission for SMAQ's outbound IPs.

How to add a connection

  1. Open your project and click Data Source in the side menu.

  2. Click Add data source (or Add your first data source if it's your first).

  3. Pick the platform.

  4. Follow the platform-specific flow. The per-integration guides linked above walk through each one.

Naming convention

When SMAQ asks you to name the connection, follow the pattern Company - Source — e.g. "Acme Co - Google Ads". When you have 10+ connections across projects, you'll be glad you did.

Revoking access

SMAQ never holds permanent access to your platform. To revoke:

  • OAuth platforms: revoke from the platform's app permissions (Google Account, Meta Business Suite, etc.). Your SMAQ connection will fail on next refresh and prompt you to reconnect.

  • API key platforms: regenerate or delete the API key in the source platform.

  • From SMAQ: open the connection, click Delete. The connection and any datablocks built on it are removed.

Troubleshooting

  • "Connection failed" after OAuth — usually a scope or account-access issue. Re-run the flow and double-check you're authorizing with an account that has access to the right ad account / property / page.

  • Data looks stale — refresh the connection from the Data Source list (look for the refresh icon on the connection card).

  • Need to swap accounts — easier to delete and re-add than to edit the connection.

If you hit something the per-integration guides don't cover, email [email protected].

Last updated