Filter
User User( id="9feae76d929647b38a473a24301f6aeb", external_auth_id="google-oauth2|103463387658369661150", name="Sirimas Chotipairat", email="sirimas@revstep.com", onboarded="True", amazon_users=.... )
Created At 2022-05-04 20:17:23.597041
Params {"merchant_name": "Forester", "date_to": "2022-05-03", "merchant_type": "seller", "report_name": "Forester", "date_from": "2022-03-05", "profile_ids": "2756550437056315", "country_code": "US"}
Result
{
  "ad_groups": {
    "average_per_campaign": 92.0
  },
  "ad_spend": {
    "total": 16323.27,
    "wasted": 4686.02
  },
  "asins": {
    "converting": {
      "total": 264
    },
    "unique": {
      "total": 134
    }
  },
  "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": 60,
      "percent_full_spend": 0.0,
      "percent_high_spend": 0.0,
      "percent_low_spend": 1.0,
      "percent_zero_spend": 0.0,
      "total_days": 60,
      "zero_spend": 0
    },
    "summary": {
      "percent_spend": 0.2849,
      "percent_underspend": 0.7151,
      "total": 57300.0,
      "total_underspend": 40976.73
    },
    "top_daily_underspend": [
      {
        "date": "2022-04-06",
        "percent_spend": 0.07775916230366492,
        "total": 955.0,
        "total_ad_spend": 74.26,
        "total_underspend": 880.74
      },
      {
        "date": "2022-04-24",
        "percent_spend": 0.10409424083769633,
        "total": 955.0,
        "total_ad_spend": 99.41,
        "total_underspend": 855.59
      },
      {
        "date": "2022-04-23",
        "percent_spend": 0.10735078534031414,
        "total": 955.0,
        "total_ad_spend": 102.52,
        "total_underspend": 852.48
      }
    ]
  },
  "campaigns": {
    "unique": {
      "total": 22
    }
  },
  "clicks": {
    "click_through_rate": 0.0132,
    "cpc": 0.85,
    "total": 19224
  },
  "conversions": {
    "conversion_rate": 0.1202,
    "total": 2311
  },
  "impressions": {
    "total": 4625296
  },
  "keywords": {
    "unique": {
      "average_per_campaign": 25.0,
      "total": 174
    }
  },
  "match_types": {
    "asin": {
      "ad_spend": {
        "converting": {
          "total": 1097.86
        },
        "summary": {
          "percentage_of_total": 0.0787,
          "total": 1284.63,
          "wasted": 186.77
        }
      },
      "campaigns": {
        "total_budget": 9900.0,
        "unique": 5
      },
      "clicks": {
        "click_through_rate": 0.0105,
        "cpc": 0.61,
        "total": 2109
      },
      "conversions": {
        "conversion_rate": 0.1171,
        "total": 247
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.1106,
          "roas": 9.0449,
          "total": 9930.0,
          "total_orders": 247.0
        },
        "summary": {
          "acos": 0.1294,
          "roas": 7.7299,
          "total": 9930.0,
          "total_orders": 247
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1056,
            "ad_spend": 151.5,
            "clicks": 188,
            "cpc": 0.81,
            "query": "b00ake2goe",
            "sales": 1434.49
          },
          {
            "acos": 0.0561,
            "ad_spend": 46.11,
            "clicks": 124,
            "cpc": 0.37,
            "query": "b073xr2cb3",
            "sales": 821.89
          },
          {
            "acos": 0.0285,
            "ad_spend": 21.48,
            "clicks": 32,
            "cpc": 0.67,
            "query": "b00ict06ua",
            "sales": 753.74
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 14.06,
            "clicks": 32,
            "cpc": 0.44,
            "query": "b08tj13l7x",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 11.63,
            "clicks": 14,
            "cpc": 0.83,
            "query": "b087cr2tg8",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.31,
            "clicks": 12,
            "cpc": 0.86,
            "query": "b01iw9gjjq",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 57,
          "non_converting": 98,
          "percent_converting": 0.3677,
          "total": 155
        }
      }
    },
    "auto": {
      "ad_spend": {
        "converting": {
          "total": 2677.03
        },
        "summary": {
          "percentage_of_total": 0.4107,
          "total": 6703.56,
          "wasted": 4026.53
        }
      },
      "campaigns": {
        "total_budget": 17700.0,
        "unique": 6
      },
      "clicks": {
        "click_through_rate": 0.0154,
        "cpc": 0.64,
        "total": 10446
      },
      "conversions": {
        "conversion_rate": 0.0781,
        "total": 816
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.0763,
          "roas": 13.0982,
          "total": 35064.35,
          "total_orders": 816.0
        },
        "summary": {
          "acos": 0.1912,
          "roas": 5.2307,
          "total": 35064.35,
          "total_orders": 816
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1097,
            "ad_spend": 164.25,
            "clicks": 272,
            "cpc": 0.6,
            "query": "b015n8av02",
            "sales": 1496.79
          },
          {
            "acos": 0.0868,
            "ad_spend": 84.87,
            "clicks": 131,
            "cpc": 0.65,
            "query": "b00jw6bmb4",
            "sales": 978.29
          },
          {
            "acos": 0.0222,
            "ad_spend": 21.26,
            "clicks": 33,
            "cpc": 0.64,
            "query": "b07y25h581",
            "sales": 955.8
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 35.68,
            "clicks": 48,
            "cpc": 0.74,
            "query": "capstan winch",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 30.18,
            "clicks": 36,
            "cpc": 0.84,
            "query": "b086868ncv",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 27.18,
            "clicks": 25,
            "cpc": 1.09,
            "query": "b011k7fuug",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 405,
          "non_converting": 2904,
          "percent_converting": 0.1224,
          "total": 3309
        }
      }
    },
    "broad": {
      "ad_spend": {
        "converting": {
          "total": 771.79
        },
        "summary": {
          "percentage_of_total": 0.0577,
          "total": 941.9,
          "wasted": 170.11
        }
      },
      "campaigns": {
        "total_budget": 11700.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0224,
        "cpc": 0.72,
        "total": 1303
      },
      "conversions": {
        "conversion_rate": 0.2548,
        "total": 332
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.06,
          "roas": 16.6627,
          "total": 12860.1,
          "total_orders": 332.0
        },
        "summary": {
          "acos": 0.0732,
          "roas": 13.6534,
          "total": 12860.1,
          "total_orders": 332
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0988,
            "ad_spend": 443.18,
            "clicks": 657,
            "cpc": 0.67,
            "query": "forester brush blade",
            "sales": 4484.22
          },
          {
            "acos": 0.0009,
            "ad_spend": 1.34,
            "clicks": 1,
            "cpc": 1.34,
            "query": "chainsaw chaps forester one size",
            "sales": 1496.4
          },
          {
            "acos": 0.0387,
            "ad_spend": 51.06,
            "clicks": 53,
            "cpc": 0.96,
            "query": "log wizard",
            "sales": 1319.7
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 8.66,
            "clicks": 4,
            "cpc": 2.17,
            "query": "notch apron style chainsaw chaps",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.35,
            "clicks": 18,
            "cpc": 0.46,
            "query": "draw knife debarking tool",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 3.53,
            "clicks": 2,
            "cpc": 1.77,
            "query": "forester chainsaw apron chaps",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 55,
          "non_converting": 156,
          "percent_converting": 0.2607,
          "total": 211
        }
      }
    },
    "exact": {
      "ad_spend": {
        "converting": {
          "total": 6484.22
        },
        "summary": {
          "percentage_of_total": 0.406,
          "total": 6627.3,
          "wasted": 143.08
        }
      },
      "campaigns": {
        "total_budget": 10200.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0092,
        "cpc": 1.52,
        "total": 4350
      },
      "conversions": {
        "conversion_rate": 0.1726,
        "total": 751
      },
      "is_research_type": false,
      "sales": {
        "converting": {
          "acos": 0.188,
          "roas": 5.3203,
          "total": 34497.78,
          "total_orders": 751.0
        },
        "summary": {
          "acos": 0.1921,
          "roas": 5.2054,
          "total": 34497.78,
          "total_orders": 751
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.1697,
            "ad_spend": 3170.7,
            "clicks": 1691,
            "cpc": 1.88,
            "query": "chainsaw chaps",
            "sales": 18687.88
          },
          {
            "acos": 0.2817,
            "ad_spend": 831.27,
            "clicks": 436,
            "cpc": 1.91,
            "query": "chainsaw chaps for men",
            "sales": 2950.91
          },
          {
            "acos": 0.2505,
            "ad_spend": 474.07,
            "clicks": 463,
            "cpc": 1.02,
            "query": "brush cutter blade",
            "sales": 1892.59
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 15.84,
            "clicks": 41,
            "cpc": 0.39,
            "query": "gas powered winch",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.53,
            "clicks": 5,
            "cpc": 2.11,
            "query": "chaps chainsaw safety",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 10.17,
            "clicks": 18,
            "cpc": 0.57,
            "query": "capstan winch",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 58,
          "non_converting": 51,
          "percent_converting": 0.5321,
          "total": 109
        }
      }
    },
    "phrase": {
      "ad_spend": {
        "converting": {
          "total": 473.61
        },
        "summary": {
          "percentage_of_total": 0.0469,
          "total": 765.88,
          "wasted": 292.27
        }
      },
      "campaigns": {
        "total_budget": 8700.0,
        "unique": 3
      },
      "clicks": {
        "click_through_rate": 0.0238,
        "cpc": 0.75,
        "total": 1016
      },
      "conversions": {
        "conversion_rate": 0.1624,
        "total": 165
      },
      "is_research_type": true,
      "sales": {
        "converting": {
          "acos": 0.053,
          "roas": 18.8636,
          "total": 8934.0,
          "total_orders": 165.0
        },
        "summary": {
          "acos": 0.0857,
          "roas": 11.665,
          "total": 8934.0,
          "total_orders": 165
        }
      },
      "search_terms": {
        "top_converting": [
          {
            "acos": 0.0818,
            "ad_spend": 164.88,
            "clicks": 88,
            "cpc": 1.87,
            "query": "log wizard debarking tool",
            "sales": 2015.55
          },
          {
            "acos": 0.0007,
            "ad_spend": 1.08,
            "clicks": 1,
            "cpc": 1.08,
            "query": "portable winch battery powered capstn winch lit w/ batteries- 2200 lbs max pull pcw3000-li-bk",
            "sales": 1611.0
          },
          {
            "acos": 0.0071,
            "ad_spend": 6.73,
            "clicks": 12,
            "cpc": 0.56,
            "query": "portable winch gas powered",
            "sales": 949.05
          }
        ],
        "top_non_converting": [
          {
            "acos": null,
            "ad_spend": 66.09,
            "clicks": 75,
            "cpc": 0.88,
            "query": "portable winch",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 13.6,
            "clicks": 19,
            "cpc": 0.72,
            "query": "chainsaw winch",
            "sales": 0.0
          },
          {
            "acos": null,
            "ad_spend": 8.02,
            "clicks": 16,
            "cpc": 0.5,
            "query": "arborist throw weight",
            "sales": 0.0
          }
        ],
        "unique": {
          "converting": 61,
          "non_converting": 191,
          "percent_converting": 0.2421,
          "total": 252
        }
      }
    }
  },
  "metadata": {
    "brand_search_terms": null,
    "campaign_ids": null,
    "currency_symbol": "$",
    "date_from": "2022-03-05",
    "date_to": "2022-05-03",
    "exclude_zero_spend_days": false,
    "generated_at": "2022-05-04T20:17:28.218369+00:00",
    "market": "US",
    "profile_ids": [
      2756550437056315
    ],
    "wasted_spend_click_threshold": 1
  },
  "missed_revenue": {
    "total": 29069.602977667495
  },
  "research_types": {
    "ad_spend": 8411.34,
    "percentage_of_total": 0.5153
  },
  "sales": {
    "acos": 0.1612,
    "roas": 6.205,
    "total": 101286.23,
    "total_orders": 2311
  },
  "search_terms": {
    "duplicate": {
      "summary": {
        "acos": 0.1484,
        "ad_spend": 9331.88,
        "sales": 62881.04
      },
      "top_duplicate": [
        {
          "acos": 0.1681,
          "ad_groups": [
            "Brush Cutter and Chaps",
            "General"
          ],
          "ad_spend": 3181.25,
          "campaigns": [
            52362015543404,
            96831304862110
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "chainsaw chaps",
          "sales": 18927.73
        },
        {
          "acos": 0.2841,
          "ad_groups": [
            "Brush Cutter and Chaps",
            "General",
            null
          ],
          "ad_spend": 838.5,
          "campaigns": [
            52362015543404,
            96831304862110
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "chainsaw chaps for men",
          "sales": 2950.91
        },
        {
          "acos": 0.2242,
          "ad_groups": [
            "Ad group 1",
            "Brush Cutter and Chaps",
            "General",
            null
          ],
          "ad_spend": 533.52,
          "campaigns": [
            17240641151202,
            96831304862110,
            164711152669900
          ],
          "match_types": [
            "AUTO",
            "EXACT"
          ],
          "query": "brush cutter blade",
          "sales": 2379.82
        }
      ]
    },
    "top_duplicate": [],
    "unique": {
      "converting": 581,
      "non_converting": 3279,
      "total": 3860
    }
  }
}