search

file-exportData Exports

Once you have connected your data sources and BigQuery data warehouse to Weavely, you can set up data exports to begin transferring data into your data warehouse. Follow the steps below to configure exports and manage your datasets.

hashtag
Access Data Export Settings

  1. Go to the Data tab in Weavely.

  2. Check if BigQuery is connected. If it is not, you will see a warning, and you can click on it to navigate directly to the data warehouse connection settings.

hashtag
Configure Export Schedule

  1. Review the current export schedule at the top of the page (default is daily at 4 a.m. GMT).

  2. Adjust the schedule and time zone as needed to fit your reporting requirements.

hashtag
Select and Enable Data Tables for Export

  1. In the Export section, you’ll see all available integrations and their associated data tables.

  2. For each integration (e.g., Google Ads), expand to view available tables, such as the Campaigns table.

  3. View the dimensions and metrics for each table. To enable a table, toggle it on. Once enabled, Weavely will:

    • Perform an initial backfill of data (up to two years where available).

    • Pull recent data first, followed by historical data, which can take a few minutes to several hours depending on dataset size.

hashtag
Verify Data in BigQuery

  1. Switch over to your BigQuery project to confirm data export.

  2. For each integration, Weavely creates a new dataset with the prefix “Weavely,” such as Weavely Google Ads or Weavely Microsoft Ads.

  3. Within each dataset, enabled tables will appear, allowing you to view the schema and preview the data.

circle-info

Note that every table will have a compiled_view created for it — this is the table you should connect to as it will ensure all data is deduplicated.

hashtag
Special Dataset: Weavely Clients

  • Weavely Clients is an automatically generated dataset containing client information and metadata. This includes:

    • Client Information: Name, industry vertical, spend model, and more.

    • Mapping Table: Maps Weavely’s client and data source IDs to external IDs (e.g., Google Ads ID, Microsoft Ads ID) for use in cross-channel reporting.

This mapping allows you to combine data across platforms (e.g., Search Console and Google Ads) by joining on the client ID.

Your data exports are now set up, and you’re ready to build cross-channel reports with a unified dataset.

PreviousBigQuery SetupNextDashboards

Last updated