Filter
User User( id="11df4febe4ba43e6af6bbde38b517a25", external_auth_id="amazon|amzn1.account.AESWABV6RHVA2NMJKHSF43Y56AWA", name="Ronald Mulder", email="ronald_mulder@goldpeak.com", onboarded="True", amazon_users=.... )
Created At 2022-05-06 07:11:07.877018
Params {"report_name": "Test", "profile_ids": "1950077876696150", "date_from": "2022-03-07", "country_code": "UK", "merchant_name": "A28JUFOJ3T6SD0", "date_to": "2022-05-05", "merchant_type": "seller"}
Result
{
  "ad_groups": {
    "average_per_campaign": 422.0
  },
  "ad_spend": {
    "total": 13830.32,
    "wasted": 2231.72
  },
  "asins": {
    "converting": {
      "total": 207
    },
    "unique": {
      "total": 198
    }
  },
  "branded": {
    "False": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    },
    "True": {
      "ad_spend": {
        "total": 0,
        "wasted": 0
      },
      "clicks": {
        "click_through_rate": 0,
        "cpc": 0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0,
        "total": 0
      },
      "sales": {
        "summary": {
          "acos": 0,
          "roas": 0,
          "total": 0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "total": 0
        }
      }
    }
  },
  "budget": {
    "daily_efficiency": {
      "full_spend": 0,
      "high_spend": 0,
      "low_spend": 52,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 52,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.0165,
      "percent_underspend": 0.9835,
      "total": 828776.0,
      "total_underspend": 815101.49
    },
    "top_daily_underspend": [
      {
        "date": "2022-03-26",
        "percent_spend": 0.0009800476847785168,
        "total": 15938.0,
        "total_ad_spend": 15.62,
        "total_underspend": 15922.38
      },
      {
        "date": "2022-03-15",
        "percent_spend": 0.0018220604843769608,
        "total": 15938.0,
        "total_ad_spend": 29.04,
        "total_underspend": 15908.96
      },
      {
        "date": "2022-03-21",
        "percent_spend": 0.0021985192621407955,
        "total": 15938.0,
        "total_ad_spend": 35.04,
        "total_underspend": 15902.96
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 36
    }
  },
  "clicks": {
    "click_through_rate": 0.0037,
    "cpc": 1.5,
    "total": 9227
  },
  "conversions": {
    "conversion_rate": 0.3537,
    "total": 3371
  },
  "impressions": {
    "total": 11957187
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 304.5,
      "total": 5876
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 1620.2
        },
        "summary": {
          "percentage_of_total": 0.1099,
          "total": 1585.89,
          "wasted": 64.46
        }
      },
      "campaigns": {
        "total_budget": 219950.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0021,
        "cpc": 1.26,
        "total": 1259
      },
      "conversions": {
        "conversion_rate": 0.3575,
        "total": 473
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.1815,
          "roas": 5.5111,
          "total": 8929.07,
          "total_orders": 473.0
        },
        "summary": {
          "acos": 0.1888,
          "roas": 5.2969,
          "total": 8929.07,
          "total_orders": 473
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1643,
            "ad_spend": 275.14,
            "clicks": 210,
            "cpc": 1.31,
            "query": "b093c9b1hk",
            "sales": 1674.87
          },
          {
            "acos": 0.1971,
            "ad_spend": 277.52,
            "clicks": 215,
            "cpc": 1.29,
            "query": "b07mlfbjg3",
            "sales": 1408.37
          },
          {
            "acos": 0.1346,
            "ad_spend": 146.8,
            "clicks": 113,
            "cpc": 1.3,
            "query": "b093lvb4p7",
            "sales": 1091.03
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 12.45,
            "clicks": 11,
            "cpc": 1.13,
            "query": "b00ntch52w",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 11.34,
            "clicks": 10,
            "cpc": 1.13,
            "query": "b00utgzjgk",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.5,
            "clicks": 6,
            "cpc": 1.75,
            "query": "b093cbbkg8",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 23,
          "non_converting": 13,
          "percent_converting": 0.6389,
          "total": 36
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 894.84
        },
        "summary": {
          "percentage_of_total": 0.2099,
          "total": 3028.19,
          "wasted": 2133.35
        }
      },
      "campaigns": {
        "total_budget": 96407.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0134,
        "cpc": 1.08,
        "total": 2811
      },
      "conversions": {
        "conversion_rate": 0.1854,
        "total": 523
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1546,
          "roas": 6.4681,
          "total": 5837.27,
          "total_orders": 523.0
        },
        "summary": {
          "acos": 0.5203,
          "roas": 1.9221,
          "total": 5837.27,
          "total_orders": 523
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2936,
            "ad_spend": 59.87,
            "clicks": 48,
            "cpc": 1.25,
            "query": "batteries aaa pack",
            "sales": 203.93
          },
          {
            "acos": 0.2177,
            "ad_spend": 40.79,
            "clicks": 32,
            "cpc": 1.27,
            "query": "batteries aa pack",
            "sales": 187.4
          },
          {
            "acos": 0.3361,
            "ad_spend": 42.52,
            "clicks": 26,
            "cpc": 1.64,
            "query": "aaa",
            "sales": 126.51
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 10.15,
            "clicks": 10,
            "cpc": 1.02,
            "query": "b093lt2n4q",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.26,
            "clicks": 6,
            "cpc": 1.21,
            "query": "b094r47h8q",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.09,
            "clicks": 6,
            "cpc": 1.02,
            "query": "b004fq6kfe",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 371,
          "non_converting": 1770,
          "percent_converting": 0.1733,
          "total": 2141
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 6425.85
        },
        "summary": {
          "percentage_of_total": 0.455,
          "total": 6563.95,
          "wasted": 138.1
        }
      },
      "campaigns": {
        "total_budget": 333900.0,
        "unique": 5
      },
      "clicks": {
        "click_through_rate": 0.003,
        "cpc": 1.77,
        "total": 3708
      },
      "conversions": {
        "conversion_rate": 0.4404,
        "total": 1633
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.2886,
          "roas": 3.465,
          "total": 22265.82,
          "total_orders": 1633.0
        },
        "summary": {
          "acos": 0.2948,
          "roas": 3.3921,
          "total": 22265.82,
          "total_orders": 1633
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2866,
            "ad_spend": 2380.99,
            "clicks": 1136,
            "cpc": 2.1,
            "query": "aa batteries",
            "sales": 8306.89
          },
          {
            "acos": 0.3425,
            "ad_spend": 1860.02,
            "clicks": 839,
            "cpc": 2.22,
            "query": "aaa batteries",
            "sales": 5430.09
          },
          {
            "acos": 0.3658,
            "ad_spend": 843.25,
            "clicks": 394,
            "cpc": 2.14,
            "query": "batteries",
            "sales": 2305.41
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 25.68,
            "clicks": 20,
            "cpc": 1.28,
            "query": "a+ batteries",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.09,
            "clicks": 4,
            "cpc": 2.52,
            "query": "aaa batteries amazon",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 9.33,
            "clicks": 3,
            "cpc": 3.11,
            "query": "aa-batteries",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 91,
          "non_converting": 44,
          "percent_converting": 0.6741,
          "total": 135
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        },
        "summary": {
          "percentage_of_total": 0.0,
          "total": 0.0,
          "wasted": 0.0
        }
      },
      "campaigns": {
        "total_budget": 0.0,
        "unique": 0
      },
      "clicks": {
        "click_through_rate": 0.0,
        "cpc": 0.0,
        "total": 0
      },
      "conversions": {
        "conversion_rate": 0.0,
        "total": 0
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        },
        "summary": {
          "acos": 0.0,
          "roas": 0.0,
          "total": 0.0,
          "total_orders": 0
        }
      },
      "search_terms": {
        "top_converting": [],
        "top_non_converting": [],
        "unique": {
          "converting": 0,
          "non_converting": 0,
          "percent_converting": 0.0,
          "total": 0
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-03-07",
    "date_to": "2022-05-05",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-06T07:14:21.984464+00:00",
    "market": "UK",
    "profile_ids": [
      1950077876696150
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 7417.606100795756
  },
  "research_types": {
    "ad_spend": 3036.99,
    "percentage_of_total": 0.2079
  },
  "sales": {
    "acos": 0.3058,
    "roas": 3.2697,
    "total": 45220.55,
    "total_orders": 3219
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.2471,
        "ad_spend": 5438.31,
        "sales": 22007.56
      },
      "top_duplicate": [
        {
          "acos": 0.281,
          "ad_groups": [
            "AA 40 Extra - DEAL",
            "SPTOP | AA 40 Ultra | B00CO00Y32",
            null
          ],
          "ad_spend": 3362.31,
          "campaigns": [
            80873080298827,
            119653202971448
          ],
          "match_types": [
            "AUTO",
            "EXACT",
            null
          ],
          "query": "aa batteries",
          "sales": 11966.79
        },
        {
          "acos": 0.1948,
          "ad_groups": [
            "GP | AAA 24 Ultra",
            "PDA | AA",
            null
          ],
          "ad_spend": 493.6,
          "campaigns": [
            3728643359072,
            197195698879255
          ],
          "match_types": [
            "ASIN",
            "AUTO",
            null
          ],
          "query": "b093c9b1hk",
          "sales": 2533.61
        },
        {
          "acos": 0.1649,
          "ad_groups": [
            "AU | AA 40 Ultra",
            "PDA | AA",
            null
          ],
          "ad_spend": 237.87,
          "campaigns": [
            3728643359072,
            200745887348052
          ],
          "match_types": [
            "ASIN",
            "AUTO",
            null
          ],
          "query": "b093lvb4p7",
          "sales": 1442.53
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 479,
      "non_converting": 1794,
      "total": 2273
    }
  }
}