March 2021link
Ad Reporting dbt Packagelink
Fivetran has created an ad reporting dbt package that aggregates data from our most popular advertising connectors into a unified table. This dbt package allows you to compare how your ad spend converts into clicks and impressions on each advertising platform.
The ad reporting dbt package supports the following connectors:
- Facebook Ads
- Google Ads
- LinkedIn Ads
- Microsoft Ads
- Pinterest Ads
- Twitter Ads
You do not need to have all six advertising connectors to use this package, though you should have at least two.
Learn more in our ad reporting dbt package documentation.
Diagnostic data accesslink
We now ask you to grant Fivetran access to your data for a 21-day period when we need to troubleshoot or fix your broken connector or destination. You can allow or deny the diagnostic data access as well as revoke it at any time before the access period has expired.
Schema changeslink
Coupalink
We have fixed a bug where the attributes of the EXPENSE_MILEAGE_VEHICLE_TYPE table were added to the separate EXPENSE_TRIP_MILEAGE table. We no longer add the attributes of the EXPENSE_MILEAGE_VEHICLE_TYPE table to the EXPENSE_TRIP_MILEAGE table.
We have renamed the following tables in the Schema tab of your Connector Details page to align them with the source table names:
CHARGEStoCHARGEPROJECT_BUSINESS_GROUP_RELATIONtoPROJECT_BUSINESS_GROUP_MAPPINGPROJECT_USER_RELATIONtoPROJECT_USER_MAPPINGSHIPPING_TERM_BUSINESS_GROUP_RELATIONtoSHIPPING_TERM_BUSINESS_GROUP_MAPPINGUOMtoUNIT_OF_MEASURE
These name changes will not impact your destination tables.
Facebook Ad Accountlink
We have deprecated table ACCOUNT_ATTRIBUTION as Facebook has deprecated the field attribution_spec.
Squarelink
We have added two new tables, CASH_DRAWER and CASH_DRAWER_EVENT. See Square's documentation on cash drawers for more information.
Improvementslink
Facebook Adslink
We have upgraded our Facebook Ads connector from version 7.0 to 9.0 of the Facebook Marketing API and handled deprecations and updates. Learn more about the deprecations and changes in Facebook Marketing API v8.0 changelog and Facebook Marketing API v9.0 changelog.
Frontlink
We have added a new field, author_id, to the MESSAGE table.
Greenhouselink
We have released a pre-built dbt package for Greenhouse. Find the package in Fivetran's dbt hub. Learn more about our dbt integration in our dbt Transformations documentation.
Intercomlink
For all new Intercom connectors created after March 1, we will capture webhook events through the endpoint registered in our OAuth app. This change makes it simpler and faster to set up an Intercom connector. For existing Intercom connectors, we will continue to capture webhook events through the Fivetan endpoint you registered in Intercom during setup.
Mailchimplink
The Mailchimp connector now supports table blocking for all Mailchimp tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.
If you want to sync a child table, you must include the parent table in the sync.
Sailthrulink
The Sailthru connector now supports table blocking for all Sailthru tables. You can now choose which tables to sync and which to block from syncing to your destination. On your Connector Details page, go to the Schema tab and select or deselect the tables.
If you want to sync a child table, you must include the parent table in the sync.
Squarelink
We have updated our OAuth scopes to support the Cash Drawer, Loyalty, and Labor-Shift endpoints of the Square API. You must re-authorize the connector. On your Connector Details page, go to the Setup tab, click Edit connection details, and then click Re-authorize connection. See Square's documentation for more information.