Skip to main content

JustReact Data Sheet

-justreact-data-sheet

  1. DS Sheet
    1. Named Ranges
    2. Named Range Example:
  2. DS Sheet Columns and Named Ranges
      1. Level
      2. Setting
      3. Type
      4. Period
      5. Info Text
      6. Info Number
      7. Channel
      8. Campaign Id
      9. Campaign
      10. Campaign Status
      11. Campaign Serving Status
      12. Campaign Primary Status
      13. Campaign Primary Status Reasons
      14. AdGroup Id
      15. AdGroup
      16. AdGroup Status
      17. AdGroup Type
      18. Ad Id
      19. Ad Type
      20. Ad Status
      21. Ad Approval Status
      22. Ad
      23. Ad Destination Url
      24. Ad Strength
      25. Ad Action Items
      26. Extension Text
      27. Extension Description 1
      28. Extension Description 2
      29. Extension Values
      30. Extension Url
      31. Keyword Id
      32. Keyword
      33. Keyword Match Type
      34. Keyword Status
      35. Keyword Approval Status
      36. Bid Strategy
      37. QS
      38. QS Ctr
      39. QS Creative
      40. QS Landingpage
      41. Cpc
      42. Page 1 Cpc
      43. Page Top Cpc
      44. Pos 1 Cpc
      45. Keyword Url
      46. Query
      47. Landing Page
      48. Speed Score
      49. Searches
      50. Impressions
      51. Clicks
      52. Cost
      53. Conversions
      54. Conversion Value
      55. Search Impression Share
      56. Search Top Impression Share
      57. Search Absolute Top Impression Share
      58. Budget Lost Share
      59. Rank Lost Share
      60. Search Exact Match Impression Share
      61. Ad Serving Optimization Status
      62. User Email
      63. Operation

DS Sheet

The DS (Data Set or Dataset) sheet is the sheet that will be updated from Google Ads according to your settings.

After updating the data the named ranges will be set according to the column headers.

Named Ranges

Named ranges in Google Sheets are pretty handy!

They let you refer to cells or ranges with custom names instead of the usual cell addresses like A1 or B2.

It's like giving a nickname to a part of your sheet.

This makes your formulas way easier to understand because you're using meaningful names instead of just cell coordinates.

Plus, if you decide to move things around, your formulas still work just fine because they're linked to the name, not the cell's specific location.

It's a real time-saver and keeps your sheets looking clean and understandable!

Next to this, it also allows us to add some important columns to the sheet, without breaking your formula's :-)

Named Range Example:

The "Campaign Serving Status" column will set the named range of this column to dsCampaignServingStatus, where ds is for the DS sheet and the columnheader is in CamelCase.

DS Sheet Columns and Named Ranges

Currently we use the following data columns in JustReact. For all these columns we use named ranges that use camelCase.

Level

Named range: dsLevel

Setting

Named range: dsSetting

Type

Named range: dsType

Period

Named range: dsPeriod

Info Text

Named range: dsInfoText

Info Number

Named range: dsInfoNumber

Channel

Named range: dsChannel

Campaign Id

Named range: dsCampaignId

Campaign

Named range: dsCampaign

Campaign Status

Named range: dsCampaignStatus

Campaign Serving Status

Named range: dsCampaignServingStatus

Campaign Primary Status

Named range: dsCampaignPrimaryStatus

Campaign Primary Status Reasons

Named range: dsCampaignPrimaryStatusReasons

AdGroup Id

Named range: dsAdGroupId

AdGroup

Named range: dsAdGroup

AdGroup Status

Named range: dsAdGroupStatus

AdGroup Type

Named range: dsAdGroupType

Ad Id

Named range: dsAdId

Ad Type

Named range: dsAdType

Ad Status

Named range: dsAdStatus

Ad Approval Status

Named range: dsAdApprovalStatus

Ad

Named range: dsAd

Ad Destination Url

Named range: dsAdDestinationUrl

Ad Strength

Named range: dsAdStrength

Ad Action Items

Named range: dsAdActionItems

Extension Text

Named range: dsExtensionText

Extension Description 1

Named range: dsExtensionDescription1

Extension Description 2

Named range: dsExtensionDescription2

Extension Values

Named range: dsExtensionValues

Extension Url

Named range: dsExtensionUrl

Keyword Id

Named range: dsKeywordId

Keyword

Named range: dsKeyword

Keyword Match Type

Named range: dsKeyword

Keyword Status

Named range: dsKeywordStatus

Keyword Approval Status

Named range: dsKeywordApprovalStatus

Bid Strategy

Named range: dsBidStrategy

QS

Named range: dsQS

QS Ctr

Named range: dsQSCtr

QS Creative

Named range: dsQSCreative

QS Landingpage

Named range: dsQSLandingpage

Cpc

Named range: dsCpc

Page 1 Cpc

Named range: dsPage1Cpc

Page Top Cpc

Named range: dsPageTopCpc

Pos 1 Cpc

Named range: dsPos1Cpc

Keyword Url

Named range: dsKeywordUrl

Query

Named range: dsQuery

Landing Page

Named range: dsLandingPage

Speed Score

Named range: dsSpeedScore

Searches

Named range: dsSearches

Impressions

Named range: dsImpressions

Clicks

Named range: dsClicks

Cost

Named range: dsCost

Conversions

Named range: dsConversions

Conversion Value

Named range: dsConversionValue

Search Impression Share

Named range: dsSearchImpressionShare

Search Top Impression Share

Named range: dsSearchTopImpressionShare

Search Absolute Top Impression Share

Named range: dsSearchAbsoluteTopImpressionShare

Budget Lost Share

Named range: dsBudgetLostShare

Rank Lost Share

Named range: dsRankLostShare

Search Exact Match Impression Share

Named range: dsSearchExactMatchImpressionShare

Ad Serving Optimization Status

Named range: dsAdServingOptimizationStatus

User Email

Named range: dsUserEmail

Operation

Named range: dsOperation