Quick Links
Introduction
With Product Tags you can effortlessly group and organize products in the Sales & Traffic tab, streamlining the review of reports and performance analysis of distinct product groups. You can define your own three product tags, creating customized keys and values.
For instance, keys could include Category, Product Stage, or Target Total ACOS, while values might encompass options like Kids' Shoes, Newly Launched, or 25%.
Assigning these product tags to each ASIN allows you to categorize and organize your products effectively.
In the Sales & Traffic table, you can then group products based on these tags, facilitating easy comparison and analysis of performance across different product groupings.
Moreover, you can assign these tags in bulk to various ASINs, download the table data, and filter the table based on product tags.
This functionality is invaluable for customers who seek to group products by Amazon brand, Amazon category, and common product attributes such as colour, size, or flavour. By doing so, you can generate reports on performance against the budget set for these diverse product groupings, aiding in strategic decisions regarding enabling, pausing, doubling down, or scaling back ads on specific product groups.
Product Tags Spreadsheet Breakdown
Getting your product tags uploaded is just a few steps away. Ensure a smooth process by reviewing the following considerations when editing the spreadsheet: familiarize yourself with the table structure, address any errors promptly, and be prepared for seamless uploading
You have the option to assign up to 3 product tags to each ASIN.
To create a product tag, simply rename the 3“Product Tag #” columns (D, E and F) as you like. For example, to create a Shoe type product tag, simply rename the column name to the “Shoe type” tag.
Enter specific tag values for easy organization of ASIN and filtering. For example, use tags like "Shoe Types" to assign values such as Sneakers, Boots, Sandals, and Flats
If you prefer not to apply any tags to a product, leave the tag cell empty.
Column | Name | What to enter |
|
| |
B | Product Title (Read-Only) | No values are required (Read-Only). |
C | Amazon Brand (Ready-Only) | No values are required (Read-Only). |
|
|
|
|
|
|
H | Error | Instructs on the type of error detected when uploading the file. |
I | Warnings | Instructs on the type of warning detected when uploading the file |
Product Tags Spreadsheet Editing
1️⃣ Edit the Columns D, E, and F with the Tag's name you wish.
Example: Category, Color and Size.
2️⃣ Enter the Tag values you wish to assign to your ASINs to the corresponding row. There is no limit on the number of values.
Example:
Category (Tag) = Shoes, Tape and RedPluot (Values)
3️⃣ Continue editing the file by entering the remaining values for the other 2 Tags.
🚨 Note 🚨
Each ASIN can have a maximum of 1 value assigned for each tag.
Troubleshooting Spreadsheet Errors
The "Errors" column (H) in the spreadsheet provides details on why the file upload failed.
Listed below are several potential errors you might encounter, along with their respective solutions for resolution:
1️⃣ ASIN Does Not Exist
Reason:
You've observed that a product/ASIN is absent from the downloaded list and are attempting to include it using this spreadsheet to apply a tag.Resolution:
Confirm that the product/ASIN you intend to tag already exists in your account. If not, consider adding it by following the guidelines outlined in this article.
This feature is being continuously improved. The above lists will be updated regularly to reflect the current state.
Upload Tags from the Bulk Operation Tab
Access the "Bulk Operations" tab.
In step 1, choose "Bulk Edit & Create" from the "Select Object" drop-down menu, and then select the "Product Tags" option.
Download the spreadsheet by clicking the purple "Download Custom Spreadsheet" button.
Edit the spreadsheet according to the guidelines provided in the "Product Tags Spreadsheet Breakdown" and "Product Tags Spreadsheet Editing" sections of this article.
Upload the edited spreadsheet on Perpetua by selecting the "Select or drag & drop your file" option. As you upload the edited spreadsheet, a new item labelled "Product Tags" will appear in the "Download & Upload History" section, indicating the progress of the upload process.
Upon successful upload, the status of your upload will show as "Complete".
And...done! 🥳
Hover over the tags' badge on your ASIN to view the preview of the applied tags.
🚨 Note 🚨
It can take up to 10 minutes for uploaded changes to take effect in Perpetua.
Upload Tags from the Sales & Traffic Tab
Access the "Sales & Traffic" Tab and navigate your mouse to the "Upload" option, then select "Product Tags".
You will be redirected to the Bulk Operations tab where you can follow the instructions from the Upload Tags from the Bulk Operation Tab section of this article.
Grouping Product Performance by Tags
Access the "Sales & Traffic" tab and click on the "Group by" option to expand the drop-down list. Select one among the applied tags.c
By selecting a tag option, products will be grouped into separate rows based on tag values, consolidating products according to their tags. You can then expand the grouped tag row to view the underlying ASINs associated with it.
Filtering Products by Tags
Access the "Sales & Traffic" tab and expand the drop-down list by clicking on the "Add Filter" option. It will reveal all available tag sets at the bottom:
Select the tag and click on the second empty field below to open up all the available tag values, where you can make multi-selections from the menu.
Once you've chosen the tag values, click "Apply" to confirm the filter.
Your ASINs will then appear on the "Sales & Traffic" dashboard, filtered according to the applied filters. Each selected value among the filters will be visible for reference.
🚨 Note 🚨
The filters applied will be reflected on the values of both the graph at the top and the table at the bottom of the "Sales & Traffic" dashboard.
Download ASIN Report and Amazon Brands Report by Tags
You can export your ASIN Report and Amazon Brand report by tag by using a Daily or an Aggregate Performance:
1️⃣ Daily Performance: create an individual row for each ASIN tag daily performance metrics for the specified date range.
2️⃣ Aggregate Performance: create an individual row for each ASIN tag aggregated performance metrics for the specified date range.
How to Download the report:
Access the "Sales and Traffic" tab.
Choose the desired time range for exporting data and click the "Download CSV" icon.
Select the tag you wish to download the report for and one among the Aggregate or Daily performance report options.
Article last updated March 2024. If you find this information to be out of date, please contact hello@perpetua.io.