SEO Reporting
Our advanced SEO reporting integrates data from multiple sources, including SEMRUSH, AWR, Google Trends, Google Search Console and clients Keyword Research documents. Our SEO reporting allows clients to identify trends and prioritise keywords globally in order to maximise return on investment, alongside reporting on the performance of SEO efforts.
To get started with SEO reporting, please follow the steps below.
Google Search Console
We require access to Google Search Console to advance our SEO reporting. To set up the Google Search Console integration, please go to the Account Configuration section within the Cubed platform and create an API connection.
Handling SEO Keywords
To upload your keyword document, including your keywords, markets, categorisations and mapped pages, please visit our SEO Keyword Importer via Account Configuration within the Cubed platform. It is important to use the defined CSV structure to upload your keywords. A Goal must be selected to enable Cubed to model sales and revenue.
The Keyword Importer CSV template consists of many fields. The Keyword, Market and Active fields are the only mandatory fields, but we would encourage clients to also use Parent_Category, Child_Category, Sub_Category and Mapped Page to enhance reporting and categorisation of keywords.
| Field | Description |
|---|---|
| Market | Market is a two letter (alpha2) country code, for example GB, FR, DE or ES. We have over 200 country codes within our Cubed system. Please find an extensive list of our markets and country codes here. |
| Language | The language associated with a given keyword, we also provide a lookup table here of ISO 639-1 standard language codes. We encourage you to use these (language code) for both consistency and readability. here. |
| Translation | A translation of your uploaded keyword.* |
| Product | The primary product which is targeted by the keyword being uploaded.* |
| Parent_Category | The first categorisation of your uploaded keyword. |
| Child_Category | The second categorisation of your uploaded keyword. |
| Sub_Category | The third categorisation of your uploaded keyword. |
| Keyword_Modifier | The modifier of your uploaded keyword.* |
| Locale | The locale of your uploaded keyword.* |
| Mapped_Page | The URL the keyword is mapped to, in format https://www.example.com. |
| Active | Active state of keyword (0 or 1). To remove a keyword, please set to 0. |
*optional additional categorisation - please leave blank if not applicable.
Removing Keywords
To remove keywords from the Cubed platform please use the SEO Keyword Uploader in Account Configuration and the CSV template, setting the Active column to 0. The Keyword, Market and Active columns are mandatory for removal of keywords. Once keywords are removed, we will stop pulling data from external data sources and keywords will no longer feed into our Cubed platform reports.
Summary
Once the Google Search Console integration has been set up, and keywords have been imported, we push the keywords up to our AWR, SEMRUSH and Google Trends accounts. This allows us to pull ongoing keyword metrics into our systems, including monthly search volumes and trends and weekly rankings and competition scores. These metrics will start to feed into our many SEO reports within the Cubed Platform over the coming days, including our SEO Keyword Prioritisation Tool, Search Trends Report and Rank and Marketshare Report.