Filter
User User( id="6efe5bc2721a41b8803f13f476a98cb7", external_auth_id="auth0|627a8493bae05700687ff3f5", name="Matthew Lee", email="hello@linknutrition.com", onboarded="True", amazon_users=.... )
Created At 2022-08-05 08:55:03.870456
Params {"exclude_zero_spend_days": false, "report_name": "July 22", "date_from": "2022-07-01", "date_to": "2022-07-31", "merchant_name": "Immune Nation", "wasted_spend_click_threshold": 1, "brand_search_terms": [], "campaign_ids": [], "country_code": "UK", "merchant_type": "seller", "profile_ids": "216071166409416"}
Result
{
  "ad_groups": {
    "average_per_campaign": 306.0
  },
  "ad_spend": {
    "total": 1858.69,
    "wasted": 1034.97
  },
  "asins": {
    "converting": {
      "total": 13
    },
    "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": 0,
      "low_spend": 31,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 31,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.0498,
      "percent_underspend": 0.9502,
      "total": 37339.5,
      "total_underspend": 35480.81
    },
    "top_daily_underspend": [
      {
        "date": "2022-07-19",
        "percent_spend": 0.02912411789124118,
        "total": 1204.5,
        "total_ad_spend": 35.08,
        "total_underspend": 1169.42
      },
      {
        "date": "2022-07-09",
        "percent_spend": 0.030228310502283105,
        "total": 1204.5,
        "total_ad_spend": 36.41,
        "total_underspend": 1168.09
      },
      {
        "date": "2022-07-28",
        "percent_spend": 0.03456205894562059,
        "total": 1204.5,
        "total_ad_spend": 41.63,
        "total_underspend": 1162.87
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 90
    }
  },
  "clicks": {
    "click_through_rate": 0.0139,
    "cpc": 1.29,
    "total": 1442
  },
  "conversions": {
    "conversion_rate": 0.1012,
    "total": 146
  },
  "impressions": {
    "total": 583822
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 28.7,
      "total": 1092
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 195.59
        },
        "summary": {
          "percentage_of_total": 0.2697,
          "total": 501.32,
          "wasted": 305.73
        }
      },
      "campaigns": {
        "total_budget": 11005.0,
        "unique": 26
      },
      "clicks": {
        "click_through_rate": 0.0131,
        "cpc": 1.33,
        "total": 377
      },
      "conversions": {
        "conversion_rate": 0.0743,
        "total": 28
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.3754,
          "roas": 2.6638,
          "total": 521.02,
          "total_orders": 28.0
        },
        "summary": {
          "acos": 0.9622,
          "roas": 1.0393,
          "total": 521.02,
          "total_orders": 28
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3357,
            "ad_spend": 83.94,
            "clicks": 50,
            "cpc": 1.68,
            "query": "b07gs5ctbh",
            "sales": 250.06
          },
          {
            "acos": 0.0386,
            "ad_spend": 2.12,
            "clicks": 2,
            "cpc": 1.06,
            "query": "b002folb6q",
            "sales": 54.87
          },
          {
            "acos": 1.8773,
            "ad_spend": 68.67,
            "clicks": 58,
            "cpc": 1.18,
            "query": "b082xgljq5",
            "sales": 36.58
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 41.78,
            "clicks": 42,
            "cpc": 0.99,
            "query": "b07drhdjrt",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 25.47,
            "clicks": 21,
            "cpc": 1.21,
            "query": "b07hm5d7nw",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 12.76,
            "clicks": 9,
            "cpc": 1.42,
            "query": "b08yrt6k76",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 13,
          "non_converting": 83,
          "percent_converting": 0.1354,
          "total": 96
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 21.86
        },
        "summary": {
          "percentage_of_total": 0.05,
          "total": 93.01,
          "wasted": 71.15
        }
      },
      "campaigns": {
        "total_budget": 2480.0,
        "unique": 1
      },
      "clicks": {
        "click_through_rate": 0.1239,
        "cpc": 0.72,
        "total": 129
      },
      "conversions": {
        "conversion_rate": 0.0543,
        "total": 7
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.2149,
          "roas": 4.6528,
          "total": 101.71,
          "total_orders": 7.0
        },
        "summary": {
          "acos": 0.9145,
          "roas": 1.0935,
          "total": 101.71,
          "total_orders": 7
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.3955,
            "ad_spend": 10.65,
            "clicks": 10,
            "cpc": 1.07,
            "query": "vitamin c complex",
            "sales": 26.93
          },
          {
            "acos": 0.1215,
            "ad_spend": 2.02,
            "clicks": 4,
            "cpc": 0.51,
            "query": "link nutrition",
            "sales": 16.62
          },
          {
            "acos": 0.0271,
            "ad_spend": 0.45,
            "clicks": 1,
            "cpc": 0.45,
            "query": "stomach bug clear",
            "sales": 16.62
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 3.28,
            "clicks": 3,
            "cpc": 1.09,
            "query": "bioflavonoids",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 2.69,
            "clicks": 2,
            "cpc": 1.35,
            "query": "omega 3",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 2.28,
            "clicks": 7,
            "cpc": 0.33,
            "query": "blis k12",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 6,
          "non_converting": 88,
          "percent_converting": 0.0638,
          "total": 94
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 9.15
        },
        "summary": {
          "percentage_of_total": 0.0789,
          "total": 146.64,
          "wasted": 137.49
        }
      },
      "campaigns": {
        "total_budget": 5270.0,
        "unique": 13
      },
      "clicks": {
        "click_through_rate": 0.0097,
        "cpc": 1.33,
        "total": 110
      },
      "conversions": {
        "conversion_rate": 0.0727,
        "total": 8
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.068,
          "roas": 14.7158,
          "total": 134.65,
          "total_orders": 8.0
        },
        "summary": {
          "acos": 1.089,
          "roas": 0.9182,
          "total": 134.65,
          "total_orders": 8
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0115,
            "ad_spend": 0.48,
            "clicks": 3,
            "cpc": 0.16,
            "query": "link multi plus vitamins",
            "sales": 41.58
          },
          {
            "acos": 0.031,
            "ad_spend": 1.03,
            "clicks": 2,
            "cpc": 0.52,
            "query": "link nutrition synbiotic 7",
            "sales": 33.24
          },
          {
            "acos": 0.1607,
            "ad_spend": 2.94,
            "clicks": 3,
            "cpc": 0.98,
            "query": "brain fog supplement",
            "sales": 18.29
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 16.61,
            "clicks": 7,
            "cpc": 2.37,
            "query": "fish oil omega 3",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 13.33,
            "clicks": 6,
            "cpc": 2.22,
            "query": "prebiotics and probiotics for adults",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 6.53,
            "clicks": 3,
            "cpc": 2.18,
            "query": "multi vitamin",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 6,
          "non_converting": 76,
          "percent_converting": 0.0732,
          "total": 82
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 121.15
        },
        "summary": {
          "percentage_of_total": 0.1178,
          "total": 218.94,
          "wasted": 97.79
        }
      },
      "campaigns": {
        "total_budget": 5425.0,
        "unique": 14
      },
      "clicks": {
        "click_through_rate": 0.0273,
        "cpc": 1.47,
        "total": 149
      },
      "conversions": {
        "conversion_rate": 0.2215,
        "total": 33
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.2032,
          "roas": 4.9201,
          "total": 596.07,
          "total_orders": 33.0
        },
        "summary": {
          "acos": 0.3673,
          "roas": 2.7225,
          "total": 596.07,
          "total_orders": 33
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.4149,
            "ad_spend": 63.79,
            "clicks": 34,
            "cpc": 1.88,
            "query": "synbiotic",
            "sales": 153.75
          },
          {
            "acos": 0.0087,
            "ad_spend": 0.63,
            "clicks": 4,
            "cpc": 0.16,
            "query": "link synbiotic 7",
            "sales": 72.32
          },
          {
            "acos": 0.0308,
            "ad_spend": 2.05,
            "clicks": 6,
            "cpc": 0.34,
            "query": "synbiotic 7 probiotic",
            "sales": 66.48
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 10.27,
            "clicks": 5,
            "cpc": 2.05,
            "query": "mushroom coffee",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 9.46,
            "clicks": 4,
            "cpc": 2.37,
            "query": "hey nutrition probiotic complex",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 7.39,
            "clicks": 5,
            "cpc": 1.48,
            "query": "food grown magnesium",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 12,
          "non_converting": 33,
          "percent_converting": 0.2667,
          "total": 45
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 39.07
        },
        "summary": {
          "percentage_of_total": 0.0719,
          "total": 133.69,
          "wasted": 94.62
        }
      },
      "campaigns": {
        "total_budget": 5192.5,
        "unique": 14
      },
      "clicks": {
        "click_through_rate": 0.0094,
        "cpc": 1.17,
        "total": 114
      },
      "conversions": {
        "conversion_rate": 0.1579,
        "total": 18
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.1232,
          "roas": 8.1188,
          "total": 317.2,
          "total_orders": 18.0
        },
        "summary": {
          "acos": 0.4215,
          "roas": 2.3727,
          "total": 317.2,
          "total_orders": 18
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0272,
            "ad_spend": 1.47,
            "clicks": 1,
            "cpc": 1.47,
            "query": "brain food supplement",
            "sales": 54.03
          },
          {
            "acos": 0.0074,
            "ad_spend": 0.31,
            "clicks": 1,
            "cpc": 0.31,
            "query": "link nutrition",
            "sales": 41.9
          },
          {
            "acos": 0.2406,
            "ad_spend": 6.4,
            "clicks": 4,
            "cpc": 1.6,
            "query": "ashwagandha",
            "sales": 26.6
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 6.41,
            "clicks": 4,
            "cpc": 1.6,
            "query": "ksm66 ashwagandha",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 5.35,
            "clicks": 4,
            "cpc": 1.34,
            "query": "brain fog supplement",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 4.38,
            "clicks": 6,
            "cpc": 0.73,
            "query": "nootropics brain supplements",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 13,
          "non_converting": 58,
          "percent_converting": 0.1831,
          "total": 71
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "£",
    "date_from": "2022-07-01",
    "date_to": "2022-07-31",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-08-05T08:55:09.166401+00:00",
    "market": "UK",
    "profile_ids": [
      216071166409416
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 1423.0303863605116
  },
  "research_types": {
    "ad_spend": 373.34,
    "percentage_of_total": 0.2009
  },
  "sales": {
    "acos": 0.7273,
    "roas": 1.375,
    "total": 2555.74,
    "total_orders": 146
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.4063,
        "ad_spend": 213.91,
        "sales": 526.54
      },
      "top_duplicate": [
        {
          "acos": 0.4354,
          "ad_groups": [
            "Ad group 1",
            "B07GQ1JCCL",
            "B07GR89VG4",
            null
          ],
          "ad_spend": 124.81,
          "campaigns": [
            18657314492989,
            59619825033407,
            117652120449708,
            148177075406622,
            179633071590150,
            250061969860385
          ],
          "match_types": [
            "ASIN",
            "CATEGORY",
            null
          ],
          "query": "b07gs5ctbh",
          "sales": 286.64
        },
        {
          "acos": 0.5005,
          "ad_groups": [
            "Ad group - 08/06/2022 10:11:52",
            "Ad group 1",
            "B07GS5CTBH",
            null
          ],
          "ad_spend": 27.46,
          "campaigns": [
            32222528720189,
            51993284458197,
            181246063602339
          ],
          "match_types": [
            "BROAD",
            "EXACT",
            "PHRASE",
            null
          ],
          "query": "brain fog supplement",
          "sales": 54.87
        },
        {
          "acos": 1.0433,
          "ad_groups": [
            "Ad group - 11/07/2022 18:41:57",
            null
          ],
          "ad_spend": 17.34,
          "campaigns": [
            41059590267046
          ],
          "match_types": [
            "BROAD",
            "PHRASE",
            null
          ],
          "query": "ashwagandha ksm 66",
          "sales": 16.62
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 69,
      "non_converting": 451,
      "total": 520
    }
  }
}