Once you save or update a table, you can change the table and column names or add new columns, but you can't change a column type.
If you change the name of a business data table or column, keep the following notes in mind:
- If the table is included by other business data tables, Search Ads 360 will automatically update all business data tables to refer to the new name.
- If you're using business data in a formula column, Search Ads 360 does not update the formula column. Instead, the formula column will return an error the next time you view it in a report.
To change a table or column name or add a new column:
-
Navigate to an advertiser.
Steps for navigating to an advertiser-
Click the navigation bar to display navigation options.
-
In the "Agency" list, click on the agency that contains the advertiser. You can search for an agency by name or scroll through the list.
-
In the "Advertiser" list, click on the advertiser.
-
Click Apply or press the Enter key.
Search Ads 360 displays the advertiser page, which contains data for all of the advertiser’s engine accounts.
-
-
In the left navigation panel, click Business data.
-
Select the checkbox next to the name of the business data table and click the Edit details... button.
-
Change the name of the table or of a column.
-
Optionally add more columns:
-
Click the Add column button.
-
Select a data type.
The data type list contains the basic data types as well as one entry for each business data table in your advertiser. To include a reference to another table, select the table from the list. -
Enter a name for the column.
To remove a column that you've just added, click Remove.
-
-
Click Save.