Filter
User User( id="6efe5bc2721a41b8803f13f476a98cb7", external_auth_id="auth0|627a8493bae05700687ff3f5", name="Matthew Lee", email="hello@linknutrition.com", onboarded="True", amazon_users=.... )
Created At 2022-11-02 17:15:20.406479
Params {"brand_search_terms": [], "country_code": "UK", "date_from": "2022-04-01", "merchant_type": "seller", "exclude_zero_spend_days": false, "report_name": "Apr 2022 - Oct 2022", "campaign_ids": [], "date_to": "2022-10-31", "wasted_spend_click_threshold": 1, "merchant_name": "Immune Nation", "profile_ids": "216071166409416"}
Result
{
  "ad_groups": {
    "average_per_campaign": 306.0
  },
  "ad_spend": {
    "total": 12893.68,
    "wasted": 4862.73
  },
  "asins": {
    "converting": {
      "total": 43
    },
    "unique": {
      "total": 21
    }
  },
  "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": 1,
      "low_spend": 202,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0049,
      "percent_low_spend": 0.9951,
      "percent_zero_spend": 0.0,
      "total_days": 203,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.0618,
      "percent_underspend": 0.9382,
      "total": 208739.52,
      "total_underspend": 195845.84
    },
    "top_daily_underspend": [
      {
        "date": "2022-06-07",
        "percent_spend": 0.028097038437303087,
        "total": 1587.0,
        "total_ad_spend": 44.59,
        "total_underspend": 1542.41
      },
      {
        "date": "2022-06-05",
        "percent_spend": 0.03809016906700063,
        "total": 1597.0,
        "total_ad_spend": 60.83,
        "total_underspend": 1536.17
      },
      {
        "date": "2022-06-06",
        "percent_spend": 0.039937382592360675,
        "total": 1597.0,
        "total_ad_spend": 63.78,
        "total_underspend": 1533.22
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 137
    }
  },
  "clicks": {
    "click_through_rate": 0.0149,
    "cpc": 1.39,
    "total": 9294
  },
  "conversions": {
    "conversion_rate": 0.1003,
    "total": 932
  },
  "impressions": {
    "total": 3849168
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 29.3,
      "total": 1203
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 2467.94
        },
        "summary": {
          "percentage_of_total": 0.2792,
          "total": 3600.5,
          "wasted": 1132.56
        }
      },
      "campaigns": {
        "total_budget": 82962.13,
        "unique": 55
      },
      "clicks": {
        "click_through_rate": 0.0122,
        "cpc": 1.51,
        "total": 2386
      },
      "conversions": {
        "conversion_rate": 0.075,
        "total": 179
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.8001,
          "roas": 1.2499,
          "total": 3084.66,
          "total_orders": 179.0
        },
        "summary": {
          "acos": 1.1672,
          "roas": 0.8567,
          "total": 3084.66,
          "total_orders": 179
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.6084,
            "ad_spend": 586.1,
            "clicks": 374,
            "cpc": 1.57,
            "query": "b07gs5ctbh",
            "sales": 963.32
          },
          {
            "acos": 0.1142,
            "ad_spend": 40.82,
            "clicks": 57,
            "cpc": 0.72,
            "query": "b07gnmybpz",
            "sales": 357.4
          },
          {
            "acos": 1.2885,
            "ad_spend": 329.93,
            "clicks": 241,
            "cpc": 1.37,
            "query": "b082xgljq5",
            "sales": 256.06
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 71.71,
            "clicks": 37,
            "cpc": 1.94,
            "query": "b07gq1rjf6",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 40.36,
            "clicks": 29,
            "cpc": 1.39,
            "query": "b084hh913j",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 39.11,
            "clicks": 7,
            "cpc": 5.59,
            "query": "b01745dzhi",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 58,
          "non_converting": 282,
          "percent_converting": 0.1706,
          "total": 340
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 131.5
        },
        "summary": {
          "percentage_of_total": 0.0572,
          "total": 737.54,
          "wasted": 606.04
        }
      },
      "campaigns": {
        "total_budget": 15575.0,
        "unique": 2
      },
      "clicks": {
        "click_through_rate": 0.1251,
        "cpc": 0.77,
        "total": 959
      },
      "conversions": {
        "conversion_rate": 0.0438,
        "total": 42
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1905,
          "roas": 5.2481,
          "total": 690.13,
          "total_orders": 42.0
        },
        "summary": {
          "acos": 1.0687,
          "roas": 0.9357,
          "total": 690.13,
          "total_orders": 42
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.5543,
            "ad_spend": 64.68,
            "clicks": 57,
            "cpc": 1.13,
            "query": "vitamin c complex",
            "sales": 116.69
          },
          {
            "acos": 0.0217,
            "ad_spend": 1.12,
            "clicks": 1,
            "cpc": 1.12,
            "query": "link probiotic",
            "sales": 51.53
          },
          {
            "acos": 0.0475,
            "ad_spend": 2.13,
            "clicks": 2,
            "cpc": 1.07,
            "query": "link vitamin c complex",
            "sales": 44.88
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 12.41,
            "clicks": 12,
            "cpc": 1.03,
            "query": "bioflavonoids",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.25,
            "clicks": 9,
            "cpc": 0.92,
            "query": "withanolides",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.96,
            "clicks": 6,
            "cpc": 1.33,
            "query": "omega 3",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 29,
          "non_converting": 597,
          "percent_converting": 0.0463,
          "total": 626
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 458.82
        },
        "summary": {
          "percentage_of_total": 0.1109,
          "total": 1429.62,
          "wasted": 970.8
        }
      },
      "campaigns": {
        "total_budget": 37243.83,
        "unique": 22
      },
      "clicks": {
        "click_through_rate": 0.0076,
        "cpc": 2.07,
        "total": 689
      },
      "conversions": {
        "conversion_rate": 0.0769,
        "total": 53
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.5189,
          "roas": 1.9272,
          "total": 884.26,
          "total_orders": 53.0
        },
        "summary": {
          "acos": 1.6167,
          "roas": 0.6185,
          "total": 884.26,
          "total_orders": 53
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.2668,
            "ad_spend": 17.74,
            "clicks": 17,
            "cpc": 1.04,
            "query": "synbiotic supplements",
            "sales": 66.48
          },
          {
            "acos": 0.463,
            "ad_spend": 30.78,
            "clicks": 8,
            "cpc": 3.85,
            "query": "pro biotics probiotics for women gut",
            "sales": 66.48
          },
          {
            "acos": 0.094,
            "ad_spend": 5.86,
            "clicks": 9,
            "cpc": 0.65,
            "query": "link multi plus vitamins",
            "sales": 62.37
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 23.36,
            "clicks": 6,
            "cpc": 3.89,
            "query": "organic probiotics for women",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 20.52,
            "clicks": 7,
            "cpc": 2.93,
            "query": "lovebug probiotics for women",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 16.61,
            "clicks": 7,
            "cpc": 2.37,
            "query": "fish oil omega 3",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 38,
          "non_converting": 366,
          "percent_converting": 0.0941,
          "total": 404
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 1030.72
        },
        "summary": {
          "percentage_of_total": 0.1026,
          "total": 1323.17,
          "wasted": 292.45
        }
      },
      "campaigns": {
        "total_budget": 38438.37,
        "unique": 24
      },
      "clicks": {
        "click_through_rate": 0.0298,
        "cpc": 1.64,
        "total": 809
      },
      "conversions": {
        "conversion_rate": 0.2373,
        "total": 192
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.3007,
          "roas": 3.3251,
          "total": 3427.28,
          "total_orders": 192.0
        },
        "summary": {
          "acos": 0.3861,
          "roas": 2.5902,
          "total": 3427.28,
          "total_orders": 192
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3746,
            "ad_spend": 306.59,
            "clicks": 182,
            "cpc": 1.68,
            "query": "synbiotic",
            "sales": 818.55
          },
          {
            "acos": 0.0304,
            "ad_spend": 15.41,
            "clicks": 34,
            "cpc": 0.45,
            "query": "synbiotic 7 probiotic",
            "sales": 506.1
          },
          {
            "acos": 0.472,
            "ad_spend": 138.85,
            "clicks": 78,
            "cpc": 1.78,
            "query": "synbiotics",
            "sales": 294.17
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 25.41,
            "clicks": 8,
            "cpc": 3.18,
            "query": "live probiotics",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 18.33,
            "clicks": 8,
            "cpc": 2.29,
            "query": "spore based probiotic",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 17.96,
            "clicks": 12,
            "cpc": 1.5,
            "query": "mushroom coffee",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 36,
          "non_converting": 74,
          "percent_converting": 0.3273,
          "total": 110
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 219.73
        },
        "summary": {
          "percentage_of_total": 0.0497,
          "total": 640.41,
          "wasted": 420.68
        }
      },
      "campaigns": {
        "total_budget": 32069.43,
        "unique": 22
      },
      "clicks": {
        "click_through_rate": 0.0128,
        "cpc": 1.11,
        "total": 576
      },
      "conversions": {
        "conversion_rate": 0.1128,
        "total": 65
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1978,
          "roas": 5.0555,
          "total": 1110.85,
          "total_orders": 65.0
        },
        "summary": {
          "acos": 0.5765,
          "roas": 1.7346,
          "total": 1110.85,
          "total_orders": 65
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.775,
            "ad_spend": 70.87,
            "clicks": 90,
            "cpc": 0.79,
            "query": "nootropics brain supplements",
            "sales": 91.45
          },
          {
            "acos": 0.1345,
            "ad_spend": 12.19,
            "clicks": 10,
            "cpc": 1.22,
            "query": "brain food supplement",
            "sales": 90.61
          },
          {
            "acos": 0.0219,
            "ad_spend": 1.64,
            "clicks": 4,
            "cpc": 0.41,
            "query": "link nutrition multi",
            "sales": 74.82
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 15.23,
            "clicks": 8,
            "cpc": 1.9,
            "query": "lions mane mushroom capsules",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 14.61,
            "clicks": 7,
            "cpc": 2.09,
            "query": "immune system booster",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.45,
            "clicks": 9,
            "cpc": 0.94,
            "query": "sleep aid",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 43,
          "non_converting": 251,
          "percent_converting": 0.1463,
          "total": 294
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-04-01",
    "date_to": "2022-10-31",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-11-02T17:15:25.779677+00:00",
    "market": "UK",
    "profile_ids": [
      216071166409416
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 6105.12241054614
  },
  "research_types": {
    "ad_spend": 2807.57,
    "percentage_of_total": 0.2177
  },
  "sales": {
    "acos": 0.7965,
    "roas": 1.2555,
    "total": 16188.13,
    "total_orders": 932
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.5596,
        "ad_spend": 2971.65,
        "sales": 5310.38
      },
      "top_duplicate": [
        {
          "acos": 0.5858,
          "ad_groups": [
            "Ad group - 04/04/2022 15:37:22",
            "Ad group 1",
            "Ad group - 23/06/2022 16:44:23",
            "Ashwagandha [auto]",
            "B07GQ1JCCL",
            "B07GR89VG4",
            null
          ],
          "ad_spend": 966.54,
          "campaigns": [
            18657314492989,
            33046514239289,
            59619825033407,
            74866845206958,
            117652120449708,
            133364441543492,
            136606687325337,
            148177075406622,
            179633071590150,
            234518784067631,
            250061969860385
          ],
          "match_types": [
            "ASIN",
            "AUTO",
            "CATEGORY",
            null
          ],
          "query": "b07gs5ctbh",
          "sales": 1649.91
        },
        {
          "acos": 0.5362,
          "ad_groups": [
            "B07GQ1RJF6",
            "B07GS7FV1K",
            null
          ],
          "ad_spend": 273.57,
          "campaigns": [
            107869129451340,
            115489257061136,
            213191539683972
          ],
          "match_types": [
            "EXACT",
            "PHRASE",
            null
          ],
          "query": "synbiotics",
          "sales": 510.23
        },
        {
          "acos": 0.7719,
          "ad_groups": [
            "Ad group - 08/06/2022 10:11:52",
            "B07GS5CTBH",
            null
          ],
          "ad_spend": 127.07,
          "campaigns": [
            32222528720189,
            181246063602339
          ],
          "match_types": [
            "BROAD",
            "PHRASE",
            null
          ],
          "query": "nootropics brain supplements",
          "sales": 164.61
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 310,
      "non_converting": 2212,
      "total": 2522
    }
  }
}