How to Replace Ad Values in Ads Manager Pivot

Updated

4 months ago

SUMMARY

This article will cover the advanced Replace Value From Table capability which is a powerful tool that allows you to quickly edit and swap/replace values in seconds .

Replace Value from ads manager pivot

On the Ads Manager Pivot window, hover over the Options icon alongside the desired ad entity whose values you want to replace and select View and Edit.
Now check the boxes alongside the desired entities that are performing well from your Pivot Table.
From the Edit panel at the bottom of the Pivot Table, click View & Edit.
The Edit pane will open up to the right. Based on the values you want to replace for your ad entity, click Replace from Table below each field that supports the replace capability. For more information, see Replace from Table — Supported Fields.

For instance, if you are at the Ad Set level, scroll down to the Audience section and click Replace from Table below the fields whose values you want to replace (ex. Custom Audiences, Age Range, Gender, etc.).

Note

The Replace from Table option will be shown only if the selected dimension contains that field. For example, if an Audience is selected from the table, then at the Ad Set level, only the values that are available in the currently selected audience will have the Replace from Table option.

Tip

Click the Add Creative or Add Audience option alongside the Creative or Audience section respectively and select Replace from Table to replace the entire Audience or Creative details.

5. Select Replace from Table

6. Select the values from the drop-down menu showing the different values you can replace with based on the selected entities in the Pivot Table.
Select values from the Replace from Table drop-down

7. Once you have made the necessary changes, click Review Changes in the bottom-right corner of the Edit pane.

8. On the Review Changes window, you can glance over the updates. Click Apply Changes in the bottom-right corner to publish your campaign.

Caveats

Term	Caveat
Cross Channel Entities	Cross channel entities are not supported. All the values need to be of the same channel.
Replace from Table
Replace from Table Dimensions	Only the following dimensions will have the option to Replace from Table: Click to view the Dimensions Creative Name Landing Page URL Call to Action (Pivot) Headline (Pivot) Body (Pivot) Image (Pivot) Video (Pivot) Destination (Pivot) Lead Form Name Sprinklr Audience Name Sprinklr Audience Group Sprinklr Campaign Id Reporting Benchmark Devices (Pivot) Excluded Devices (Pivot) Operating System (Pivot) Country (Pivot) Ad post
Website URLs	Replace from Table is not supported.
Location Customization Language Customization Slideshow Formats	Replace from Table is not supported.
Audiences	You can either select Audience Groups or individual audience values to replace from the table.
Existing Snapchat Creatives	Replace from Table is not supported for editing existing Snapchat creatives.
Custom Fields	You will only be able to replace the values for all custom fields. Replacing individual custom fields is not possible as there could be dependent custom fields.
Dependent Fields	The child properties of the dependent fields will NOT be automatically added/changed. For example, if you select the Operating System dimension from the table, only the Operation System field will have the Replace from Table option. The OS Version or Device will not be automatically added/changed.

Replace from Table — Supported Fields

Channel	Fields
Campaign
All Channels	Naming Convention Sprinklr Campaign Budget Source Benchmark Campaign Properties section
Ad Set
All Channels	Entire Audience (replace option) Audience Naming Convention
Facebook, Pinterest, LINE, TikTok	Custom Audience
Facebook, Twitter, LinkedIn, Pinterest, Snapchat, LINE, TikTok, Nextdoor	Location
Facebook, Twitter, Pinterest, Snapchat, LINE, TikTok, Nextdoor	Age Gender
Facebook, Twitter, LinkedIn, Pinterest, Snapchat, TikTok	Language
Facebook, LinkedIn	Detailed Targeting (include, exclude, narrow)
Facebook, Twitter, LINE, Nextdoor	User OS
Facebook, Twitter, Snapchat	OS Version
Facebook, Twitter, Pinterest, Snapchat	User Device
Facebook	Excluded User Device Excluded Categories Excluded Publisher List Ids Account Level Block List Product Set Connections Friends of people who liked your app or page Exclude people who liked your app or page
Facebook, Twitter, LinkedIn, Pinterest, Snapchat, TikTok, Nextdoor	Placement section
Twitter	Tailored Audience Expanded Audience Flexible Tailored Audiences Network Operator Similar to followers of user Engagement Type Campaign Engagement User Engagement Tv Markets Movies and TV Shows Event Conversation Domain Name IAB Categories Campaign Conversion Pixel Double Click Tracking Tag
Twitter, Pinterest	Keywords
Twitter, Pinterest, LINE, TikTok, Nextdoor	Interests
LinkedIn, Snapchat	Tracking Pixel
Pinterest	View Tag URLs
Snapchat	Location category Advanced demographics Predefined audiences Device Carrier
Snapchat, TikTok	OS Type Connection type
LINE, TikTok	iOS Version Android Version
Nextdoor	Neighborhood Homeownership Household Income
Ad Variant
All Channels	Entire Creative (replace option) Creative Naming Convention Web Analytics Media Text Web URL Headline Link Description URL Shortener Branded Content Display URL CTA Tracking Pixel URL parameter Mobile App Event Tracking Offline Event Set Ad Variant Properties section
LINE	Click URL
Pinterest	Board Destination URL Android Deeplink iOS Deeplink
Facebook, Pinterest	View Tag URL
LinkedIn, Snapchat, Nextdoor	Impression Tag URL
Snapchat	Swipe Up Tag URL
LinkedIn	Click Tag URL
TikTok	Click Tracking URL Video View Tracking URL
Nextdoor	Brand Logo Business Name Offer Text Business URL

How to Replace Ad Values in Ads Manager Pivot

SUMMARY

Caveats

Replace from Table — Supported Fields

Was this article helpful?

Related Articles