Integrations

MySQL Integration and PostgresSQL Integration

• When selecting SQL as a network you have two different Sql types to choose from: MySQL and PostgreSQL
• "Custom SQL" is the data source in the template editor and behaves identically to that of the Custom Data datasource
• Configuration of the mapping is similar to that of like our other mapping networks.

BigQuery Integration

• "Custom SQL" is the data source in the template editor and behaves identically to that of the Custom Data datasource
• Configuration of the mapping is similar to that of like our other mapping networks.
• This is a Google OAuth network

Reach Local

• Direct connection OAUTH - meaning NinjaCat does the authorization for clients.
  • Client's will have to set up for each account at the agency and advertiser level for every campaign.
    • This implies that campaign grouping will not be available but mapping options are.
  • Reach Local can only be deleted from Agency and Account levels. There is no revoking token options.
  • The following dimensions only provide totals per period.
    • Age, Gender, Device, Keyword
    • When viewing data with these dimensions you will not be able to view these by day, only the the total will display and the date will display as the final day of the date period/range (If you are set to show last month you will only see 2/28/2018).

Improvements

Add link to referral program

• This link will not be available with Sub Agencies.
• Anyone with the "Contact NinjaCat" permission will see the link:
  

Bugs

Hubspot Integration

• If the campaign name can not be determined, all of the data will be associated with the campaign name "Deleted Campaign"
• "Deleted Campaign" are campaigns that were actually deleted that used to throw an error and the blank ones are that way because that is how it comes back from Hubspot.

Add "Ad Final URL" and "Ad Mobile Final URL" dimension to Yahoo Gemini Integration

Yelp help text - Advertiser network connection needs text for legacy integration

• Added text to indicate that the Yelp Reviews integration is currently available for Legacy reports only.

Reporting - Adwords- error with "VideoQuartile100Rate"

Bing Ads only shows the first 1000 accounts

• When adding a Bing Ads network to an Advertiser there is now a maximum of 5,000 Accounts allowed.

Comparing "previous month" when in February to January is only comparing 28 days of Jan and not all 31 days

Constant Contact date filter using wrong attribute

• The correct dates are now being returned.

Legacy Facebook Insights: Undefined variable key

• No data was being returned in Facebook Insights widgets in our Legacy PDF reports.