Skip to main content
Last updated: March 18, 2026
Some platforms have settings that affect how data is fetched and reported. These are configured per table and appear in the Platform Options section of the table editor.

​
Meta Ads

​
Click Attribution Window

Controls how many days after a click a conversion is attributed to the ad. Options:
  • 1 day
  • 7 days (default)
  • 28 days

​
View Attribution Window

Controls how many days after a view (impression) a conversion is attributed to the ad. Options:
  • 1 day (default)
  • 7 days
  • 28 days

​
Conversion Report Time

When conversions are counted in your reports:
  • Impression time — Conversions are attributed to the date the ad was shown
  • Conversion time (default) — Conversions are attributed to the date the conversion happened
For most e-commerce and performance marketing use cases, 7-day click / 1-day view with conversion time reporting gives the most accurate picture of campaign performance.

​
Pinterest Ads

​
Click Window

Days after a click that conversions are counted. Options: 1, 7, 14, 30, or 60 days.

​
View Window

Days after a view that conversions are counted. Options: 1, 7, 14, 30, or 60 days.

​
Conversion Report Time

  • Time of ad interaction — Attributed to when the ad was clicked/viewed
  • Time of conversion — Attributed to when the conversion occurred

​
Klaviyo

​
Flow Attribution Model

How revenue attribution is calculated for email flows:
  • Last touch — Revenue attributed to the most recent email interaction
  • First touch — Revenue attributed to the first email interaction

​
HubSpot

​
Entity Type

HubSpot organizes data into entities (object types). When creating a HubSpot table, you select which entity to query:
  • Contacts — People in your CRM
  • Deals — Sales opportunities and pipeline
  • Companies — Organizations in your CRM
Each entity type has its own set of available metrics and dimensions.

​
Association Mode

Controls how related records are joined across entities:
  • Primary — Returns only the primary associated record (e.g., the primary company for a contact)
  • Comma separated — Returns all associated records as a comma-separated string in one row
  • Row expanded — Creates one row per association (e.g., if a contact belongs to 3 companies, you get 3 rows)

​
How Platform Options Affect Your Data

Platform options are applied at the API request level — they change what data the platform returns. This means:
  • Changing attribution windows will change your conversion numbers (because different conversions fall in/out of scope)
  • Changing entity types gives you completely different fields
  • These changes don’t affect data already in BigQuery — only future syncs
If you change platform options on an existing table, consider running a resync to ensure historical data is consistent with the new settings. Otherwise, you’ll have data before the change using old settings and data after using new settings.