June 2018link
Account Managementlink
Account Owners (replaced by Account Administrators) can now manage your warehouses and permissions in your new account management view. Learn more in our Account Management documentation.
Restrict Auth Typelink
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 connectorslink
Google Cloud Functionslink
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. See our Google Cloud Functions documentation.
Pinterest Adslink
The connector syncs Pinterest advertising meta-data related to Campaigns, AdGroups, Pin Promotions etc.
Link to Pinterest Ads Account documentation
Sharded MongoDBlink
Sync a Sharded MongoDB cluster with automatic node discovery and roll-over.
Link to Sharded MongoDB documentation
Schema changeslink
AdRolllink
AdRoll has deprecated the errors
and has_errors
fields, so we no longer support them.
Adwordslink
We no longer support the LABEL_REPORT
report because it does not support date fields.
Apple App Storelink
We have renamed the _fivetran_id
column to _index
in the SALES
and FINANCE
reports.
Facebook Ad Accountlink
We have made continual improvements to make it easier for you to know which of your links was clicked.
We have added a new table, URL_TAG
.
We have added the link_caption
, link_message
, template_caption
, and template_message
columns to and removed the url_tags
column from the CREATIVE_HISTORY
table.
Marketolink
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.
Mavenlinklink
We have added the following tables:
HOLIDAY
PARTICIPATION
HOLIDAY_CALENDAR
HOLIDAY_CALENDAR_ASSOCIATIONS
HOLIDAY_CALENDAR_MEMBSHIP
WORKSPACE_ALLOCATION
WORKSPACE_RESOURCE
WORKWEEK
WORKWEEK_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 |
Mixpanellink
We have added a new table, CAMPAIGN
, which includes campaign names.
Xerolink
We have added the tax_number_name
field to the ORGANISATION
table, if the field is present in the API response.
We have added the account_id
field to MANUAL_JOURNAL_LINE
table, if the field is present in the API response.
Zendesklink
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).
Improvementslink
Apple App Storelink
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.
Link to Analytics Tables documentation
Doubleclick Campaign Managerlink
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.
Mandrilllink
You can now filter your exported data by the specific API keys that you used to send messages.
NetSuite SuiteAnalyticslink
The _fivetran_synced
field will now reflect the actual moment when we insert or update rows, rather than the sync start time.
Log eventslink
Log eventslink
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).
We have added logs for the following applications:
- Adwords
- DoubleClick Campaign Manager
- DoubleClick for Publishers
- DynamoDB
- Facebook Ad Insights
- Front
- Google Analytics
- Google Sheets
- HubSpot
- LinkedIn Ad Analytics
- Mandrill
- Marketo
- Optimizely
- Quickbooks
- Recharge
- Sailthru
- Segment
- Stripe
- Xero
- Zendesk Support
- Zendesk Chat
- Jira
- Github