This article outlines the details specific to updating the Data Source Connections table CSV. 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
NinjaNote: 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.
Section Links
Designating Datasource Connections
List of Supported Network Types
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 Header |
Details |
Action |
Accepted 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 Name |
Name of the account that the data source connection exists under. |
Network Type |
The 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 Organizations CallRail Instagram Business Profile Snapchat Twitter Ads Twitter Organic YouTube Organic |
Agency-Level Network Name |
This is the unique name given to the network at the Agency level. |
Advertiser-Level Data Source Connection ID |
The 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:
- 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!
- 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 Type |
Advertiser-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 Ads |
9876543210|0123456789 |
– |
– |
Google Ads |
– |
9876543210 : Starbucks-Denver Location |
– |
Google Analytics** |
9876543210 **Profile ID |
– |
UA-654321-1 **UA Code |
Google Analytics** |
– |
Account ID: 123456, Property : UA-654321-1 https://bestbusinessever.com, Profile: 987654321 BestBusinessEver |
– |
Google Analytics 4 | 9876543210 | ||
Google Analytics 4 | bestbusinesserver.com - GA4 : 9876543210 | ||
Facebook Ads |
01234567891011 |
– |
–- |
Facebook Ads |
– |
Starbucks - Denver Location |
– |
Facebook Insights |
01234567891011 |
– |
– |
Facebook Insights |
– |
Starbucks - Denver Location |
– |
Bing Ads |
1234567 |
– |
– |
Bing Ads |
– |
Starbucks - Denver Location |
– |
Google My Business |
accounts/01234567891011121314/locations/41312111019876543210 |
– |
– |
Google My Business |
– |
Starbucks - Denver, CO (S123) - 321 Speer Blvd Denver CO |
– |
Simpli.fi |
123456|654321 |
– |
– |
Simpli.fi |
– |
STAR123 (Starbucks of Denver CO) (123456|654321) |
– |
Google Display & Video 360 |
123456789 **Only 1 Option |
– |
– |
Google Campaign Manager |
1234567||7654321 |
– |
– |
Google Campaign Manager |
– |
Starbucks Denver Location |
– |
Google Search Ads 360** |
123-456-7890 **Advertiser ID |
– |
098-765-4321 **Agency ID |
Google Ad Manager |
5060022406 **Property Text |
– |
7675 **Account Value |
Google Ad Manager |
– |
123 STARBUCKS - 0123456789 |
– |
SearchConsole |
http://bestbusinessever.com |
– |
– |
SearchConsole |
– |
http://bestbusinessever.com |
– |
|
123456789 |
– |
– |
|
– |
Starbucks Denver |
– |
LinkedIn Organizations |
urn:li:organization:12345678 |
– |
– |
LinkedIn Organizations |
– |
Starbucks Denver |
– |
CallRail |
MCD1234c567d8910fe112134d1556g98765||COM9846b3216fe98710g8949b0506g54321 |
– |
– |
CallRail |
– |
Best Agency Ever - Starbucks Denver |
– |
Instagram Business Profile |
01234567891011121 |
– |
– |
Instagram Business Profile |
– |
Starbucks Denver / 01234567891011121 |
– |
Snapchat |
1234ab12-34cd-1234-a567-8abc90de1a00 |
||
Snapchat |
|
Org: NinjaCat Ad Account: NinjaCat | |
Twitter Ads |
12ab34c56d7 |
||
Twitter Ads |
|
Best Agency Ever | |
Twitter Organic |
|
||
Twitter Organic |
|
||
YouTube Organic |
ABC__1dEFgHIjKlMNo2pQRXT |
||
|
Comments
0 comments
Article is closed for comments.