Filter
User User( id="2bb6f739fa674eed898194f78c17cd56", external_auth_id="auth0|6284b2aa6b892100690e12ed", name="Hannah Lovell", email="amazon@healthspan.co.uk", onboarded="True", amazon_users=.... )
Created At 2022-05-19 08:40:40.006324
Params {"date_to": "2022-05-18", "country_code": "UK", "report_name": "Test Report", "date_from": "2022-03-20", "merchant_name": "Healthspan Elite", "merchant_type": "seller", "profile_ids": "2403324758720750"}
Result
{
  "ad_groups": {
    "average_per_campaign": 1774.0
  },
  "ad_spend": {
    "total": 45393.8,
    "wasted": 9916.18
  },
  "asins": {
    "converting": {
      "total": 321
    },
    "unique": {
      "total": 351
    }
  },
  "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": 59,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 59,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.0798,
      "percent_underspend": 0.9202,
      "total": 568698.0,
      "total_underspend": 523304.2
    },
    "top_daily_underspend": [
      {
        "date": "2022-05-03",
        "percent_spend": 0.03919601121844812,
        "total": 9627.0,
        "total_ad_spend": 377.34,
        "total_underspend": 9249.66
      },
      {
        "date": "2022-05-04",
        "percent_spend": 0.04132128388906201,
        "total": 9627.0,
        "total_ad_spend": 397.8,
        "total_underspend": 9229.2
      },
      {
        "date": "2022-03-22",
        "percent_spend": 0.045997714760569235,
        "total": 9627.0,
        "total_ad_spend": 442.82,
        "total_underspend": 9184.18
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 292
    }
  },
  "clicks": {
    "click_through_rate": 0.0107,
    "cpc": 1.58,
    "total": 28688
  },
  "conversions": {
    "conversion_rate": 0.2469,
    "total": 7083
  },
  "impressions": {
    "total": 13332597
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 44.5,
      "total": 3644
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 20791.97
        },
        "summary": {
          "percentage_of_total": 0.4844,
          "total": 21987.15,
          "wasted": 1195.18
        }
      },
      "campaigns": {
        "total_budget": 116125.24,
        "unique": 62
      },
      "clicks": {
        "click_through_rate": 0.0094,
        "cpc": 1.87,
        "total": 11751
      },
      "conversions": {
        "conversion_rate": 0.279,
        "total": 3279
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.5371,
          "roas": 1.8618,
          "total": 38709.88,
          "total_orders": 3279.0
        },
        "summary": {
          "acos": 0.568,
          "roas": 1.7606,
          "total": 38709.88,
          "total_orders": 3279
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.6507,
            "ad_spend": 2115.59,
            "clicks": 743,
            "cpc": 2.85,
            "query": "b01m4ghoke",
            "sales": 3251.22
          },
          {
            "acos": 0.799,
            "ad_spend": 1955.1,
            "clicks": 1101,
            "cpc": 1.78,
            "query": "b07234c288",
            "sales": 2446.93
          },
          {
            "acos": 0.3004,
            "ad_spend": 505.69,
            "clicks": 241,
            "cpc": 2.1,
            "query": "b01m22gha1",
            "sales": 1683.3
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 16.95,
            "clicks": 12,
            "cpc": 1.41,
            "query": "b004sgxy00",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 16.41,
            "clicks": 6,
            "cpc": 2.74,
            "query": "b084wpm76x",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 14.83,
            "clicks": 6,
            "cpc": 2.47,
            "query": "b004ma2agg",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 249,
          "non_converting": 625,
          "percent_converting": 0.2849,
          "total": 874
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 834.1
        },
        "summary": {
          "percentage_of_total": 0.0885,
          "total": 4018.43,
          "wasted": 3184.33
        }
      },
      "campaigns": {
        "total_budget": 40369.72,
        "unique": 36
      },
      "clicks": {
        "click_through_rate": 0.0151,
        "cpc": 1.11,
        "total": 3617
      },
      "conversions": {
        "conversion_rate": 0.0849,
        "total": 307
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2062,
          "roas": 4.8491,
          "total": 4044.62,
          "total_orders": 307.0
        },
        "summary": {
          "acos": 0.9935,
          "roas": 1.0065,
          "total": 4044.62,
          "total_orders": 307
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1986,
            "ad_spend": 27.6,
            "clicks": 23,
            "cpc": 1.2,
            "query": "healthspan",
            "sales": 138.99
          },
          {
            "acos": 0.0101,
            "ad_spend": 1.09,
            "clicks": 1,
            "cpc": 1.09,
            "query": "slippery elm tablets",
            "sales": 107.9
          },
          {
            "acos": 0.0176,
            "ad_spend": 1.41,
            "clicks": 2,
            "cpc": 0.71,
            "query": "healthspan whey",
            "sales": 79.98
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 30.4,
            "clicks": 35,
            "cpc": 0.87,
            "query": "gastric band drink",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 21.36,
            "clicks": 14,
            "cpc": 1.53,
            "query": "weight loss",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 20.52,
            "clicks": 26,
            "cpc": 0.79,
            "query": "viagra",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 247,
          "non_converting": 2013,
          "percent_converting": 0.1093,
          "total": 2260
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 2034.8
        },
        "summary": {
          "percentage_of_total": 0.0891,
          "total": 4045.64,
          "wasted": 2010.84
        }
      },
      "campaigns": {
        "total_budget": 109704.6,
        "unique": 59
      },
      "clicks": {
        "click_through_rate": 0.0256,
        "cpc": 1.36,
        "total": 2981
      },
      "conversions": {
        "conversion_rate": 0.2523,
        "total": 752
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2413,
          "roas": 4.1437,
          "total": 8431.54,
          "total_orders": 752.0
        },
        "summary": {
          "acos": 0.4798,
          "roas": 2.0841,
          "total": 8431.54,
          "total_orders": 752
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.512,
            "ad_spend": 261.95,
            "clicks": 169,
            "cpc": 1.55,
            "query": "calcium tablets",
            "sales": 511.66
          },
          {
            "acos": 0.3527,
            "ad_spend": 101.66,
            "clicks": 62,
            "cpc": 1.64,
            "query": "glucosamine for dogs",
            "sales": 288.24
          },
          {
            "acos": 0.0502,
            "ad_spend": 9.86,
            "clicks": 28,
            "cpc": 0.35,
            "query": "healthspan vitamin d",
            "sales": 196.3
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 13.59,
            "clicks": 6,
            "cpc": 2.27,
            "query": "senior dog joint supplements",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.63,
            "clicks": 8,
            "cpc": 1.33,
            "query": "turmeric for dogs",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.46,
            "clicks": 2,
            "cpc": 5.23,
            "query": "multivitamin over 70 men",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 449,
          "non_converting": 1288,
          "percent_converting": 0.2585,
          "total": 1737
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 8293.42
        },
        "summary": {
          "percentage_of_total": 0.2186,
          "total": 9925.28,
          "wasted": 1631.86
        }
      },
      "campaigns": {
        "total_budget": 133316.68,
        "unique": 83
      },
      "clicks": {
        "click_through_rate": 0.0081,
        "cpc": 1.53,
        "total": 6508
      },
      "conversions": {
        "conversion_rate": 0.2769,
        "total": 1802
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.4299,
          "roas": 2.326,
          "total": 19290.87,
          "total_orders": 1802.0
        },
        "summary": {
          "acos": 0.5145,
          "roas": 1.9436,
          "total": 19290.87,
          "total_orders": 1802
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.5647,
            "ad_spend": 1104.37,
            "clicks": 691,
            "cpc": 1.6,
            "query": "vitamin b complex",
            "sales": 1955.64
          },
          {
            "acos": 0.5548,
            "ad_spend": 310.57,
            "clicks": 148,
            "cpc": 2.1,
            "query": "cod liver oil capsules high strength",
            "sales": 559.8
          },
          {
            "acos": 0.0218,
            "ad_spend": 11.4,
            "clicks": 57,
            "cpc": 0.2,
            "query": "gastrisoothe",
            "sales": 523.05
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 16.46,
            "clicks": 12,
            "cpc": 1.37,
            "query": "vitamin b8 inositol",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 15.27,
            "clicks": 8,
            "cpc": 1.91,
            "query": "b vitamins high strength",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 13.63,
            "clicks": 8,
            "cpc": 1.7,
            "query": "zinc acetate",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 463,
          "non_converting": 577,
          "percent_converting": 0.4452,
          "total": 1040
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 2651.84
        },
        "summary": {
          "percentage_of_total": 0.1193,
          "total": 5417.3,
          "wasted": 2765.46
        }
      },
      "campaigns": {
        "total_budget": 123677.0,
        "unique": 82
      },
      "clicks": {
        "click_through_rate": 0.0152,
        "cpc": 1.41,
        "total": 3831
      },
      "conversions": {
        "conversion_rate": 0.2461,
        "total": 943
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2335,
          "roas": 4.2826,
          "total": 11356.8,
          "total_orders": 943.0
        },
        "summary": {
          "acos": 0.477,
          "roas": 2.0964,
          "total": 11356.8,
          "total_orders": 943
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0435,
            "ad_spend": 21.75,
            "clicks": 53,
            "cpc": 0.41,
            "query": "opti turmeric",
            "sales": 500.5
          },
          {
            "acos": 0.0753,
            "ad_spend": 30.87,
            "clicks": 48,
            "cpc": 0.64,
            "query": "healthspan probiotics",
            "sales": 409.87
          },
          {
            "acos": 0.034,
            "ad_spend": 9.9,
            "clicks": 27,
            "cpc": 0.37,
            "query": "gastrisoothe sachets",
            "sales": 291.33
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 62.18,
            "clicks": 8,
            "cpc": 7.77,
            "query": "tumeric supplements with black pepper",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 53.39,
            "clicks": 6,
            "cpc": 8.9,
            "query": "organic turmeric capsules",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 35.35,
            "clicks": 4,
            "cpc": 8.84,
            "query": "neem and turmeric capsules",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 489,
          "non_converting": 1654,
          "percent_converting": 0.2282,
          "total": 2143
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-03-20",
    "date_to": "2022-05-18",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-19T08:40:42.955629+00:00",
    "market": "UK",
    "profile_ids": [
      2403324758720750
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 17876.65404723274
  },
  "research_types": {
    "ad_spend": 13481.37,
    "percentage_of_total": 0.297
  },
  "sales": {
    "acos": 0.5547,
    "roas": 1.8028,
    "total": 81833.71,
    "total_orders": 7083
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.5124,
        "ad_spend": 20975.0,
        "sales": 40933.83
      },
      "top_duplicate": [
        {
          "acos": 0.7992,
          "ad_groups": [
            "Ad Group 1"
          ],
          "ad_spend": 1955.52,
          "campaigns": [
            76270045074555,
            82244375157332,
            132545991121596,
            263396001354222
          ],
          "match_types": [
            "ASIN",
            "AUTO"
          ],
          "query": "b07234c288",
          "sales": 2446.93
        },
        {
          "acos": 0.5673,
          "ad_groups": [
            "Ad Group 1",
            "Ad Group EXACT Match",
            "Ad Group PHRASE Match"
          ],
          "ad_spend": 1109.38,
          "campaigns": [
            62007097097226,
            79227266620088,
            90211748364272,
            147036537798033,
            264518429265625
          ],
          "match_types": [
            "AUTO",
            "EXACT",
            "PHRASE"
          ],
          "query": "vitamin b complex",
          "sales": 1955.64
        },
        {
          "acos": 0.8333,
          "ad_groups": [
            "Ad Group 1"
          ],
          "ad_spend": 921.99,
          "campaigns": [
            6362436713501,
            82244375157332,
            132545991121596,
            181860729264298,
            267282515800737
          ],
          "match_types": [
            "ASIN",
            "AUTO"
          ],
          "query": "b07trmvh31",
          "sales": 1106.41
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 1728,
      "non_converting": 5575,
      "total": 7303
    }
  }
}