[Shopee] - Integrating CSV Data from All Ads and Traffic Reports
Last updated
Last updated
This is a guide on how to obtain CSV data from All Ads and store Traffic Reports from your Shopee store and integrate this data with AnyX. This allows you to combine and check metrics such as sessions, conversion rates (CVR) and return on ad spends (ROAS) for your omni-channel store; while also providing Shopee specific reports more accessible through AnyX.
By connecting CSV data from your All Ads Reports from Shopee, you can display advertising data on the report page and analyze purchases using indicators such as revenue from advertising, advertising costs and ROAS.
1. Log in to Shopee Seller Center, go to "Marketing Centre" -> "Shopee Ads"
2. Make sure that you are in the "All Ads" tab and select the appropriate date range and download the CSV.
After the All Ads data is uploaded to AnyX from Shopee - using the Product Codes in the report downloaded from Shopee and matching them with the same Listings and Products on AnyX from the Shopee channel integration, the Product Analytics reports automatically attribute the advertising costs and revenue for each product:
Since the All Ads data from Shopee is are combined figures at the product level across the entire selected date range duration, AnyX makes a few assumptions to attribute and make an estimated daily breakdown of advertising costs and revenue:
If ad time range is entirely within the exported time range -> AnyX distributes ad cost and revenue evenly within the exported time range
If ad time range is not entirely within the exported time range -> AnyX distributes ad cost and revenue evenly within the ad time range
By connecting CSV data on Traffic data from your Lazada store, it allows you analyze session metrics in relation to purchases.
Log in to Shopee Seller Centre, go to "Data" -> "Business Insights"
2. Make sure that you are in the "Traffic" tab, select the relevant date range and download the CSV
Once you have downloaded the CSV reports above from your Shopee Seller Centre - integrating this onto AnyX is easy.
1. From a single-store view, click Integration and select the Shopee Channel you've connected
2. In the CSV Upload tab, click upload file and upload the CSV reports you've downloaded previously.
3. AnyX is able to automatically detect the CSV file and provide an Uploaded status if there are no issues.
Once this data is connected - AnyX factors in and aggregates metrics such as sessions, CVRs, ad costs and ROAs within the Sales Channel and Product Analytics reports.
