June 25, 2018: Intelligent Data Warehouse, New Integrations, Bug fixes+ more!

New Integrations

Salesforce Integration

DoubleClick for Publishers

Advice Local

• This API does not have dates so you will not see the date range option as well as no options for comparisons.

Media Math integration

Adobe Ad Cloud/TubeMogul

Listrak Integration

New Features / Improvements

Intelligent Data Warehouse

• Downloads and stores dashboard and report data on a daily basis
• Reports and dashboards will be faster and more reliable
• APIs that have strict quota limitations will be more reliable
• Unique calculations such as Facebook Reach, frequency, etc. will now report accurate totals
• Methods for calculating weighted averages were improved.

Upgraded Hardware Infrastructure and added system redundancy

• Increased reliability of the app and web servers
• Added redundancy to application servers to prevent system outages
• Added web servers to improve performance and reduce processing time.

Improved performance of Google Sheets

Facebook Ads Additions:

• New metrics added:
  • Landing Page View
  • Offsite_conversion.fb_pixel_custom
  • Onsite_conversion.messaging_conversation_started_7d
  • Outbound_click
  • Instagram_profile_engagement
  • App_custom_event
  • Initiate_checkout
  • Add_payment_info
  • Add_to_wishlist
  • lead

DoubleClick Bid Manager additions:  

• New dimensions added:
  • Age
  • Trueview Age (video)
  • Gender
  • Trueview Gender (video)
• New Metrics added:
  • Video Starts
  • Trueview Views (Video)
  • Trueview Rate (Video)
  • Trueview View Through

LinkedIN additions:  

• New dimensions added:
  • Conversion
  • Share
  • Card Index
  • Campaign Group
• New Metrics added:
  • Card Clicks
  • Card Ctr
  • Card Impressions

Hubspot Integration upgraded to V2

Google My Business API upgraded to 4.0

• New Dimensions added:
  • Post dimension added

Instagram Business Profile improvements

• New Metrics added:
  • Follower count
  • Phone call clicks
  • Profile reach
  • Profile views
• The above metrics are only compatible with the dimensions under the "aggregate" section

Reach Local lead details report

• "Lead Details" has been added as a Report Data Source to the Reach Local integration.
• Users can select to report on "Lead Details" from the dropdown in the template editor when using Reach Local.

Improved the way charts work with hidden dimensions

• You are now able to include as many "hidden" custom dimensions as you would like to your widgets.  These dimensions will be hidden from the end output in the widgets
• If the user has exceeded the number of visible items by unhiding their hidden dimensions, then the dimension will have an error message stating that they have exceeded the number of dimensions/metrics and will not be able to save the template until they have corrected their actions.

Version 2 Dashboards have single loading icon

• Instead of previously having a loading icon appear for each single widget, there is only 1 loading icon per each dashboard tab for the first 5 seconds; after 5 seconds, each widget will have its own loading icon (if not already loaded).

Access to Dashboard via Login Credentials

• A user may now bookmark their auto-login dashboard link that they have received by email without ever having to login. This feature is only accessible by speaking with support or your customer success manager.

Reach Local lead details report

• "Lead Details" has been added as a Report Data Source to the Reach Local integration.
• Users can select to report on "Lead Details" from the dropdown in the template editor when using Reach Local.

Bug Fixes

CSV export shifts values over due to the extra comma

• Previously if one of the columns in a report had a comma or an apostrophe, it would push the rest of the data in the spreadsheet to the next column showing incorrect data.  All CSV export fields that may have characters that may cause problems are now surrounded with double quotes (").

FB Link Click CTR is now showing correct Total Row value in a table

• In addition to fixing the calculation for Link Click CTR, the following metric calculations have been fixed as well:
  • Outbound Clicks CTR
  • Website CTR
  • Cost / Unique Outbound Click
  • Cost / Outbound Click
  • Cost / Inline Post Engagement
  • Cost / 10 sec Video view
  • Cost / Unique Inline Link Click
  • Unique Inline Link Click CTR
  • Cost / Unique Click
  • Unique CTR
  • Cost / inline Link Click
  • Cost / inline Link Click

BrightRoll User Authorization Issue

Extended Dynamic Search Ads - missing dynamic generated headlines and URLs

Facebook: Post Consumption Photo View incorrect

DCM comparisons not working

Campaign Filtering in TTD Scorecards

Unhandled LinkedIn API Error

First Quartile and Third Quartile Views are defaulted as Percentages in DBM

• These metrics are now displaying as integers

Facebook Insights City / Cities Dimension

• Countries and Cities are now in separate compatibility groups and not compatible in the same widget.

Dynamic Search Ads not formatting correctly

Legend in Pie Chart still limited to 20 characters

• Within the legend Styles tab, there is now a field "Legend Item Character Length" that exists for all charts, including pie charts.
• The default Character Limit for all pie charts is set to 20
• For all other charts, the "Legend Item Character Length" field will be blank which shows the maximum number of characters
  

Improve DoubleClick Bid Manager 'DoubleClick Bid Manager Account ID' Help Text

• The previous field "DoubleClick Bid Manager Account" has been slightly altered to better assist users in finding the required advertiser ID in the DBM platform
  
  

Google My Business Reviews - does not respect date filters

Dashboard V2 error - Call tracking tabs not being hidden

• A template with CT data will only show if it has data associated to that account

Twitter and Facebook Insights not Aggregating Correctly

ReachLocal API - Keyword report,  paging not implemented.

• Paging was implemented, all data is now returning in the keyword report.

Sourcing Updates | Issues with Saving "Assign Source" As PPC or SEO

• When changing the assign source to any value, after saving the tracking number the value will retain and not revert back to the provider-source
• If the assign source field is left blank for dynamic pools, than the assign source field will show the respective value by default.

Facebook Insights Page Impressions Organic metric discrepancy when looking at different date range

Analytics Cost / Conv. metric causes data to zero out when using source / medium filter

Facebook Ads Website Clicks + Pixels now showing correct data

Updated Budget Now Correctly Showing on New Dashboard

Background color for a widget

• Custom color selection in a widget is no longer being ignored

Facebook Insights Page Impressions Organic metric discrepancy when looking at different date range

Analytics Cost / Conv. metric causes data to zero out when using source / medium filter

Yahoo Gemini - Margins are now being applied correctly

Twitter Ads Media Engagement Metric shows zeros across the board

Mailchimp: new calculated openRate returns values over 100%

Dates are not being consolidated if multiple data sources are being used

• This issue mainly affects the case where there was date consolidation and dimension filters being used.  Previously, rows were not being consolidated but rather showing separately. This has now been resolved

Changing an Agency's Time Zone Triggers Scheduled Reports

• Changing an agency default time zone will no longer trigger scheduled report to kick off.  It will only kick off any scheduled reports that are supposed to due to changing the agency's timezone.

Data Discrepancies & Error with Roll Up PDF Report and Dashboard (Qiigo)

Vendasta metrics "citation" and "positive/negative reviews" are no longer compatible

• The "citations" metric only works in scorecards.  The vendor API does not even support it in tables or charts for any dimensions used except "account" as it is not really considered to be a real dimension as it gets generated on our side.
• The "citations" metric can now appear alongside "Negative Reviews" as well as "Positive reviews  within the scorecard widget.

Mailchimp: new calculated openRate returns values over 100%

Dates are not being consolidated if multiple data sources are being used

• This issue mainly affects the case where there was date consolidation and dimension filters being used.  Previously, rows were not being consolidated but rather showing separately. This has now been resolved

Remove the filter behaviour dropdown

• The filter behaviour dropdown has been removed.  Previously we had "remove rows", "Zero out rows" and "default" options.  The reason for doing this is that RDW does not support the "Zero out rows" behaviour.
  • It was previously used to "Zero out rows" in order to "fill in dates" but RDW does that automatically so it removes this case scenario.  Additionally, it would be difficult to replicate the "zero out data" behaviour in our data warehouse.
  • Since everything will use our data warehouse, all filter will use the "remove rows" behaviour.

Change 'Table General Font Style' to 'Text Table Style' in Template Editor

• 'Table General Font Style' under Typography for Global Style Settings has been changed to 'Text Table Style'
• 'Table General Font Style' under General for the Text Widget has been changed to 'Text Table Style'