Which report
Komplet imports a product-level report from Google Ads: one row per item (Item ID) with the metrics for a period. Two ways to get it:
- Products view of a campaign. Open a Shopping or Performance Max campaign, choose Products, set the date range, segment by Day if Komplet should detect the period, and use the download icon.
- Report editor. Under Reports (Insights and reports) open the Report editor and use the predefined Shopping report by Item ID, or build a table with Item ID as the row.
Columns
Required: Item ID. Recommended: Impressions, Clicks, Cost, Conversions, Conv. value, Search impr. share, CTR, Avg. CPC, Currency code and Day (or Date) for the period. The import recognises the column names of English, Czech, Slovak, German and Polish exports.
Format
- Download as CSV. Files ending in .csv, .tsv or .txt are accepted, up to 20 MB.
- Google Ads exports are often UTF-16 with tab separators and a title line above the header; all of that is handled, and "Total" rows are skipped.
- When a report is segmented by day, rows are summed per Item ID; impression share is averaged, CTR and average CPC are recalculated from the sums.
- Numbers may use decimal commas, thousands separators, currency symbols or percent signs.
Where to upload
The Komplet tools that work with Google Ads data (Cockpit, Lineup, Checkup, Product Lab, Margin and the forecast in Verdict) have an upload form for this report. The newest upload is the one the tools use; the last five uploads are kept per shop.