On Creatopy, you can create and deliver one ad for your products by adjusting the Ad Tag to control which ad variant you want to show your audience. Below, you'll find a scenario on how to do this using the Feed, Ad Serving, and Google Sheets.
Set up your CSV
- Create your spreadsheet using Google Sheets¹.
- Input the data in your spreadsheet. In addition to the information in the CSV, a column with the Product ID is mandatory, as this will help you adjust which product you want to show to your audience.
- Go to File > Share > Publish to web.
- On the Publish window, go to the Link section.
- Select the sheet you want to be published.
- Set the spreadsheet as Comma-separated values (CSV).
- Copy the link and save it for later.
Import the Feed in Creatopy
- Head over to the left sidebar, and select
Feed.
- Select Create feed.
- Click on Import feed.
- A pop-up window will open, where you can go to the Sync from URL tab.
- Paste the CSV saved from earlier.
- Click on Confirm link.
- From the Target ID section, select the column that contains your Product IDs.
- Click Import content.
- Click Apply feed.
Bind the Feed with your Creative
- Select the layer from your design.
- Head over to the Properties bar.
- Click the
Diamond icon to connect a layer property to your feed's variables.
Set up and Adjust the Ad Tag code
- Enable Ad Serving.
- Obtain the Ad Tag code of your design. Choose one of the two:
- Download as XLS. A Spreadsheet is downloaded to your computer where you can copy the Ad Tag.
- Copy code. Copy the Ad Tag directly from Creatopy.
- Before uploading the Ad Tag, adjust the macro code as follows:
- In the "targetID" column, replace {TARGET_ID} with a value from the Product ID column from the CSV. In this scenario, we showcased the Organic Cotton T-shirt and replaced {TARGET_ID} with 3, as that's the value representing the t-shirt in the Product ID column.
- Copy the adjusted code into your Ad Network of choice as a 3rd party tag.
Note¹: You can use any spreadsheet software to input your data. Additionally, you can use any of these platforms to source your data from a CSV file.