Bulk Management Datasource Connections

This article outlines the details specific to updating the Data Source Connections table CSV.

Bulk Management Datasource Connections

There are several actions that can be taken through the Bulk Management feature for this section: 

  • Add a net new data source connection to existing accounts
  • Update a current data source connection
  • Delete existing data source connections within the existing rows

📘

An action that you cannot manage through this function is adding new accounts or editing the settings of those accounts. This is a separate function; see the article for Accounts and Account Settings in order to update/add/delete accounts._

Data Table Columns

Each row in the information table represents one existing data source connection, and the table contains columns that allow for the following:

Column HeaderDetails
ActionAccepted Values: ‘Add’ : to be used when a new row is being included in the file, symbolizing a new data source connection for an existing account ‘Update’ : to be used when an already existing row is being updated in some way ‘Delete’ : to be used when a data source connection for an existing account should be removed as a connection ‘Ignore’ : to be used if nothing should be done with the row. Leaving the cell blank is also accepted, defaulting to “ignore”
Company NameName of the account that the data source connection exists under.
Network TypeThe following network types are currently supported and accepted through the bulk management feature. If a value exists here that is not included in the following list, an error will be returned:  Google Analytics Google Analytics 4 (GA4) Google Ads Facebook Ads Facebook Insights Bing Ads Google My Business Simpli.fi Google Display & Video 360 Google Campaign Manager Google Search Ads 360 Google Ad Manager SearchConsole LinkedIn LinkedIn Organizations CallRail Instagram Business Profile Snapchat Twitter Ads Twitter Organic YouTube Organic
Agency-Level Network NameThis is the unique name given to the network at the Agency level.
Advertiser-Level Data Source Connection IDThe unique ID for an existing data source connection. This is not required when adding a new data source connection since a unique ID has not been given yet by the system. This ID needs to remain for those existing data source connections that you wish to update otherwise the system will not find a match to an existing data source connection.
Advertiser-Level Data Source Account ID (Option 1)This is one option for connecting a unique account from the network to the appropriate NinjaCat account. To see the accepted formats per accepted Network Type see the table below.
Advertiser-Level Data Source Account Name (Option 2)This is another option for connecting a unique account from the network to the appropriate NinjaCat account. To see the accepted formats per accepted Network Type see the table below.
FLEX Advertiser-Level Data Source Account ID (Required if Special Case)In some cases, the system requires an additional unique element in order to connect the account from the network to the appropriate NinjaCat account. These are considered “Special Cases” and are only required for certain network types. This is outlined in the table below along with the other accepted formats per Network Type.
Description (Optional)An optional name for the data source connection. If no value is given, will default to the Network Type.
Mapping Name (Optional)Accepted values: ‘Primary’ or the already given name of an existing mapping at the network level. ‘Primary’ data source connection can only exist one time per account for that Network Type. If more than one exists according to the file, an error will be thrown. A mapping name must be an exact match to what already exists, or a match will not be found and an error will be thrown. New mappings cannot be created upon import.
Earliest Reporting Date (Optional)If no value is given for this optional field, then the system will default to the given value at the network level (if there is one). Otherwise, this is to be treated as an override of the given value at the network level if it needs to differ for this particular data source connection.
Latest Reporting Date (Optional)If no value is given for this optional field, then the system will default to the given value at the network level (if there is one). Otherwise, this is to be treated as an override of the given value at the network level if it needs to differ for this particular data source connection.

Designating Datasource Connections

In the table below you will find the accepted options per Network Type. In most cases, you have 2 options of formats to get a particular data source connection added to an account. Except for the Network Types that are noted with asterisks in the first column, the following options are allowed: 

  1. Advertiser-Level Data Source Account ID (Option 1): If you choose to add a data source connection with this first option, then it must be an exact match to what exists in the ‘Value’ column provided to you through the Download Account List CSV button of an existing data source connection of that Network Type. Some users may already have these IDs stored on their end, so they could use what you have already instead of this file for reference, as long as it's the same matching ID!
  2. Advertiser-Level Data Source Account Name (Option 2): If you choose to add a data source connection with this second option, then you have a little more flexibility in what can be included here. It can be an exact match to the ‘Text’ column of the “Download Account List CSV” file, or it can be any form of that name. It’s suggested to include as unique as possible value to the account you’re attempting to connect to. As an example, in the below listed ‘9876543210 : Starbucks-Denver Location,’ the system could accept the following options, but isn’t limited to this list: 
  • 9876543210 : Starbucks-Denver Location

  • 9876543210

  • Starbucks

  • Starbucks-Denver

In either of the above options, if the system cannot find a match to an account in the given network, then an error will be returned for that row. If the second formatting option is being utilized and the system finds multiple match options based on the given value, an error will be returned and will display the options that the given value could match. It is then up to the user to then correct these errors.


List of Supported Network Types

For the few Network Types that are noted with asterisks, you will find additional instructions within the row on what is required in those cells. Some may require the use of the ‘FLEX Advertiser-Level Data Source Account ID (Required if Special Case)’ column.

Network TypeAdvertiser-Level Data Source Account ID (Option 1)Advertiser-Level Data Source Account Name (Option 2)FLEX Advertiser-Level Data Source Account ID (Required if Special Case)
Google Ads9876543210|0123456789
Google Ads9876543210 : Starbucks-Denver Location
Google Analytics**9876543210 **Profile IDUA-654321-1 **UA Code
Google Analytics**Account ID: 123456, Property : UA-654321-1 https://bestbusinessever.com, Profile: 987654321 BestBusinessEver
Google Analytics 49876543210
Google Analytics 4bestbusinesserver.com - GA4 : 9876543210
Facebook Ads01234567891011–-
Facebook AdsStarbucks - Denver Location
Facebook Insights01234567891011
Facebook InsightsStarbucks - Denver Location
Bing Ads1234567
Bing AdsStarbucks - Denver Location
Google My Businessaccounts/01234567891011121314/locations/41312111019876543210
Google My BusinessStarbucks - Denver, CO (S123) - 321 Speer Blvd Denver CO
Simpli.fi123456|654321
Simpli.fiSTAR123 (Starbucks of Denver CO) (123456|654321)
Google Display & Video 360123456789 **Only 1 Option
Google Campaign Manager1234567|7654321
Google Campaign ManagerStarbucks Denver Location
Google Search Ads 360**123-456-7890 **Advertiser ID098-765-4321 **Agency ID
Google Ad Manager5060022406 **Property Text7675 **Account Value
Google Ad Manager123 STARBUCKS - 0123456789
SearchConsolehttp://bestbusinessever.com
SearchConsolehttp://bestbusinessever.com
LinkedIn123456789
LinkedInStarbucks Denver
LinkedIn Organizationsurn:li:organization:12345678
LinkedIn OrganizationsStarbucks Denver
CallRailMCD1234c567d8910fe112134d1556g98765|COM9846b3216fe98710g8949b0506g54321
CallRailBest Agency Ever - Starbucks Denver
Instagram Business Profile01234567891011121
Instagram Business ProfileStarbucks Denver / 01234567891011121
Snapchat1234ab12-34cd-1234-a567-8abc90de1a00
SnapchatOrg: NinjaCat Ad Account: NinjaCat
Twitter Ads12ab34c56d7
Twitter AdsBest Agency Ever
Twitter Organic
Twitter Organic
YouTube OrganicABC__1dEFgHIjKlMNo2pQRXT