June 2018
Account management
Account Owners (replaced by Account Administrators) can now manage your destinations and permissions in your new account management view. Learn more in our Account Management documentation.
Logs
Log events
We no longer support read_start and read_end log event values.
We can now load all of your log event data into a single column (packing).
Logs support
We have added logs for the following applications:
- Adwords
- Amazon DynamoDB
- DoubleClick Campaign Manager
- DoubleClick for Publishers
- Facebook Ad Insights
- Front
- GitHub
- Google Ad Manager
- Google Ads
- Google Campaign Manager 360
- Google Sheets
- HubSpot
- Jira
- LinkedIn Ad Analytics
- Mandrill
- Marketo
- Optimizely
- QuickBooks
- Recharge
- Sailthru
- Segment
- Stripe
- Xero
- Zendesk Support
- Zendesk Chat
Restrict authentication type
You can now restrict your account's authentication type to Google OAuth or SAML. You can configure your authentication type on the Settings tab in the account management section of your dashboard.
New connectors
Google Cloud Functions
Google Cloud Functions is a serverless computing platform that runs code in response to events and automatically manages the compute resources required by that code.
Read our Google Cloud Functions documentation.
Pinterest Ads
The Pinterest Ads connector syncs Pinterest advertising meta-data related to Campaigns, AdGroups, Pin Promotions etc.
Read our Pinterest Ads connector documentation.
Sharded MongoDB
We now support MongoDB sharded cluster.
For more information, see our MongoDB Sharded Cluster setup instructions.
Schema changes
AdRoll
AdRoll has deprecated the errors and has_errors fields, so we no longer support them.
Apple App Store
We have renamed the _fivetran_id column to _index in the SALES and FINANCE reports.
Google Ads
We no longer support the LABEL_REPORT report because it does not support date fields.
Kantata
We have added the following new tables:
HOLIDAYPARTICIPATIONHOLIDAY_CALENDARHOLIDAY_CALENDAR_ASSOCIATIONSHOLIDAY_CALENDAR_MEMBSHIPWORKSPACE_ALLOCATIONWORKSPACE_RESOURCEWORKWEEKWORKWEEK_MEMBERSHIP
We have added new columns in the following tables:
| TABLE | NEW COLUMN(S) |
|---|---|
| ESTIMATE | updated_at |
| ESTIMATE_SCENARIO | created_at, updated_at |
| ESTIMATE_SCENARIO_RESOURCE | created_at, updated_at |
| RATE_CARD | created_at, updated_at |
| STORY_ALLOCATION_DAY | created_at |
| STORY_STATE_CHANGE | updated_at |
Marketo
We have added a new table, EMAIL_TEMPLATE_HISTORY.
All activity tables related to emails (for example, ACTIVITY_SEND_EMAIL, ACTIVITY_EMAIL_DELIVERED, etc.) now have a foreign key relationship to the EMAIL_TEMPLATE_HISTORY table.
Mixpanel
We have added a new table, CAMPAIGN, which includes campaign names.
Xero
We now add the tax_number_name column to the ORGANISATION table, if the field is present in the API response.
We now add the account_id column to the MANUAL_JOURNAL_LINE table, if the field is present in the API response.
Zendesk Support
We have added two new columns, start_time_utc and end_time_utc, to the SCHEDULE table. These two columns make it easier to calculate ticket metrics that depend on working hours. The column units are minutes from Sunday at midnight UTC. For example, a column value of 720 is equivalent to Sunday at noon UTC because it is 720 minutes later than Sunday at midnight (12 hours * 60 minutes).
Improvements
Apple App Store
We have added App Analytics for Apple App Store. We can now fetch apps, app analytics, and retention data for all of your iTunes apps. For more information, see our Analytics Tables documentation.
Google Campaign Manager 360
Google has changed their retention period for Floodlight reports from 540 days to 62 days, so we will now fetch data starting from 62 days back.
Mandrill
You can now filter your exported data by the specific API keys that you used to send messages.
NetSuite SuiteAnalytics
The _fivetran_synced column will now reflect the actual moment when we insert or update rows, rather than the sync start time.